Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
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

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans