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.