Versions Compared

Key

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

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
typeflat

...

Database Field: ERPx_SPProgramSettlementHeader.ComputedAmount

Database Field: ERPx_SPProgramSettlementHeader.SettlementMethodName

Settled Program AmtSettledAmount
Toolbar IconsDescription

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].

(lightbulb) 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
nopaneltrue
Edit AmountsOpens 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
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Remove PaymentRemoves 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
nopaneltrue
FieldsDescription
Amt. to Settle

Insert excerpt
SP - Amount to Settle
SP - Amount to Settle
nopaneltrue
 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
nopaneltrue
 This is not editable.

Database Field: ERPx_SPProgramSettlementHeader.OrderPaidOffDate

Customer ID

Insert excerpt
Customer ID
Customer ID
nopaneltrue
 This is not editable.

Database Field: ERPx_SPProgramSettlementHeader.CustomerID

Customer Name

Insert excerpt
Customer Name
Customer Name
nopaneltrue
 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".

(lightbulb) 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
nopaneltrue

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
nopaneltrue
This comes from the 'Purchase Order' field on the 'Home' tab of the Sales Transaction Record View. This is not editable. 

Database Field: ERPx_SPProgramSettlementHeader.PONumber

Program

Insert excerpt
Program ID & Description
Program ID & Description
nopaneltrue
 This is not editable

Database Fields: ERPx_SPProgramHeader.Description, ERPx_SPProgramSettlementHeader.ProgramHeaderSK

Program Amt.Remaining Amt.Settle To

Insert excerpt
SP - Program Amount
SP - Program Amount
nopaneltrue
 This is not editable.

Database Field: ERPx_SPProgramSettlementHeader.

ComputedAmount

Trans Amt.
Identifies Remaining Program Amt.

Insert excerpt
SP - Remaining Program Amount
SP - Remaining Program Amount
nopaneltrue
 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_SPProgramSettlementHeader.SettlementMethodName

Settled Program Amt.

Insert excerpt
SP - Settled Program Amount
SP - Settled Program Amount
nopaneltrue
 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
nopaneltrue
 This comes from the 'Transaction Class' value selected by the user when the transaction was created. This is not editable. 

Insert excerpt
Def - Transaction Class - General
Def - Transaction Class - General
nopaneltrue

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
nopaneltrue
It is formatted from the users 'Date Format' preference. This comes from the '

Order

Invoiced Date' field on the '

Home

Shipments' tab of the Sales Transaction Record View and is not editable. 

Database Field: ERPx_SPProgramSettlementHeader.InvoiceDate

Tran Trans Open Amt.

Identifies the open/unpaid amount of the sales transaction. This

value is updated when

is only editable by applying Payment Receipts, Credits, or Returns

This is not editable

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
nopaneltrue
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
nopaneltrue

Database Fields: ERPx_ARTransactionType.TransactionName, ERPx_SOOrderHeader.OrderTypeSK

Transaction

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
This is a system assigned value and is not editable.

Insert excerpt
Def - Transaction ID - Sales
Def - Transaction ID - Sales
nopaneltrue

Database Field: ERPx_SPProgramSettlementHeader.InvoiceNumber

Write Off Program Amt.

Insert excerpt
SP - Write Off Program Amount
SP - Write Off Program Amount
nopaneltrue
 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

...