PO Invoice match variance error.

(0) Share

Report

Posted on by Mav

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

I have the same question (0)

All responses (13)

Answers (0)

Mav on at

Like (0)

Report

I found the solution here can anyone please share details of this proposed customiation which solves this issue , as suggested in below link.

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Mav,

In your AP parameters there is one that is called post invoice with discrepancies.

You can find this one in the invoice validation tab.

If you set it to 'require approval' then you should be able to see an approval checkbox in the invoice matching details form that allows you getting this approved and posted.

Please see the next screenprint for details.

Have you checked this functionality and whether it helps overcoming your issue?

Best regards,

Ludwig

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

Hi Dr,

I can see the approval checkbox with check in it appearing after changing in AP parameter from warning to require approval, however checkbox it is disabled , i.e. i cannot uncheck the box or choose approver.

Do i need to add myself to some user group for this.

Thanks

Mav

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mav,

What user roles do you have assigned?

Are you a system admin?

Best regards,

Ludwig

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

Hi Dr,

Yes I am Sys admin.

Thanks

Mav

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mav,

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

Best regards,

Ludwig

Was this reply helpful? Yes No