Hello,
we have activated the three-way matching in the vendor invoice validation parameters.
Scenario:
PO Line with 100 pz (with price unit 100) * unit price 3.79
- Invoiced = (18/100)*3.79=0.68
- Invoice Remainder = (82/100)*3.79=3.11
At the moment of posting the 82 pz (the remainder of the PO line) --> Matching details: there is a net unit price discrepancy!
![cee) Policy violations Unit price matching errors exist. Invoice matching details (1 @ Show all lines (filt?r may apply) Purchase order: 00001428_064, Litware, Inc. (DE), Purchase order: 00001428 064 Vendor: Litware, Inc. (DE) Invoice: 82 pezzi Match status Line number Unit price: Price unit: Charges on purchases: Discount: Discount percent: Multiline discount: Multiline discount percentage: Net amount: Net unit price: Unmatched purchase order total: Invoice quantity: Total product receipts matched: Receiving requirements: Deduction requirements: C) Show only lines with matching discrepancies Color Site Warehouse CW quantity Quant iw Inventory PO unit price Inv Item number Procurement category Text Line matching policy Configuration Size Three-way matching Invoice: 82 pezzi Purchase order: 00001428 064 nvoice unit price EUR 00379 00379 Invoice totals Balance: Total discount: Charges: Sales tax: Round-off: Invoice amount: Total price variance amount: Compared charges: Invoice matching approval Approve posting with matching discrepancies: Approver. Comment: Display all invoice lines (filter may apply) or only invoice lines with matching discrepancies All) cee 5/19/2017 AXE WPM_DEV TEST Close]()
Net unit price has apparently no variance (since it is the same as the net unit price of the PO).
However we found out that the reason might be the rounding, because in the invoice column the values are saved without rounding (in our case: 3.11/82=0.0379268293..).
Do you maybe know if MS has already provided a fix for this issue?
Many thanks in advance,
Fjorela
*This post is locked for comments
I have the same question (0)