Extract is the option used to list Debit, Credit and Balance totals of the AR/AP transactions, along with transaction information. This option is located under the Info menu of the AR/AP browser.
The Extract (Group) option lists the debit, credit and balance totals of AR/AP records with parent level connections. This option is located under the Info menu of the AR/AP List.
In both cases, the AR/AP Extract Filters window is used to specify the extract conditions. The AR/AP Extract filter options are:
Filter | Value |
|---|---|
Group Detail | Yes / No |
Contract No | Selection from Contracts browser |
Debit Balance Range | Amount entry |
Credit Balance Range | Amount entry |
Risk Total | Amount entry |
Slip Numbers | Group / Range |
Invoice Detail | Yes / No |
List Collateral Transaction | |
Slip Document No. | Group / Range |
Date Range | Start and End |
Transaction Type | Dispatch / Receipt / Invoice / AR/AP Transaction / Check - Promissory Note / Bank Slip / Safe Deposit Slip / G/L Slip / Order |
Order Type | Purchase Order / Sales Order |
Invoices | Purchase Invoice / Retail Sales Return Invoice / Wholesale Return Invoice / Service Purchase Invoice / Purchase Return Invoice / Retail Sales Invoice / Wholesale Invoice / Service Sales invoice / Due Date Diff. Invoice (Issued) / Due Date Diff. Invoice (Issued) / Price Diff. Invoice (Received) / Price Diff. Invoice (Issued) / Asset Purchase Invoice / Fixed Asset Sales Invoice / Producer Invoice |
AR/AP Slips | Opening / Collection / Payment / Daily/Journal / Exch. Rate Difference / Inflation Accounting / Closing / Credit Card / Tradesman Invoice (Received) / Tradesman Invoice (Issued) / Credit Card Return / Company Credit Card / Company Credit Card Return |
Bank Money Orders | Check/P.Note Group Processing Slip / Opening / Collection / Payment / Daily/Journal / Service Purchased Invoice / Service Sales Invoice / Credit Card / Credit Card Return / Company Credit Card / Company Credit Card Return |
Slips | Checks Received / P. Notes Received / Check Issued (To AR/AP) / P. Note Issued (To AR/AP) |
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 types |
Transaction Trading Group | Group / Range |
Balance Type | Debit / Credit / Debit+Credit / All |
Slip Status | Unapproved / Approved / G/L Approved / Cancelled |
Payment Plan Detail | Yes / No |
Total of Due Date | Yes / No |
Org. Unit | Defined departments |
Department | Defined departments |
Page No | Increasingly / AR/AP Dependent |
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.
Once the extract is generated after setting conditions, AR/AP transactions within the given date range are listed with Date, Slip Type, Slip Number, Document Number, Description, Debit, Credit, Balance, Corresponding Account, Reference Number, Reporting Currency Amount, Transaction Currency and Transaction Currency Amount column information.