web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Posting AP invoice different currency

(0) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • Suggested answer
    P.k.Kaushik Profile Picture
    1,031 on at

    Hello,

    In a test environment please Go to General Ledger >> Setup >> Ledger 

    Make sure the exchange rate types are defined.

    pastedimage1591166629141v1.png

    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

    pastedimage1591166866121v2.png

    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.

  • Long.Thai Profile Picture
    130 on at

    Hello Kaushik,

    Thanks for your response.

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

    0447.png

    1325.png

    1134.png

    6116.png

    2543.png

    Thank you

  • Suggested answer
    P.k.Kaushik Profile Picture
    1,031 on at

    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.

     

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    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

  • Long.Thai Profile Picture
    130 on at

    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

  • Long.Thai Profile Picture
    130 on at

    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.

    2112.png

    Do I miss something?

    Best regards,

    Long

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    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 Profile Picture
    130 on at

    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

    4532.png

    Is there any parameters that I could be missed?

    Best regards,

    Long

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 657

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 615 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 356

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans