Customer Inquiry - Transactions field descriptions

Fields are presented in alphabetical order.

Transactions

Amount

The amount of the transaction and the amounts of all activity associated with that transaction. The amounts of all checks, credit memos, unapplied credits, miscellaneous credits, and reversals display as negative values. They are credits to the customer's account. When a scheduled payment is made, the amount is positive because it is a debit to the account.

Amount Due

The amount due on the transaction.

Applied Journal #

The number of the GL journal the transaction was applied to.

Check #

The check number that is attached to the transactions being paid. If the transaction has been paid, the check number is displayed in this field. The check number is also displayed if a transaction is made through Customer Cash Receipts Entry and associated with a particular check number. Transactions include manual payment, COD, split check, unapplied credit, or miscellaneous cash.

Customer Purchase Order #

Customer Purchase Order (PO) number from original invoice.

Customer #

The customer number is displayed for each transaction.

Dispute

Indicate if issues exist on this transaction.

Due Date

The due date, as calculated from the terms, is displayed for active scheduled payments (PY).

Invoice #

The invoice numbers for the customer are in date order. Invoices that have been archived using the SA Data Archive Receivables Report are shown with an -A following the invoice number (e.g., 1000-00-A).

Invoice Date

The date of the invoice.

Journal #

The journal number for this transaction.

Module
This column shows the module associated with the Journal number. This information enables you to identify transactions paid through the Accounts Payable module.
National Program Claim #
This column shows the vendor claim number associated with the OE Correction (CR) claim order. This transaction number is used for billing an National Program Claim Account in Customer Setup.
Paid Check #

The check number entered when you apply an initial Unapplied Cash (UC) payment for an invoice payment during Customer Cash Receipts Entry. The paid check number is included when you search for a check number using the banner-level search criteria for the inquiry; both check numbers and paid check numbers that match the search criteria appear in the search results.

Pay Date

For inactive scheduled payments, the date of the payment made.

Payment Reference

This field is optionally available in Customer Cash Receipt Entry-Transaction. Payment Reference is a 30-character alphanumeric field that provides flexibility in recording a transaction, such as an Automated Clearinghouse (ACH) or wire transfer payment. If the Payment Reference value has been specified in Customer Cash Receipt Entry-Transaction, you can inquire on the value from the Customer Inquiry-Transactions-Additional Search. The Payment Reference value is also displayed in the Transactions grid.

Payment Type
When a payment entered in Customer Cash Receipt Entry is received, the Payment Type for the transaction may be displayed. Payment types are defined in SA Table Code Value Setup. For example, the payment was made from a third-party retail management system or point of sale (POS) system. If the transaction is posted as a 7-Check Record transaction type, the Payment TypeDescription field in SA Table Code Value Setup.
Reference

Any references associated with an invoice are displayed here. For example, if you use Customer Lockbox, any checks posted through the Customer Entry Lockbox Import Report or Customer Entry Lockbox Update Report are noted with the function name and journal number.

Sequence Number

The invoice sequence number, if one exists, appears. Sequence numbers denote scheduled payments.

Status

If the transaction is an active invoice, miscellaneous credit, rebate, service charge, or COD, then Open is displayed. If the transaction is a scheduled payment and active, then Due is displayed. If a transaction is closed, the Status column is blank.

Transaction #

The transaction number is a byproduct of invoice processing in Customer Transaction Entry.

Transaction Code

The type of transaction. For example, invoice, service charge, credit, or Debit.

Transaction Type

Indicates the transaction type of the record. Each transaction entered is assigned a type during entry in Customer Transaction Entry. For example: invoice, service charge, rebate, miscellaneous credit, credit memo, debit memo, and reversal.

GL Distribution - Details grid

Account #

The number of the General Ledger account an entry was made to for this invoice.

Credit

The amount of the credit to the account.

Debit

The amount of the debit to the account.

Title

The title of the General Ledger account the entry was made to for this invoice.