Customer Balances
View balance, document, and transaction information for a customer. You can filter by a specific document or within a date range.
In this topic:
Enter Customer Details
Set the customer criteria for the data you want to display in the Transactions grid.
Customer ID: Select the customer ID.
Document Date From, To: Set the date range for the documents you want to display balances for in the grid.
Include Activity From: Select an AR code. The columns that display in the Transactions grid depend on the code you select here.
See here for AR codes and their corresponding columns
|
AACT: All Activity
|
Document Number: The invoice document number |
| Document Date: The session date specific to this document | |
| Due Date: The due date | |
| Document Description: The description entered on the transaction entry form | |
| Original Amount: The original amount due to the vendor | |
| Outstanding Balance: The outstanding amount due to the vendor | |
|
OARB: Open A/R Invoices
|
Invoice/Credit Number: The number assigned to the invoice or credit |
| Invoice/Credit Date: The date of the invoice or credit | |
| Due Date: The due date | |
| Invoice/Credit Description: The description entered for the invoice or credit | |
| Original Amount: The original amount due from the customer | |
| Outstanding Balance: The outstanding amount due from the customer | |
|
AARB: All A/R Invoices
|
Invoice/Credit Number: The number assigned to the invoice or credit |
| Invoice/Credit Date: The date of the invoice or credit | |
| Due Date: The due date | |
| Invoice/Credit Description: The description entered for the invoice or credit | |
| Original Amount: The original amount due from the customer | |
| Outstanding Balance: The outstanding amount due from the customer | |
|
ARM: A/R Credits
|
Credit Number: The number assigned to the applied credit |
| Credit Type: The credit type of Applied Credit, Prepayment, or On Account displayst | |
| Date: The session date specific to this document | |
| Description: The description entered for the credit, receipt, or deposit | |
|
Amount: The credit, receipt, or deposit amount |
|
|
ARC/ARP: A/R Payments Received
|
Receipt Number: The number assigned to the receipt |
| Deposit Number: The number assigned to the deposit | |
| Date: The session date specific to this document | |
|
Status: The check or voucher status |
|
| Description: The description entered for the credit, receipt, or deposit | |
| Amount: The credit, receipt, or deposit amount |
Document Number: Optionally, select an invoice document number.
AR Account: Optionally, select an AR account code.
Apply Filters: Select to apply your filters and generate your results in the Transactions grid.
View & Export Your Results
The Transactions grid displays the results based on the filters you applied above, with columns varying depending on the chosen AR code. You can drill down into specific transactions and documents. You can Export your data in PDF or XLS format.
Level 1 - Original Document
The original document information.
Document Number: The document number associated with the transaction code
Document Date: The session date specific to this document
Due Date: The due date for the document
Document Description: The description entered during transaction entry
Original Amount: The functional amount of the document
Outstanding Balance: The functional outstanding balance
Level 2 - Related Documents
All applicable documents associated with the original document.
Document Number: The document number associated with the transaction code
Transaction Type: The transaction type associated with the document
Session ID: The session ID associated with the document
Applied Amount: The amount applied to the customer balance
Document Date: The session date specific to this document
Document Description: The description entered during transaction entry
Status: The payment status
GL/AR Account: The General Ledger or Accounts Rayable account number associated with the document
Level 3 - Transactions
All transaction lines for the original and related documents.
{Segment Name}: The system displays one column for each valid segment. If account level security is applied, you may not see some segments and/or account codes. If you do not have access to one or more accounts, you will not see that record.
Document Number: The number assigned to the document
Debit: The debit amount for the transaction line
Credit: The credit amount for the transaction line
Entry Type: The entry type chosen during transaction entry
Effective Date: The effective date entered during transaction entry
Transaction Description: The description entered for the transaction line item
Customer Balances Summary
For AACT, OARB, and AARB:
-
Total Original Amount: The total original amount due from all customers included in the filtered results.
-
Total Outstanding Balance: The total outstanding balance due from all customers included in the filtered results.
For ARM and ARP/ARC:
-
Total Amount: The total credit amount or total check amount for all customers included in the filtered results.