...

• Program Class Setup
  • To assign to the Sales Program for categorical purposes.
• Item Setup
  • Specifically, an Item to code promotions as that will display on the invoice for promotions.
• Item Set Setup
  • To assign to the promotion, making all items on this item set eligible for the promotion to be applied when sold on a Sales Order transaction that is being sold to a customer also assigned to the Promotion.
• Customer Address Setup
  • To assign to the promotion, making the assigned customer addresses eligible for the promotion to be applied to any items sold to them that are also on the promotion’s assigned item set(s).
• UOM Setup
  • To assign the UOM for any promotion rate set to a calculation of $/UOM.

Optional Prerequisites

• Set the ‘Enable Real Time Transaction Integration’ Sales Order preference to ‘Yes’Integration setup
  • Setting the Host system integration for SO Invoice to immediate or timed.

Understanding the Data Flow

...

• Description: Enter the description of the promotion. This will display in the Programs list view and will help differentiate the sales program from all other promotions.
• Class: Select the Program Class to assign to the promotion. This is for categorical purposes and the lookup will only include those program classes assigned a program type of ‘Promotions’. This field is required.
• From: Enter the date as of which the promotion is eligible. This field is required.
• To: Enter the date as of which the promotion is no longer eligible.  This field is required.
• Settle To: This field defaults to ‘Invoice’ and is not editable for Promotions.
• Frequency: This field defaults to ‘Invoice’ and is not editable for Promotions.
• Inactive: This field allows users to inactivate the program. When the program is set to inactive, it is not assigned to Sales Order transactions. 

Once completing the header fields, click Save.

...

• Seq: This field defaults to the next number in the sequence and is not immediately editable. However, once the Item Sets tab is saved, each Item Set can be dragged and dropped into the correct order of hierarchy.
• Item Set: Select the Item Set to assign to the promotion. Duplicate Item Sets are not allowed to be assigned to the same sales program. This field will display a drop-down menu of all Item Sets assigned a ‘type’ of ‘Sales Programs’ or ‘All Modules’. This field is required.
  • To setup Item Sets, go to Inventory>Item Sets and click new. Enter the Item Set name and description and select the item set’s ‘Type’. By default, all new Item Sets include all items. To limit the items included in the item set, apply as many filters as necessary to include only the items meeting the filtered criteria. Filters can be placed on the following item values: Item IDType, Item TypeClass, Attribute Class, UOM Schedule , Item Class, and all Item Attributes, and Inactive. Once the desired filters have been applied to the Items list grid, click SaveAttribute Values. Items can be manually included and excluded if necessary. Saving the item set record updates the Items tab displaying the items assigned to the item set record. When a new item is added to NorthScope that fits the filtered criteria of an Item Set, that item is automatically added to the Item Set and therefore assigned to any sales program the Item Set is assigned to. 
• Promotion Item: Select the item that will display on the transaction for this promotion and will therefore drive the accounting rules of the sales program. This field displays a drop-down menu of all non-Sales Inventory items. This field is required.
• Calculation Method: Select the method by which the promotion will be calculated. This field displays a drop-down menu of calculation methods including the following:
  • $/UOM: Calculates the promotion based on the rate assigned to the item set for the promotion and the UOM assigned to the item set for the promotion. This calculation is the rate times the quantity (of the Promotion UOM) that exists on the invoice for all items belonging to the item set. If this calculation method is selected, the UOM field is required.
  • % Gross $’s: Calculates the promotion based on the percentage rate assigned to the item set for promotion and the total dollars of all items on the item set. This calculation is the percentage rate times the sum dollar amount of all items belonging to the item set on the invoice.
  • % Net $’s: Calculates the promotion based on the percentage rate assigned to the item set for promotion and the total dollars of all items on the item set. This calculation is the sum dollar amount of all items belonging to the item set on the invoice less the charges from all other sales programs times the percentage rate.
  • % off Total Invoice $’s: Calculates the promotion based on the percentage rate assigned to the item set for the promotion and the invoice’s total amount. This calculation is the percentage rate times the total invoice dollar amount, including items not belonging to the assigned item set(s).
• Rate: Enter the rate by which to calculate the promotion. If the Calculation Method is set to $/UOM, the rate being entered must be a dollar amount to be charged/discounted per 1 unit of the selected UOM. If the Calculation Method is set to anything other than $/UOM, the rate being entered is a percentage to be charged/discounted.
• UOM: Select the unit of measure by which to calculate the promotion. If the Calculation Method is set to $/UOM, the UOM field is required and will determine the unit by which the rate is charged/discounted. If the Calculation Method is set to anything other than $/UOM, the UOM field is disabled and will display %.
• # Items: This field is never editable by the user and will automatically update once the Item Set is saved to display the number of items on the item set, which are now assigned to the Sales Program.

...

The Customers tab will display all customer addresses with a check box, allowing the user to select the address(es) to assign to the brokerageprogram. Each column within the list is filterable, allowing the user to easily narrow down the addresses that display to select the appropriate address(es) addresses to assign. Once finding an address to assign to the brokerage, select the checkbox that corresponds to the address and click the save grid toolbar icon. This will sort the selected address(es) to the top of the list to easily identify the address(es) currently assigned to the brokerageTo assign addresses to a program, check the check box displayed before the Customer ID and click Mass Update.  This opens the mass update dialog, where addresses can be assigned. Set ‘Assign Addresses’ to ‘Yes’ and click Apply. Also the start date can be assigned on the mass update dialog, but this is not required. Multiple addresses can be assigned to the program simultaneously. To remove addresses from the program, check the check box and click Mass Update toolbar icon. Set ‘Remove Addresses’ to ‘No’ and click Apply. When an address is assigned to a program, the On Program column displays Yes. Addresses assigned to the program are displayed on top of the list view.

Step 2: Entering a transaction with the Promotion

...

• Gross $: Displays the item’s total gross dollar amount.  
• Item Set: Displays the name of the Item Set assigned to the program to which the corresponding transaction item belongs to.
• Item: Description: Displays the item and item description of the transaction item affected by the program.
• Method: Displays the calculation method of the program.
• Net $: Displays the item’s total net dollar amount.  
• Program Amt.: Displays the amount of the program as calculated for the corresponding line item.
• Program Group: Displays the Sales Program type, ID and Description. Note: This field column is not in the system view. 
• Program ID: Displays the Program ID of the Sales Program. Note: This field column is not in the system view. 
• Program Name: Displays the name of the Sales Program. Note: This field column is not in the system view. 
• Program Type: Displays the type of the Sales Program. Note: This field column is not in the system view. 
• Promo Item ID: Displays the item ID that will display on the invoice for the program calculations.
• Rate: This field displays the sales program rate as defined on the sales program record. This field is editable and the Program Amount is re-calculated after clicking Save. Note: Updating the rate on this window impacts only this transaction and it does not update the Sales Program record.
• Unit UOM: Identifies the unit UOM of the item that is affected by the sales program.  
• Units: Displays the total number of units ordered of the item that is affected by the sales program.
• UOM: Displays the UOM upon which the program was calculated.
• Weight: Displays total weight of the item that is affected by the sales program.
• Wt. UOM: Identifies the weight UOM of the item that is affected by the sales program.  

...

The promotion item will integrate to the host system the same as the other line items on the invoice, so long as the ‘Enable Real Time Transaction Integration’ Sales Order preference SO Invoice integration is set to ‘Yes’immediate or timed.