Insert excerpt
Software Version: 2021.03.05 and newer
Table of Contents | ||
---|---|---|
|
Page Header
...
Updates the grid section with new transactions that match the filter criteria. This icon is only displayed after the initial batch is created to allow users to redefine search criteria and add additional transactions to the batch.
Append to Batch only adds new transactions to the batch, but does not remove previously added transactions from the batch.
...
Builds a payment batch based on filter criteria selected / entered. This icon is only displayed when a new batch is being created, and is replaced with "Append to Batch" after the initial payment batch is created.
...
Identifies the date the payment will be applied. This is a date picker that defaults to the current date. It is required and if missing, will default to current date on Save. This date will automatically populate the 'Payment Date' field on the Process Payments Record View. This field is editable prior to clicking the Build Batch button. After a payment batch is saved, this field is disabled.
Database Field: EERPx_MFTransactionBatch.BatchDate
...
Determines if expired discounts should be applied or not. Any non-expired discounts are applied by default, but the discount amounts can be manually edited. This is a Yes/No lookup that is required. It defaults as "No" and is always editable.
Database Field: EERPx_MFTransactionBatch.ApplyExpiredDiscounts
...
The purpose of this page is to create, update and process Vendor payment batches. Users will be able to search for unapplied or partially applied invoice, credit memo and check payment transactions to include on the payment batch. Payment batches, when posted, automatically apply payable transactions and receivable transactions towards each other to settle vendor balances. Insert excerpt Def - Payment Batch Def - Payment Batch nopanel true
Software Version: 2021.03.05 and newer
Table of Contents | ||
---|---|---|
|
Page Header
Toolbar Icons | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Append to Batch | Updates the grid section with new transactions that match the filter criteria. This icon is only displayed after the initial batch is created to allow users to redefine search criteria and add additional transactions to the batch.
| ||||||||||||||||
Build Batch | Builds a payment batch based on filter criteria selected / entered. This icon is only displayed when a new batch is being created, and is replaced with "Append to Batch" after the initial payment batch is created. | ||||||||||||||||
Delete |
| ||||||||||||||||
Grid Layout |
| ||||||||||||||||
Help |
| ||||||||||||||||
Print Reports |
| ||||||||||||||||
Process Payments | Opens Process Payments Record View for Vendors, where users can create, print and post check and ACH payments from the payment batch. | ||||||||||||||||
Fields | Description | ||||||||||||||||
Apply Date | Identifies the date the payment will be applied, formatted from the users 'Date Format' preference. This is a date picker that defaults to the current date. It is required and if missing, will default to current date on Save. This date will automatically populate the 'Payment Date' field on the Process Payments Record View. This field is editable prior to clicking the Build Batch button. After a payment batch is saved, this field is disabled. Database Field: EERPx_MFTransactionBatch.BatchDate | ||||||||||||||||
Apply Expired Discounts | Determines if expired discounts should be applied or not. Any non-expired discounts are applied by default, but the discount amounts can be manually edited. This is a Yes/No lookup that is required. It defaults as "No" and is always editable. Database Field: EERPx_MFTransactionBatch.ApplyExpiredDiscounts | ||||||||||||||||
Batch ID |
Database Field: ERPx_MFTransactionBatch.BatchID | ||||||||||||||||
Checkbook |
The lookup contains a list of all the 'Active' Checkbooks. Database Fields: ERPx_MFCheckbook.CheckbookDescription, ERPx_MFTransactionBatch.CheckbookSK | ||||||||||||||||
Discount Date as of | Identifies the Discount Date to use to filter transactions for the payment batch, formatted from the users 'Date Format' preference. Invoices and Credit Memos with a Discount Date on or before the defined 'Discount Date as of' field are added to the payment batch. This is a date picker that is not required to return results. This field defaults as blank and is always editable.
Database Field: ERPx_MFTransactionBatch.DiscountDateAsOf | ||||||||||||||||
Doc No | Identifies the document number of a transaction to be included in a payment batch. This is a text box that is not required to return results. If entered, it must be <= 150 characters. It defaults as blank and is always editable. Database Field: ERPx_MFTransactionBatch.InvoiceNumber | ||||||||||||||||
Due Date as of | Identifies the Due Date to use to filter transactions for the payment batch, formatted from the users 'Date Format' preference. Invoices and Credit Memos with a Due Date on or before the defined 'Due Date as of' field are added to the payment batch. This is a date picker that is not required to return results. This field defaults as blank and is always editable.
Database Field: ERPx_MFTransactionBatch.DueDateAsOf | ||||||||||||||||
Include Transactions | Identifies the types of transactions to be included in the payment batch. This is a single-select standard lookup that is required to return results. This defaults as blank. If missing, the message "Include Transactions is required." will be displayed when the Build Batch button is clicked. This field is always editable. This lookup contains the values in the APBuildCheckInclude Enumeration Class. Database Field: ERPx_MFTransactionBatch.APBuildCheckIncludeEN | ||||||||||||||||
One Payment Per | Identifies whether payments should be applied per Document or per Vendor. One payment can be applied towards several invoices simultaneously and also several payment transactions can be used towards one invoice. This is a single-select standard lookup that allows users to navigate between active batches. The field defaults to (Build New Batch) when the Build Payment Batch Record View is opened. Once the Build Batch button is clicked, this field defaults to the username, formatted as [User First Name] + [User Last Name] + [Previous Batch Number + 1]. Selecting a Batch ID from the lookup will reload the page with the associated fields and transactions grid. This is a system assigned value and is never editable by a user. A user may have several check batches simultaneouslyis required to return results. It defaults as "Vendor" and is editable prior to clicking the Build Batch button. Updating the value to "Document" will automatically update the 'Include Transactions' field to be "Invoices Only". After a payment batch is saved, this field is disabled. This lookup contains the values in the MFOneCheckPer Enumeration Class. Database Field: ERPx_MFTransactionBatch. BatchIDMFOneCheckPerEN | ||||||||||||||||
Checkbook | Insert excerpt | | Checkbook | Checkbook | |||||||||||||
nopanel | true | Identifies the Due Date to use to filter transactions for the payment batch. Invoices and Credit Memos with a Doc Date on or before the defined Due Date are added to the payment batch. Payments with a Payment Date on or before the defined Due Date are added to Identifies the transaction class(es) to be included in the payment batch. This is a multi-select lookup that is not required to return results. It defaults with no Transaction Classes selected and is always editable.
The This lookup contains a list of all the 'Active' Checkbooks. Database Fields: ERPx_MFCheckbook.CheckbookDescription, ERPx_MFTransactionBatch.CheckbookSK | Discount Date as of | Doc No | Due Date as of | active Transaction Classes where the
Database Field: ERPx_MFTransactionBatch.TransactionClassSKCSV | |||||||||||
Vendor | Used to enter a Vendor Name or Vendor ID to filter transactions for the payment batch.This is a date picker text box that is not required to return results. This field It defaults as blank and is always editable.
Database Field: ERPx_MFTransactionBatch.DueDateAsOf | Include Transactions | Identifies the types of transactions to be included in VendorSKCSV | ||||||||||||||
Vendor Class | Used to select a Vendor Class to filter transactions for the payment batch. This is a multi-select lookup that is not required to return results. It defaults as blank This lookup contains the values in the APBuildCheckInclude Enumeration Class. Database Fieldand is always editable. The lookup contains a list of all the 'Active' Vendor Classes.
Database Fields: ERPx_MFTransactionBatch. VendorClassCSV | One Payment Per | Transaction Class | Vendor | Used to enter a Vendor Name or Vendor ID to filter transactions for the payment batch.This is a text box that is not required to return results. It defaults as blank and is always editable.|||||||||||||
Insert excerpt | Def - Vendor | Def - Vendor | |||||||||||||||
nopanel | true | Vendor Class | Used to select a Vendor Class to filter transactions for the payment batch.This is a multi-select lookup that is not required to return results. It defaults as blank and is always editable.|||||||||||||||
Insert excerpt | Def - Vendor Class | Def - Vendor Class | |||||||||||||||
nopanel | true |
Page Detail
Transactions Grid
The purpose of this grid is to display and manage the individual transactions associated with the payment batch. Transactions that Credit the Settlement Accrual Account will be displayed as positive and in black font. Transactions that Debit the Settlement Accrual Account will be displayed as negative and in red font, as they will be subtracted from the payment amount. Transactions that are removed will be displayed in blue font. The default grid layout for this grid is grouped by Vendor Name. The group heading displays as "Vendor Name: [VendorName] + ([VendorID])".
Clicking the Edit Amounts toolbar icon opens a dialog box that allows users to edit the amount to settle. It defaults to the Open Amount of the selected transaction. Users may enter the Amount and when Saved, the Amount will populate in the 'Amount to Settle' field. If the transaction that was edited is a payable transaction then the 'Hold Back Amt.' field will be recalculated as [Open Amt.] - [Amount to Settle] on the Build Settlement Batch page.
The 'Amount' field entered in the dialog box cannot be greater than the 'Open Amt.' field. If so, the message "The Amount cannot be greater than is left on the transaction." will be displayed on Save & Close. Additionally, if the 'Hold Back Comment' field was previously populated, the 'Hold Back Comment' field will be cleared if the user edits the 'Amount' field.
![(lightbulb)](/wiki/s/348552385/6452/04bac681dd10a222a704ff3a0610b982ed45ee35/_/images/icons/emoticons/lightbulb_on.png)
Database Field: ERPx_MFTransactionBatchTransaction.AmountToConsume
This button displays the following options: “Include Filtered” and “Include Selected”. This allows users to add previously removed transactions back to the batch by selecting/filtering the transactions in the grid and clicking “Include Transactions” and choosing either “Include Filtered” or Include Selected”.
Included transactions credit the Settlement Accrual Account are displayed in black font. Included transactions debit the Settlement Accrual Account are displayed in red font.
This button displays the following options: “Remove Filtered” and “Remove Selected”. If filter criteria have been entered in the grid, and “Remove Filtered” is clicked, the filtered transactions will be removed from the settlement batch. If the check box next to the transaction is checked and the “Remove Selected” is clicked, those transactions checked will be removed from the settlement batch. If there was value in the 'Hold Back Comment' field, it will be cleared when the transaction is removed from the settlement batch.
![(lightbulb)](/wiki/s/348552385/6452/04bac681dd10a222a704ff3a0610b982ed45ee35/_/images/icons/emoticons/lightbulb_on.png)
Database Field: ERPx_APDeliveryTicketHeader.TicketDate (Fish Ticket), ERPx_APTransactionHeader.TransactionDate
Database Field: ERPx_APTransactionHeader.DocNumber
Page Detail
Transactions Grid
The purpose of this grid is to display and manage the individual transactions associated with the payment batch. Transactions that Credit the Accounts Payable Account will be displayed as positive and in black font. Transactions that Debit the Accounts Payable Account will be displayed as negative and in red font, as they will be subtracted from the payment amount. Transactions that are removed will be displayed in blue font. The default grid layout for this grid is grouped by Vendor Name. The group heading displays as "Vendor Name: [VendorName] + ([VendorID])".
Toolbar Icons | Description | ||||||||||||||||||||||||||
Edit Amounts | Clicking the Edit Amounts toolbar icon opens a dialog box that allows users to edit the Discount Amount to Take (if applicable) and Max Amount to Pay. The 'Discount Amount to Take' field defaults from the 'Terms Discount Taken' column. This field is disabled if the Payment Terms of the transaction do not allow for discounts. The 'Amount' field defaults from the 'Max Amount to Pay' column. The 'Amount' entered in the dialog box cannot be greater than the 'Open Amt.' field. If so, the message "The Amount cannot be greater than is left on the transaction." will be displayed on Save & Close. Additionally, the 'Discount Amount to Take' entered in the dialog box cannot be greater than the 'Original Terms Discount Amt.' field. If so, the message "Cannot set a Discount Amount to Take greater than is left on the transaction" will be displayed on Save & Close.
Database Fields: ERPx_MFTransactionBatchTransaction.DiscountToConsume, ERPx_MFTransactionBatchTransaction.AmountToConsume | ||||||||||||||||||||||||||
Excel |
| ||||||||||||||||||||||||||
Included Transactions | This button displays the following options: “Include Filtered” and “Include Selected”. This allows users to add previously removed transactions back to the payment batch by selecting/filtering the transactions in the grid and clicking “Include Transactions” and choosing either “Include Filtered” or Include Selected”.
| ||||||||||||||||||||||||||
Remove Transactions | This button displays the following options: “Remove Filtered” and “Remove Selected”. If filter criteria have been entered in the grid, and “Remove Filtered” is clicked, the filtered transactions will be removed from the payment batch. If the check box next to the transaction is checked and the “Remove Selected” is clicked, those transactions checked will be removed from the settlement batch.
| ||||||||||||||||||||||||||
Fields | Description | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Checkbox |
| ||||||||||||||||||||||||||
Doc Date |
Database Fields: ERPx_APTransactionHeader.TransactionDate (Invoice/Credit Memo), ERPx_MFCheckbookTransaction.CreatedDate (Payment) | ||||||||||||||||||||||||||
Doc No |
Database Fields: ERPx_APTransactionHeader.DocNumber (Invoice/Credit Memo), ERPx_MFCheckbookTransaction.TransactionID (Payment) | ||||||||||||||||||||||||||
Discount Date |
Database Field: ERPx_APTransactionHeader.DiscountDate | ||||||||||||||||||||||||||
Due Date |
Database Field: ERPx_APTransactionHeader.DueDate | ||||||||||||||||||||||||||
Max Amount to Pay | Identifies the maximum amount to be paid for the document. This is a non-editable text box that is required. This field is calculated as [Open Amount] - [ | Hold Back Amt.Terms Discount Taken] - [Previous Payment Applications]. This field can be | changed edited by clicking the 'Edit Amounts' icon in the grid header and entering a amount in the 'Amount' field | or by entering a value in the 'Hold Back Amount' field on the | Mass Update Edit Amounts dialog box. This field is | always editablealways editable from the Edit Amounts dialog box.
| Settlement Accrual Accounts Payable Account, this field will display as positive | (for example $100.00) regardless of the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preference. For transactions that Debit the | Settlement Accrual Accounts Payable Account, this | field will display as negative (for example -$100.00) regardless of the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preferencefield will display as negative. Database Field: ERPx_MFTransactionBatchTransaction.AmountToConsume | |||||||||||||||||
Open Amt. | Displays the amount due for payment on the transaction. This | field is a non-editable text box that is required | and calculated by taking the Original Transaction Amount and subtracting any applications that have previously been made. It is calculated as [Orig. Trans. Amt] - previous applications. This field is for information only and never editable. This field is | never editablenot stored in the database.
| Settlement Accrual Accounts Payable Account, this field will display as positive | (for example $100.00) regardless of the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preference. For transactions that Debit the Settlement Accrual Account, this field will display as negative (for example -$100.00) regardless of the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preference. For transactions that Debit the Accounts Payable Account, this field will display as negative. | |||||||||||||||||||||
Orig. Trans. Amt. |
| For AP Invoice/Credit Memo, Adjustment, Tender Resale and Balance Transfer transaction types, this comes from the 'Extended' amount of the individual line item. For Fish Ticket and Payment Receipt transaction typesThis is a non-editable text box that is required. For Invoice and Credit Memo transactions, this defaults from the 'Amount' field on the 'Home' tab of the Invoice Record View. For Payment transactions, this comes from the 'Amount' field for the specific check or ACH payment on the Process Payments Record View. This field is for information only and never editable. | For Fisherman Sale transaction types, this comes from the 'On Account' field. For Check and ACH payment transaction types, this comes from the 'Amount' field for the specific check or ACH payment. This field is always editable by changing the Price or Quantity of line items while the transaction is in a Status of New.Orig. Terms Discount Amt. | Terms Discount Amt. Not Taken | Terms Discount Taken | Transaction | |||||||||||||||||||||
Insert excerpt | Transaction ID | Transaction ID | |||||||||||||||||||||||||
nopanel | true | ||||||||||||||||||||||||||
Insert excerpt | Def - Transaction ID | Def - Transaction ID | |||||||||||||||||||||||||
nopanel | true | Transaction Type | |||||||||||||||||||||||||
Insert excerpt | Transaction Type | Transaction Type | |||||||||||||||||||||||||
nopanel | true |
Database Fields: ERPx_APTransactionHeader.ExtendedAmount (Invoice/Credit Memo), ERPx_MFCheckbookTransaction.Amount (Payment) | |||||||||||||||||||||||||
Orig. Terms Discount Amt. | Displays the original discount amount. This is a non-editable text box that is not required. It is calculated based on the Payment Terms associated with the transaction by using the [Percent of Discount] x [Amount] if the Payment Terms of the transaction allows for discounts. This field is for information only and never editable. Is this stored in the db? | ||||||||||||||||||||||||||
Terms Discount Amt. Not Taken | Displays the discount amount that has not been used yet. This is a non-editable text box that is not required. It is calculated as [Orig. Terms Discount Amt.] - [Terms Discount Taken] if the Payment Terms of the transaction allows for discounts. Else, it will default as "0.00". This field will be automatically updated if the 'Terms Discount Taken' field is updated. This field is for information only and never editable. Is this stored in the db? | ||||||||||||||||||||||||||
Terms Discount Taken | Identifies the amount of discount applied to the transaction. This is a non-editable text box that is not required. It defaults from the 'Orig. Terms Discount Amt.' field when:
This defaults to "0.00" if the discount is expired and the ‘Apply Expired Discounts’ is set to No. It also defaults to "0.00" when the Payment Terms of the transaction do not allow for discounts. This field is only editable on the Edit Amounts dialog box if the Payment Terms of the transaction allows for discounts. Database Field: ERPx_MFTransactionBatchTransaction.DiscountToConsume | ||||||||||||||||||||||||||
Transaction |
| Types
| Types
Database Fields: | ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader. | TransactionClassSKTransactionID (Invoice/Credit Memo), ERPx_ | APDeliveryTicketHeader.TransactionClassSKVendor Name MFCheckbookTransaction.TransactionID (Payment) | |||||||||||||||||||||
Transaction Type | Account Name
| Account Name |
| This is displayed as [Account Name] ([Account ID]) and comes from:This is a non-editable text box that is required. This defaults from the Transaction Type selected when creating a new transaction. This field is for information only and never editable.
Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionClass.TransactionTypeSK, ERPx_APTransactionHeader.TransactionClassSK (Invoice/Credit Memo), ERPx_MFCheckbookTransaction.TransactionTypeSK (Payment) | |||||||||||||||||||||||
Vendor Name |
| transaction record view.Payments - Invoice Record View. For Payment transactions, this defaults from the 'Account' field | in on the | header Payments grid of the Process Payments | page. This field is always editable while the transaction is in a Status of New.Record View. This field is for information only and never editable.
Database Fields: ERPx_APVendor.VendorName | , ERPx_APTransactionHeader.VendorSK ( | Payment Receipt, Fisherman Sale & Tender Resale), ERPx_ | APTransactionLine.ToDistributionAccountSK (Adjustment & Balance TransferAPVendor.VendorID), ERPx_APTransactionHeader.VendorSK ( | AP Invoice | & AP /Credit Memo), ERPx_ | APDeliveryTicketHeader.FishermanAccountVendorSK (Fish Ticket), ERPx_APSettlementTransaction.SettleToEntitySK MFCheckbookTransaction.EntitySK (Payment) |
Related Topics
...