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) / Price variance in acco...
Microsoft Dynamics AX (Archived)

Price variance in accounting distribution (PO Invoice)

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

Do anyone know why there is price variance in the accounting distribution when posting the PO invoice?

This happened for partial invoice. So when we try to post the second invoice for the PO, we there will be price variance with the same amount as first invoice.

Example :

The quantity in the PO line : 100 unit

Unit price : USD 3.00

Invoice 1 :

Quantity : 25 Unit

Net amount : 25 * 3 = USD 75

Invoice 2 :

Quantity : 75 Unit

Net amount : 75 * 3 = USD 225

But in the accounting distribution for the invoice 2, there is price variance with amount USD 75.

Do anyone know why there is price variance for this case?

Thanks,

Jimmi

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Price variance in accounting distribution (PO Invoice)

    Good morning Jimmi,

    In this case I would suggest that you contact the MS Support Team then. There are some other hotfixes that might fit but rather than testing around I believe they can help you much faster. Probably they already know ...

    Would be great to keep the community updated here.

    Many thanks and all the best,

    Ludwig

  • Community Member Profile Picture
    Community Member on at
    RE: Price variance in accounting distribution (PO Invoice)

    Hi Ludwig,

    We have applied the hotfix  and the hotfix doesn't fix the issue.

    We are still looking for the problem now and will update if we find the problem. Thanks.

    Regards,

    Jimmi

  • Community Member Profile Picture
    Community Member on at
    RE: Price variance in accounting distribution (PO Invoice)

    Hi Ludwig,

    Okay, I will update you once we finish apply the hotfix.

    Thanks for your help.

    Thanks,

    Jimmi

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Price variance in accounting distribution (PO Invoice)

    Hello Jimmi,

    Would be great if you could keep us updated on that issue.

    Many thanks and all the best,

    Ludwig

  • Community Member Profile Picture
    Community Member on at
    RE: Price variance in accounting distribution (PO Invoice)

    Hi Ludwig,

    Thanks for your information.

    I'll asked my technical team for this and see if it is working or not.

    Hopefully this can fix my issue.

    Once again, thanks for your help.

    Thanks,

    Jimmi

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Price variance in accounting distribution (PO Invoice)

    Hello Jimmi,

    According to this site (community.dynamics.com/.../overview-of-microsoft-dynamics-ax-build-numbers) your AX Version is from November 2013.

    I believe this is the reason why you get this strange behavior. In early 2014 a hotfix (KB2950163 "Incorrect line distributions during the partial invoicing of the purchase order") has been released that seems to fix the very problem you report.

    MS does not suggest implementing single Hotfixes but rather the whole CU package. So I would suggest that you talk with one of your developers on whether or not you upgrade to the latest CU for AX2012 R2 or whether they will try installing this single hotfix.

    All the best,

    Ludwig

  • Community Member Profile Picture
    Community Member on at
    RE: Price variance in accounting distribution (PO Invoice)

    Hi Ludwig,

    I am using AX 2012 R2 CU 7 (6.2.1000.4051).

    I haven't check in LCS as I want to know first what is the price variance in accounting distribution. Thanks..

    Thanks,

    Jimmi

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Price variance in accounting distribution (PO Invoice)

    Hello Jimmi,

    On what AX2012 System are you running?

    I cannot replicate the issue in my demo system

    Have you checked LifeCycle Services for an available hotfix?

    Ludwig

  • Community Member Profile Picture
    Community Member on at
    RE: Price variance in accounting distribution (PO Invoice)

    Hi Ludwig,

    We don't setup the purchase price in the released product form.

    And the item using the item model group with below setup :

    Stock : Ticked

    Post physical & financial inventory : Not ticked

    Accrue liability : Ticked

    Inventory model : FIFO

    And I have tried to split the invoicing to 3 part like you suggested and I got below result :

    Invoice 1 :

    Quantity : 25 Unit

    Net amount : 25 * 3 = USD 75

    Invoice 2 :

    Quantity : 70 Unit

    Net amount : 70 * 3 = USD 210

    Invoice 3 :

    Quantity : 5 Unit

    Net amount : 5 * 3 =  USD 15

    And now there is no price variance for invoice 2. But in invoice 3, there is price variance in the accounting distribution like below :

    Net amount : 15.00 USD

       Extended price : 300.00 USD

       Price variance : -285.00 USD

    Somehow, the variance only show up when I try do post invoice for the remaining amount of the PO.

    Thanks,

    Jimmi

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Price variance in accounting distribution (PO Invoice)

    Hello Jimmi,

    How is your item setup? I mean what cost price & purchase price is setup in the released product form?

    Have you tested what happens if you split up the invoicing into 3 parts lets say with invoice 1 for 75$, invoice 2 for 200$ and invoice 3 for 25$. What variance do you see then?

    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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August 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
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans