Customer Balances

The Customer Balances form displays when you select Customer Balances from the Operations>Accounts Receivable submenu.

Use this form to filter customer balance details and display the matching transactions.

Note: You must have full menu rights to these forms in order to view and access these buttons.

Customer Details Information

The Customer Details Information section of the form includes the following filtering information.

Customer ID: Unique ID string for the customer. Select a Customer ID from the drop-down list. This activates the remaining Customer Detail required fields.

Document Date From: Defaults to one year previous to the current date. Click the calendar icon to select a date.

Document Date To: Defaults to the current date. Click the calendar icon to select a date.

Include Activity From: General Ledger account codes. Select a GL account code from the drop-down list. This activates the remaining optional Customer Detail fields.

Note: The columns displayed in the Transaction Table depend on the General Ledger code selected.

Document Number: Invoice document number. Select a document from the drop-down list.

AR Account: Accounts Receivable account codes. Select an account code from the drop-down list.

Clear Filters: Click to clear all selected filters and reset the Vendor Details Information section of the form.

Apply Filters: Click to apply the selected filters and generate the results in the Transactions Table.

Transactions Table

The Transaction Table displays the results of the filter criteria set in Customer Details Information section of the form.

Search Transactions: Enter a sequence of characters to filter the list displayed in the Transactions Table. For example, entering 10 will display only transaction documents that include the number 10.

Collapse All (Up Arrow Icon): Click to collapse any expanded Document Number or Document Number Details tables.

Export: Click to export the vendor filtered results in PDF or XLS format.

The results are exported according your browser selection and settings.

Reset Grid: The Reset Grid button will reset the specific table to its default order. See the Tips and Shortcuts page for more information on reorganizing grids.

Note: The columns displayed in the Transaction Table depend on the General Ledger code selected.

Code: Description	Column: Description
ACCT: All Activity	Document Number: Invoice document number. Click to view the Document Number Table.	Document Date: Session date specific to this document.	Due Date: The due date.	Document Description: The description entered on the transaction entry form.	Original Amount: Original amount due from customer.	Outstanding Balance: Outstanding amount due from customer.
OARB: Open AR Invoices	Invoice/Credit Number: The number assigned to the invoice or credit. Click to view the Document Number Table.	Invoice/Credit Date: The date of the invoice or credit.		Invoice/Credit Description: The description entered for the invoice or credit.
AARB: All AR Invoices		Invoice/Credit Date: The date of the invoice or credit.
ARM: AR Credits	Credit Number: The number assigned to the applied credit. Click to view the Document Number Table.	Credit Type: The credit type of Applied Credit, Prepayment, or On Account displays.	Date: Session date specific to this document.			Description: The description entered for the credit, receipt, or deposit.	Amount: Indicates the credit, receipt, or deposit amount.
ARC/ARP: AR Payments Received	Receipt Number: The number assigned to the receipt.. Click to view the Document Number Table.	Deposit Number: The number assigned to the deposit.	Date: Session date specific to this document.	Status: Indicates the check or voucher status.

Document Number Table

The Document Number Table displays the vendor document details.

Document Number: The document number associated with the transaction code. Click to view the Document Number Details Table.

Transaction Type: The transaction type associated with the document, such as ARB, ARC, ARM, ARP, ARR, ARS, ARV, CR, CRS, or CSR.

Session ID: The session ID associated with the document.

Applied Amount: Amount applied to the customer balance.

Document Date: Session date specific to this document.

Document Description: The description entered on the transaction entry form.

Status: Indicates the payment status. (Does not apply to ARM or ARC/ARP.)

GL/AR Account: General Ledger or Accounts Receivable account number associated with the document.

Document Number Details Table

The Document Number Details Table displays additional customer document details.

Note: The columns available for Document Number Details can vary depending on your MIP Cloud implementation. The most common columns are described here.

GL Account: The General Ledger account code.

Fund: The associated Fund code.

Document Number: The number assigned to the document.

Debit: The debit amount.

Credit: The credit amount

Entry Type: The entry type chosen during transaction entry—Normal (N), End of Year Adjustment (A), or Beginning Balance (UO).

Effective Date: The effective date entered on the transaction entry form.

Transaction Description: The description entered for the transaction line item.

Customer Balances Summary

For AACT, OARB, and AARB:

Total Original Amount: Lists the total original amount due all vendors included in the filtered results.
Total Outstanding Balance: Lists the total outstanding balance due all vendors included in the filtered results.

For ARM and ARP/ARC.

Total Amount: Lists the total credit amount or total check amount for all vendors included in the filtered results.