Thursday, June 27, 2019

Show Exact Exchange Rate Values on Financial Reports

As an alternate solution, users may follow the steps below:

1. Navigate to Reports > Financial > Balance Sheet > Detail > Customize.

2. Go to Edit Columns page.

3. Expand Financial folder and add the field Amount (Foreign Currency)

4. Add Formula Field

---> In the new column added > make sure it is highlighted

---> Below it, look for 'Formula Type' field > choose Ratio (x/y)

---> Where X = Amount; & Y = Amount (Foreign Currency)

---> Change the Label of the column

4) Click Save or Preview.

No comments:

Post a Comment