The Process Payments record view is used to manage the details of ACH and/or check payments. Users may print ACH and check payments, view Journal Details, generate reports, Post or Void batches. There are two types of payments that can be processed on this page: Quick Payment or Payment Batch. Once posted, Quick Payments can to be manually applied to document using the Apply Documents button on the Vendor Balances list view. Posting Payment Batches automatically apply the payment to the transaction(s) included in the settlement batch.
Software Version: 2023.XX.XX and newer
| Table of Contents | ||
|---|---|---|
|
Page Header
...
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.XX.XX and newer
| Table of Contents | ||
|---|---|---|
|
Page Header
| Toolbar Icons | Description | ||||||||
| Delete |
| ||||||||
| Help |
| ||||||||
| More Actions |
| ||||||||
|
Allows users to select "Print ACH" or "Print Checks" and opens a PDF allowing users to view the selected payments. Once the Print Payments button has been clicked, the Batch Status field will be updated to "Checks Printed", "ACH" or "ACH & Checks Printed". | ||
| Save |
|
|
|
|
|
| Save & Close |
|
|
|
- Journal Details:
Allows users to select "Print ACH" or "Print Checks" and opens a PDF allowing users to view the selected payments. Once the Print Payments button has been clicked, the Batch Status field will be updated to "Checks Printed", "ACH" or "ACH & Checks Printed".
| 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 is calculated once the check/ACH has been printed. This field is never editable by the user |
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
. Database Field: ERPx_MFTransactionBatch.ACHTotal | |||||||||
| ACH Date | Identifies the date that is used to generate the ACH file. Database Field: ERPx_MFTransactionBatch.ACHEffectiveDate | ||||||||
| Batch ID |
The lookup contains a list of all non-posted Batch IDs associated with the user. Database Field: ERPx_MFTransactionBatch. |
The lookup contains a list of all non-posted Batch IDs associated with the user.
Database Field: ERPx_MFTransactionBatch.BatchID
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
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 |
Changing the Checkbook will
The lookup contains a list of all the 'Active' Checkbooks where the Currency is the same as the payments being processed for AP batches. |
Changing the Checkbook will automatically update the 'Next Check #' field. 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 records in this Batch to Check, or you can click Cancel and set up the checkbook to support ACH." to be displayed. This field is editable prior to clicking Print Payments.
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
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 check/ACH has been printed. 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 check/ACH has been printed. 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 Settlement/Payment Batch page this field is disabled and for Quick Payments this field is editable prior to posting the batch. Database Field: ERPx_MFTransactionBatch.BatchDate | |
| Status |
|
|
|
|
|
|
Post: Sets the Batch Status to "Posted". This indicates that the checks and ACH payments have been printed successfully, and the printed checks and ACH are valid for use. Once the batch is posted, the Posted Balance and Net Balance for the Account(s) will be updated. When posting a Payment Batch, the payment will automatically be applied to the included transactions on the settlement batch. Posting a Quick Payment will not result in any applications. Note: If the payment pays the Posted Balance in full, the vendor's Settlement Balance line item will no longer appear. Void: Sets the Batch Status to "Void". This indicates that the checks have not been printed successfully, and the printed checks are invalid for use. Some examples of when a check may be voided would be if the check paper got jammed in the printer, printed on the wrong side or upside down on the check paper, or if an incorrect paper was used to print |
Once voided, the check is destroyed in the system and cannot be used.
Wirethe check. Once voided, the check is destroyed in the system and cannot be used. | |||||||||||||||||
| 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 check/ACH has been printed. This field is never editable by the user. Database Field: ERPx_MFTransactionBatch.WireTotal | ||||||||||||||||
| Batch Status | Identifies the Status of the Batch. This is a non-editable text box that defaults as 'New' and is required. This is never editable by the user.
ACH: User clicked the Print Payments button and selected Print ACH. ACH & Checks Printed: User clicked the Print Payments button and selected both Print Checks and Print ACH. Checks Printed: User clicked the Print Payments button and selected Print Checks. Posted: User clicked the Post Batch button and Posted Balance and Net Balance for the Account(s) have been updated. When posting a Payment Batch, the payment will be automatically applied to the included transactions on the settlement batch. Posting a Quick Payment will not result in any applications. Void: User clicked the Void Batch button and payments were cancelled for all Account(s) on the Payment Batch or Quick Payment. Posted Balance and Net Balance for the Account(s) will remain unchanged. Database Field: ERPx_MFTransactionBatch.TransactionStatusSK |
Page Detail
Payment Grid
The Process Checks grid allows users to view or manage the details of all ACH/check payments being written as part of a payment batch or quick payment. From this grid, users are also able to update Address and Payee information and separate a single payment into multiple payments.
| Toolbar Icons | Description | ||||||||
Add Item |
| ||||||||
| Column Filter Show/Hide |
| ||||||||
| Excel |
| ||||||||
| Group By Show/Hide |
| ||||||||
| Quick Column Filter |
| ||||||||
| Remove Items |
| ||||||||
| Saved Layouts |
|
|
Used to select one or more records.
| Fields | Description | |
|---|---|---|
| Checkbox | Used to select one or more records. | |
Address | Displays the full Address of the Vendor's payment address. This is a non-editable textbox that defaults to [Address1] _[Address2]_[Address3]_[City]_[State]_[Zip] of the corresponding Address ID selected for the Vendor's payment address. Database Fields: ERPx_MFCheckbookTransaction.Address1, ERPx_MFCheckbookTransaction.Address2, ERPx_MFCheckbookTransaction.Address3, ERPx_MFCheckbookTransaction.City, ERPx_MFCheckbookTransaction.State, ERPx_MFCheckbookTransaction.Zip | |
| Address 1 | Displays the Address 1 line of the |
Vendor's payment address. This is a text box that is not required. It defaults from the 'Address 1' field saved for the selected Address ID. If entered, this must be <= 75 characters. This field is editable |
while the payment batch is |
in a status of 'New' and a Payment # has not been assigned.
Database Field: ERPx_MFCheckbookTransaction.Address1 | ||||||||
| Address 2 | Displays the Address 2 line of |
the Vendor's payment address. This is a text box that is not required. It defaults from the 'Address 2' field saved for the selected Address ID. If entered, this must be <= 75 characters. |
This field is editable |
while the payment batch is in a status of 'New' and a Payment # has not been assigned.
Database Field: ERPx_MFCheckbookTransaction.Address2 | ||||||||
| Address 3 | Displays the Address 3 line of the |
Vendor's payment address. This is a text box that is not required. It defaults from the 'Address 3' field saved for the selected Address ID. If entered, this must be <= 75 characters. |
This field is editable |
while the payment batch |
is in a status of 'New' and a Payment # has not been assigned.
Database Field: ERPx_MFCheckbookTransaction.Address3 | |||||||||
| Address ID |
|
while the payment batch is |
in a Status of 'New' and a Payment # has not been assigned. |
The lookup contains the current assigned value, "None", and a list of all the 'Active' Vendor Addresses associated with the Account. Database Fields: ERPx_APVendorAddress.AddressID, ERPx_MFCheckbookTransaction.EntityAddressSK | |
| Amount | Identifies the amount to be paid to the associated Account. This is a text box that is required. For a Quick Payment, this amount defaults from the Payment value entered on the Vendor Balances list view. For a Payment Batch, this amount defaults from the 'Max Amount to Pay' total for the associated Account on the Build Payment Batch page. If changed |
, the new amount will override the defaulted amount when the batch is saved. Negative and zero dollar amounts are not permitted. If the field contains a negative amount, the message "Checks must be greater than zero." will be displayed on Save. If the field contains a zero dollar amount, the associated row will be removed on Save. For a Quick Payment, this field is editable until the payment batch is printed. For a Payment Batch, this field is never editable. Database Field: ERPx_MFCheckbookTransaction.Amount | |||||||||
| City | Displays the City associated with the Vendor's payment address. This is a text box that is not required. It defaults from the 'City' field saved for the selected Address ID. If entered, this must be <= 35 characters. This field is editable while the payment batch is in a status of 'New' and a Payment # has not been assigned.
Database Field: ERPx_MFCheckbookTransaction. |
City |
| Description | Displays |
a description of the payment. This is a text box that is not required. It defaults |
to blank, but if entered, this must be <= |
250 characters. |
This field is editable |
while the payment batch is |
in a status of 'New' and a Payment # has not been assigned. Database Field: ERPx_MFCheckbookTransaction. |
Description |
| Payee | Displays |
| the individual to whom the check will be written out. This is a text box that is not required. |
| This field defaults from the 'Payment Name' field associated with the Account's Address ID and must be <= |
| 150 characters. |
| This field is editable |
| while the payment batch is |
| in a status of 'New' and a Payment # has not been assigned. Database Field: ERPx_MFCheckbookTransaction. |
PayeeName |
| Payment # | Displays |
the Check, ACH, Draft or Wire number for the payment. This is a |
numeric textbox that defaults to blank and is required to post the payment batch. This field defaults |
to blank and is auto-generated when the batch is saved as Approved or Ready To Post, or a value may be entered manually. This field is editable while in a status of 'New' until a Payment # has been assigned then it is disabled. Database Field: ERPx_MFCheckbookTransaction. |
TransactionID |
| Payment # |
| Override | Identifies if the Payment # assigned to the line item has been manually assigned or not. This is a non-editable |
textbox that defaults to blank and is |
not required. If a Payment # is manually entered this field will display 'Yes', if the Payment # has been automatically assigned this field will be blank. Database Field: ERPx_ |
MFTransactionBatch.IsPaymentNumberOverride | |
| Payment Type | Identifies how an Account will get paid. This is a single-select standard lookup that is required. If defaults from the 'Default Payment Type' field saved for the Address ID. |
If ACH has been set up on the Vendor ACH list view for the Address ID, then this field is editable until the payment batch is printed. Else, "Check" will be defaulted and the field will always be disabled. If the Payment Type is set to "ACH", changing the Address ID to one not set up with ACH will change the Payment Type to "Check" and disable to Payment Type field. The lookup contains "Check" and "ACH". Database Field: ERPx_MFCheckbookTransaction.TransactionTypeSK | |
| State | Displays the State associated with the |
Vendor's payment address. This is a text box that is not required. It defaults from the 'State' field saved for the selected Address ID. If entered, this must be <= 30 characters. |
This field is editable |
while the payment batch is |
in a status of 'New' and a Payment # has not been assigned. Database Field: ERPx_MFCheckbookTransaction.State |
| Vendor |
Identifies the Vendor associated with the payment. This is a |
non- |
editable textbox that is required. It defaults the 'Vendor Name' + '(Vendor ID)' fields for the specific Account associated with the payment |
. Database Fields: ERPx_APVendor.VendorName, ERPx_APVendor.VendorID | |
| Vendor Name | Identifies the name of the Vendor associated with the payment. This is a single-select lookup that is required. It defaults the 'Vendor Name' for the specific Account associated with the payment. This is editable prior to Save for a new line that is added via the 'Add Item' button, else it is disabled. The lookup contains the current assigned value and a list of all the 'Active' Vendors. Database |
Field: ERPx_APVendor.VendorName |
| Zip | Displays the Zip Code associated with |
the Vendor's payment address. This is a text box that is not required. It defaults from the 'Zip' field saved for the selected Address ID. If entered, this must be <= 15 characters. |
This field is editable |
while the payment batch is |
in a status of 'New' and a Payment # has not been assigned. Database Field: ERPx_MFCheckbookTransaction.Zip |
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
...