Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Difference in net amount and unit price

Posted on by 660

Dear All,

We have a very rare issue found in our system where a user has entered a sales order with a quantity and have entered the unit price and posted the invoice.

Now if we check the invoice the net amount which should be equal to the quantity multiplied by unit price is not matching.

Example:

Standard Scenario: Sales Order:
Line 1
Item A Quantity 100 Unit Price 10 Net Amount 10000

Issue:

Sales Order
Line 1
Item A Quantity 100 Unit Price Net Amount 10010

How is this possible
Please help

*This post is locked for comments

  • shaik arif Profile Picture
    shaik arif 41 on at
    RE: Difference in net amount and unit price

    did you find any solution 

    same issue me also facing can you help me

  • binitshah Profile Picture
    binitshah 660 on at
    RE: Difference in net amount and unit price

    Hi Crispin,

    The price unit is 1

  • binitshah Profile Picture
    binitshah 660 on at
    RE: Difference in net amount and unit price

    Hi Ludwig,

    The issue is that only the net amount on the sales order line is different, rest all places the net amount has been posted correct. Even the net sales order confirmation journal shows the correct net amount, but on sales order lines, the net amount is having a different amount.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Difference in net amount and unit price

    Hi Binit Shah,

    Can this be caused by some taxes that are posted on surcharges or simply be caused by the fact that the prices include or exclude tax?

    Best regards,

    Ludwig

  • binitshah Profile Picture
    binitshah 660 on at
    RE: Difference in net amount and unit price

    Hello Martin,

    Yes I know the net amount includes other things, but in my case even the voucher is posted in a different amount..

    How is that possible in AX?

  • Martin Dráb Profile Picture
    Martin Dráb 230,064 Most Valuable Professional on at
    RE: Difference in net amount and unit price

    It might be caused by charges.

    Also note that net amount includes other things as well, such as discounts. It's not merely quantity * unit price.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,232 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans