Posting AP invoice different currency

(0) Share

Report

Posted on by Long.Thai

130

Dear experts,

I'm facing an error when posting AP Invoice. The company currency is SGD, the invoice is USD. It keeps showing 'The transaction on voucher XXX do not balance as per date...' when posting.

Currency exchange rates is already setup. Do I missed something?

Any supports would be appriciated.

Regards,

Long

All responses (11)

Answers (1)

Long.Thai 130 on at

Like (0)

Report

RE: Posting AP invoice different currency

Good morning Ludwig,

So sorry for late reply. After double checked at the parameters and deeply debugged, it turned out there was a customized condition when posting AP invoices.

Thanks a lot for your supports.

Best regards,

Long
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Posting AP invoice different currency

Good morning Long,

Have you double checked those parameter settings?

If the did not help, can you then possibly open a support request with the MS team to get this problem resolved for all users/companies that use AX2012 R3?

Many thanks and best regards,

Ludwig
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Posting AP invoice different currency

Hello Long,

Please check the following parameters:

1. GL parameters: penny difference settings

2. Currencies: The rounding rules that have been setup for the different currencies that you use.

Best regards,

Ludwig
Long.Thai 130 on at

Like (0)

Report

RE: Posting AP invoice different currency

Hello Ludwig,

Thanks for you response.

Im now using AX 2012 R3 CU13, I also have debug when posting journal, it was a system bug when validate BalanceRounding

Is there any parameters that I could be missed?

Best regards,

Long
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Posting AP invoice different currency

Hello Long,

What AX2012 version do you operate?

Are you on an older R3 or R2 version or do you have the very latest version deployed?

I am asking this because there are a number of hotfixes available for older AX2012 system that seem to be related to the things you mentioned and shared.

Can you have a look at LCS - probably together with a technical colleague - to check if the messages that you get are the result of a system bug?

Best regards,

Ludwig
Long.Thai 130 on at

Like (0)

Report

RE: Posting AP invoice different currency

Hello Ludwig,

Thanks alot for your response.

The exchange rate for USD - SGD is already set in General Ledger.

I've checked the offset Bank, it also has main account and currency is USD. Journal posting profile is 211-1100 which is already set in Vendor posting profile.

Do I miss something?

Best regards,

Long
Long.Thai 130 on at

Like (0)

Report

RE: Posting AP invoice different currency

Hello Kaushik,

Thanks for your response.

I've tried setting 0.01 in Maximum penny difference but its not worked, the error is still the same.

Do I miss something?

Regards,

Long
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Posting AP invoice different currency

Hi,

The payment is made in USD.

Do you have all the exchange rates for the USD setup?

If this is the case can you check whether the bank has a ledger account assigned and whether your vendor is assigned to a group that is setup in the vendor posting profile with a summary account configured?

Best regards,

Ludwig
Suggested answer

P.k.Kaushik 1,031 on at

Like (0)

Report

RE: Posting AP invoice different currency

Hello,

It seems the error comes at the time of settlement.

Please go to Accounts payable >> Setup >> Accounts payable parameter

Go to the settlement section and mention 0.01 in Maximum penny difference.

and then try to post.

Please perform the actions in test before doing it in PROD.

Thanks, Kaushik

This post is my own opinion and does not necessarily reflect the opinion or view of my company or Microsoft.
Long.Thai 130 on at

Like (0)

Report

RE: Posting AP invoice different currency

Hello Kaushik,

Thanks for your response.

The setup is already set in AX, I also attached some screenshots of my error

Thank you