| |
|---|
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 |
|
Grid Layout |
|
Help |
|
Inquiry Criteria |
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 |
|
Fields | Description |
Checkbox | Used to select one transaction to apply a document to. |
Customer | This field is required and is not editable after the transaction has been posted.
Database Fields: ERPx_ARCustomer.CustomerID, ERPx_ARTransactionHeader.CustomerSK (Payment Receipt and negative Customer Sale), ERPx_SOOrderHeader.CustomerSK (Price Adjustment, Return and negative Invoice) |
Customer Name | This field is required and is not editable after the transaction has been posted.
Database Fields: ERPx_ARCustomer.CustomerName, ERPx_ARTransactionHeader.CustomerSK (Payment Receipt and negative Customer Sale), ERPx_SOOrderHeader.CustomerSK (Price Adjustment, Return and negative Invoice) |
Doc Date | 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 negative Invoice) |
Doc No | This field is not required. There is no 'Doc No' associated with Return, 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 | 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 | 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 | 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 | 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 negative Invoice) |
Transaction | 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.
Database Fields: ERPx_ARTransactionHeader.TransactionID (Payment Receipt and negative Customer Sale), ERPx_SOInvoiceHeader.InvoiceNumber (Price Adjustment, Return and negative Invoice) |
Transaction Type | 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 | 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. |