The report option used to list AR/AP transactions along with transaction types and daily totals. The report is located in the AR/AP reports menu of the Finance section.
The AR/AP extract list the transactions of each AR/AP separately. The last debit or credit balance is also displayed next to the transaction amounts on the extract depending on the transaction type. The filter options are:
Filter | Value |
---|---|
AR/AP Code | Group / Range |
AR/AP Title | Group / Range |
AR/AP Title 2 | Group / Range |
AR/AP Status | Active / Passive |
AR/AP Aux. Code 1-5 | 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 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 | Actual / Proposal |
Invoices | (31) Purchase Invoice / (32) Retail Sales Return Invoice / (33) Wholesale Return Invoice / (34) Services Purchased Invoice / (36) Purchase Return Invoice / (37) Retail Sales Invoice / (38) Wholesale Invoice / (39) Service Sales invoice / (43) Purchase Price Diff. Invoice / (44) Sales Price Diff. Invoice / (56) Producer Invoice |
Slip Status | Actual / Proposal |
AR/AP Slips | (1) Cash Collection / (2) Cash Payment / (3) Debit Note / (4) Credit Note / (5) Remittance Slip / (6) Exch. Rate Diff. Transaction / (12) Special Slip / (14) Opening Slip / (41) Sales Due Date Diff. Invoice / (42) Purchase Due Date Diff. Invoice / (70) Credit Card Slip / (71) Credit Card Return Slip |
Bank Slips | (20) Money Orders (Received) / (21) Money Orders (Issued) / (24) Conversion Letter (for Purchases) / (25) Conversion Letter (for Sales) |
Slips | (61) Checks Received / (62) P. Notes Received / (63) Check Issued (To AR/AP) / (64) 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 |
Accounts Without Balance | List / Do Not List |
Page Setup | Same Page / Different Pages |
Transaction Currency Type | Currency options |
Salesperson Code | Group / Range |
Salesperson Name | Group / Range |
Salesperson Position Code | Group / Range |
Route Code | Group / Range |
Payment Plan Detail | Yes / No |
Transaction Trading Group | Group / Range |
Balance Type | Debit / Credit / Debit + Credit |
Project Code | Group / Range |
Project Description | Group / Range |
Reevaluation 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 |
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.