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.