Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Transaction currency id and check book currency id are not the same

Posted on by Microsoft Employee

I am getting an error"Transaction currency id and check book currency id are not the same" when i go to "Cahs reciept entry" and adding a check amount in dollar to our KD check book id... ..Please help me.... I am able to save , If i select payment method "cash"....

 

 

 

*This post is locked for comments

  • Suggested answer
    Dale Coulthard Profile Picture
    Dale Coulthard 3,055 on at
    Re: Transaction currency id and check book currency id are not the same

    It appears that you are in a test company (the company name is only partially showing in your screen shot, but I think it says TEST).  So, has multicurrency (ie, USD and the associated Exchange Table ID) been assigned to that company (Tools>Setup>System>Multicurrency Access)?

    If USD and the associated exchange table id has been assigned, then I do not know where else to look for the problem you are experiencing.

    One other thought, have you tested the payables side and have the same error message (ie, try to pay a vendor in USD against NBK-KWD) ?

    Best regards,

    Dale

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Transaction currency id and check book currency id are not the same

    Thank you very much for your reply.

    1)

    a) Check book currency id is KWD(Kuwait dinar)

    b) Functional Currency id is same (KWD)

    2) USD is assigned to to all of our accounts

  • Verified answer
    Dale Coulthard Profile Picture
    Dale Coulthard 3,055 on at
    Re: Transaction currency id and check book currency id are not the same

    1) You are posting USD.

              a) What is the currency of the checkbook?

              b) What is the functional currency of the company?

    2) Have you assigned USD to the g/l the checkbook is assigned to (Cards>Financial>Account Currencies)?

    Best regards,

    Dale

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Transaction currency id and check book currency id are not the same

    anybody please help

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Transaction currency id and check book currency id are not the same

     

    Plse see above image. I am getting this message When ever 'Currency ID' and 'Check Book ID'  currencies are not matching.But i wanted to save not matching currency also.Please help............

  • Suggested answer
    Dale Coulthard Profile Picture
    Dale Coulthard 3,055 on at
    Re: Transaction currency id and check book currency id are not the same

    First, do you have multicurrency ability with GP?  If so, is the currency id for the checkbook the same as the company's functional currency?  If it is, I would assume there is a setup issue related to the currency for the cash received.

    If the checkbook currency is different from the company's functional currency and the cash being received is different from the functional, then I am unaware of a direct way to get it posted. I am in the US and my company's functional currency is the USD.  If I have a Canadian bank account and that account receives Euros, I am unaware of any way to get the Euro posted directly to the CDN account because GP does not have the ability to convert Euros to CDN then convert the CDN to USD for functional reporting purposes.  What I have to do is enter a cash receipts through a bank transaction (I am on GP 9, so I would go through Transactions>Financial>Bank Transaction, then enter a receipt in CDN (for what the bank gave you in equivalent CDN dollars- I enter a note explaining why I am entering the cash at the bank level instead of the subledger level) and offset this to an account that I can zero out.  I then go to the subledger (for me, it would be sales side, but not sure if that is what is happening with the transaction you have), I would then go to the customer and enter a credit memo for the Euro amount they paid and offset that credit to the same account as the cash transaction (at the sales level, I also enter a note to fully explain why I had to enter a credit memo for the cash paid instead of a cash entry at the sales level). Most likely, this will create a foreign exchange gain/loss in the wash account which I then have to do a general ledger entry to zero out and move the gain/loss to the income statement account we use for capturing foreign exch gain/losses.

    Not sure if I have helped any.  Good luck.

    Dale

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Transaction currency id and check book currency id are not the same

    Some body please help.....

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans