- Customize the Open Purchase Orders Report.
- On the Edit Columns tab> Add Fields section, expand the Open Purchase Orders group and add the Exchange Rate field.
- On the Edit Columns tab> Add Fields section, click on the Add Formula Field button.
- Click the pencil icon for the Formula column, and set the following values:
- Formula Type = Ratio x/y
- x = Current Amount
- y = Exchange Rate
- The Formula column would then show the Open Amount which is based on Transaction Currency.