Announcements
No record found.
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
Hello,
In a test environment please Go to General Ledger >> Setup >> Ledger
Make sure the exchange rate types are defined.
Review the exchange rate types and make sure exchange rate for USD-SGD pair exist
Also setup a rounding of 0.01 in General ledger parameters
Try to post.
Thanks, Kaushik
This post is my own opinion and does not necessarily reflect the opinion or view of my company or Microsoft.
Hello Kaushik,
Thanks for your response.
The setup is already set in AX, I also attached some screenshots of my error
Thank you
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.
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
I've tried setting 0.01 in Maximum penny difference but its not worked, the error is still the same.
Do I miss something?
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.
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?
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?
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.
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,
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 657
André Arnaud de Cal... 615 Super User 2026 Season 1
CP04-islander 356