web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Sales Price and Invoic...
Microsoft Dynamics AX (Archived)

Sales Price and Invoice Price do not agree

(0) ShareShare
ReportReport
Posted on by Konrad U 804

If anyone can help we would appreciate it on how to diagnose a case of the sales order line item net price and the invoice net price not agreeing with no evidence of why they differ.

The line item is quantity one $2,648.03 and the invoice $2,753.37. No special charges or taxes. The voucher shows $2,648.03. The invoice journal $2,753.37.  As a percent the difference does not make sense either, seems like a random amount.

This is a return order, intercompany. The purchase order side is fine.

Any suggestions?

Thanks

Konrad

*This post is locked for comments

I have the same question (0)
  • Konrad U Profile Picture
    Konrad U 804 on at
    RE: Sales Price and Invoice Price do not agree

    Hello Ludwig,

    Please go ahead and post. Not sure why they changed the intercompany mirror so much from 2009 to 2012 but usually before I fix stuff I review the 2009 code. It was a real mystery until I looked at the sales parmline table and found the invoiced amount that was erroneous. In mirroring AX had not mirrored the parm tables (thankfully).

    Thanks!

    Konrad

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales Price and Invoice Price do not agree

    Hi Konrad,

    If you do not mind then I will post a thread on MS connect to let MS know about this issue and (hopefully) let them fix this in future releases.

    Best regards,

    Ludwig

  • Konrad U Profile Picture
    Konrad U 804 on at
    RE: Sales Price and Invoice Price do not agree

    Ludwig,

    Thanks! From past experience I think we have figured out the scenario and unless we get a lot of rewriting it is probably not easily fixable due to the refactoring that took place in 2012 R3. In short there are holes in the intercompany mirror for various operations. Some have been fixed but a lot are unreported and not likely to be repaired.

    The scenario:

    This was a return order of a serialized unit to the non originating warehouse. This scenario causes a problem right away because the originating sale cannot be easily reversed. Plus as a return order the return reason is mandatory.

    In brief the return order was created in the first company which created the purchase order analogue in the second company.  The first company supplied the cost which was not correct. Easy to do unless you are able to reverse the exact unit order.

    The order was invoiced in the first company.

    Company two touched the order after the first company invoiced and the purchase cost was set in company two to the defined purchase price. The intercompany mirror fired to move the cost to the company one order not testing for invoice status. Exacerbating this was a price change after the return order was done and the addition of return reason.

    Price syncing when overriding prices has been an ongoing issue that has been addressed by hotfixes but there are so many scenarios that only the simplest cases have been tested.

    Our workaround is to change the company two price to allow 3 way match to invoice in company two then adjust the financials side.

    Konrad

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales Price and Invoice Price do not agree

    Hello Konrad U,

    I have not come across such an issue and would suggest that you try to debug it with a developer. There is also no hotfix that seems to fix your description.

    Do you know whether this occured only one-time or have you seen this issue for many of your orders?

    Best regards,

    Ludwig

  • Konrad U Profile Picture
    Konrad U 804 on at
    RE: Sales Price and Invoice Price do not agree

    Thanks for the response. There is no exchange rate involved. Without the evidence of the invoice itself the line item appears fine.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales Price and Invoice Price do not agree

    Hi Konrad,

    If this is related to an intercompany transaction, can exchange rate differences be responsible for that?

    Have you checked that your ledgers still reconcile?

    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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
KP-31070522-0 Profile Picture

KP-31070522-0 3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans