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.

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

Identifies a description of the distribution, including the name of the Vendor, Fisherman, Fisherman & Tender, Tender or Loan. This is displayed for Tender Resale, AP Invoice/Credit Memo and Balance Transfer transaction types and not displayed for all other transaction types. For Tender Resale transaction types, this field comes from the 'Tender' field on the 'Home' tab of the Tender Resale record view. For AP Invoice/Credit Memo transaction types, this field comes from the 'Vendor' field on the 'Home' tab of the Invoice/Credit Memo record view. For Balance Transfer transaction types, this field comes from the 'Transfer Balance From - Debit' field on the Items grid of the Balance Transfer record view. This is only editable by changing the Tender, Vendor or Transfer Balance To fields on the associated transactions while in a Status of New.

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.FromVendorSK (Tender Resale), ERPx_APTransactionHeader.VendorSK (AP Invoice/Credit Memo), ERPx_APTransactionLine.FromDistributionAccountSK (Balance Transfer)

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

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.

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.