Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Foreign Currency Totals option is used to track AR/AP debt, credit and balance totals in transaction currency. This option is located under the Info menu of Accounts Receivable & Payable browser. In order to filter AR/AP transactions to display foreign currency totals, the followings filter values are set:

Filter

Value

Date Range

Start / End

Organizational Unit

Group / Range

Department

Group / Range

Transaction Currency Type

Currency Options

Transaction Type

Invoice / AR/AP Transaction / Check - P. Note / Bank Slip / Safe Deposit Slip / G/L Slip / Order

Order Type

Purchase Orders / Sales Orders

Invoices

Purchase Invoice / Retail Sales Return Invoice / Wholesale Return Invoice / Service Purchased Invoice / Purchase Return Invoice / Retail Sales Invoice / Wholesale Invoice / Service Sales Invoice / Due Date Difference Invoice (Issued) / Due Date Difference Invoice (Received) / Price Difference Invoice (Received) / Price Difference Invoice (Issued) / Asset Purchase Invoice / Asset Sales Invoice / Producer Invoice

AR/AP Slips

Opening / Collection / Payment / Daily-Journal / Exchange Rate Difference / Credit Card / Credit Card Return / Tradesman Invoice (Received) / Tradesman Invoice (Issued) / Company Credit Card / Company Credit Card Return

Bank Slips

Opening / Collection / Payment / Daily-Journal / Conversation Letter (For Purchase) / Conversation Letter (For Sales) / Service Purchased Invoice / Service Sales Invoice / Exchange Rate Difference

Slips

Check Received / Promissory Notes Received / Check Issued (to AR/AP) / Promissory Note Issued (to AR/AP)


Date Range filter line is used to determine the date range of transactions of which foreign currency total will be calculated.
Slip type filter lines are used to determine the relevant slip types of which foreign currency total will be calculated.
After setting the filter values, click on the "Apply" button. Values of the relevant transactions complying with the filter values are added up in foreign currency, a separate line is generated for each transaction currency type (including Local Currency) in Foreign Currency Totals window.