S9Dev 3/12/2019 3:05:37 PM

Variance Account Amount Calculation

I have a PO invoice with an amount variance on the invoice.  When I manually enter the invoice, the amount calculates correctly.  When pushing the transaction through econnect, the calculated variance amount is wrong.

In this XML, there is 1 line, PO'd at Unit Cost 90, Ext Cost 900.  The invoice is at 80/800, and the variance is 1500 instead of 100.  I can not seem to find where the calculation is going wrong... 

<?xml version="1.0" encoding="utf-8"?>
<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/>
<taPopDistribution_Items xsi:nil="true"/>
<taAnalyticsDistribution_Items xsi:nil="true"/>
<taPopEnterMatchLotInsert_Items xsi:nil="true"/>
<taPopEnterMatchSerialInsert_Items xsi:nil="true"/>
<taPopEnterMatchInvLine_Items>
<taPopEnterMatchInvLine>
<POPRCTNM>RCT1266</POPRCTNM>
<PONUMBER>PO2098</PONUMBER>
<QTYINVCD>10</QTYINVCD>
<ITEMNMBR>3-C2924A</ITEMNMBR>
<VENDORID>ADVANCED0001</VENDORID>
<UNITCOST>80.00</UNITCOST>
<EXTDCOST>800</EXTDCOST>
<POLNENUM>16384</POLNENUM>
</taPopEnterMatchInvLine>
</taPopEnterMatchInvLine_Items>
<taPopEnterMatchInvToShpMultiLine_Items>
<taPopEnterMatchInvToShpMultiLine>
<POPRCTNM>RCT1266</POPRCTNM>
<POPMtchShpRcpt>RCT1264</POPMtchShpRcpt>
<PONUMBER>PO2098</PONUMBER>
<QTYINVCD>10</QTYINVCD>
<VNDITNUM>3-C2924A</VNDITNUM>
<ShipRCPTLNNM>16384</ShipRCPTLNNM>
<VENDORID>ADVANCED0001</VENDORID>
<IVCLINNO>16384</IVCLINNO>
<VarianceAccount>000-4750-01</VarianceAccount>
<Revalue_Inventory>1</Revalue_Inventory>
</taPopEnterMatchInvToShpMultiLine>
</taPopEnterMatchInvToShpMultiLine_Items>
<taPopEnterMatchInvHdr>
<POPRCTNM>RCT1266</POPRCTNM>
<VNDDOCNM>INV1106</VNDDOCNM>
<receiptdate>3/12/19 12:00:00 AM</receiptdate>
<BACHNUMB>GLOBAL SEARCH</BACHNUMB>
<VENDORID>ADVANCED0001</VENDORID>
<SUBTOTAL>800</SUBTOTAL>
<PYMTRMID>Net 30</PYMTRMID>
<TAXSCHID>ALL DETAILS</TAXSCHID>
<USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
<CURNCYID>Z-US$</CURNCYID>
</taPopEnterMatchInvHdr>
<taMdaUpdate_Items xsi:nil="true"/>
</POPEnterMatchInvoiceType>
</eConnect>

 

 

Version: GP 2015
Section: Dynamics GP, eConnect


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3