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.