Versions Compared

Version Old Version 4 New Version 5
Changes made by

Janice Dannenberg (Unlicensed)

Janice Dannenberg (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerptDef -

Insert excerpt
Def - Payment Batch
Def - Payment Batch
nopaneltrue
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.

...

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

After a payment batch is saved, this field is disabled.

Toolbar IconsDescription
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. 

(lightbulb) Append to Batch only adds new transactions to the batch, but does not remove previously added transactions from 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
Insert excerpt
Delete - RV Header
Delete - RV Header
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
Print Reports
Insert excerpt
Print - RV Header
Print - RV Header
nopaneltrue
Process PaymentsOpens Process Payments Record View for Vendors, where users can create, print and post check and ACH payments from the payment batch.
FieldsDescription
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 pageRecord View. 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 buttonis 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 DiscountsBatch ID
Insert excerpt
Batch ID
Batch ID

Insert excerpt
Batch ID
Batch ID
nopaneltrue
 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 Settlement Payment Batch page 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 simultaneously.

Database Field: ERPx_MFTransactionBatch.BatchID

Checkbook

Insert excerpt
Checkbook
Checkbook
nopaneltrue
This is a single-select standard lookup that allows users to select the checkbook that will be used to make the payments. This is required and defaults to from the Fisherman Accounting Settlement Default preference 'Default Fisherman Vendor Checkbook ID' field on the Vendor Preferences page. This is editable prior to clicking the Build Batch button.
Insert excerpt
Insert excerpt
Def - Checkbook
Def - Checkbook
nopaneltrue

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 Due 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 the payment batch. Invoices and Credit Memos with a Doc Date on or before the 'Settlement Date' field. Else, the message "Trans Date Thru must be defined Due Date are added to the payment batch. Payments with a Payment Date on or before the Settlement Date" will be displayeddefined Due Date 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 not required to display transactions in the settlement batch. The transactions selected for the batch are filtered based on this. always editable.

Database Field: ERPx_MFTransactionBatch.AsOfDateDueDateAsOf

Include Transactions

Identifies the types of transactions to be included in the settlement payment batch. This is a multisingle-select load on demand standard 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 batchis 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. 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

This lookup contains the values in the APBuildCheckInclude Enumeration Class.

Database Field: ERPx_MFTransactionBatch.IncludedTransactionTypeSKCSVAPBuildCheckIncludeEN

One Payment Per
Transaction Class
Vendor

Insert excerptAccount nameAccount namenopaneltrueUsed to enter a Vendor Name or Vendor ID to filter transactions for the payment batch.This is a text box that allows users to enter all or part of a Fisherman, Tender, or Loan account. This is not required to select transactions in the settlement batch, return results. It defaults as blank and is always editable. The transactions selected for the batch are filtered based on this. 

Insert excerpt
Def - Vendor
Def - Vendor
nopaneltrue

Database Field: ERPx_MFTransactionBatch.VendorSKCSV

Vendor Class Insert excerptFisherman (Account) ClassFisherman (Account) Classnopaneltrue

Used to select a Vendor Class to filter transactions for the payment batch. This is a multi-

select load on demand lookup that allows users to select one or more Fisherman Classes. This

select lookup that is not required to

select transactions in the settlement batch,

return results. It defaults as blank

,

and is always editable.

The transactions selected for the batch are filtered based on this. 

The lookup contains a list of all the 'Active' Fisherman Classes.

Database Field


The lookup contains a list of all the 'Active' Vendor Classes.

Insert excerpt
Def - Vendor Class
Def - Vendor Class
nopaneltrue

Database Fields: ERPx_MFTransactionBatch.VendorClassCSV

d

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])".

Toolbar IconsDescription
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.

(lightbulb)The Edit Amounts toolbar icon will only open a dialog box when a single transaction is selected.  

Database Field: ERPx_MFTransactionBatchTransaction.AmountToConsume

Excel
Insert excerpt
Excel - RV Grid
Excel - RV Grid
nopaneltrue
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”.

(lightbulb)Removed transactions Included transactions credit the Settlement Accrual Account are displayed in black font. Included transactions debit the Settlement Accrual Account are displayed in blue red font.

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.

(lightbulb)Removed transactions are displayed in blue font.

FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
Doc Date

Insert excerpt
Doc Date
Doc Date
nopaneltrue
For Fish Tickets, this defaults from the 'Landed Date' field. For Adjustments, Balance Transfers and Tender Resales, this defaults from the 'Date' field. For AP Credit Memos/Invoices and Fisherman Sales, this defaults from the 'Doc Date' field. For check and ACH payments, this defaults from the 'Payment Date' field. This field is always editable while the transaction is in a Status of New.

Database Field: ERPx_APDeliveryTicketHeader.TicketDate (Fish Ticket), ERPx_APTransactionHeader.TransactionDate

Doc No

Insert excerpt
Doc No
Doc No
nopaneltrue
This field comes from the 'Doc No' field on the 'Home' tab of the associated transaction. This is always editable while the transaction is in a Status of New.

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.

(lightbulb) 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

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.

(lightbulb) 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.

Orig. Trans. Amt.

Insert excerpt
Amount - Original
Amount - Original
nopaneltrue
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 types, this comes from the 'Amount' field. 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.

(lightbulb) 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 Fields: ERPx_APTransactionLine.ExtendedAmount, ERPx_APTransactionheader.ExtendedAmount, ERPx_APDeliveryTicketHeader.TotalNetAmount

Orig. Terms Discount Amt.
Terms Discount Amt. Not Taken
Terms Discount Taken
Transaction

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
Clicking on this link opens the transaction record view for the selected record. This is a system assigned number that comes from the 'Transaction Class' and is required but is never editable.

Insert excerpt
Def - Transaction ID
Def - Transaction ID
nopaneltrue

Database Field: ERPx_APTransactionHeader.TransactionID, ERPx_APDeliveryTicketHeader.TicketNumber

Transaction Type

Insert excerpt
Transaction Type
Transaction Type
nopaneltrue
This comes from the Transaction Type selected when starting a new transaction. This is never editable.

Insert excerpt
Def - Transaction Types
Def - Transaction Types
nopaneltrue

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK, ERPx_APDeliveryTicketHeader.TransactionClassSK

Vendor Name

Insert excerpt
Account Name
Account Name
nopaneltrue
 This is displayed as [Account Name] ([Account ID]) and comes from:

  • 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)


Related Topics

User Guide: Vendor Balances


Expand
titlePage Definitions

Page Definitions


...