Process Payments Record View - AP

Process Payments Record View - AP

The Process Payments record view is used to manage the details of ACH, Draft, Wire and/or Check payments. Users may print ACH and check payments, view Journal Details, generate reports, Post or Void (Delete) batches. There are two types of payments that can be processed on this page: Quick Payment or Payment Batch. Once posted, Quick Payments can be manually applied to a document using the Apply Documents button on the Vendor Balances list view. Posting Payment Batches automatically applies the payment to the transaction(s) included in the settlement batch.

Software Version: 2023.12.19 and newer

[ 1 Page Header ] [ 2 Page Detail ] [ 2.1 Payment Grid ] [ 2.1.1 Related Topics ] [ 2.1.1.1 Page Definitions ] [ 2.1.1.2 Technical Details ]

Page Header

Toolbar Icons

Description

Delete

Help

More Actions

  • Journal Details: Opens the Journal Details page showing the Journal Entry for the batch.

  • Generate ACH File: Generates a .txt file with the ACH information. This button is only visible after the batch is successfully posted and there is at least one ACH payment that was processed.

New

Print 

 Payment # must be assigned before any payments can be printed. 

Save

Save & Close

Fields

Description

# of ACH

Identifies the total number of ACH payments in the batch. This is a non-editable calculated text box. It is automatically updated when the page is first opened, on Save, or when another Batch ID is selected. This field is never editable by the user and is not stored in the database.

# of Checks

Identifies the total number of Checks in the batch. This is a non-editable calculated text box. It is automatically updated when the page is first opened, on Save, or when another Batch ID is selected. This field is never editable by the user and is not stored in the database.

# of Draft

Identifies the total number of Draft payments in the batch.  This is a non-editable calculated text box. It is automatically updated when the page is first opened, on Save, or when another Batch ID is selected. This field is never editable by the user and is not stored in the database.

# of Payments

Identifies the total number of checks and ACH payments in the batch. This is a non-editable calculated text box that summarized the '# of ACH' and '# of Checks' when the page is first opened, or on Save, or when another Batch ID is selected. This field is never editable by the user.

Database Field: ERPx_MFTransactionBatch.TransactionCount

# of Wire

Identifies the total number of Wire payments in the batch.  This is a non-editable calculated text box. It is automatically updated when the page is first opened, on Save, or when another Batch ID is selected. This field is never editable by the user and is not stored in the database.

ACH 

Identifies the total amount of all ACH payments included on this payment batch. This is a non-editable calculated text box. For a manual payment, this amount is automatically calculated when the page is opened, or on Save, or another Batch ID is selected. For a Payment Batch, this amount is calculated once the batch is Saved. This field is never editable by the user.

Database Field: ERPx_MFTransactionBatch.ACHTotal

ACH Date

Identifies the date that is used to generate the ACH file.  This is a date field that defaults to the date of the Pmt. Date field and is always editable. This date must be greater than or equal to the Pmt. Date when the record contains ACH payments, else the message “The ACH Date must be greater than or equal to the Pmt. Date.” will be displayed when the record is saved as Approved or greater. When there are one or more ACH payments this date must be in a fiscal period open to Financial and Purchasing, else the message "The ACH Date must be in a Fiscal Period open to both Financial and Purchasing.” will be displayed when the record is saved as Approved or greater. 

If the date entered is in the past or occurs on a weekend the message "Warning, one or more of the ACH batches you have selected has a date that is either in the past or occurs on a weekend.”  will be displayed when the 'Generate ACH File' button is clicked with the option to click ‘OK’ or ‘Cancel’ and change the date if needed.  If the date is changed the record MUST be saved prior to choosing to generate the ACH file again to use the updated date.

Database Field: ERPx_MFTransactionBatch.ACHEffectiveDate

Batch ID

This is a single-select standard lookup that defaults to the system generated Batch ID associated with the user, formatted as [User First Name] + [User Last Name] + [Batch Number + 1] + [Quick Payment or Payment Batch]. This field defaults the most recent payment batch, if one exists. A batch may contain a list of one or more Accounts whose payment(s) are being processed. Selecting a different Batch ID refreshes page to display the associated Account(s) and payment details. This field is required and is never editable by a user.

The lookup contains a list of all non-posted Batch IDs associated with the user.

Database Field: ERPx_MFTransactionBatch.BatchID

Batch Total

Identifies the total amount of all checks and ACH payments included on this payment batch. This is a non-editable calculated text box. For a Quick Payment, this is calculated and defaulted when the page is first opened, or on Save, or another Batch ID is selected. For a Payment Batch, this amount is calculated once the check/ACH has been printed. This field is never editable by the user.

Database Field: ERPx_MFTransactionBatch.TransactionTotalAmount

Checkbook

This is a single-select standard lookup that allows users to select the checkbook used to distribute the payments in the batch. This is required and defaults to the checkbook of the same currency as the payments being processed.

If the payment includes one or more ACH payments, changing the Checkbook to one that does not have ACH set up will result in the message "This checkbook is not set up for ACH. Clicking 'Confirm' will set the Payment Type of all the ACH records in this Batch to Check, or you can click Cancel and set up the checkbook to support ACH." to be displayed. For Quick Payments, this field is editable while the payment batch is in a status of 'New' until a Payment # has been assigned, then it is disabled. For a Payment Batch, this is always disabled. 

The lookup contains a list of all the 'Active' Checkbooks where the Currency is the same as the payments being processed for AP batches. 

Database Fields: ERPx_MFCheckbook.CheckbookDescription, ERPx_MFTransactionBatch.CheckbookSK

Checks

Identifies the total amount of all Checks included on this payment batch. This is a non-editable calculated text box. For a manual payment, this is calculated and defaulted when the page is first opened, or on Save, or another Batch ID is selected. For a Payment Batch, this amount is calculated once the batch is Saved. This field is never editable by the user.

Database Field: ERPx_MFTransactionBatch.CheckTotal

Draft

Identifies the total amount of all Draft payments included on this payment batch. This is a non-editable calculated text box. For a manual payment, this is calculated and defaulted when the page is first opened, or on Save, or another Batch ID is selected. For a Payment Batch, this amount is calculated once the batch is Saved. This field is never editable by the user.

Database Field: ERPx_MFTransactionBatch.DraftTotal

Pmt. Date

Identifies the date the payments will post to the General Ledger, the data that will be printed on the checks, and the date assigned to the ACH record. This is a text box that is required. It defaults to the current date. The payment date entered must reside within an open fiscal period, else the message "This Fiscal Period is not open." will be displayed when user attempts to Print Payments. For payments processed from a Payment Batch page this field is disabled and for Quick Payments this field is editable while in New Status. 

Database Field: ERPx_MFTransactionBatch.BatchDate

Status

 This is a single-select standard lookup that defaults as 'New' and is required. This is always editable while the transaction is in a Status of 'New' or 'Approved'.

 Saving the Payment batch as Approved (or greater) will automatically assign any Payment #'s that have not already been assigned. 

Once the batch is posted, the Posted Balance and Net Balance for the Vendor's account(s) will be updated. When posting a Payment Batch, the payment will automatically be applied to the included transactions on the payment batch. Posting a Quick Payment will not result in any applications. 

Note: If the Vendor’s ‘Accounts Payable’ account is missing from the Vendor master file, the following message will appear when saving a payment with a status of Approved or Ready To Post:

“JE:[JournalID] Src Trans: [Batch ID] - is unbalanced.”

To resolve the issue, add the Accounts Payable account to the Vendor’s record and save the record. The batch can then be saved as Approved or Ready To Post.

Note: If the payment pays the Posted Balance in full, the Vendor's Balance line item will no longer appear unless the 'Hide Vendors where all balances are 0.00' filter is set to "No".

Wire

Identifies the total amount of all Wire payments included on this payment batch. This is a non-editable calculated text box. For a manual payment, this is calculated and defaulted when the page is first opened, or on Save, or another Batch ID is selected. For a Payment Batch, this amount is calculated once the batch is Saved. This field is never editable by the user.

Database Field: ERPx_MFTransactionBatch.WireTotal