Unapplied Payable Documents List View 3.0
Software Version: 2025.04.21 and newer
Page Header
Search
Search Options | Description |
|---|---|
Auto Hide Filters | |
Auto Refresh on Open | |
Hide fully applied transactions | A Yes/No lookup that defaults to "Yes". If set to Yes then fully applied transactions will not be visible. |
Include transactions through | A Date picker to select a date that determines which transactions to include in the grid. It defaults to the current date but can be changed at any time. |
Saved Searches | |
Vendor | A multi-select lookup that defaults to the Account(s) that was selected prior to clicking the Apply Documents button on the Vendor Balances list view. If no Account was selected, all the accounts that were visible in the grid will default in the lookup. |
Page Detail
Toolbar Icons | Description |
|---|---|
Apply Document | Opens the Apply Payables Document Record View. Users must select a transaction prior clicking this toolbar icon. Only one transaction can be selected at a time. |
Column Filter Show/Hide | |
Excel | |
Group By Show/Hide | |
Help | |
Quick Column Filter | |
Refresh | |
Saved Layouts | |
Search Options | |
Fields | Description |
Checkbox | Used to select one transaction to apply a document to. |
Doc Date |
Database Fields: ERPx_APTransactionHeader.TransactionDate (Credit Memo), ERPx_MFTransactionBatch.BatchDate (Payment) |
Doc No |
Database Field: ERPx_APTransactionHeader.DocNumber (Credit Memo), ERPx_MFTransactionBatch.TransactionID (Payment) |
GL Date |
Database Field: ERPx_ARTransactionHeader.GLDate (Credit Memo), ERPx_MFTransactionBatch.BatchDate (Payment) |
GL Period |
|
GL Year |
|
Original Amount |
Database Fields: ERPx_APTransactionHeader.ExtendedAmount (Credit Memo), ERPx_MFCheckbookTransaction.Amount (Payment) |
Transaction |
Database Field: ERPx_APTransactionHeader.TransactionID (Credit Memo), ERPx_MFTransactionBatch.TransactionID (Payment) |
Transaction Type |
Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionClass.TransactionTypeSK, ERPx_APTransactionHeader.TransactionClassSK |
Unapplied Amount |
|
Vendor |
Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK (Credit Memo), ERPx_MFCheckbookTransaction.EntitySK (Payment) |
Vendor Name |
Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK (Credit Memo), ERPx_MFCheckbookTransaction.EntitySK (Payment) |