Add Amount Due (Foreign Currency) into Open Bills Report
Published on
December 27, 2023 at 7:50:32 AM PST December 27, 2023 at 7:50:32 AM PSTth, December 27, 2023 at 7:50:32 AM PST
Scenario:
In this article you can find alternate solution forEnhancement 121606. Currently, the Amount Due (Foreign Currency) for A/P Reports including the Open Bills Report is not available.
Solution:
- Navigate toReports>Vendors/Payables>Open Bills
- ClickCustomizebutton
- ClickEdit Columnstab
- ClickOpen Billsfolder
- ClickExchange Ratefield
- ClickAdd Formula Fieldbutton
- ClickFormulacolumn
- Column Label:EnterAmount Due (Foreign Currency)
- Formula type:SelectMultiply x*y
- x:SelectExchange Rate
- y:SelectAmount Due
- ClickOpen Billsfolder
- ClickCurrencyfolder
- ClickName
- ClickSave