The report option used to list AR/AP transactions along with transaction types and daily totals in specified f. currency. In report, check and p. notes' exchange rate revenues and expenditures are listed too. The report is located in the AR/AP reports menu of the Finance section. The filter options are:
Filter | Value |
|---|---|
AR/AP Code | Group / Range |
AR/AP Title | Group / Range |
AR/AP Status | Active / Passive |
AR/AP Aux. Code | Group / Range |
AR/AP Auth. Code | Group / Range |
AR/AP Trading Group | Group / Range |
Group Company Code | Select from list |
Listing | By Code / By Description |
Record Type | Customer / Vendor / Customer + Vendor |
Debit Balance Range | Start / End |
Credit Balance Range | Start / End |
Risk Total | Start / End |
Division Number | Defined divisions |
Department Number | Defined departments |
Slip Detail | Yes / No |
Date Range | Start / End |
Invoice Status | Actual / Proposal |
Slip Status | Actual / Proposal |
Check / P.Note Slips | Checks Received / P.Notes Received / Checks Issued (To AR/AP) / P.Notes Issued (To AR/AP) |
Invoices Related To Order (Prepayment) | List / Do Not List |
Slips | Not Cancelled / Cancelled / All |
Accounts Without Balance | List / Do Not List |
Page Setup | Same Page / Different Pages |
Transaction Trading Group | Group / Range |
Currency Type | Currency options |
Balance Type | Debit / Credit / Debit + Credit |
Valuation Exchange Rate | Exchange Rate on Reporting Date / Exchange Rate on Reporting / Exchange Rate on Transaction Date |
Report Exchange Rate | Data entry |
Current Account Details Total | Yes / No |
Local Currency Check Valuation | By Reporting Currency / By Valuation F. Currency |
Checks Issued (Not Collected) will not be Valuated | Yes / No |
By which f. currency type will the report be taken, is specified in F. Currency Type filter line and exchange rate info is specified in Valuation Exchange Rate line.
Valuation Exchange Rate line includes 3 options:
- Exchange Rate on Reporting Date: The f. currency type specified in "AR/AP slips" field of f. currency usage parameters is considered. The currency type's exchange rate in the date when report has been taken is considered for valuation.
- Exchange Rate on Reporting: After report exchange rate is activated, the entered exchange rate is considered for valuation.
- Exchange Rate on Transaction Date: Valuation is done by considering exchange rate in transaction date.
Checks and P.Notes
In the report, checks and p.notes are valuated separately.
- Collected Check / P.Notes: The exchange rate in collection date is considered.
- Check / P.Notes Not Collected: The exchange rate in report date is considered. Valid for "At Portfolio", "Endorsed", "To Collateral", "Issued for collection by the bank" and "Irrevocable" status check and p.notes.
- NSF Checks / P.Notes: The exchange rate in transaction date is considered. Valid for "NFS", "Returned" and "Protested" check and p.notes.
- Endorsed Checks / P.Notes: If endorsed checks and p.notes have not been collected, the exchange rate in report date is considered. If they have been collected, exchange rate in transaction date is considered.
In the event of approving slip detail filter line, as well as check/p.note exchange rate revenues and expenses, outstanding check/p.note totals are listed too.
When "By Valuation F. Currency" option is selected in "Local Currency Check Valuation" filter line, the valuation is done by considering the specified currency type and its exchange rate in check/p.note slips.
Checks Issued (Not Collected) will not be Valuated: This filter line is used to determine whether the issued checks will be valuated in report or not. When "Yes" is selected, the uncollected issued checks are listed as "TL" in report. When "No" is selected, the uncollected checks are valuated according to the exchange rate when the checks are entered. If checks are issued to AR/AP, they are valuated according to the exchange rate of the slip.