Apply Documents

Opens the Unapplied Receivable Documents List View to see the list of all open (not fully applied) Payment Receipts, Returns, negative Invoices, negative Price Adjustments, and negative Quick Sale transactions across the entire company. The Unapplied Receivable Documents List View will open filtered based on the selected Customer(s). If no Customer was selected, all unapplied transactions for all Customers will be displayed. From here users can select a single transaction and apply it.

Excel

Favorites

Grid Layout

Help

Inquiry Criteria

• Hide Customers where all balances are 0.00: A Yes/No lookup that allows you to show all Customers or only show Customers that have a balance in at least one of the columns. This defaults to Yes

• Customer Class: A multi-select lookup to select one or more Customer Classes. This defaults to All. 

Refresh

View

Allows users to select the detail inquiry they want. The options include:

• Transactions - Opens the 'Customer Activity Inquiry' to show the list of all transactions for the selected Customer.

• Payment Applications - Opens the 'AR Transaction & Check Applications' inquiry to shows the list of Payment Receipts, Returns, negative Invoices, negative Price Adjustments, and negative Quick Sale transactions and the transactions they were applied to. 

• Invoice Applications - Opens the 'AR Transaction & Check Applications' inquiry to shows the list of Invoices, positive Price Adjustments, and Quick Sale transactions and the payment transactions that were applied to them.

Fields

Description

Checkbox

Available Credit Amount

Identifies the amount of available credit that is remaining for the Customer. This is a non-editable numeric text box that is not required. It defaults as blank if the 'Credit Limit Option' property on the Customer Record View is set as "No Credit" or "Unlimited Credit". Else if the Customer has a Credit Limit amount, then this field is calculated as [Credit Amount] - [Unpaid Invoices] - [Open Balances] - [Total Ext. Amount]. This field is automatically updated when item quantities are entered and the transaction is Saved.

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

Credit Limit Amount

Displays the credit amount assigned to the Customer. This is a non-editable numeric text box that is not required. This information is only displayed when the ‘Credit Limit Option‘ on the Customer Record View is set to ‘Specific Amount’. This field is for informational use only and cannot be edited on this page but is always editable on the 'Credit Amount' property of the Customer Record View (when the Credit Limit Option is set to Specific Amount).

Database Field: ERPx_ARCustomer.CreditLimitAmount

Credit Limit Option

Identifies if, and how, Credit Limits are established for the Customer. This is always editable from the Customer Record View.

This property works in conjunction with 'Credit Amount' property on this page and with the "When credit limits are exceeded" Sales Preference.  Click here for additional information on managing Credit Limits.

The options include:

• No Credit: The Customer does not have any credit and the 'Credit Limit Amount' displays 0.00. 

• Specific Amount: The Customer has a set Credit Limit that will be specified in the 'Credit Amount' property on the Customer Record View.

• Unlimited Credit: The Customer has unlimited credit (i.e., Credit Limits are not managed for the Customer), and the 'Credit Limit Amount' displays blank.   

This lookup contains the values in the ARCreditLimitOption Enumeration Class.

Database Field: ERPx_ARCustomer.CreditLimitOptionEN

Customer

A hyperlink displaying the Customer Name (Customer ID). Clicking on the link opens the record view of the corresponding customer. This field is not editable.

Database Field: ERPx_ARCustomer.CustomerName

Database Field: ERPx_ARCustomer.CustomerID

Customer Class

A non-editable text box to identify the class the corresponding customer belongs to.  

Database Field: ERPx_ARCustomer.CustomerClassSK

Customer ID

A hyperlink displaying the unique identifier of the customer. Clicking on the link opens the record view of the corresponding customer. This field is not editable.

Database Field: ERPx_ARCustomer.CustomerID

Customer Name

A hyperlink displaying the Customer Name. Clicking on the link opens the record view of the corresponding customer. This field is not editable.

Database Field: ERPx_ARCustomer.CustomerName

Default Accounts Receivable Account

A non-editable text box to identify the Accounts Receivable account setup for the corresponding customer. 

Database Field: ERPx_ARCustomer.GLARAccountSK

Net Balance

A non-editable text box to display the outstanding balance for the corresponding customer.  This is calculated as [Posted Balance]+[Open Transactions]-([Unapplied Receipts]+[Unapplied Credits/Returns]). 

This is a calculated amount and not linked to a Database Field. 

Net Balance Home Currency

A non-editable text box to display the outstanding balance in the home currency for the corresponding customer.  This is calculated as [Posted Balance]+[Open Transactions]-([Unapplied Receipts]+[Unapplied Credits/Returns]). 

This is a calculated amount and not linked to a Database Field. 

Open Transactions

A non-editable text box to display the total amount from any sales transactions saved in a status less than 'Ready to Post' or 'Posted'.  The following transactions are included in this total: Quick Sale, Payment Receipt, Sales Order, Price Adjustment and Return.

This is a calculated amount and not linked to a Database Field. 

Posted Balance

A non-editable text box to display the total balance from any sales transactions saved in a status of 'Ready to Post' or 'Posted'.  The following transactions are included in this total: Quick Sales (positive or negative), Payment Receipts, Sales Orders (positive or negative), Price Adjustments (positive or negative) and Returns.

This is a calculated amount and not linked to a Database Field. 

Posted Balance Home Currency

A non-editable text box to display the total balance in the home currency from any sales transactions saved in a status of 'Ready to Post' or 'Posted'. The following transactions are included in this total: Quick Sales (positive or negative), Payment Receipts, Sales Orders (positive or negative), Price Adjustments (positive or negative) and Returns.

This is a calculated amount and not linked to a Database Field. 

Transaction Currency

A non-editable text box to display the Currency ID of the customer from the sales transactions. 

This is a calculated amount and not linked to a Database Field. 

Unapplied Credits/Returns

A non-editable text box to display the total balance of all the credits and returns in a posted status that have not yet been applied to a transaction. The following transactions are included in this total:  Quick Sales (negative), Sales Orders (negative), Price Adjustments (negative) and Returns.

This is a calculated amount and not linked to a Database Field. 

Unapplied Receipts

A non-editable text box to display the total balance of all the payment receipts in a posted status that have not yet been applied to a transaction. The following transactions are included in this total: Payment Receipts. 

This is a calculated amount and not linked to a Database Field. 

Unpaid Invoices

A non-editable text box to display the total balance of all the posted sales transactions that have not had a payment applied yet and therefore remain as an outstanding amount owed by the customer. The following transactions are included in this total: Quick Sales (positive), Sales Orders (positive) and Price Adjustments (positive).

This is a calculated amount and not linked to a Database Field.