cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple Account for exchange Rate Difference

former_member419030
Active Participant
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member225732
Contributor

Dear MD Amall,

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

Else,

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

former_member419030
Active Participant
0 Kudos

Dear Sandesh,

Thank you for your suggestion.

Then, how im going to differentiate the account for loss and gain exchange rate?

As per my checking, in advance GL, we dont have separate account for gain and loss right?

Abdul
Active Contributor
0 Kudos

Dear

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

former_member419030
Active Participant
0 Kudos

Dear Abdul Mannan,

Thank you for your response.

Can you help explain with one sample?Thank you