The option used to list Debit, Credit and Balance totals of the AR/AP transactions, along with transaction information. The option is located in the right mouse button menu of the AR/AP window. The conditions to be applied for extract generation are specified on the AR/AP extract filter list accessed by clicking the Filters option located on the AR/AP extract window. The AR/AP extract filter options are:
Filter |
Value |
Division Number |
Defined divisions |
Department Number |
Defined departments |
Slip Numbers |
Group / Range |
Invoice Detail |
Yes / No |
Slip Detail |
Yes / No |
Order Detail |
Yes / No |
Slip Document No. |
Group / Range |
Date Range |
Start / End |
Transaction Type |
Inventory Transactions / Promotion Transactions / Deposit Transactions / Service Transactions / Mixed Case Transactions / Fixed Asset Transactions / Optional Material Transactions / Material Class Transactions / Subcontracting Transactions |
Invoice Status |
Active / Passive |
Invoices |
Purchase Invoice / Retail Sales Return Invoice / Wholesale Return Invoice / Service Purchased Invoice / Purchase Return Invoice / Wholesale Invoice / Retail Sales Invoice / Service Sales invoice / Purchase Price Diff. Invoice / Sales Price Diff. Invoice / Producer Invoice |
Slip Status |
Actual / Proposal |
AR/AP Slips |
Cash Collection / Cash Payment / Debit Note / Credit Note / Remittance Slip / Exch. Rate Diff. Transaction / Special Slip / Opening Slip / Sales Due Date Diff. Invoice / Purchase Due Date Diff. Invoice / Credit Card Slip / Credit Card Return Slip |
Bank Slips |
Money Orders (Received) / Money Orders (Issued) / Conversion Letter (For Purchase) / Conversion Letter (For Sales) / Service Purchases Invoice / Service Sales Invoice |
Slips |
Checks Received / P. Notes Received / Check Issued (To AR/AP) / P. Note Issued (To AR/AP) |
Orders |
Sales Orders / Purchase Orders |
Invoices Related to Order (Prepayment) |
List / Do Not List |
Slips |
Not Cancelled / Cancelled / All |
AR/AP Transactions Aux. Code |
Group / Range |
AR/AP Slip Aux. Code |
Group / Range |
AR/AP Slip Auth. Code |
Group / Range |
Bank Money Order Aux. Code |
Group / Range |
Invoice Aux. Code |
Group / Range |
Slip Aux. Code |
Group / Range |
Transaction Currency Type |
Currency options |
Salesperson Code |
Group / Range |
Salesperson Name |
Group / Range |
Salesperson Position Code |
Currency options |
Payment Plan Detail |
Yes / No |
Transaction Trading Group |
Group / Range |
Project Code |
Group / Range |
Project Description |
Group / Range |
Revaluation of Checks in F. Currency |
Yes / No |
Group Company List |
Yes / No |
Transfer Check Notes Will Be Listed |
Yes / No |
Currency-Linked Check Notes |
As Local Currency / Linked Currency Type |
Credit Card Slip Lines |
Will be listed / Will not be listed |
Summary Carried Forward |
Will be listed / Will not be listed |
If invoice and slip line information is required to be included in the extract, "Yes" should be selected on the Invoice Detail and Slip Detail filter lines.
When the AR/AP extract is generated using invoice detail, all transactions on the invoice line are separately listed under the relevant transaction line with Code, Description, Quantity and Unit Price information.
The selection made on the Transaction Currency Type filter lines allows the AR/AP extract to be listed by including transactions performed with a specific transaction currency. Required currency types are checked on the transaction currency type list. All currency types are selected as default in the application.
Summary Carried Forward: When AR/AP extract is taken according to a date range, this filter must be selected as "Will not be listed" if summary carried forward is not required in the extract.
Once the extract is generated after setting conditions, AR/AP transactions within the given date range are listed with the following information:
- AR/AP Code
- Description
- Risk Limit
- Date
- Slip No.
- Slip Type
- Document No.
- Debit
- Credit
- Balance
- Reporting Currency Amount
- Reporting Currency Balance
- Transaction Currency
- Transaction Currency Amount
- Division Number
- Department Number
- Auth. Code
- Aux. Code
Totals of AR/AP transactions are displayed at the bottom of the extract.