Jcurve Support Articles / Order to Cash

Add Amount Due (Foreign Currency) into Open Bills Report

Written by
Junica Ann Capili
Published on
December 27th, 2023

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:

  1. Navigate toReports>Vendors/Payables>Open Bills
  2. ClickCustomizebutton
  3. ClickEdit Columnstab
  4. ClickOpen Billsfolder
  5. ClickExchange Ratefield
  6. ClickAdd Formula Fieldbutton
  7. ClickFormulacolumn
    • Column Label:EnterAmount Due (Foreign Currency)
    • Formula type:SelectMultiply x*y
    • x:SelectExchange Rate
    • y:SelectAmount Due
  8. ClickOpen Billsfolder
  9. ClickCurrencyfolder
  10. ClickName
  11. ClickSave
#Show Foreign Currency Amount in Open Bills Report
#Add Amount Due (Foreign Currency) into Open Bills Report
#Open Bills > Foreign Currency Amount
#Open Bill Transaction Amount in Foreign Currency
Jcurve Support Articles / Order to Cash