The purpose of the is page is to show current balances for all Vendors. Users can view balances owed to or from Vendors, view transaction activity tied to a Vendor, view Payment and Invoice applications, apply Payable Documents, and process payments and payment batches. Insert excerpt Def - Vendor Def - Vendor nopanel true
...
Toolbar Icons | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apply Payables Documents | Opens Unapplied Payable Documents list view, which displays unapplied payable transactions for users to apply towards invoices. If one or more Vendor(s) are selected prior to clicking the Apply Payables Documents button, the results will be filtered on the selected Vendor(s). Else if no Vendors are selected, then all applicable transactions will be displayed. | ||||||||||||||||
Build Payment Batch | Opens Build Payment Batch Record View, where users can create new payment batches. | ||||||||||||||||
Excel |
| ||||||||||||||||
Favorites |
| ||||||||||||||||
Grid Layout |
| ||||||||||||||||
Help |
| ||||||||||||||||
Inquiry Criteria |
| ||||||||||||||||
Process Payments | Opens Process Payments Record View, where users can modify, print and post check and ACH payments. | ||||||||||||||||
Refresh |
| ||||||||||||||||
View | Displays a drop down menu of related drill-through inquiries. The list of options includes:
| ||||||||||||||||
Fields | Description | ||||||||||||||||
Checkbox |
| ||||||||||||||||
Default Accounts Payable Account | Identifies the accounts payable account for the associated Vendor, displayed as [Account Number] - [Description]. This is not required and is always editable from the 'Accounts Payable' field in the 'Accounts' tab of the Vendor Record View.
Database Fields: ERPx_GLAccount.AccountNumber - ERPx_GLAccount.Description, ERPx_APVendor.APGLAcctRef | ||||||||||||||||
Net Balance | Displays the total unapplied balance for the Vendor, including balances on open transactions, before any payments are processed. It is calculated as [Unpaid Invoices] - [Unapplied Payments] - [Unapplied Credits] + [Open Transactions]. Negative net balances will appear within parentheses. This is a calculated field that is not editable and is not stored in the database. | ||||||||||||||||
On Hold | Displays the total dollar amount of Invoices/Credit Memos that are on hold for a Vendor. This is not required. If "Yes" i selected for the 'Pmt./Apply Hold' field on the 'Properties' tab of the Invoice or Credit Memo Record View, then the 'Extended' amount of the transaction will apply to this column. Negative amounts will appear within parentheses. This is a calculated field that is not editable and not stored in the database. | ||||||||||||||||
Open Transactions | Displays the total balance amount from all transactions in a status of "New" or "Approved" for a Vendor. Once the Status is set to "Ready to Post" or "Posted", the transaction will apply to the Posted Balance. Negative amounts will appear within parentheses. This is a calculated field that is not editable and is not stored in the database. | ||||||||||||||||
Payment Amount | Identifies the amount to be paid to the Vendor as a manual payment. This field is required to create a new Quick Payment. It defaults to '0.00'. Entering a value in this field and clicking the 'Process Payments' icon in the header toolbar will create a new Quick Payment batch. This field is always editable. Database Fields: ERPx_MFCheckbookTransaction.Amount, ERPx_MFTransactionBatch.TransactionBatchSK | ||||||||||||||||
Pending Payments | Identifies whether or not there is a pending payment for the Vendor. This field is not required and displays "Yes" if the Vendor has any checks on a check batch that has not been printed yet. This field auto-populates after a payment has been entered, processed, but not yet Posted or when a settlement batch has been built, but not yet Posted. This field is not editable and not stored in the database. | ||||||||||||||||
Posted Balance | Displays the total balance from all transactions in a status of "Ready to Post" or "Posted". Negative balances will appear within parentheses. This is a calculated field that is not editable and is not stored in the database. | ||||||||||||||||
Unapplied Credits | Displays the total amount of available credits for a Vendor that have not been applied towards Invoices. This is not required. This is a calculated field that is not editable and is not stored in the database. | ||||||||||||||||
Unapplied Payments | Displays the total amount of payments for a Vendor that have not been applied towards Invoices. This is not required. This is a calculated field that is not editable and is not stored in the database. | ||||||||||||||||
Unpaid Invoices | Displays the total Invoice amount for a Vendor that have no credit or payment applications. This is not required. This is a calculated field that is not editable and is not stored in the database. | ||||||||||||||||
Vendor | Identifies the name and ID of the Vendor, displayed as 'Vendor Name' + '(Vendor ID)'. Clicking the link opens the Vendor Record View for the selected Vendor. This is required and is always editable from the 'Vendor Name' field on the 'Properties' tab of the Vendor Record View.
Database Fields: ERPx_APVendor.VendorName, ERPx_APVendor.VendorID | ||||||||||||||||
Vendor Class | Identifies the class that is assigned to the Vendor. This is required and is always editable from the 'Vendor Class' field on the 'Properties' tab of the Vendor Record View.
Database Fields: ERPx_APVendorClass.ClassDescription, ERPx_APVendor.VendorClassSK | ||||||||||||||||
Vendor ID | Identifies the unique ID of the Vendor. Clicking the link opens the Vendor Record View for the selected Vendor. This is required and is always editable from the 'Vendor ID' field on the 'Properties' tab of the Vendor Record View.
Database Field: ERPx_APVendor.VendorID | ||||||||||||||||
Vendor Name | Identifies the name of the Vendor. Clicking the link opens the Vendor Record View for the selected Vendor. This is required and is always editable from the 'Vendor Name' field on the 'Properties' tab of the Vendor Record View.
Database Fields: ERPx_APVendor.VendorName |
...