Insert excerpt |
---|
| Def - Receivable Documents |
---|
| Def - Receivable Documents |
---|
nopanel | true |
---|
|
The purpose of this page is to display all outstanding credit balance transactions that have not been fully applied (unapplied payment receipts, credit memos, returns, and price adjustment transactions with a negative balance). This page will be filtered to display transactions associated with the Customer(s) selected on the Customer Balances List View. If no Customers are selected, then this page will display all outstanding credit balance transactions that have not been fully applied. From here, users can select a single transaction and click the 'Apply Documents' icon in the header toolbar to manually apply the selected transaction to one or more debit balance transactions.
Software Version: 2021.xx04.xx 09 and newer
...
Toolbar Icons | Description |
---|
Apply Document | Opens the Apply Documents Record View. Users must select a transaction prior clicking this toolbar icon. Only one transaction can be selected at a time. If no transaction is selected, the message "Please select one item and try again." will be displayed. |
Excel | Insert excerpt |
---|
| Excel - LV |
---|
| Excel - LV |
---|
nopanel | true |
---|
|
|
Grid Layout | Insert excerpt |
---|
| Grid Layout - Global |
---|
| Grid Layout - Global |
---|
nopanel | true |
---|
|
|
Help | Insert excerpt |
---|
| Help - Global |
---|
| Help - Global |
---|
nopanel | true |
---|
|
|
Inquiry Criteria | Insert excerpt |
---|
| Inquiry Criteria - Global |
---|
| Inquiry Criteria - Global |
---|
nopanel | true |
---|
|
- Show balances through: A textbox that defaults to the current date.
- Hide fully Settled transactions: A Yes/No lookup that defaults to "Yes". If set to "Yes", then fully applied transactions will not be in the returned results.
- Customer: A multi-select lookup that defaults to the Customer(s) that was selected prior to clicking the Apply Documents button on the Customer Balances list view. If no Customer was selected, this field defaults to blank.
|
Refresh | Insert excerpt |
---|
| Refresh - Global |
---|
| Refresh - Global |
---|
nopanel | true |
---|
|
|
Fields | Description |
Checkbox | Used to select one transaction to apply a document to. |
Customer | Insert excerpt |
---|
| Customer ID - Transaction |
---|
| Customer ID - Transaction |
---|
nopanel | true |
---|
| This field is required and is not editable after the transaction has been posted. Insert excerpt |
---|
| Def - Customer ID |
---|
| Def - Customer ID |
---|
nopanel | true |
---|
|
Database Fields: ERPx_ARCustomer.CustomerID, ERPx_ARTransactionHeader.CustomerSK (Payment Receipt and negative Customer Sale), ERPx_SOOrderHeader.CustomerSK (Price Adjustment, Return and Returnnegative Invoice)
|
Customer Name | Insert excerpt |
---|
| Customer Name - Transaction |
---|
| Customer Name - Transaction |
---|
nopanel | true |
---|
| This field is required and is not editable after the transaction has been posted. Insert excerpt |
---|
| Def - Customer Name |
---|
| Def - Customer Name |
---|
nopanel | true |
---|
|
Database Fields: ERPx_ARCustomer.CustomerName, ERPx_ARTransactionHeader.CustomerSK (Payment Receipt and negative Customer Sale), ERPx_SOOrderHeader.CustomerSK (Price Adjustment, Return and Returnnegative Invoice) |
Doc Date | Insert excerpt |
---|
| Doc Date |
---|
| Doc Date |
---|
nopanel | true |
---|
| This field is required. It comes from the 'Invoiced' field on the 'Shipments' tab of the Sales Transaction List View for Return and Price Adjustment transactions. It comes from the 'Receipt Date' field on the 'Home' tab of the Payment Receipt Record View for Payment Receipt transactions. It comes from the 'Doc Date' field on the 'Home' tab of the Quick Sale Record View. This field is not editable after the transaction has been posted.Database Fields: ERPx_ARTransactionHeader.TransactionDate (Payment Receipt and negative Customer Sale), ERPx_SOInvoiceHeader.InvoiceDate (Price Adjustment, Return and Returnnegative Invoice)
|
Doc No | This field is not required. There is no 'Doc No' associated with Return and , Price Adjustment and negative Invoice transactions. For Payment Receipt transactions, this field comes from the 'Payment #' field on the Payment Receipt Record View. For negative Customer Sale transactions, this field comes from the 'Doc No' field on the 'Home' tab of the Quick Sale Record View. This field is not editable after the transaction has been posted.Database Field: ERPx_ARTransactionHeader.DocNumber (Payment Receipt and negative Customer Sale)
|
GL Date | Insert excerpt |
---|
| GL Date |
---|
| GL Date |
---|
nopanel | true |
---|
| This field is required and is not editable after the transaction has been posted.
Database Field: ERPx_ARTransactionHeader.GLDate (Payment Receipt and negative Customer Sale), ERPx_SOInvoiceHeader.GLDate (Price Adjustment and Return)
|
GL Period | Insert excerpt |
---|
| GL Period |
---|
| GL Period |
---|
nopanel | true |
---|
| This field is required and calculated using the 'GL Date' on the 'Properties' tab (Payment Receipt transaction) or 'Shipments' tab (Return and Price Adjustment transaction) of the associated transaction Record View. This field is not editable.
|
GL Year | Insert excerpt |
---|
| GL Year |
---|
| GL Year |
---|
nopanel | true |
---|
| This field is required and calculated using the 'GL Date' on the 'Properties' tab (Payment Receipt transaction) or 'Shipments' tab (Return and Price Adjustment transaction) of the associated transaction Record View. This field is not editable. |
Original Amount | Insert excerpt |
---|
| Amount - Original |
---|
| Amount - Original |
---|
nopanel | true |
---|
| This is the original amount of the transaction when it was posted, prior to any applications being done. This field is required. For Price Adjustment, Return and negative Customer Sale transactions, this field is the total extended amount of all line items. For Payment Receipt transactions, this field comes from the 'Amount' field on the Payment Receipt Record View. This field is not editable after the transaction has been posted.Database Fields: ERPx_ARTransactionHeader.ExtendedAmount (Payment Receipt and negative Customer Sale), ERPx_SOInvoiceHeader.ExtendedAmount (Price Adjustment, Return and Returnnegative Invoice) |
Transaction | Insert excerpt |
---|
| Transaction ID |
---|
| Transaction ID |
---|
nopanel | true |
---|
|
Clicking on this link opens the record view for the selected transaction. This is a system assigned number that comes from the 'Transaction Class' and is not editable.
Insert excerpt |
---|
| Def - Transaction ID |
---|
| Def - Transaction ID |
---|
nopanel | true |
---|
|
Database Fields: ERPx_ARTransactionHeader.TransactionID (Payment Receipt and negative Customer Sale), ERPx_SOInvoiceHeader.InvoiceNumber (Price Adjustment, Return and Returnnegative Invoice) |
Transaction Type | Insert excerpt |
---|
| Transaction Type |
---|
| Transaction Type |
---|
nopanel | true |
---|
| This is required and comes from the Transaction Type selected when starting a new transaction. This field is not editable. The following transaction types have the ability to credit the Accounts Receivable Account and display on this page:
- Invoice
- Customer Sale
- Payment Receipt
- Price Adjustment
- Return
Database Fields: ERPx_ARTransactionType.TransactionName, ERPx_ARTransactionClass.TransactionTypeSK, ERPx_ARTransactionHeader.TransactionClassSK, ERPx_SOOrderHeader.OrderTypeSK
|
Unapplied Amount | Insert excerpt |
---|
| Amount - Unapplied |
---|
| Amount - Unapplied |
---|
nopanel | true |
---|
| This is required and updates when amounts are entered in the 'Applied Amount' field on the Apply Documents Record View. This is calculated by subtracting previous applications from the 'Original Amount'. This value is not stored in the database. |
Related Topics
User Guide: Customer Balances
...