Page Comparison

Program amounts for Brokerage, Off Book, and Rebate programs are accrued for and posted with sales transactions. The 'Settle' (pay) the accrued amounts, the programs must be Settled. The purpose of this page is to create settlements that reduce the open program balances by converting them to Accounts Payable Invoices (or AP Credit Memos for sales returns) or Accounts Receivable credits.

Software Version: 2022.06.16 and newer

Table of Contents

type	flat

...

Database Field: ERPx_SPProgramSettlementHeader.SettlementMethodName

Database Field: ERPx_SPProgramSettlementHeader.SettledAmount

This comes from the 'Transaction Class' value selected by the user when the transaction was created. It is not editable. true It is formatted from the users 'Date Format' preference. This comes from the 'Order Date' field on the 'Home' tab of the Sales Transaction Record View. It is not editable.

Database Field: ERPx_SPProgramSettlementHeader.InvoiceDate

SettlementMethodName

Toolbar Icons

Description

Auto Fill Amounts

This button displays options to:

Fully Pay - Filtered: Updates the 'Amt. to Settle' value for all the records in the grid to [Open Program Amt.] - [Write Off Program Amt.]
Fully Pay - Selected: Updates the 'Amt. to Settle' value for all the tagged/selected records in the grid to [Open Program Amt.] - [Write Off Program Amt.]
Write Off - Filtered: Updates the 'Write Off Program Amt.' value for all the records in the grid to [Open Program Amt.] - [Amt. to Settle].
Write Off - Selected: Updates the 'Write Off Program Amt.' value for all the tagged/selected records in the grid to [Open Program Amt.] - [Amt. to Settle].

If using this feature to Write Off balances, you must either have a Write Off code saved in the Sales Program 'Reason Code for Write Offs' Preference or you must manually assign the Write Off Code to each transaction by selecting the record, clicking the 'Edit Amounts' icon, and manually assigning the Write Off Code to each transaction item.

Column Filter Show/Hide

Insert excerpt

	Column Filter Show/Hide - Global
	Column Filter Show/Hide - Global
nopanel	true

Edit Amounts

Opens the 'Edit Amounts' List View, filtered for the transaction that was selected, to allow edit of the 'Amt. To Settle' and/or 'Write Off Program Amt.' for the individual Sales Transactions Iines. This can only be opened for one Transaction at a time else the message "Please select one row and try again." will be displayed.

Excel

Insert excerpt

	Excel - RV Grid
	Excel - RV Grid
nopanel	true

Group By Show/Hide

Insert excerpt

	Group By Show/Hide - Global
	Group By Show/Hide - Global
nopanel	true

Quick Column Filter

Insert excerpt

	Quick Column Filter
	Quick Column Filter
nopanel	true

Remove Payment

Removes the amounts in both the 'Amt. to Settle' and 'Write Off Program Amt.' columns for all the tagged/selected records.

Saved Layouts

Insert excerpt

	Column Layouts for Framework 3.0 - Global
	Column Layouts for Framework 3.0 - Global
nopanel	true

Fields

Description

Amt. to Settle

Insert excerpt

	SP - Amount to Settle
	SP - Amount to Settle
nopanel	true

This is a non-editable textbox that defaults to 0.00 and displays the sum of the 'Amt. to Settle' for each transaction item. This can only be edited by selecting a record and clicking the 'Edit Amounts' icon to open the Sales Program: Edit Amounts List View or by clicking the 'Auto Fill Amounts' icon and selecting one of the Fully Pay options.

Database Field: ERPx_SPProgramSettlementHeader.

Closed Date

Insert excerpt

	Date - Closed SP
	Date - Closed SP
nopanel	true

This is not editable.

Database Field: ERPx_SPProgramSettlementHeader.OrderPaidOffDate

Customer ID

Insert excerpt

	Customer ID
	Customer ID
nopanel	true

This is not editable.

Database Field: ERPx_SPProgramSettlementHeader.CustomerID

Customer Name

Insert excerpt

	Customer Name
	Customer Name
nopanel	true

This is not editable.

Database Field: ERPx_SPProgramSettlementHeader.CustomerName

OK To Pay

A Yes/No value that indicates whether a transaction on a sales program is okay to pay/settle.

Programs with a 'Settle To' of either "AR Credit Memo" or "AP Invoice - All Orders", this is always "Yes".
Programs with a 'Settle To' of "AP Invoice - Paid In Full Orders" this is set based on whether or not the sales transaction has an open balance. If the sales transaction has been fully paid or written off this will be "Yes", otherwise it will be "No".

This is used for auto-selecting transactions to settle and for informational purposes only. Program transactions can still be settled no matter what this value is.

This is a calculated field that is not stored in the database.

Open Program Amt.

Insert excerpt

	SP - Open Program Amount
	SP - Open Program Amount
nopanel	true

This is a calculated field that is not stored in the database.

Payee ID

Identifies the ID of the Customer or Vendor that will be paid for the Program. This is not editable.

Database Field: ERPx_SPProgramHeader.ProgramEntitySK, ERPx_SPProgramSettlementHeader.SettleToEntityID

Payee Name

Identifies the Name of the Customer or Vendor that will be paid for the Program. This is not editable.

Database Fields: ERPx_APVendor.VendorName, ERPx_ARCustomer.CustomerName, ERPx_SPProgramHeader.ProgramEntitySK, ERPx_SPProgramSettlementHeader.SettleToEntityName

PO

Insert excerpt

	Purchase Order
	Purchase Order
nopanel	true

This comes from the 'Purchase Order' field on the 'Home' tab of the Sales Transaction Record View.

It is

This is not editable.

Database Field: ERPx_SPProgramSettlementHeader.PONumber

Program

Insert excerpt

	Program ID & Description
	Program ID & Description
nopanel	true

This is not editable

Database Fields: ERPx_SPProgramHeader.Description, ERPx_SPProgramSettlementHeader.ProgramHeaderSK

Program Amt.

Insert excerpt

	SP - Program Amount
	SP - Program Amount
nopanel	true

This is not editable.

Database Field: ERPx_SPProgramSettlementHeader.ComputedAmount

Remaining Program Amt.

Settle To

Settled Program Amt.

Trans Class

Insert excerpt

Transaction Class

nopanel

true

Insert excerpt

Def - Transaction Class - General

nopanel

Insert excerpt

	SP - Remaining Program Amount
	SP - Remaining Program Amount
nopanel	true

This is a calculated field that can only be edited by changing either the 'Amt. to Settle' or the 'Write Off Program Amt.'

This value is not stored in the database.

Settle To

Identifies how the Program will be settled (paid). This defaults from the Sales Program and is not editable. The available options include:

AP Invoice - Paid In Full Orders
AP Invoice - All Orders
AR Credit Memo: Only available for Rebate and Off Book Programs

Database Field: ERPx_SOOrderHeaderSPProgramSettlementHeader.DocumentID

Trans Curr.

Identifies the Currency ID that the transaction was entered in. This comes from the Customer and is not editable.

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_SOOrderHeader.CurrencySK

Trans Date

Insert excerpt

Doc Date

nopanel

true

Settled Program Amt.

Insert excerpt

	SP - Settled Program Amount
	SP - Settled Program Amount
nopanel	true

This is only editable by settling and/or writing off a Program Amount.

Database Field: ERPx_SPProgramSettlementHeader.SettledAmount

Trans Amt.

Identifies the 'Invoice' amount of the Sales transaction. This is not editable.

Database Field: ERPx_SPProgramSettlementHeader.TotalOrderAmount

Trans Class

Insert excerpt

	Transaction Class
	Transaction Class
nopanel	true

This comes from the 'Transaction Class' selected when the transaction was created. This is not editable.

Insert excerpt

	Def - Transaction Class - General
	Def - Transaction Class - General
nopanel	true

Database Field: ERPx_SOOrderHeader.DocumentID

Trans Curr.

Identifies the Currency ID that the transaction was entered in. This comes from the Customer and is not editable.

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_SOOrderHeader.CurrencySK

Trans Date

Insert excerpt

	Doc Date
	Doc Date
nopanel	true

It is formatted from the users 'Date Format' preference. This comes from the 'Invoiced Date' field on the 'Shipments' tab of the Sales Transaction Record View and is not editable.

Database Field: ERPx_SPProgramSettlementHeader.InvoiceDate

Trans Open Amt.

Identifies the open/unpaid amount of the sales transaction. This is only editable by applying Payment Receipts, Credits, or Returns to the transaction.

Not sure where this comes from or if it is calculated, how it is calculated.

Trans Type

Insert excerpt

	Transaction Type
	Transaction Type
nopanel	true

This is a system assigned value and is not editable. The applicable transaction types are:

Quote,

Order, Return and Price Adjustment.

Insert excerpt

	Def - Transaction Types
	Def - Transaction Types
nopanel	true

Database Fields: ERPx_ARTransactionType.TransactionName, ERPx_SOOrderHeader.OrderTypeSK

Transaction

Insert excerpt

	Transaction ID
	Transaction ID
nopanel	true

This is a system assigned value and is not editable.

Insert excerpt

	Def - Transaction ID - Sales
	Def - Transaction ID - Sales
nopanel	true

Database Field: ERPx_SPProgramSettlementHeader.InvoiceNumber

Transaction Amt.

Identifies the 'Invoice' amount of the Sales transaction. This is not editable.

Database Field: ERPx_SPProgramSettlementHeader.TotalOrderAmount

Write Off Program Amt.

Insert excerpt

	SP - Write Off Program Amount
	SP - Write Off Program Amount
nopanel	true

This is a non-editable textbox that defaults to 0.00 and displays the sum of the 'Write Off Program Amt.' for each transaction item. This can only be edited by selecting a record and clicking the 'Edit Amounts' icon to open the Sales Program: Edit Amounts List View or by clicking the 'Auto Fill Amounts' icon and selecting one of the Write Off options.

Database Field: ERPx_SPProgramSettlementHeader.WriteOffAmount

...

Versions Compared

Old Version 7

New Version Current

Key