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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Dale Coulthard 3,055 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Dale Coulthard 3,055 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

anybody please help

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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............

Was this reply helpful? Yes No
Suggested answer

Dale Coulthard 3,055 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Some body please help.....

Was this reply helpful? Yes No