The purpose of the Customer Balances page is to show current balances for all Customers. The balances are displayed for posted transactions, unapplied Receipts & Credits, and Open transactions. From here, users can navigate to the Payment Receipts and Apply Documents pages as well as open the detail inquiries showing all the transactions, Payment Applications, and Invoice Applications for the selected Customer..
Software Version: 20201.0304.20 09 and newer
| Table of Contents | ||
|---|---|---|
|
...
| Toolbar Icons | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Apply Documents | Opens the Apply Documents page 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 |
| ||||||||
| Refresh |
| ||||||||
| View | Allows users to select the detail inquiry they want. The options include:
| ||||||||
| Fields | Description | ||||||||
| Checkbox |
| ||||||||
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. Linked Database Field: ERPx_ARCustomer.CustomerName Linked Database Field: ERPx_ARCustomer.CustomerID | ||||||||
| Customer Class | A non-editable text box to identify the class the corresponding customer belongs to. Linked 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. Linked 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. Linked 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. Linked 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. |
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
...