Skip to Content

Multiple Account for exchange Rate Difference

Dear Experts,

I'm having below scenario :

1) My company's client is divided into two types of clients : Trade and Non-Trade

2) For each type, when it involve exchange rate gain/loss, we want to post it to different account

Example :

Trade Client : Loss Account = Account A

Gain Account =Account B

Non Trade Client : Loss Account = Account C

Gain Account =Account D

3) We are using standard G/L Account Determination, thus we only have one option for gain/loss account.

Currently we only can setup for Account A, and Account B, of course this setting will overwrite to Non Trade Client also.

4) Thus we are thinking to change our G/L setting to Advance G/L Account Determination because it is more flexible and we can group our account setting based on the determination criteria.

However, when we do testing, we only can find column 'Price Different Account' for exchange rate difference, but we have different account for gain/loss

We note that, if we left this blank, the setting will capture account based on the standard setting.

Any advise for this issue?

Thank you in advance

untitled.png (4.9 kB)
untitled.png (11.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jun 17, 2019 at 04:10 AM

    Dear MD Amall,

    You can achieve your scenario with advance GL account determination easily.


    Create Project or Cost centre as Trade and Non Trade coz based on that you can generate report to get that amount transaction wise.

    Hope above will work for you and test in in TEST DB first then only apply it in LIVE DB.

    Best Regards,

    Sandesh Shinde

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 24, 2019 at 08:17 PM


    Post gain and loss in one account and develop a report to segregate based on groups and other requirements then post it in to relevant GL accounts

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.