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 settlement 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 page. This field must be on or after the 'Trans Date Thru' field. If not, the message "Trans Date Thru must be on or before the Settlement Date" will be displayed. This field is editable prior to clicking the Build Batch button.
Database Field: EERPx_MFTransactionBatch.BatchDate
...
Database Field: ERPx_MFTransactionBatch.BatchID
...
The lookup contains a list of all the 'Active' Checkbooks where the Currency is USD.
Database Fields: ERPx_MFCheckbook.CheckbookDescription, ERPx_MFTransactionBatch.CheckbookSK
...
Database Field: ERPx_MFTransactionBatch.AsOfDate
...
Identifies the types of transactions to be included in the settlement batch. This is a multi-select load on demand lookup that allows users to lookup transactions by the specified transaction types. This is defaulted as blank and required to display transactions in the settlement batch. If missing, the message "Include Transactions is required." will be displayed when the Build Batch button is clicked. This field is always editable. The transactions selected for the batch are filtered based on this.
The lookup contains the following values: All, Adjustment, Balance Transfer, Credit Memo, Fish Ticket, Fisherman Sale, Invoice, Payment, Payment Receipt and Tender Resale
Database Field: ERPx_MFTransactionBatch.IncludedTransactionTypeSKCSV
...
Database Field: ERPx_MFTransactionBatch.VendorSKCSV
...
The lookup contains a list of all the 'Active' Fisherman Classes.
Database Field: ERPx_MFTransactionBatch.VendorClassCSV
Page Detail
Transactions Grid
The purpose of this grid is to display and manage the individual transactions associated with the settlement 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 are will be subtracted from the payment amount. Users can edit the 'Hold Back Amt.' and 'Amount to Settle' fields for any Credit balance transaction (transaction that Credits the Settlement Accrual Account). The default grid layout for this grid is grouped by Fisherman Name. The group heading displays as "Fisherman Name: [VendorName] + ([VendorID]) + PO Amount: [POAmount]". The PO Amount comes from the 'Open PO's' field on the Fisherman Balance list view and if 0.00, then will not be appended to the Fisherman Name.
...
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.
Note: The Edit Amounts toolbar icon will only open a dialog box when a single transaction is selected.
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”.
Note: Removed transactions are displayed in blue font.
...
- Hold Back Comment: A text box that defaults to blank. Assigns the text to the selected/filtered transactions when Apply is clicked.
- Hold Back Method: A single-select lookup that defaults to "Hold back all Transactions by a fixed Amount", but also has an option for "Hold back all Transactions by a fixed Percent". Takes the 'Hold Back Percent / Amount' value in conjunction with the selected method and assigns the calculated amount to the 'Hold Back Amt.' field and the 'Amount to Settle' field for the selected/filtered transactions when Apply is clicked.
- Hold Back Percent / Amount: A text box that defaults to blank. Takes the 'Hold Back Method' selection in conjunction with the value entered and assigns the calculated amount to the 'Hold Back Amt.' field and the 'Amount to Settle' field for the selected/filtered transactions when Apply is clicked.
Hold Back Amounts and Hold Back Comments will only apply to transactions where the 'Payable (GL Credit)" value is "Yes".
...
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.
Note: Removed transactions are displayed in blue font.
...
Identifies the maximum amount to be paid for the document. This field is calculated as [Open Amount] - [Hold Back Amt.]. This field can be changed 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 dialog box. This field is always editable.
For transactions that Credit the Settlement Accrual 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.
Database Field: ERPx_MFTransactionBatchTransaction.AmountToConsume
...
Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.FromVendorSK (Tender Resale), ERPx_APTransactionHeader.VendorSK (AP Invoice/Credit Memo), ERPx_APTransactionLine.FromDistributionAccountSK (Balance Transfer)
...
Database Field: ERPx_APDeliveryTicketHeader.TicketDate (Fish Ticket), ERPx_APTransactionHeader.TransactionDate
...
Database Field: ERPx_APTransactionHeader.Description
...
Database Field: ERPx_APTransactionHeader.DocNumber
...
- Adjustment transactions - from the 'Distributed To' field of the Adjustment transaction line.
- Balance Transfers - from the 'Transfer Balance To - Credit' field or 'Transfer Balance From - Debit' field of the Balance Transfer Line
- Payment Receipts - from the 'Received From' in the header of the Payment Receipt transaction
- AP Invoice/Credit Memos - from the 'Distributed To' field of the Adjustment transaction line.
- Fish Tickets - from the 'Paid Account' on the Fish Ticket.
- For Fisherman Sale/Tender Resale transaction types, this field comes from the 'Fisherman' field on the 'Home' tab of the transaction record view.
- Payments - from the 'Account' field in the header of the Process Payments page.
This field is always editable while the transaction is in a Status of New.
Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK (Payment Receipt, Fisherman Sale & Tender Resale), ERPx_APTransactionLine.ToDistributionAccountSK (Adjustment & Balance Transfer), ERPx_APTransactionHeader.VendorSK (AP Invoice & AP Credit Memo), ERPx_APDeliveryTicketHeader.FishermanAccountVendorSK (Fish Ticket), ERPx_APSettlementTransaction.SettleToEntitySK (Payment)
...
Identifies the hold back amount to be paid for the payable document. This field comes from a fixed amount or percentage of the Original Transaction Amount that has been held back using the Mass Update button in the grid header. This field is also auto calculated as [Open Amt.] - [Amount to Settle] for a payable document when the user clicks the 'Edit Amounts' button and enters an amount. For payable transactions that credit the Settlement Accrual Account, this field is always editable. For receivable transactions that debit the Settlement Accrual Account, this field displays "0.00" and is not editable. This value is not stored in the database.
This field will always display as negative, regardless of the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preference.
...
Identifies the hold back comment for the transaction. This field comes from a combination of the values entered/selected on the 'Hold Back Amount', 'Hold Back Comment' and 'Hold Back Method' fields on the Mass Update dialog box. If no values are entered for the 'Hold Back Comment' field on the Mass Update dialog box, the 'Hold Back Comment' field on the Build Settlement Batch will be "Hold Back Amount: " + [Hold Back Amount] or "Hold Back Percent: " + [Hold Back Amount], depending on the user selection for the 'Hold Back Method' field. If a value is entered on the 'Hold Back Comment' field on the Mass Update dialog box, the 'Hold Back Comment' field on the Build Settlement Batch will be [Hold Back Comment] + "Amount: " or "Percent: " + [Hold Back Amount]. This field is not required, but if entered, it must be <= 100 characters. For payable transactions that credit the Settlement Accrual Account, this field is always editable. For receivable transactions that debit the Settlement Accrual Account, this field is not editable.
This field is only populated when utilizing the Mass Update functionality from the grid header. When updating the 'Amount to Settle' field by clicking the Edit Amounts button, any existing value in the 'Hold Back Comment' field will be removed.
Database Field: ERPx_MFTransactionBatchTransaction.HoldBackComment
...
Database Field: ERPx_APTransactionLine.LineDescription
...
Displays the amount due for payment on the transaction. This field is required and calculated by taking the Original Transaction Amount and subtracting any applications that have previously been made. This field is never editable.
...
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. 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 page. This field must be on or after the 'Trans Date Thru' field. If not, the message "Trans Date Thru must be on or before the Settlement Date" will be displayed. This field is editable prior to clicking the Build Batch button. Database Field: EERPx_MFTransactionBatch.BatchDate | ||||||||||||||||
| Apply Expired Discounts | |||||||||||||||||
| Batch ID |
Database Field: ERPx_MFTransactionBatch.BatchID | ||||||||||||||||
| Checkbook |
The lookup contains a list of all the 'Active' Checkbooks where the Currency is USD. Database Fields: ERPx_MFCheckbook.CheckbookDescription, ERPx_MFTransactionBatch.CheckbookSK | ||||||||||||||||
| Discount Date as of | |||||||||||||||||
| Doc No | |||||||||||||||||
| Due Date as of | Identifies the transaction date to use to filter transactions. This is a date picker that allows users to search for a transaction based on the GL Date of the transaction.This field must be on or before the 'Settlement Date' field. Else, the message "Trans Date Thru must be on or before the Settlement Date" will be displayed. This field defaults as blank and is not required to display transactions in the settlement batch. The transactions selected for the batch are filtered based on this. Database Field: ERPx_MFTransactionBatch.AsOfDate | ||||||||||||||||
| Include Transactions | Identifies the types of transactions to be included in the settlement batch. This is a multi-select load on demand lookup that allows users to lookup transactions by the specified transaction types. This is defaulted as blank and required to display transactions in the settlement batch. If missing, the message "Include Transactions is required." will be displayed when the Build Batch button is clicked. This field is always editable. The transactions selected for the batch are filtered based on this. The lookup contains the following values: All, Adjustment, Balance Transfer, Credit Memo, Fish Ticket, Fisherman Sale, Invoice, Payment, Payment Receipt and Tender Resale Database Field: ERPx_MFTransactionBatch.IncludedTransactionTypeSKCSV | ||||||||||||||||
| One Payment Per | |||||||||||||||||
| Transaction Class | |||||||||||||||||
| Vendor |
Database Field: ERPx_MFTransactionBatch.VendorSKCSV | ||||||||||||||||
| Vendor Class |
The lookup contains a list of all the 'Active' Fisherman Classes. Database Field: ERPx_MFTransactionBatch.VendorClassCSV |
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. 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 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.
Database Field: 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 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 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.
| ||||||||||||||||
| Fields | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Checkbox |
| ||||||||||||||||
| Doc Date |
Database Field: ERPx_APDeliveryTicketHeader.TicketDate (Fish Ticket), ERPx_APTransactionHeader.TransactionDate | ||||||||||||||||
| Doc No |
Database Field: ERPx_APTransactionHeader.DocNumber | ||||||||||||||||
| Discount Date | |||||||||||||||||
| Due Date | |||||||||||||||||
| Max Amount to Pay | Identifies the maximum amount to be paid for the document. This field is calculated as [Open Amount] - [Hold Back Amt.]. This field can be changed 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 dialog box. This field is always editable.
Database Field: ERPx_MFTransactionBatchTransaction.AmountToConsume | ||||||||||||||||
| Open Amt. | Displays the amount due for payment on the transaction. This field is required and calculated by taking the Original Transaction Amount and subtracting any applications that have previously been made. This field is never editable.
| ||||||||||||||||
| Orig. Trans. Amt. |
| . Orig. Trans. Amt. | |||||||||||||||
| Insert excerpt | Amount - Original | Amount - Original | |||||||||||||||
| nopanel | true | ||||||||||||||||
| Payable (GL Credit) | Displays whether or not the transaction is a payable. The value will display as "Yes" if the transaction resulted in a Credit to the Settlement Accrual Account. The value will display as blank if the transaction resulted in a Debit to the Settlement Accrual Account. This field is not stored in the database and is never editable. | ||||||||||||||||
| 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 | ||||||||||||||||
| Insert excerpt | Def - Transaction Types | Def - Transaction Types | |||||||||||||||
| nopanel | true | 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. Database Fields: ERPx_APTransactionLine.ExtendedAmount, ERPx_APTransactionheader.ExtendedAmount, ERPx_APDeliveryTicketHeader.TotalNetAmount | |||||||||||||||
| Orig. Terms Discount Amt. | |||||||||||||||||
| Terms Discount Amt. Not Taken | |||||||||||||||||
| Terms Discount Taken | |||||||||||||||||
| Transaction |
Database Field: ERPx_APTransactionHeader.TransactionID, ERPx_APDeliveryTicketHeader.TicketNumber | ||||||||||||||||
| Transaction Type |
Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK, ERPx_APDeliveryTicketHeader.TransactionClassSK | ||||||||||||||||
| Vendor Name |
This field is always editable while the transaction is in a Status of New. Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK (Payment Receipt, Fisherman Sale & Tender Resale), ERPx_APTransactionLine.ToDistributionAccountSK (Adjustment & Balance Transfer), ERPx_APTransactionHeader.VendorSK (AP Invoice & AP Credit Memo), ERPx_APDeliveryTicketHeader.FishermanAccountVendorSK (Fish Ticket), ERPx_APSettlementTransaction.SettleToEntitySK (Payment) |
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
...