Delete

Help

New

Notes

Save

Save & Close

Program

Excel

Quick Column Filter

Program ID

Database Field: ERPx_SPProgramHeader.ProgramID

Description

Identifies the Description of the corresponding Program. This is a textbox that defaults to blank for new records and is not required. If entered it must be <= 200 characters. This is always editable.

Database Field: ERPx_SPProgramHeader.Description

Setup

Program Type

Identifies the Type of program. This defaults from the value selected when the 'New' icon was selected, and the program was initially saved. This is always disabled.

Database Fields: ERPx_MFSysEnumeration WHERE EnumerationClass = 'SPProgramType', ERPx_SPProgramHeader.ProgramClassSK

Program Class

Identifies the Class associated with the Program Type. This is a single select lookup that defaults as blank, is required, and if missing, the message "Program Class is required." will be displayed on Save. This is not editable after the initial save.

The lookup contains a list of all Program Classes associated with the Program Type being added/edited.

Database Fields: ERPx_SPProgramClass.ClassName, ERPx_SPProgramHeader.ProgramClassSK

Start

Identifies the date the Program starts. Sales Orders with an 'Ordered Date' on or after this date will be evaluated for the Program. This is a date picker that defaults as blank, is required, and if missing the message "From date is required." will be displayed on Save. This is always editable.

Database Field: ERPx_SPProgramHeader.StartDate

End

Identifies the date the Program ends. Sales Orders with an 'Ordered Date' on or after this date will not be evaluated for the Program. This is a date picker that defaults as blank, is required, and if missing the message "To date is required." will be displayed on Save. This is always editable. The 'To' date must be >= the 'From' date else the message "The To (date) must occur on or after the From (date)." will be displayed on Save. This is always editable.

Database Field: ERPx_SPProgramHeader.EndDate

Program Rate Currency 

The lookup contains a blank value, the current assigned value, and all the Currencies assigned to the Company from System-->Configuration-->Currencies.

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_SPProgramHeader.CurrencySK

Assign Address By

Customers are assigned to programs by Customer Address and this property identifies which method is used for assigning the Addresses to the program. This is a single select lookup that defaults as blank, is required, and if missing, the message "Assign Address By is required." will be displayed on Save. This is not editable after the initial save.

The lookup contains opens for

• Address: Addresses will be assigned to the program individually. If this option is selected, the Addresses tab will be visible after the initial save allowing the assignment of individual customer addresses. 

• Address Set: Addresses will be assigned to the program selecting one or more Address Sets. If this option is selected, the Address Sets tab will be visible after the initial save allowing the assignment of Addresses Sets. 

Database Field: ERPx_SPProgramHeader.AddressFilterEN

Freight Accrual

A Yes/No lookup to Identify whether an Accrual Program is used to accrue "Delivered Freight" amounts. This defaults to "No", is required, and is always editable.

• If "Yes", the computed program amount for each applicable sales transaction line is considered "Delivered Freight" and will be included in the 'Freight Amt.' columns and will have an impact on the Net Amt. calculation for the line item. 

• If "No", the computed program amount for each applicable sales transaction line is considered a non-freight accrual and will not be included in the 'Freight Amt.' columns and will not have an impact on the Net Amt. calculation for the line item.

This setting impacts other Programs with a 'Calculated On' of "% (Gross - Freight)" by allowing them to exclude a "Freight Accrual" program amount. If this is set to "Yes", no existing or new Item Sets can have a 'Calculated On' of "% (Gross - Freight)" else the message "Item Sets - Calculated On cannot be % (Gross - Freight) when the Freight Accrual property is set to Yes." will be displayed on Save.

Note: This property is only visible for Accrual program types.

Database Field: ERPx_SPProgramHeader.ExcludeFromNetAmtBalance

Inactive

Database Field: ERPx_SPProgramHeader.Isinactive

Settlements - This group is not visible for 'Accrual' and 'On Invoice' program types.

Settle To 

Identifies how the Program will be settled (paid). This is a single select lookup that defaults as blank, is required, and if missing, the message "Settle To is required." will be displayed on Save. Once this has been set and saved, it is no longer editable.

The lookup contains the values in the SPSettlementMethod Enumeration Class. The options include:

• AP Invoice - Paid In Full Orders: Only Sales Orders that have been paid in full will be auto selected to be settled by creating an A/P Invoice to the Vendor identified as the 'Payee'.

• AP Invoice - All Orders: As soon as the Sales Order is posted it is eligible to be settled by creating an A/P Invoice to the Vendor identified as the 'Payee'.

• AR Credit Memo: As soon as the Sales Order is posted it is eligible to be settled by creating an A/R Credit Memo to the Customer identified as the 'Payee'. This option is not available for 'Brokerage' programs.:

This is not visible for 'Accrual' and 'On Invoice' program types.

Database Field: ERPx_SPProgramHeader.SettlementMethodSK

Settlement Frequency

Identifies how often the Program will be settled (paid). This is a single select lookup that defaults to 'As Needed', is required, and if missing, the message "Settlement Frequency is required." will be displayed on Save. This is always editable and is for informational purposes only, this does not drive any functionality. 

The lookup contains the values in the SPSettlementFrequency Enumeration Class.

This is not visible for 'Accrual' and 'On Invoice' program types or for Rebate programs where the 'Settle To' is set to "AR Credit Memo".

Database Field: ERPx_SPProgramHeader.SettlementFrequencySK

Payee

If the 'Settle To' value is:

• AP Invoice - Paid In Full Orders, the lookup contains all the active Vendors

• AP Invoice - All Orders, the lookup contains all the active Vendors

• AR Credit Memo, the lookup contains all the active Customers. This option is not available for 'Brokerage' programs.

This is not visible for 'Accrual' and 'On Invoice' program types.

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

Consolidate Settlement Transactions by

Identifies how program settlements are created, when there are more than one Sales Transaction being settled for the same Payee. This is required and defaults to "Payee" for Brokerage & Off Book programs and to "Sales Transaction" for Rebate Programs. This is always editable.    

Settlements behave as follows:

• Payee: one A/P Invoice or A/R Credit memo will be created for each Payee regardless of how many sales transactions are being settled.

• Sales Transaction: one A/P Invoice or A/R Credit memo will be created for each sales transaction being settled.

This is not visible for 'Accrual' and 'On Invoice' program types.

Database Field: ERPx_SPProgramHeader.ConsolidateSettlementTransactionsByEN

Accounting Rules

Expense Account

Accrual: Default as "(From Item Sales Freight Expense)", is required, and is always editable. If left as the default, the GL Account will be assigned for each item, from the 'Sales Freight Expense' GL Account configured on the Item Master.

Brokerage: Defaults as "(From Item Brokerage Expense)", is required and is always editable. If left as the default, the GL Account will be assigned for each item, from the 'Brokerage Expense' GL Account configured on the Item Master.

Off Book: Defaults as blank, is required, and is editable. If missing the message "Expense Account is required." will be displayed on save.

On Invoice: Not applicable or visible for this Program Type.

Rebate: Defaults as "(From Item Brokerage Expense)", is required and is and is always editable. If left as the default, the GL Account will be assigned for each item, from the 'Brokerage Expense' GL Account configured on the Item Master.

Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_SPProgramHeader.DRAccountSK

Accrual Account

Accrual: Defaults as "(From Item Sales Freight Accrual)", is required and is always editable. If left as the default, the GL Account will be assigned for each item, from the 'Sales Freight Accrual' GL Account configured on the Item Master.

Brokerage: Defaults as "(From Item Brokerage Accrual)", is required and is and is always editable. If left as the default, the GL Account will be assigned for each item, from the 'Brokerage Accrual' GL Account configured on the Item Master.

Off Book: Default as Blank and is never editable. After the initial save, it is updated to either "Payee's Accounts Payable Account" or "Payee's Accounts Receivable Account" based on whether the Payee is a customer or vendor. This is never editable.

On Invoice: Not applicable or visible for this Program Type.

Rebate: Defaults as "(From Item Brokerage Accrual)", is required, and is always editable. If left as the default, the GL Account will be assigned for each item, from the 'Brokerage Accrual' GL Account configured on the Item Master.

Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_SPProgramHeader.CRAccountSK

Add Item

Column Filter Show/Hide

Excel

Group By Show/Hide

Quick Column Filter

Remove Items

Saved Layouts

Checkbox

# Items

A calculated field to show the count of Item IDs that are assigned to the Item Set. This is informational only; it is not stored in the database. The only way to change this value is by adding/removing items from the item set.

Calculated On

Database Field: ERPx_SPProgramItemSet.ProgramCalcMethodSK

Item Set

Identifies the Item Set assigned to the Program. This defaults to blank for new records but is required. This is always editable.

Database Field: ERPx_SPProgramItemSet.ItemSetSK

Item

A single select lookup to assign the Item ID that will be auto added to the Sales Transaction to reflect the program amount. For 'On Invoice' programs, this defaults as blank but is required. If missing, the message 'Item Sets: Program Item is required' will be displayed on Save. This column is only visible for 'On Invoice' programs. 

The lookup contains the current assigned value, and a list of all 'Active' Items with an Item Type of Freight, Misc, and Tax displayed as [ItemID]: [Item Description].

Database Fields: ERPx_IMItem.ItemID - ItemDescription, ERPx_SPProgramItemSet.PromoProgramItemSK

Rate

Database Field: ERPx_SPProgramItemSet.Rate

Seq

Identifies the sequence for how the Item Sets will be evaluated. If a sales line item is included on more than one Item Set, within a single sales program, the rate from the first Item Set will be used. This ensures that a single sales program is not applied multiple times to a single sales line item. 

The Seq column for each row begins with 10 and always increments in multiples of 10. To insert a row between two other rows, enter a Seq value that falls between the rows. For example, to move the 4th row (seq 40) to the 2nd position (seq 20), enter any value >= 21 and <= 29. On Save, the rows will sort and the Seq values will be automatically updated to base-10 values.

Database Field: ERPx_SPProgramItemSet.Sequence

UOM

Identifies the UOM associated with the Item Set Rate. This value is displayed as '%' for all Item Sets with a 'Calculated On' of "% Gross Amt." or "% Net Amt." and it is disabled. For Item Sets with a 'Calculated On' of "$/UOM" this is an editable lookup that is required. The lookup contains all the 'Active' UOMs configured in the system.

 Items belonging to an Item Set that do not convert to the UOM specified will not calculate a program amount. 

Database Field: ERPx_SPProgramItemSet.ProgramCalcUnit

Column Filter Show/Hide

Excel

Group By Show/Hide

Mass Update

• Assign Addresses: Assigns the Address(es) to the Program

• Remove Addresses: Removes the Address(es) from the Program

• Start Date: Assigns the 'Start Date' to the Address(es)

Quick Column Filter

Saved Layouts

Checkbox

Address

Identifies the value entered as 'Address Line 1' of the Customer Address. This is informational only on this grid, it is only editable from the Customer Address Record View. 

Database Field: ERPx_ARCustomerAddress.AddressLine1

Address ID

Database Field: ERPx_ARCustomerAddress.AddressID

City

Identifies the 'City' of the Customer Address. This is informational only on this grid, it is only editable from the Customer Address Record View. 

Database Field: ERPx_ARCustomerAddress.City

Country 

Identifies the 'Country' of the Customer Address. This is informational only on this grid, it is only editable from the Customer Address Record View. 

Database Field: ERPx_ARCustomerAddress.Country

Customer ID

Identifies the 'Customer ID' of the customer that the Address belongs to. This is informational only on this grid, it is only editable from the Customer Record View. 

Database Field: ERPx_ARCustomer.CustomerID

Customer Name

Identifies the 'Customer Name' of the customer that the Address belongs to. This is informational only on this grid, it is only editable from the Customer Record View. 

Database Field:ERPx_ARCustomer.CustomerName

On Program 

Identifies whether the Adress is assigned to the program. This defaults as blank (No) but can be changed to "Yes" using the 'Mass Update'. 

Database Field:ERPx_SPProgramCustomerAddress.CustomerAddressSK

Start Date

Identifies the Date the program begins for a specific address record. This defaults as blank, is not required, and is always editable. If blank, the program is effective for the address as soon as the address is added, else it becomes effective on the date specified. 

Database Field: ERPx_SPProgramCustomerAddress.CustomerStartDate

State

Identifies the 'State' of the Customer Address. This is informational only on this grid, it is only editable from the Customer Address Record View. 

Database Field: ERPx_ARCustomerAddress.State

Zip

Identifies the 'Zip' of the Customer Address. This is informational only on this grid, it is only editable from the Customer Address Record View. 

Database Field: ERPx_ARCustomerAddress.State

Column Filter Show/Hide

Excel

Group By Show/Hide

Quick Column Filter

Saved Layouts

Checkbox

Address Set

Identifies which Address Sets are applicable to the Program. All Address Sets are included in the grid but only the "selected" Address Sets are applicable to the Sales Program. To select an Address Set you must click the checkbox. Address Sets that have been selected will sort to the top of the grid once the program has been saved.

Add Each Site

Auto Adds all Sites to the Program. This is a data entry tool that is helpful in configuring programs that apply to a majority of Sites, but not all. In this instance, it easier to auto add them all and remove the ones you do not need. Clicking this icon adds all 'Active' Sites that are 'Visible to Sales' to the Program. 

Add Item

Column Filter Show/Hide

Excel

Group By Show/Hide

Quick Column Filter

Remove Items

Saved Layouts

Checkbox

Site

Identifies which Sites are applicable to the Program. This is a single select lookup that displays the [Site ID] - [Site Name] for all 'Active' Sites that are 'Visible to Sales'. If no Sites have been selected there will be one row indicating "All".

Add Each Carrier

Auto Adds all Carriers to the Program. This is a data entry tool that is helpful in configuring programs that apply to a majority of Carriers, but not all. In this instance, it easier to auto add them all and remove the ones you do not need. Clicking this icon adds all 'Active' carriers to the Program. 

Add Item

Column Filter Show/Hide

Excel

Group By Show/Hide

Quick Column Filter

Remove Items

Saved Layouts