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 |