Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Bank Management bank G...

Bank Management bank GL accounts Revaluation

(0) Share

Report

Posted on by Romryan

Dear All,

How are the foreign bank accounts revalued so that the differences experienced during bank reconcilliation between Cash book and GL are well represented. Cashbook is always in Foreign currency but GL is in local currency in the bank reconciliation window option on bank management. If you divide lcy (GL amount) with fcy (cashbook amount) the resultant amount is not equal to the prevailing monthly exchange rate in the system.

RomRyan

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Bank Management bank GL accounts Revaluation

Does anybody have any suggestions on this topic. This is something I am stuck on.

I have run revaluation for AR & AP using the Multicurrency Revaluation tool for Sales and Purchased in the Series drop down.

When I do this for Financial drop down I was assuming this would pick up my Bank accounts in Euro and USD (functional currency is GBP).

Essentially I have too much GBP value cash in my TB based on the month-end exchange rate. Surely there must be a way of revaluing Bank accounts in a similar way to AR & AP.

Kind regards,

Lee
Romryan on at

Like (0)

Report

RE: Bank Management bank GL accounts Revaluation

any idea please