Versions Compared

Old Version 4

changes.mady.by.user Janice Dannenberg (Unlicensed)

Saved on

compared with

New Version 5

changes.mady.by.user Janice Dannenberg (Unlicensed)

Saved on

Key

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

The Process Checks record view box is used to manage details of ACH payments and checks printed out to vendors. Users may print ACH and check payments, view Journal Details, generate reports, Post or Void batches.

Software Version: YYYY.MM.DD and newer

Table of Contents
typeflat

Page Header

...

Sets the Batch Status to "Posted". This indicates that the checks have been printed successfully, and the printed checks are valid for use. Once the batch is posted, the Posted Balance and Net Balance for the Account will be updated.

Note: If the payment pays the Posted Balance in full, the vendor's Settlement Balance line item will no longer appear. 

...

The Process Checks record view box is used to manage details of ACH payments and checks printed out to vendors. Users may print ACH and check payments, view Journal Details, generate reports, Post or Void batches.

Software Version: YYYY.MM.DD and newer

Table of Contents
typeflat

Page Header


This is a single-select standard lookup that defaults to the system generated Batch ID if there are no existing batches associated with the user, formatted as [User First Name] + [User Last Name] + [Batch Number + 1]. This field defaults the most recent payment batch, if one exists. A batch may contain a list of multiple Accounts whose payment(s) are being processed. Selecting the Batch ID refreshes page to display the associated values. 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

the system generated Batch ID if there are no existing batches associated with the user, formatted as [User First Name] + [User Last Name] + [Batch Number + 1]. This field defaults the most recent payment batch, if one exists. A batch may contain a list of multiple Accounts whose payment(s) are being processed. Selecting the Batch ID refreshes page to display the associated values. This field is required and is never editable by a user.

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

Database

Fields: ERPx_MFCheckbook.CheckbookDescription,

Field: ERPx_MFTransactionBatch.

CheckbookSKCheck # Range beginning and ending number check numbers for printing is a non-editable text box that is only required when there are checks in the payment batch. It is auto-populated after the check payments have been printed The range is a looked up value and not stored in the database.Check is automatically calculated and defaulted when the page is first opened, or on Save, or another Batch ID is selected. This field is never editable by the user.

Database Field: ERPx_MFTransactionBatch.CheckTotal

Toolbar IconsDescription
Generate ACH FileGenerates a .txt file with the ACH information.
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
Journal Details
Insert excerpt
Journal Details - RV Header
Journal Details - RV Header
nopaneltrue
Post BatchACH Total

Sets the Batch Status to "Posted". This indicates that the checks have not been printed successfully, and the printed checks are invalid valid 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 the check.

Once voided, the check is destroyed in the system and cannot be used.

FieldsDescription
# of ACHIdentifies the total number of ACH payments to be printed on the batch. This is a non-editable text box that is required. It is automatically defaulted when the page is first opened, or 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 to be printed on the batch. This is a non-editable text box that is required. It is automatically defaulted when the page is first opened, or on Save, or 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 to be printed on the batch. This is a non-editable text box that is required. It is automatically defaulted to the sum of the '# of ACH' field and '# of Checks' field 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

Identifies the total amount of all ACH payments included on this payment Once the batch is posted, the Posted Balance and Net Balance for the Account will be updated.

Note: If the payment pays the Posted Balance in full, the vendor's Settlement Balance line item will no longer appear. 

Print PaymentsAllows 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".
ReportsOpens the Print dialog window showing all available reports.
Save
Insert excerpt
Save - Global
Save - Global
nopaneltrue
Void Batch

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 the check.

Once voided, the check is destroyed in the system and cannot be used.

FieldsDescription
# of ACHIdentifies the total number of ACH payments to be printed on the batch. This is a non-editable text box that is required. This number It is automatically calculated and defaulted 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.ACHTotal

Batch ID
Insert excerpt
Batch IDBatch ID
nopaneltrue
Batch StatusIdentifies the Status of the Batch. This field is required, defaults to "New" and and is not stored in the database.
# of Checks

Identifies the total number of checks to be printed on the batch. This is a non-editable text box that is required. It is automatically defaulted when the page is first opened, or on Save, or 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 to be printed on the batch. This is a non-editable text box that is required. It is automatically defaulted to the sum of the '# of ACH' field and '# of Checks' field 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.TransactionStatusSKTransactionCount

Batch ACH Total

Identifies the total amount of all checks and ACH payments included on this payment batch. This is a non-editable text box that is required. This number is automatically calculated and defaulted when the page is first opened, or on Save, or another Batch ID is selected. This field is never editable by the user.

Database Field: ERPx_MFTransactionBatch.TransactionTotalAmountACHTotal

CheckbookBatch ID

Insert excerpt
Checkbook
Batch ID
Checkbook
Batch ID
nopaneltrue
This is a single-select standard lookup that allows users defaults to select the checkbook used to distribute the ACH and/or check payments in the settlement batch. This is required and defaults to the Fisherman Accounting Settlement Default preference 'Default Fisherman Checkbook ID'. Changing the Checkbook will automatically update the 'Next Check #' field. This field is editable prior to clicking Print Payments.
Insert excerpt
Def - CheckbookDef - Checkbook
nopaneltrue

BatchID

Batch Status

Identifies the

Status of the

Batch. This

field is required, defaults to "New" and is never editable by the user.

Database Field: ERPx_MFTransactionBatch.TransactionStatusSK

Batch Total

Identifies the total amount of all checks and ACH payments included on this payment batch. This is a non-editable text box that is required. This number

Next Check #

Displays the next check number to be printed. This is a text box that auto-populates based on the 'Next Check #' field for selected Checkbook. This field is required and if updated, it must be <= 20 characters. Duplicate check numbers are not allowed, else the message "One of the Check Numbers has already been used. Please change the Next Check Number." will be displayed when "Print Checks" is clicked. This field is editable if there are checks on the batch and only prior to clicking "Print Checks".

Linked Database Field: ERPx_MFTransactionBatch.NextTransactionID

Payment Date

Identifies the date that will be printed on the checksis automatically calculated and defaulted when the page is first opened, or on Save, or another Batch ID is selected. This field is never editable by the user.

Database Field: ERPx_MFTransactionBatch.TransactionTotalAmount

Checkbook

Insert excerpt
Checkbook
Checkbook
nopaneltrue
This is a single-select standard lookup that allows users to select the checkbook used to distribute the ACH and/or check payments in the settlement batch. This is required and defaults to the Fisherman Accounting Settlement Default preference 'Default Fisherman Checkbook ID'. Changing the Checkbook will automatically update the 'Next Check #' field. This field is editable prior to clicking Print Payments.

Insert excerpt
Def - Checkbook
Def - Checkbook
nopaneltrue

The lookup contains a list of all the 'Active' Checkbooks.

Database Fields: ERPx_MFCheckbook.CheckbookDescription, ERPx_MFTransactionBatch.CheckbookSK

Check # Range

Identifies the beginning and ending number of the check numbers for printing. This is a non-editable text box that is only required when there are checks in the payment batch. It is auto-populated after the check payments have been printed and is never editable by the user. The range is a looked up value and not stored in the database.

Check Total

Identifies the total amount of all checks included on this payment batch. This is a non-editable text box that is required. This number is automatically calculated and defaulted when the page is first opened, or on Save, or another Batch ID is selected. This field is never editable by the user.

Database Field: ERPx_MFTransactionBatch.CheckTotal

Next Check #

Displays the next check number to be printed. This is a text box that auto-populates based on the 'Next Check #' field for selected Checkbook. This field is required and if updated, it must be <= 20 characters. Duplicate check numbers are not allowed, else the message "One of the Check Numbers has already been used. Please change the Next Check Number." will be displayed when "Print Checks" is clicked. This field is editable if there are checks on the batch and only prior to clicking "Print Checks".

Linked Database Field: ERPx_MFTransactionBatch.NextTransactionID

Payment Date

Identifies the date that will be printed on the checks. This is a text box that is required. It defaults to the current date. The check 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. This field is editable prior to posting the batch.

Database Field: ERPx_MFTransactionBatch.BatchDate


Page Detail

Payment Grid

Toolbar IconsDescription
New

Insert excerpt
New - multi blank rows - RV Grid
New - multi blank rows - RV Grid
nopaneltrue

Split PaymentOpens the Split Payment record to add individual split payments for the selected Account.
FieldsDescription
CheckboxUsed to select one or more records to Split Payment.

Account

Insert excerpt
Account Name
Account Name
nopaneltrue
This is a single-select lookup that is required. It defaults the 'Vendor Name' + '(Vendor ID)' fields for the specific Account associated with the payment. This field is editable until the payment batch is printed.

The lookup contains the current assigned value and a list of all the 'Active' Fishermen, Fishermen & Tenders, and Tenders and Loans without a Master Vendor account assigned and not on hold.

Database Fields: ERPx_APVendor.VendorName,ERPx_APVendor.VendorID

Address 1

Displays the Address 1 line of the vendor address. This is a text box that is not required. It defaults

to the current date. The check 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

from the 'Address 1' field saved for the selected Address ID. If entered, this must be <= 75 characters. This field is editable

prior to posting the batch

until the payment batch is printed.

Database Field: ERPx_

MFTransactionBatch

MFCheckbookTransaction.

BatchDate

Address1

Page Detail

Payment Grid

This is a single-select lookup that is required. It defaults the 'Vendor Name' + '(Vendor ID)' fields for the specific Account associated with the paymentAddress 2

The lookup contains the current assigned value and a list of all the 'Active' Fishermen, Fishermen & Tenders, and Tenders and Loans without a Master Vendor account assigned and not on hold.

Database FieldsAPVendor.VendorName,ERPx_APVendor.VendorIDDisplays the Address 1 line of the vendor address. This is a text box that is not required. It defaults from the Vendor address selected in the Address ID field. If entered, this must be <= 75 characters. Database Field: Address1Address 2Displays the Address 2 line of the vendor address not It Vendor address selected in the Address ID field. If entered, this must be <= 75 charactersAddress2 Address 3 line of Vendor address selected in the field 75 Address3 This is a single-select lookup that allows users to specify the Address ID to which to make the payment. It is required and defaults from the Vendor ID field for the selected Account. If the Account is changed, this field will default to blank. Once an Address ID is selected, the corresponding Address fields will defaultDescriptionDisplays a description of the payment text box not It defaults to blank, but if entered, this must be <= 250 characters. This DescriptionPayee individual to whom the check will be written out This field Check Name field associated with the Account and 150 MFCheckbookTransaction.PayeeName
Toolbar IconsDescription
New
Insert excerpt
New - multi blank rows - RV GridNew - multi blank rows - RV Grid
nopaneltrue
Split PaymentOpens the Split Payment record to add individual split payments for the selected Account.
FieldsDescription
CheckboxUsed to select one or more records to Split Payment.

Account

Insert excerpt
Account NameAccount Name
nopaneltrue

Displays the Address 2 line of the vendor 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 until the payment batch is printed.

Database Field: ERPx_MFCheckbookTransaction.Address2

Address 3

Displays the Address 3 line of the vendor 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 until the payment batch is printed.

Database Field: ERPx_

Address 1

MFCheckbookTransaction.Address3

Address ID

Insert excerpt
Address ID
Address ID
nopaneltrue
This is a single-select lookup that allows users to specify the Address ID to which to make the payment. It is required and defaults from the selected Account record. If the Account is changed, this field will default to blank. Once an Address ID is selected, the corresponding Address fields will default. This field is editable until the payment batch is printed.

The lookup contains the current assigned value, "None", and a list of all the 'Active' Fishermen Addresses or Loan 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.

This amount defaults from the

Payment value entered on the Fisherman Balances list view. If changed, the new amount will override the defaulted amount when the batch is saved. Negative and zero dollar amounts are not permitted. This field is editable until the payment batch is printed.

Database Field: ERPx_MFCheckbookTransaction.

Amount

Address 3
City

Displays the

City associated with the vendor 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 until the payment batch is printed.

Database Field: ERPx_MFCheckbookTransaction.

City

Address ID
Insert excerpt
Address IDAddress ID
nopaneltrue

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 until the payment batch is printed.

Database

Fields: ERPx_APVendorAddress.AddressID,

Field: ERPx_MFCheckbookTransaction.

EntityAddressSK

Description

AmountPayeeIdentifies Displays the amount individual to be paid to the associated Accountwhom the check will be written out. This is a text box that is not required. This amount field defaults from the Payment value entered on the Fisherman Balances list view. If changed, the new amount will override the defaulted amount when the batch is saved. Negative and zero dollar amounts are not permitted'Check Name' field associated with the Account and must be <= 150 characters. This field is editable until the payment batch is printed.

Database Field: ERPx_MFCheckbookTransaction.AmountPayeeName

CityPayment Number

Displays the City associated with the vendor addresscheck number or ACH number for the payment. This is a non-editable text box that is not required . It defaults from the Vendor Address selected in the Address ID field. If entered, this must be <= 35 charactersto post the payment batch. This field defaults to blank and is auto-generated when the check or ACH is printed. This field is never editable until the payment batch is printedby the user.

Database Field: ERPx_MFCheckbookTransaction.CityTransactionID

Description
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 selected Address ID. If  ACH has been set up on the Fisherman ACH list view, then this field is editable until the payment batch is printed. Else, "Check" will be defaulted and the field will always be disabled.

The lookup contains "Check" and "ACH".

Database Field: ERPx_MFCheckbookTransaction.

TransactionTypeSK

State

Displays the

State associated with the vendor 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 until the payment batch is printed.

Database Field: ERPx_

Payment NumberPayment TypeStateDisplays the State of the vendor address. Defaults from the Vendor address selected in the Address ID field. This field supports up to 30 characters and is editable until the check batch is printed. 

MFCheckbookTransaction.State

Zip

Displays the Zip

of

Code associated with the vendor address.

Defaults from the Vendor address selected in the Address ID field. This field supports up to 15 characters and 

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 until the

check

payment batch is printed

. 

.

Database Field: ERPx_MFCheckbookTransaction.Zip




Related Topics



Expand
titlePage Definitions

Page Definitions


...