Customer Activity Report

The ID assigned to the customer. The report shows the Customer ID-Smith, Jones, or Adams, for example.

The customer's name. This customer was set up using the Maintenance>Accounts Receivable>Customers form. The report shows Ann Smith, Brian Jones, Steven Adams, for example.

The status of the customer ID-Active, Inactive, or Discontinued.

This item is used to limit or sort a range of customer IDs. Assign it to different IDs so that they can be grouped together. The report shows the class-Financial Counseling or Budget Counseling, for example.

This is used as a second-level sort for Class. Use it to limit or sort a range of customer IDs. For example, within the Class Financial Counseling, you might assign Types Bankruptcy, Debt Consolidation, or Refinancing. The report would show these types.

The customer's addressee information.

The number assigned to the original invoice or credit. This allows the report to be sorted by invoice/credit number so that all entries made to an invoice/credit are together.

The number assigned to the document.

The number assigned to the receipt.

The date of the receipt.

The date of the document.

The due date.

The description entered on the transaction entry form.

For functional currency, the document amount entered during transaction entry. For non-functional currency, the Source Document Amount times the Exchange Rate.

The credit type of Applied Credit, Prepayment, or On Account displays. This was selected on the Enter AR Credits and Enter AP Credits forms.

The actual account code associated with a transaction. The report prints the account code, such as 201, 05, 45001. One column displays for each code type, such as Fund Code or GL Code.

The title associated with each code above. The report prints one column for each code type, such as Fund Title or GL Title.

The short title for the title above (15 characters or less). One column displays for each code type, such as Fund Short.

The group code you assigned. The report prints a column for each group code, such as Fund Group Code.

The title associated with the group code above. The report prints one column for each group code title.

The short title for the group title above (15 characters or less). One column displays for each group code short title, such as Fund Group.

The session ID assigned to this batch of AR documents. This ID was assigned using the Transactions>Accounts Receivable>Enter AR Invoices, Enter AR Credits, Enter AR Receipts, Edit AR Invoices; Activities>Receipt Writing; Revalue Multicurrency; or Accounts Receivable>Void Invoices Session forms.

The date entered on the AR Session form.

The description entered on the AR Session form.

The currency type assigned to the session, such as USD, CAD, or EUR. Currencies were created and activated by the Administrator using the Organization>Currency Setup form.

The description associated with the currency, such as US Dollar, Canadian Dollar, or Euro.

The transaction type for the invoice, credit, or receipt, such as ARB, ARC, ARM, ARP, ARR, ARS, ARV, CR, CRS, or CSR.

The effective date entered on the transaction entry form.

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

The description entered for the transaction line item.

For functional currency, the credit amount entered for revenue type accounts in the transaction entry table for the AR invoice, credit, or receipt. The system automatically processes the credit amount for revaluations (Activities>Revalue Multicurrency). For non-functional currency, the Source Revenues times the Exchange Rate.

For functional currency, the debit amount entered for General Ledger cash type accounts in the transaction entry table for the AR invoice, credit, or receipt. The system automatically processes the debit amount for revaluations. For non-functional currency, the Source Receipts times the Exchange Rate.

For functional currency, the debit amount entered in the transaction entry table for the AR invoice, credit, or receipt (Transactions>Accounts Receivable>Enter AR Invoice, Enter AR Credits, or Enter AR Receipts). The system automatically processes the debit amount for revaluations (Activities>Revalue Multicurrency). For non-functional currency, the Source Charges times the Exchange Rate.

The source currency type associated with the transaction, such as USD, MXN, or CAD.

The description associated with the source currency, such as US Dollar, Mexican Peso, or Canadian Dollar.

The credit amount entered for revenue type accounts in the transaction entry table for the AR invoice, credit, or receipt. It follows the currency of the session.

The debit amount entered for General Ledger cash type accounts in the transaction entry table for the AR invoice, credit, or receipt. It follows the currency of the session.

The debit amount entered for Accounts Receivable type accounts in the transaction entry table for the AR invoice, credit, or receipt. It follows the currency of the session.

The currency type, such as USD, MXN, or CAD, assigned to Accounts Payable or Accounts Receivable transaction lines.

The description associated with the invoice or credit currency, such as US Dollar, Mexican Peso, or Canadian Dollar.

The debit amount for the invoice or credit in the currency that the invoice was originally booked in.

The form of payment selected on the Receipt Writing form using Activities>Receipt Writing or Enter AR Receipts form using Transactions>Accounts Receivable>Enter AR Receipts.

A customer type user defined field and its data. There is a separate column for each field.

A transaction documents type user defined field and its data. There is a separate column for each field.

A transaction lines type user defined field and its data. There is a separate column for each field.

An AR Invoice type user defined field and its data. There will be a separate column for each field.

An AR Invoice Detail type user defined field and its data. There will be a separate column for each field.