Accrual Account

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

Database Field: ERPx_SPProgramHeader.EndDate

Expense Account

Database Field: ERPx_SPProgramHeader.

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.

Linked Database Field: ERPx_SPProgramHeader.ProgramID

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 

Linked Database Field: ERPx_SPProgram.ProgramClassSK

DRAccountSK

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

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

Database Field: ERPx_SPProgram.ProgramClassSK

Program ID

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

Linked Database Field: ERPx_SPProgramHeader.CurrencySK

A system assigned value, from the Program Class, that identifies the Type of Sales Program. The options include: Brokerage, Freight Accrual, On Invoice, and Promotion. This is not editable

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

Linked Database Field: ERPx_SPProgramHeader.SettlementFrequencySK

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

Linked Database Field: ERPx_SPProgramHeader.SettlementFrequencySK

A date field to indicate when the Program starts. Programs with a Start Date that occurs after a Sales Orders Invoice Date will not be evaluated. 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.

Database Field: ERPx_SPProgramHeader.CurrencySK

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