Customer Collection Inquiry

The Customer Collection Inquiry is used to view posted A/R Transactions (Sales Orders, Returns, Price Adjustments, Quick Sales, and Payment Receipts) that have an open/unapplied balance. The purpose of this inquiry is to review outstanding receivables and add ‘Collection’ notes to document any dialog with the customer.

Software Version: 2023.07.31 and newer

[ 1 Page Header ] [ 1.1 Search  ] [ 2 Page Details ] [ 2.1 Related Topics ] [ 2.1.1 Page Definitions ] [ 2.1.2 Technical Details ]

Page Header

Search 

Search Options

Description

Search Options

Description

Auto Hide Filters

Auto Refresh on Open

Saved Searches

Search

  • Customer: [Customer ID] or [Customer Name]

  • Doc No

  • Invoice

  • PO

  • Transaction

Page Details

Toolbar Icons

Description

Toolbar Icons

Description

Column Filter Show/Hide

Excel

Favorites

Group By Show/Hide

Help

More Actions

  • IQ: Applications

    • If the selected record is a Payment, Price Adj Credit, or Quick Sale Credit, the Payment Applications inquiry for the selected record will open in a new tab.

    • If the selected record is a Sales Order, Price Adj Debit, or Quick Sale Debit, the Invoice Applications inquiry for the selected record will open in a new tab.

  • IQ: Customer Balance Details - opens the Customer Activity Inquiry in a new tab, for the selected Customer, filtered for posted transactions with an open balance.

  • IQ: Transaction History - opens the Customer Activity Inquiry, in a new tab, for the selected Customer, filtered for posted transactions within the past year.

  • RV: Customer - opens the Customer Record View in a new tab.

  • RV: Transaction - opens the record view of the selected Transaction in a new tab.

Notes

Print

Quick Column Filter

Refresh

Saved Layouts

Search Options

Fields

Description

Checkbox

Aging Period

Identifies the Aging Period the transaction falls into.

This will only be populated for Sales, Quick Sales, and positive Quick Sales. It will be blank for Payment Receipts, Returns, negative Price Adjustments, and negative Quick Sales.

This is a system calculated value that is not stored in the database.

Avail. Credit

Identifies the Available Credit for the Customer.

  • If the Customer is assigned as “No Credit” this will display as 0.00

  • If the Customer is assigned a Credit Limit, this will display as [Credit Limit] - [Open Balance of all open transactions]

  • If the Customer is assigned as “Unlimited Credit” this will be Blank.

This is a system calculated value that is not stored in the database.

Avg. Days to Pay

Note: This is a Customer-level value so it will display the same for all transactions by the same customer.

This is a system calculated value that is not stored in the database.

Collection Note

Identifies if there is a ‘Collection’ note saved on the transaction. If there is a Collection note the value will be “Yes” otherwise it will be blank.

Note: If you add a ‘Collection’ note for a transaction, the ‘Refresh’ icon must be clicked before the value or “Yes” will be visible.

Database Fields: ERPx_SOOrderHeaderNote.HeaderNoteSK, ERPx_ARTransactionHeaderNote.TransactionHeaderNoteSK, ERPx_MFNoteType.NoteType

Credit Limit

Identifies the Credit Limit assigned to the Customer.

  • If the Customer is assigned as “No Credit” this will display as 0.00

  • If the Customer is assigned a Credit Limit, this will display the credit limit.

  • If the Customer is assigned as “Unlimited Credit” this will be Blank.

Note: This is a Customer-level value so it will display the same for all transactions by the same customer.

Customer Name

This comes from the 'Ship To' field on the 'Home' tab of the Sales Transaction Record View. It can be edited from the 'Customer Name' field on the 'Properties' tab of the Customer Record View.

Database Fields: ERPx_ARCustomer.CustomerName, ERPh_SOOrderHeader.CustomerSK  

Currency

 This comes from the 'Currency' associated with the Customer on the transaction. This field is not editable.

Database Fields: ERPx_MFCurrency.CurrencyID, ERPh_SOOrderHeader.CurrencySK

Description

A non-editable text box to display the 'Description' that was entered on the header of a Quick Sale transaction, this is blank for sales invoices and price adjustments. This field is not editable from here but can be edited on the source transaction even after it was posted.

Database Field: ERPx_ARTransactionHeader.Description

Doc No

A non-editable text box to display the 'Doc No' of a Quick Sale transaction. This only applies to Quick Sales so it will always be blank for Sales Invoices and Price Adjustment transactions. This field is not editable from here but can be edited on the source transaction, even after it is posted. 

Database Field: ERPx_ARTransactionHeader.DocNumber

Due Date

A date field to display the date the payment was/is due. This is displayed for all transactions in the grid and is calculated by adding the number of due days to the invoice date for sales Invoices and to the Doc Date for Quick Sales. This field is not editable from here but can be edited on the source transaction for Quick Sales even after they were posted, but not for Sales Invoices or Price Adjustments. 

This is a calculated field based on the payment terms assigned to the order that is not stored in the database.

This will only be populated for Sales, Quick Sales, and positive Quick Sales. It will be blank for Payment Receipts, Returns, negative Price Adjustments, and negative Quick Sales.

Invoice

Identifies the invoice number associated with the sales order shipment. This comes from the 'Invoice #' field on the 'Shipments' tab of the Sales Transaction Record View. It is not editable. 

Database Field: ERPh_SOInvoiceHeader.InvoiceNumber

Invoiced

A date field to show the date of the transaction. For Sales Invoice and Price Adjustments this will be the Invoice Date and for Quick Sales this is the Doc Date. This field is not editable.

Database Fields: ERPh_SOInvoiceHeader.InvoiceDate, ERPx_ARTransactionHeader.TransactionDate

Last Payment Date

Used to show the date of the last ‘Posted’ Payment Receipt for each Customer.

Open Amount

A non-editable text box to display the open amount of the transaction. This is calculated by subtracting all previous Applied Amounts (from payments and Rebates), Discount Amounts, and Write Off Amounts from the transactions 'Orig. Amount'. Only transactions with an 'Open Amount' > 0.00 will be shown in this grid.  

This is a calculated field that is not stored in the database.

Ordered

Identifies the date of the transaction. It is formatted from the users 'Date Format' preference. This comes from the 'Order Date' field on the 'Home' tab of the Sales Transaction Record View. It is not editable. 

Database Field: ERPh_SOOrderHeader.OrderDate

Orig. Amount

A non-editable text box to display the transaction amount as it was when it was posted with no applications. This is looked up from the transaction. 

Database Fields: ERPh_SOInvoiceHeader.ExtendedAmount, ERPx_ARTransactionHeader.ExtendedAmount

Past Due

Identifies if the Sales Order, Price Adjustment Debit, or Quick Sale Debit is past due. If so, it will display as “Yes”, if not it will be blank.

Past Due Days

A calculated field that shows the past due days for transaction. It is only calculated for Sales Order, Price Adjustment Debit, and Quick Sale Debit transactions and is calculated as: [Current Date] - [Due Date].

This is a calculated field that is not stored in the database.

Payment Terms

A non-editable text box to display the Payment Term ID of the Payment Term the transaction was posted with. This defaults from the Customer but can be changed on the transaction prior to posting.

Database Fields: ERPx_MFPaymentTerms.PaymentTermName, ERPx_ARTransactionHeader.PaymentTermSK, ERPh_SOOrderHeader.PaymentTermsSK

PO

A non-editable text box to display the Purchase Order number of the transactions. This field will be blank for all Sales Invoices, Price Adjustments, and Quick Sales that were posted without a PO. This field is not editable from here but can be edited on the source transaction for Quick Sales even after they were posted, but not for Sales Invoices or Price Adjustments. 

Database Fields: ERPx_ARTransactionHeader.PurchaseOrderID, ERPh_SOOrderHeader.PurchaseOrder

Transaction

This is a system assigned value and is not editable.

Database Fields: ERPx_ARTransactionHeader.TransactionID, ERPh_SOOrderHeader.OrderID

Related Topics

 



Page Definitions





Technical Details