Insert excerptDef - Payment BatchDef - Payment Batchnopaneltrue The purpose

Insert excerpt
Def - Payment Batch Def - Payment Batch nopanel true

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.

 This record view also contains columns for each Attribute that is set up for the 'Vendors' attribute type. Because these are user defined, they are not included in the default view but can be added a saved layout. Vendor attributes are not included in the help documentation.

To view the help page for the NorthScope 2.0 Build Payment Batch Record View, please click here: Build Payment Batch Record View. 

...

Table of Contents
type flat

Page Header

Header Toolbar

Filters Tab

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 Accounts Payable Account will be displayed as positive and in black font. Transactions that Debit the Accounts Payable 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])".

Discount DateLast Updated ByDue DateOpen Amt.

Displays the amount due for payment on the transaction. This is a non-editable text box

, formatted from the users 'Date Format' preference,

that is

sometimes

required. It is calculated as [Orig. Trans. Amt] - previous applications. This field is for information only

required on Invoice and Credit Memo transactions. It defaults from the 'Due Date' field on the 'Properties' tab of the Invoice Record View. This field is for information only and never editable.
Insert excerptDef - Due DateDef - Due Datenopaneltrue

Database Field: ERPx_APTransactionHeader.DueDate

Max Amount to Pay

Identifies the maximum amount to be paid for the documentand never editable. This field is not stored in the database.

For transactions that Credit the Accounts Payable Account, this field will display as positive. For transactions that Debit the Accounts Payable Account, this field will display as negative.

Orig. Terms Discount Amt.

Displays the original discount amount. This is a non-editable text box that is required. This field is calculated as [Open Amount] - [Terms Discount Taken] - [Previous Payment Applications]. This field can be edited by clicking the 'Edit Amounts' icon in the grid header and entering a amount in the 'Amount' field on the Edit Amounts dialog box. This field is always editable from the Edit Amounts dialog box.

For transactions that Credit the Accounts Payable Account, this field will display as positive. For transactions that Debit the Accounts Payable Account, this field will display as negative.

Database Field: ERPx_MFTransactionBatchTransaction.AmountToConsume

Open Amt.

Displays the amount due for payment on the transaction. not required. It defaults from the 'Discount Amount' filed on the 'Properties' tab of the Invoice Record View. This field is for information only and never editable.

Database Field: ERPx_APTransactionHeader.DiscountAmount

Orig. Trans. Amt. It is calculated as [Orig. Trans. Amt] - previous applications. This field is not stored in the database.Orig. Trans. Amt.Terms Discount Amt. Not Taken

Displays the discount amount that has not been used yet. This is a non-editable text box that is

required. For Invoice and Credit Memo transactions, this defaults from the 'Amount' field on the 'Home' tab of the Invoice Record View. For Payment transactions, this comes from the 'Amount' field for the specific check or ACH payment on the Process Payments Record View. This field is for information only and never editable.

For transactions that Credit the Accounts Payable Account, this field will display as positive. For transactions that Debit the Accounts Payable Account, this field will display as negative.

Database Fields: ERPx_APTransactionHeader.ExtendedAmount (Invoice/Credit Memo), ERPx_MFCheckbookTransaction.Amount (Payment)

Orig. Terms Discount Amt.

Displays the original discount amount. This is a non-not required. It is calculated as [Orig. Terms Discount Amt.] - [Terms Discount Taken] if the Payment Terms of the transaction allows for discounts. Else, it will default as "0.00". This field will be automatically updated if the 'Terms Discount Taken' field is updated. This field is for information only and never editable. It is not stored in the database.

Terms Discount Taken

Identifies the amount of discount applied to the transaction. This is an editable text box that is not required. It is calculated based on the Payment Terms associated with the transaction by using the [Percent of Discount] x [Amount] if the Payment Terms of the transaction allows for discounts. This field is for information only and never editable. It is not stored in the database.

Terms Discount Amt. Not Taken

Displays the discount amount that has not been used yet. This is a non-editable text box that is not required. It is calculated as [Orig. Terms Discount Amt.] - [Terms Discount Taken] if defaults from the ' Terms Discount Amt. Not Taken' field when:

• The discount is not expired.
• The discount is expired, but the ‘Apply Expired Discounts’ is set to Yes.

Transaction Insert excerptTransaction IDTransaction IDnopaneltrueClicking on this link opens the transaction record view for the selected record. For Invoice and Credit Memo transactions, this is a system assigned number that comes from the associated Transaction Class and is required. For Payment transactions, this is a system assigned number that comes from the 'Next Check #' field for the associated Checkbook on the Checkbooks List View and is required. This field is

This defaults to "0.00" if the discount is expired and the ‘Apply Expired Discounts’ is set to No. It also defaults to "0.00" when the Payment Terms of the transaction allows do not allow for discounts. Else, it will default as "0.00". This field will be automatically updated if The amount entered cannot be greater than the ' Terms Discount Amt. Not Taken' field is updated. This field is for information only and never editable. It is not stored in the database.

Terms Discount Taken

Identifies the amount of discount applied to the transaction. This is a non-editable text box that is not required. It defaults from the 'Orig. Terms Discount Amt.' field when:

• The discount is not expired.
• The discount is expired, but the ‘Apply Expired Discounts’ is set to Yes.

This defaults to "0.00" if the discount is expired and the ‘Apply Expired Discounts’ is set to No. It also defaults to "0.00" when the Payment Terms of the transaction do not allow for discounts. This field is only editable on the Edit Amounts dialog box if the Payment Terms of the transaction allows for discounts.

Database Field: ERPx_MFTransactionBatchTransaction.DiscountToConsume

, otherwise the message "Cannot set a Discount Amount to Take greater than is left on the transaction" will be displayed on Save.  This field is only editable if the Payment Terms of the transaction allows for discounts.

Database Field: ERPx_MFTransactionBatchTransaction.DiscountToConsume

TransactionTransaction ClassTransaction ClassTypeTransaction TypeVendor

Insert excerpt

Transaction Type

Vendor

Transaction Type

Vendor nopanel true

This is a non-editable text box

that is required. This defaults from the Transaction Type selected when creating a new transaction. 

that is required. For Invoice and Credit Memo transactions, it defaults from the 'Vendor' field on the 'Home' tab of the Invoice Record View. For Payment transactions, this defaults from the 'Account' field on the Payments grid of the Process Payments Record View. This field is for information only and never editable.

Insert excerpt
Def -

Transaction Types

Vendor Def -

Transaction Types

Vendor nopanel true

Database Fields: ERPx_

APTransactionType

APVendor.

TransactionName,

VendorName (ERPx_

APTransactionClass

APVendor.

TransactionTypeSK

VendorID), ERPx_APTransactionHeader.

TransactionClassSK

VendorSK (Invoice/Credit Memo), ERPx_MFCheckbookTransaction.

TransactionTypeSK

EntitySK (Payment)

Vendor Name