Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

PO Invoice match variance error.

Posted on by

Hello experts.

I have an  invoice  where  the PO and the invoice are both in GBP for the exact GBP amount. But , the system is pulling a variance on the Price Totals match.

The exchange rate has increased since the PO was cut causing the USD equivalent to be higher on the invoice than it was when the PO was cut. Please suggest  a fix for resolving  the match variance?

Thanks

Mav

  • Suggested answer
    Mav Profile Picture
    Mav on at
    RE: PO Invoice match variance error.

    I was able to resolve it by customizing Vendinvoiceinfoline.ExtendedPriceVarianceAmountMST () to use exchange rate date that of purchtable   :-).

  • Mav Profile Picture
    Mav on at
    RE: PO Invoice match variance error.

    Has anyone build teh small customization , people talked about in this thread.

    If yes then please share details about that customization.

    community.dynamics.com/.../invoice-matching-problems-with-foreign-currency

  • Mav Profile Picture
    Mav on at
    RE: PO Invoice match variance error.

    I am the developer .

    BTW would you know what is small customization people were refering this thread which would fix this issue.

    community.dynamics.com/.../invoice-matching-problems-with-foreign-currency

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: PO Invoice match variance error.

    Hi Mav,

    Do you have a developer around who could take a look at this?

    Best regards,

    Ludwig

  • Mav Profile Picture
    Mav on at
    RE: PO Invoice match variance error.

    Hi Dr,

    Only difference i found was your line matching poilcy is set to not required vs mine which is 2 way matching. I changed that to not required like yours & when i see the invoice matching details unfortunately i still see the disabled checkbox and approver field same like i shared in my screen cap above.

    Thanks

    Mav

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: PO Invoice match variance error.

    Good Morning Mav, 

    I see. 

    I find it interesting that you don't see this checkbox to approve variances for posting. 

    Here are the settings that are made in my demo machine and that make the checkbox appear. 

    Probably compare it with what has been configured in your environment. 

    Best regards, 

    Ludwig

    apparam.png

    apparam2.png

  • Mav Profile Picture
    Mav on at
    RE: PO Invoice match variance error.

    Hi Dr,

    Yes I am Sys admin.

    Thanks

    Mav

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: PO Invoice match variance error.

    Hi Mav,

    What user roles do you have assigned?

    Are you a system admin?

    Best regards,

    Ludwig

  • Mav Profile Picture
    Mav on at
    RE: PO Invoice match variance error.

    Hi Dr,

    I do have employee record & in any case i will have to fix these old invoices. Please suggest a fix so that the checkbox is enabled & allow me to choose & approver & process the variance.

    Thanks

    Mav

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: PO Invoice match variance error.

    Hello Mav,

    Can you try and test this with a new and 'fresh' PO in your demo system?

    If the parameters are correctly set and if you are a user and employee in this system then you should be able to see and check the parameter.

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans