AR/AP Extract report is used to list AR/AP transactions together with transaction types and daily totals. Additionally, analysis dimension and project detail information, which is defined in the system regarding all source operations within the scope of the report, are also listed. Analysis dimension and project details of the source slips to which payment / collection transactions are related along with the analysis dimension and project details, which are defined for the source slips that close payment / collection transactions, are also included in this report.
Transactions of each AR/AP record are listed separately in AR/AP Extract. You can set filters to determine the scope of transactions to be listed in the report. In addition to the transaction amounts, the last debt or credit (depending on the operation) balance total is also shown.
If you set Order Detail filter to "Yes", order lines are listed. If you run the report after setting "Analysis Dimension Code", "Analysis Dimension Description", "Project Code", "Project Description", "Project Activity Code", "Project Activity Description" filters, report lists only the relevant AR/AP operations, which have lines that are distributed to the specified analysis dimension - project - project activities.
The specified filters apply to the main transactions of the AR/AP only; they will not filter the source transactions of closed transactions. If you set Analysis Details filter to "Yes", analysis details of the main and closed AR/AP transactions are shown. If the source slip is an invoice, order or check / p. note slip and "Invoice Detail", "Order Detail", and "Slip Detail" filter values are set to Yes, source slip lines are listed. Analysis details, which are defined in the specified type of slips, are shown in this case only. If the source slip type is not one of the specified types, only the analysis detail lines of the relevant AR/AP transaction slip line are shown.
AR/AP Extract filter options are as below:
Filter | Value |
Sorting | By Material Code / By Material Description |
AR/AP Code | Group / Range |
AR/AP Title | Group / Range |
AR/AP Status | Active / Inactive |
AR/AP Aux. Code (1 - 5) | Group / Range |
AR/AP Auth. Code | Group / Range |
AR/AP Trading Group | Group / Range |
Contract No | Group / Range |
Record Type | Vendor / Supplier / Customer + Supplier / Association |
Debit Balance Rate | Balance range |
Credit Balance Rate | Balance range |
Risk Total | Data entry |
Slip Numbers | Group / Range |
Invoice Detail | Yes / No |
Slip Detail | Yes / No |
Order Detail | Yes / No |
List Collateral Transaction | Yes / No |
Slip Doc. No | Group / Range |
Date Range | Date Entry |
Transaction Type | Dispatch-Receipt / Invoice / AR/AP Transactions / Check-P.Note / Bank Slip / Safe Deposit Slip / G/L Slip / Letter of Guarantee / Order |
Order Type | Purchase Order / Sales Order |
Invoices | Purchase Invoice / Retail Sales Return Invoice / Wholesale Return Invoice / Service Purchases Invoice / Purchase Return Invoice / Retail Sales Invoice / Wholesale Invoice / Service Sales Invoice / Due Date Diff. Invoice (Issued) / Due Date Diff. Invoice (Received) / Price Diff. Invoice (Received) / Price Diff. Invoice (Issued) / Asset Purchase Invoice / Fixed Asset Sales Invoice / Producer Invoice |
AR/AP Slips | Slip types |
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 | Check / P.Note slips |
AR/AP Transaction 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 |
Order Slip Aux. Code | Group / Range |
Page Setup | Same Page / Different Page |
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 | Multiple selection |
Line Related Org. Unit | Group / Range |
Department | Defined departments |
Page No. | Increasingly / AR/AP Dependent |
Analysis Details | Yes / No |
Analysis Dimension Code | Group / Range |
Analysis Dimension Description | Group / Range |
Project Code | Group / Range |
Project Description | Group / Range |
Project Activity Code | Group / Range |
Project Activity Description | Group / Range |
List Those Affecting Totals | Yes / No |