The report option used to list AR/AP debit and credit totals within specific dates. The report is located in the AR/AP reports menu of the Finance section. Start and end dates are entered on the Date Range filter line, and totals between these dates are listed. The filter options are:
Filter | Value |
|---|---|
Group Company Transaction | Yes / No /All |
Listing | By Code / By Title |
AR/AP Code | Group / Range |
AR/AP Title | Group / Range |
AR/AP Status | Active / Passive |
AR/AP Aux. Code 1-5 | Group / Range |
AR/AP Auth. Code | Group / Range |
AR/AP G/L Code | Group / Range |
AR/AP Consolidation Code | Group / Range |
AR/AP Consolidation Description | Group / Range |
Trading Group | Group / Range |
Group Company Code | Selection from list |
Record Type | Customer / Vendor / Customer + Vendor |
Division Number | Defined divisions |
Department Number | Defined departments |
Slip Document No. | Group / Range |
Date Range | Start / End |
Invoice Status | Actual / Proposal |
Invoices | (31) Purchase Invoice / (32) Retail Sales Return Invoice / (33) Wholesale Return Invoice / (34) Service Purchase 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/ 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) |
Slips | Not Cancelled / Cancelled / All |
Orders | Sales Orders / Purchase Orders |
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 |
Debt Balance Range | Amount range entry |
Credit Balance Range | Amount range entry |