Insert excerptDef - Sales ProgramDef - Sales Programnopaneltrue The purpose of this page is to add, edit, remove, and activate/inactive these records.

Sales Programs are only applicable for Sales Orders, Price Adjustments, and Returns. They are not used with Quick Sales transactions.

Software Version: 2022.06.16 and newer

Table of Contents

type	flat

Page Header

...

Identifies the GL Account for the 'Credit' side of the Journal Entry.

This defaults to (From Item) on new records, indicating that the GL Account is looked up from the Item Master for each item the program applies to as follows:

For 'Brokerage' Programs - the Item's "Brokerage Accrual (Credit)" Account Type.
For 'Freight Accrual' Programs - the Item's "Freight Accrual (Credit)" Account Type.
For 'On Invoice' Programs - the Item's "Sales Account" Account Type, for the Item identified as the 'Freight Item' on the Item Sets tab, if the program amount is negative.
For 'Promotion' Programs - the Item's "Sales Account" Account Type, for the Item identified as the 'Promotion Item' on the Item Sets tab, if the program amount is negative.

This is required for 'Brokerage' and 'Freight Accrual' programs but is not visible or editable for 'On Invoice' or 'Promotion Programs'. If blank, the message "Credit/Accrual Account is required." will be displayed on Save. This field is always editable from the record view for 'Brokerage' and 'Freight Accrual' programs.

This lookup contains a blank value, the current assigned value, a selection for (From Item), and a list of all Active GL Accounts

Database Field: ERPx_SPProgramHeader.CRAccountSK

...

A lookup to identify the Customer or Vendor that will be paid for each Program with a 'Program Type' of Brokerage (this is not applicable for Freight Accrual, On Invoice, or Promotion Programs). For Brokerage Programs, this defaults as blank on new records, but is required.

If the 'Settle To' = "AP Invoice - Paid In Full Orders" or "AP Invoice - All Orders" then an AP Vendor must be selected. If blank, the message "Vendor is required." will be displayed on Save.
If the 'Settle To' = "AR Credit Memo" then a Customer must be selected. If blank, the message "Customer is is required." will be displayed on Save.

This field is always editable from the record view.

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' Customers or Vendors, depending on the 'Settle To' value

Database Field: ERPx_SPProgramHeader.ProgramEntitySK

...

Identifies the GL Account for the 'Debit' side of the Journal Entry.

This defaults to (From Item) on new records, indicating that the GL Account is looked up from the Item Master for each item the program applies to as follows:

For 'Brokerage' Programs - the Item's "Brokerage Expense (Debit)" Account Type.
For 'Freight Accrual' Programs - the Item's "Freight Accrual (Credit" Account Type.
For 'On Invoice' Programs - the Item's "Sales Account" Account Type, for the Item identified as the 'Freight Item' on the Item Sets tab, if the program amount is negative.
For 'Promotion' Programs - the Item's "Sales Account" Account Type, for the Item identified as the 'Promotion Item' on the Item Sets tab, if the program amount is negative.

This is required for 'Brokerage' and 'Freight Accrual' programs but is not visible or editable for 'On Invoice' or 'Promotion Programs'. If blank, the message "Debit/Expense Account is required." will be displayed on Save. This field is always editable from the record view for 'Brokerage' and 'Freight Accrual' programs.

This lookup contains a blank value, the current assigned value, a selection for (From Item), and a list of all Active GL Accounts

Database Field: ERPx_SPProgramHeader.DRAccountSK

...

The 'Description' property on the Program record. This defaults to blank for new records and is not required but duplicate values are allowed. This field is always editable from the record view and must be <= 200 characters.

...

Insert excerpt

	Def - Sales Program
	Def - Sales Program
nopanel	true

The purpose of this page is to add, edit, remove, and activate/inactive these records.

Sales Programs are only applicable for Sales Orders, Price Adjustments, and Returns. They are not used with Quick Sales transactions.

Software Version: 2022.06.16 and newer

Table of Contents

type	flat

Page Header

A date field to indicate when the Program ends. Orders Invoice Date will not be evaluated, even if the Program is still Active. This defaults as blank on new records, and is required. If blank, the message "To date is required." will be displayed on Save. This must must be >= to the Start. If not, the message "The To Date cannot be before the From date" will be displayed on Save.EndDate This is a Yes/No lookup that is required. It defaults as No and is always editable.

Database Field: ERPx_SPProgramHeader.Inactive

A hyperlink that shows the value of the 'Program ID'. Clicking on the link opens the record view for the selected Program.

This defaults from the 'Program Class' and cannot be edited after creation. This field must be <= 15 characters. The 'Program' is made up of two parts, which default from the Program Class on the 'Program Classes' Master File:

Program Prefix - this is a user defined value that if present will display in front of the 'Next Program ID' value with a space placed between the two values
Next Program ID - this is a number that auto-increments and is required

The Program ID is used as a short description and unique identifier of the Program.ProgramID Class

Identifies the value in the 'Class' property of the Sales Program. This defaults to blank for new records but is required. If not assigned, the message "Program Class is required." will be displayed on Save. This field is always editable from the Record View.

The Program Class is used for reporting and to control the Program ID's. SPProgramProgramClassSK Rate Currency

A lookup to identify who the Program is settled to. This defaults to "Invoice" for all Freight Accrual, On Invoice, and Promotion programs and is not editable. This defaults to 'AP Invoice - Paid In Full Orders' for Brokerage programs but is only editable prior to the initial Save.

The 'Settle To' identifies whether the entity receiving payment or credit is a Customer or AP Vendor and for AP Vendors also identifies your intention for which Invoice should be included. The available options include:

"AP Invoice - Paid In Full Orders" - An AP Vendor will be paid when the Program is settled and by default, only Sales Invoices that have been paid in Full will be considered eligible for Settlements
"AP Invoice - All Orders" - An AP Vendor will be paid when the Program is settled and by default, Invoices with an open balance will also be considered eligible for Settlements
"AR Credit Memo" - A credit memo will be issues to the Customer that is assigned to the Program when it is settled.

This lookup contains all the values in the SPSettlementMethod Enumeration Class except "Invoice".

A date field to indicate when the Program starts. occurs . This defaults as blank on new records, and is required. If blank, the message "From date is required." will be displayed on Save. This must must be >= to the Start. If not, the message "The From Date cannot be before the End date" will be displayed on Save

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

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

Delete

Insert excerpt

	Delete - LV 3.0
	Delete - LV 3.0
nopanel	true

Edit

Insert excerpt

	Edit - LV 3.0
	Edit - LV 3.0
nopanel	true

Excel

Insert excerpt

	Excel - LV 3.0
	Excel - LV 3.0
nopanel	true

Favorites

Insert excerpt

	Favorites Add/Remove - Global
	Favorites Add/Remove - Global
nopanel	true

Group By Show/Hide

Insert excerpt

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

Help

Insert excerpt

	Help - Global
	Help - Global
nopanel	true

New

Insert excerpt

	New - Multi-Select Trans Type - Global 3.0
	New - Multi-Select Trans Type - Global 3.0
nopanel	true

The available options include:

Accrual
Brokerage
Off Book
On Invoice
Rebate

Notes

Insert excerpt

	Notes - Global 3.0
	Notes - Global 3.0
nopanel	true

Quick Column Filter

Insert excerpt

	Quick Column Filter
	Quick Column Filter
nopanel	true

Refresh

Insert excerpt

	Refresh - Global 3.0
	Refresh - Global 3.0
nopanel	true

Saved Layouts

Insert excerpt

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

Fields

Description

Checkbox

Insert excerpt

	Checkbox
	Checkbox
nopanel	true

Accrual Account

Insert excerpt

	Def - GL Account - SP Accrual
	Def - GL Account - SP Accrual
nopanel	true

This is required and editable from the Sales Program Record View for Accrual, Brokerage, Off Book, and Rebate Programs.

Database Field: ERPx_SPProgramHeader.CRAccountSK

Description

Identifies the Description (program name) associated with the Program ID. This is not required, and duplicate values are allowed. This is editable from the Sales Program Record View.

Database Field: ERPx_SPProgramHeader.Description

End

Identifies the Date the program ends. This is required and is editable from the Sales Program Record View. Programs with an End Date that occurs prior to a Sales

Orders Invoice Date will not be evaluated, even if the Program is still Active.

Database Field: ERPx_SPProgramHeader.EndDate

Expense Account

Insert excerpt

	Def - GL Account - SP Expense
	Def - GL Account - SP Expense
nopanel	true

This is required and editable from the Sales Program Record View for Accrual, Brokerage, and Rebate Programs.

Database Field: ERPx_SPProgramHeader.

DRAccountSK

Inactive

Insert excerpt

	Def - Inactive
	Def - Inactive

Def - Inactive

nopanel

true

Program


nopanel	true

This is a Yes/No value that is required and is editable from the Sales Program Record View.

Database Field: ERPx_SPProgramHeader.Inactive

Payee

Identifies the Name and ID of the Customer or Vendor that will be paid for the Program, displayed as [Customer/Vendor Name] ([Customer/VendorID]). This is not editable after the initial save and is required for Brokerage, Off Book, and Rebate Programs. This value will be blank for Accrual and On Invoice programs as they do not create settlements.

Database Field: ERPx_SPProgramHeader.ProgramEntitySK

Program Class

Identifies the Class the program is assigned to. This is not editable after the initial save and is required.

Insert excerpt

	Def - Program Class - Sales Programs
	Def - Program Class - Sales Programs
nopanel	true

Database Field: ERPx_SPProgram.ProgramClassSK

Program ID

Insert excerpt

	Program ID
	Program ID
nopanel	true

Clicking on the link opens the record view for the selected Program. This is not editable after the initial save.

Insert excerpt

	Def - Program ID - SP Programs
	Def - Program ID - SP Programs
nopanel	true

Database Field: ERPx_SPProgramHeader.

ProgramID

Program Rate Currency

Insert excerpt

	Program

Rate Currency
	Program Rate Currency
nopanel	true

This is required and not editable after the initial save. Programs can only be applied to sale transactions where the Customer Currency and the Program Currency match.

Database Field: ERPx_

SPProgramHeader.

CurrencySK

Program

A single select standard lookup to identify the Currency the Program is stated in. This defaults to blank for new records but is required. If not assigned, the message "Program Rate Currency is required." will be displayed on Save. This field is not editable after the initial Save. Programs can only be applied to sale transactions where the Customer Currency and the Program Currency match.

This lookup contains a blank value and all the System Currencies that are open to the current Company.

Database Field: ERPx_SPProgramHeader.CurrencySK

Program Type

A system assigned value, from the Program Class, that identifies the Type of Sales Program. The options include: Brokerage, Accrual, On Invoice, Off Book and Rebate. This is never editable.

Settle Frequency

A lookup to identify how often the Program is settled. This defaults to "Invoice" for all Freight Accrual, On Invoice, and Promotion programs and is not editable. This defaults to blank and is required for Brokerage programs. If missing, the message "Frequency is required." will be displayed on Save.

A Settle Frequency of "Invoice" means that the program is fully accrued for and charged when the Sales Invoice is Posted. All other options are only used for internally information and do not impact any functionality.

For Brokerage Programs, this field is always editable from the record view.

This lookup contains all the values in the SPSettlementFrequency Enumeration Class except "Invoice".

Database Field: ERPx_SPProgramHeader.SettlementFrequencySK

Settle To

Type

Identifies the Type of Program. This is required and not editable after the initial save. The Types of Programs include

Insert excerpt
Def - Program Type - SP Accrual
Def - Program Type - SP Accrual
nopanel true
Insert excerpt
Def - Program Type - SP Brokerage
Def - Program Type - SP Brokerage
nopanel true
Insert excerpt
Def - Program Type - SP Off Book
Def - Program Type - SP Off Book
nopanel true
Insert excerpt
Def - Program Type - SP On Invoice
Def - Program Type - SP On Invoice
nopanel true
Insert excerpt
Def - Program Type - SP Rebate
Def - Program Type - SP Rebate
nopanel true

Settle To

Identifies how the Program will be settled (paid). This is not editable after the initial save and is required for Brokerage, Off Book, and Rebate Programs. This value will be blank for Accrual and On Invoice programs as they do not create settlements. Accrual programs add journal lines to the Journal Entry that is created when the sales invoice, price adjustment, or return is posted and On Invoice programs add line item to sales orders, price adjustments, and returns that are included in the Journal Entry that is created when they post.

The available options include:

AP Invoice - Paid In Full Orders: Sales Invoices that have been paid in full will be considered eligible for Settlement to the Payee assigned to the Program.
AP Invoice - All Orders: Sales Invoices that have been posted, regardless of payment status will be considered eligible for Settlement to the Payee assigned to the Program.
AR Credit Memo: Sales Invoices that have been posted, regardless of payment status will be considered eligible for Settlement as an AR Credit Memo for the Payee assigned to the Program.

Database Field: ERPx_SPProgramHeader.SettlementFrequencySK

Settlement Frequency

Identifies how often the Program is settled. This is informational only (does not drive any functionality) and is always editable from the Sales Program Record View for Brokerage, Off Book, and Rebate Programs. This value will be blank for Accrual and On Invoice programs as they do not create settlements. Accrual programs add journal lines to the Journal Entry that is created when the sales invoice, price adjustment, or return is posted and On Invoice programs add line item to sales orders, price adjustments, and returns that are included in the Journal Entry that is created when they post.

Database Field: ERPx_SPProgramHeader.SettlementFrequencySK

Start

Identifies the date the program starts. This is required and is editable from the Sales Program Record View. Programs with a Start Date that

occur after a Sales Orders Invoice Date will not be evaluated

.

Database Field: ERPx_SPProgramHeader.EndDate

Versions Compared

Old Version 7

New Version Current

Key

Page Header

Page Header

Related Topics

Page Definitions

Page Comparison

Versions Compared

Old Version 7

New Version Current

Key

Page Header

Page Header

Related Topics

Page Definitions