Hello!
We are creating enter match invoices vie econnect and having issues with inventory line items. When we pass in the below XMLs for noninventory GP is setting the distributions correctly with createdist=1 (meaning we are letting GP create them) when we pass in the same XML for inventory items GP never creates the distribution correctly and will leave out the purchase line or the calculate the wrong variance. We cannot use AUTO cost because the EXT cost can be different, thus the reason for the variance. Any help will be appreciated.
Noninventory that is working fine
<?xml version="1.0" encoding="utf-16"?>
<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<POPEnterMatchInvoiceType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateItemRcd xsi:nil="true" />
<taUpdateCreateVendorRcd xsi:nil="true" />
<taCreateVendorAddress_Items xsi:nil="true" />
<taPopRcptLineTaxInsert_Items>
<taPopRcptLineTaxInsert>
<VENDORID>XXXXX</VENDORID>
<POPRCTNM>RCPT00000001823</POPRCTNM>
<TAXDTLID>P-94533 </TAXDTLID>
<TAXTYPE>0</TAXTYPE>
<ACTINDX>1933</ACTINDX>
<TAXAMNT>100.82</TAXAMNT>
<TOTPURCH>1206.24</TOTPURCH>
</taPopRcptLineTaxInsert>
</taPopRcptLineTaxInsert_Items>
<taPopDistribution_Items xsi:nil="true" />
<taAnalyticsDistribution_Items xsi:nil="true" />
<taPopEnterMatchLotInsert_Items xsi:nil="true" />
<taPopEnterMatchSerialInsert_Items xsi:nil="true" />
<taPopEnterMatchInvLine_Items>
<taPopEnterMatchInvLine>
<POPRCTNM>RCPT00000001823</POPRCTNM>
<POPMtchShpRcpt>R172502</POPMtchShpRcpt>
<ShipRCPTLNNM>16384</ShipRCPTLNNM>
<PONUMBER>PO124340</PONUMBER>
<QTYINVCD>12</QTYINVCD>
<ITEMNMBR>R90101701</ITEMNMBR>
<VENDORID>XXXXX</VENDORID>
<VNDITNUM>
</VNDITNUM>
<UNITCOST>2.92</UNITCOST>
<EXTDCOST>35.04</EXTDCOST>
<NONINVEN>1</NONINVEN>
<POLNENUM>32768</POLNENUM>
</taPopEnterMatchInvLine>
<taPopEnterMatchInvLine>
<POPRCTNM>RCPT00000001823</POPRCTNM>
<POPMtchShpRcpt>R172502</POPMtchShpRcpt>
<ShipRCPTLNNM>32768</ShipRCPTLNNM>
<PONUMBER>PO124340</PONUMBER>
<QTYINVCD>6</QTYINVCD>
<ITEMNMBR>4WE6J6X/EG24N9K4/62</ITEMNMBR>
<VENDORID>VALIN</VENDORID>
<VNDITNUM>
</VNDITNUM>
<UNITCOST>195.20</UNITCOST>
<EXTDCOST>1171.20</EXTDCOST>
<NONINVEN>1</NONINVEN>
<POLNENUM>49152</POLNENUM>
</taPopEnterMatchInvLine>
</taPopEnterMatchInvLine_Items>
<taPopEnterMatchInvToShpMultiLine_Items xsi:nil="true" />
<taPopEnterMatchInvHdr>
<POPRCTNM>RCPT00000001823</POPRCTNM>
<VNDDOCNM>3339572</VNDDOCNM>
<receiptdate>09/12/2018</receiptdate>
<BACHNUMB>TD-09212018</BACHNUMB>
<VENDORID>XXXXX</VENDORID>
<SUBTOTAL>1206.24</SUBTOTAL>
<FRTAMNT>38.51</FRTAMNT>
<TAXAMNT>100.82</TAXAMNT>
<TAXSCHID>XXXXX </TAXSCHID>
<USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
</taPopEnterMatchInvHdr>
<taMdaUpdate_Items xsi:nil="true" />
</POPEnterMatchInvoiceType>
</eConnect>
Inventory that does not work
<?xml version="1.0" encoding="utf-16"?>
<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<POPEnterMatchInvoiceType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateItemRcd xsi:nil="true" />
<taUpdateCreateVendorRcd xsi:nil="true" />
<taCreateVendorAddress_Items xsi:nil="true" />
<taPopRcptLineTaxInsert_Items>
<taPopRcptLineTaxInsert>
<VENDORID>XXXXX</VENDORID>
<POPRCTNM>RCPT00000001723</POPRCTNM>
<TAXDTLID>P-94533 </TAXDTLID>
<TAXTYPE>0</TAXTYPE>
<ACTINDX>1896</ACTINDX>
<TAXAMNT>135.83</TAXAMNT>
<TOTPURCH>1658.92</TOTPURCH>
</taPopRcptLineTaxInsert>
</taPopRcptLineTaxInsert_Items>
<taPopDistribution_Items xsi:nil="true" />
<taAnalyticsDistribution_Items xsi:nil="true" />
<taPopEnterMatchLotInsert_Items xsi:nil="true" />
<taPopEnterMatchSerialInsert_Items xsi:nil="true" />
<taPopEnterMatchInvLine_Items>
<taPopEnterMatchInvLine>
<POPRCTNM>RCPT00000001723</POPRCTNM>
<POPMtchShpRcpt>R172271</POPMtchShpRcpt>
<ShipRCPTLNNM>16384</ShipRCPTLNNM>
<PONUMBER>PO124381</PONUMBER>
<QTYINVCD>4</QTYINVCD>
<ITEMNMBR>XXXXX<</ITEMNMBR>
<VENDORID>XXXXX<</VENDORID>
<VNDITNUM>
</VNDITNUM>
<UNITCOST>414.73</UNITCOST>
<EXTDCOST>1658.92</EXTDCOST>
<NONINVEN>1</NONINVEN>
<POLNENUM>16384</POLNENUM>
</taPopEnterMatchInvLine>
</taPopEnterMatchInvLine_Items>
<taPopEnterMatchInvToShpMultiLine_Items xsi:nil="true" />
<taPopEnterMatchInvHdr>
<POPRCTNM>RCPT00000001723</POPRCTNM>
<VNDDOCNM>30448212</VNDDOCNM>
<receiptdate>08/31/2018</receiptdate>
<BACHNUMB>TD-09212018</BACHNUMB>
<VENDORID>XXXXX<</VENDORID>
<SUBTOTAL>1658.92</SUBTOTAL>
<FRTAMNT>18.00</FRTAMNT>
<TAXAMNT>135.83</TAXAMNT>
<TAXSCHID>XXXXX< </TAXSCHID>
<USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
</taPopEnterMatchInvHdr>
<taMdaUpdate_Items xsi:nil="true" />
</POPEnterMatchInvoiceType>
</eConnect>