web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Purchase Invoice Matching Details - Net unit price rounding

(0) ShareShare
ReportReport
Posted on by 339

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)
  • Fjorela Profile Picture
    339 on at

    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

  • Fjorela Profile Picture
    339 on at

    6445.Capture2.PNG

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Fjorela,

    Have you checked LCS already for an available hotfix?

    Can you post the invoice if you approve the price discrepancy?

    Do you know why the prices have been setup this way ; that is, for 100 pcs where you might often run into rounding problems as you showed above in your price calculation.

    Best regards,

    Ludwig

  • Fjorela Profile Picture
    339 on at

    Hi Ludwig,

    Yes, I did check LCS but couldn't find anything.

    Yes, I am able to approve the price discrepancy manually. However, all this process should happen automatically through a workflow...so this discrepancy causes the workflow to stop.

    The setup of the prices is due to the low value of the prices.

    Best regards,

    Fjorela

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Fjorela,

    Is it possible to setup the prices differently - for example $3790/100000 pcs and to define the default order settings in a way that those rounding issues can be avoide for example by saying that the min. order quantity is 100 pcs?

    Best regards,

    Ludwig

  • Verified answer
    Fjorela Profile Picture
    339 on at

    Hi Ludwig,

    unfortunately this is not an option for us.

    But we managed to solve it by setting a small percentage price tolerance in the invoice matching parameters.

    Many thanks and best regards,

    Fjorela

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Fjorela,

    As you seemingly found the option, can we mark your solution as verified?

    Best regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans