Field Definitions: Account Activity (12-61)

The account number that uniquely defines this A/R account.

The customer number associated with the account.

The person or company’s name associated with the account.

The email address for the account.

The Credit Status assigned to this account. Credit Status codes are defined in Credit Status Maint (12-23).

The Business Type assigned to this account. Business Type codes are defined in Business Type Maint (12-22).

The home phone number for the account.

The contact phone number associated with the account.

The credit limit for this account.

The date of the last sale paid for with this account.

The date of the last payment toward an invoice for this account.

The dollar amount for orders that have been delivered, but not updated in Sales Transactions.

The dollar amount for orders that have been entered, but not delivered in Order Processing.

The amount owed on the account.

When viewing a permanent account, if the ‘Include D-N-U 12-61 Balance’ preference is set to ‘Y’ in Open A/R Preferences (12-90), this field includes the Delivered Not Updated (D-N-U) amount. If the preference is set to ‘N,’ the D-N-U amount is not included.

The balance that will be due on a future date.

The balance that is due now.

The balance that is 01-30 days past due.

The balance that is 31-60 days past due.

The balance that is 61-90 days past due.

The number of the invoice. When viewing in Summary mode, click the plus sign to the left of the invoice number to view details about charges and payments.

This field describes the type of transaction that applied the dollar amount(s) to the invoice:

The date on which the transaction occurred.

The due date for the invoice.

The source of the transaction that applied the dollar amount to the invoice:

The discount earned for the payment (if applicable).

The amount of a sale (for DI types).

The amount of a payment (for CP types).

The amount of an adjustment (for CM types).

The total due for the invoice. This amount only appears on the top level of the invoice, not on any expanded detail entries that appear when clicking the plus sign.

This column consists of 6 sub-columns, which designate the invoice amount as a future, current, 01-30, 31-60, 61-90, or Over 90 days balance due. For example, if the entry has a future balance due, ‘F’ appears in the ‘F’ sub-column. If the entry has a 01-30 days past due balance, ‘3’ appears in the ‘3’ sub-column. If it has 31-60 days past due balance, ‘6’ appears, and so on.

If there is a Cross Reference transaction number for the invoice, it appears in this field.

These 13 columns show the charge amounts, payments, and balances, without decimals, for the current month and the previous 12 months.

This field displays the number of times the account holder has had current, 01-30, 31-60, 61-90, and Over 90 days balances since the account was opened.

he largest amount charged to the customer over the life of the A/R account.

The largest payment the customer has made to the account over the life of the A/R account.

The largest balance the customer has incurred over the life of the A/R account.

Click Refresh to reload the activity for the account.

If you make changes to the account in another partition, click Refresh to update the results.

When viewing invoices in Summary mode, click Expand to reveal the details of payments and charges for all invoices on the screen. Click Collapse to hide the details of payments and charges for all invoices.

To Expand and Collapse individual invoices, click the plus (or minus) sign to the left of the invoice number.

Click Detail to view invoices in Detail Mode. In this mode, details of payments and charges for the invoice appear in a ‘flat’ view (they cannot be expanded and collapsed).

Click Summary to view invoices in Summary Mode. In this mode, details of payments and charges for the invoice appear in an expandable and collapsible view. Use the Expand/Collapse button to reveal and hide the invoice details.

Click this button to open a report of the information directly in Excel (and save it to your computer).

Click this button to print the information on the screen. You can choose to sort the report by Invoice Number, Invoice Date, or Cross Reference, and you have the choice to include or exclude Closed Invoices. Enter the ID of a physical printer, or enter “PDF” to save the report to a PDF file.