sorry about that.
The invoices come thru biztalk edi, which puts it on an econnect message queue
No... it doesn't seem to be happening to all of them. Specifically happens on invoices that need to adjust the cost of the items. In fact... if they go into great plains, and remove the distributions, it calcuates them ok within the system.
Here's an example of one of the xml files, that was sent thru to econnect
The CreateDist flag is set, to automatically create the distributions. The only distribution that is off is type 1
We don't have multi-currency set, which is what microsoft was wanting us to do. But, we don't have a need for multi-currency.
Our exchange rate is zero, which would cause it to drop into the 3 when condition of the case statement, in the insert I've been looking at. (in my first posting)
further info
a. We don’t use discounts on any POP invoices.
b. We don’t use MDA.
c. These are all inventory items.
d. We don’t use project accounting.
e. We don’t use discounts on any POP invoices.
f. Sometimes there is a freight amount on the POP invoice, and likewise a FREIGHT distribution. But not often. And I have not seen any case where the FREIGHT distribution is incorrect (i.e. doesn’t match the Freight field on the invoice).
I don't believe we use Landed cost. Is there a way to check?
<?xml version="1.0" encoding="UTF-8"?>
-<eConnect>
-<POPEnterMatchInvoiceType>
-<taPopEnterMatchInvLine_Items>
-<taPopEnterMatchInvLine>
<POPRCTNM>INV_32356332</POPRCTNM>
<PONUMBER>WD987999</PONUMBER>
<QTYINVCD>1</QTYINVCD>
<ITEMNMBR>000009780691168821BN</ITEMNMBR>
<VENDORID>IV26521</VENDORID>
<VNDITNUM>000009780691168821BN</VNDITNUM>
<UNITCOST>29.95</UNITCOST>
<EXTDCOST>29.95</EXTDCOST>
<NONINVEN>0</NONINVEN>
<AUTOCOST>0</AUTOCOST>
<POLNENUM>32768</POLNENUM>
<CURNCYID>Z-US$</CURNCYID>
</taPopEnterMatchInvLine>
-<taPopEnterMatchInvLine>
<POPRCTNM>INV_32356332</POPRCTNM>
<PONUMBER>WD987999</PONUMBER>
<QTYINVCD>3</QTYINVCD>
<ITEMNMBR>000009780691141039BN</ITEMNMBR>
<VENDORID>IV26521</VENDORID>
<VNDITNUM>000009780691141039BN</VNDITNUM>
<UNITCOST>28.00</UNITCOST>
<EXTDCOST>84.00</EXTDCOST>
<NONINVEN>0</NONINVEN>
<AUTOCOST>0</AUTOCOST>
<POLNENUM>16384</POLNENUM>
<CURNCYID>Z-US$</CURNCYID>
</taPopEnterMatchInvLine>
-<taPopEnterMatchInvLine>
<POPRCTNM>INV_32356332</POPRCTNM>
<PONUMBER>WD987999</PONUMBER>
<QTYINVCD>6</QTYINVCD>
<ITEMNMBR>000009781441317445BN</ITEMNMBR>
<VENDORID>IV26521</VENDORID>
<VNDITNUM>000009781441317445BN</VNDITNUM>
<UNITCOST>4.63</UNITCOST>
<EXTDCOST>27.78</EXTDCOST>
<NONINVEN>0</NONINVEN>
<AUTOCOST>0</AUTOCOST>
<POLNENUM>131072</POLNENUM>
<CURNCYID>Z-US$</CURNCYID>
</taPopEnterMatchInvLine>
-<taPopEnterMatchInvLine>
<POPRCTNM>INV_32356332</POPRCTNM>
<PONUMBER>WD987999</PONUMBER>
<QTYINVCD>8</QTYINVCD>
<ITEMNMBR>000009780873518611BN</ITEMNMBR>
<VENDORID>IV26521</VENDORID>
<VNDITNUM>000009780873518611BN</VNDITNUM>
<UNITCOST>10.41</UNITCOST>
<EXTDCOST>83.28</EXTDCOST>
<NONINVEN>0</NONINVEN>
<AUTOCOST>0</AUTOCOST>
<POLNENUM>98304</POLNENUM>
<CURNCYID>Z-US$</CURNCYID>
</taPopEnterMatchInvLine>
-<taPopEnterMatchInvLine>
<POPRCTNM>INV_32356332</POPRCTNM>
<PONUMBER>WD987999</PONUMBER>
<QTYINVCD>8</QTYINVCD>
<ITEMNMBR>000009781595586834BN</ITEMNMBR>
<VENDORID>IV26521</VENDORID>
<VNDITNUM>000009781595586834BN</VNDITNUM>
<UNITCOST>14.47</UNITCOST>
<EXTDCOST>115.76</EXTDCOST>
<NONINVEN>0</NONINVEN>
<AUTOCOST>0</AUTOCOST>
<POLNENUM>163840</POLNENUM>
<CURNCYID>Z-US$</CURNCYID>
</taPopEnterMatchInvLine>
</taPopEnterMatchInvLine_Items>
-<taPopEnterMatchInvHdr>
<POPRCTNM>INV_32356332</POPRCTNM>
<VNDDOCNM>32356332</VNDDOCNM>
<receiptdate>12-28-2017</receiptdate>
<BACHNUMB>IV26521_14</BACHNUMB>
<VENDORID>IV26521</VENDORID>
<SUBTOTAL>340.77</SUBTOTAL>
<FRTAMNT>1.50</FRTAMNT>
<MISCAMNT>0.00</MISCAMNT>
<PYMTRMID>NET 30</PYMTRMID>
<AUTOCOST>0</AUTOCOST>
<CURNCYID>Z-US$</CURNCYID>
<CREATEDIST>1</CREATEDIST>
</taPopEnterMatchInvHdr>
</POPEnterMatchInvoiceType>
</eConnect>
