Adjust exchange Rate with Dimensions

(0) Share

Report

Posted on by Ola Darwish

915

I was Just wondering if someone succeeded in making the adjust exchange routine create a transaction that has dimensions.

so for example if I have a currency EUR linked to an FX account that would require a dimension as mandatory. so the transaction generated from adjust exchange routine would tag the FX account and the dimension attached to that account. ideally i would want it to get the dimensions from the original transaction that has been revaluated. but that didnt work. so i tried to fix the dimension on the FX account. still didnt work. it only worked when i removed all dimension mandatory requirements on the FX account.

is there a setup that i need to do, did anyone customize it if its not available out of the box?

Thanks

Ola

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

Ola,

If I run the Adjust Exchange Rate function, the adjustment entries are assigned from the Customer or Vendor Ledger entries. Bank Account adjustments use the default Bank Account dimensions. I am guessing that your original entries where EUR and transaction posted in the EUR currency on the Customer Ledger Entry, for example?

Check your Customer and Vendors and I would test a transaction again. My Cronus database posts correctly.

The last 4 pics is me setting the Exchange Rate for EUR = .90 and running the Adjust Exchange Rate.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
Ola Darwish 915 on at

Like (0)

Report

Thanks Steve for your response

I will try again, but just to confirm. do you have the accounts 8100, 80800, 81100 and 80900 setup with mandatory dimension code?

cause this is the error I'm getting. its on the FX accounts setup on the currency.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hello,

Yes, I setup accounts 80800, 80900, 81000, 81100 with a Department Dimension Code and Code Mandatory.

Steve

Was this reply helpful? Yes No
Ola Darwish 915 on at

Like (0)

Report

Perfect. looks like i missed something when I tried

does it take the code from the transaction that its calculating the unrealized FX for , or from the customer or vendor dimension default

so if Customer ABC has 2 invoice

invoice 1 has department value -sales

invoice 2 has department value - service

and unrealized gain or loss for invoice 1 is $3

and unrealized gain or loss for invoice 2 is $1

Then the $3 will be booked against account 80800 department value Sales

and the $1 will be booked against account 80800 department value Service ?

sorry for the many questions, but just trying to understand how it works so I can troubleshoot what i missed

Was this reply helpful? Yes No
Ola Darwish 915 on at

Like (0)

Report

Hi Steven,

I tried it again now and I know what was causing the issue. some of my transactions didnt have dimension values so it was holding up the revaluation and FX gain or loss for all the other transactions. As soon as set the filters only to grab the transactions that I'm sure they have transactions. I stopped getting the issue that it cant find the mandatory code for the FX account.

Thank you so much for your help

Ola

Was this reply helpful? Yes No