Overview

NorthScope allows the user to create sales order price lists that can be assigned to customers and/or addresses. By assigning a price list to a customer or address, the process of creating a new order or invoice is expedited as the price list items will default the price and price UOM. Moreover, price lists may be assigned to more than one customer or address and prices for a price list line item can be differentiated on an assigned customer’s order or invoice, allowing for custom price adjustments. Price lists can be updated at any time with new prices, new price effective dates, new items, removed items, and complex formulas. Price list edits will only apply to those transactions that are created after the price list is edited.

Prerequisites

Required Prerequisites

• Items Setup
• Currency Setup

Understanding the Types of Price Lists

NorthScope allows user to create three different types of price lists: Standard, Base Index, and Linked. Standard and Base Index price lists are created following the same steps and can have multiple items. The difference between a Standard price list and a Base Index price list is that the items on a Base Index price list can be linked to while the items on a Standard price list cannot. This means that when a user creates a Linked price list, the items selected on that price list can be linked to the items and corresponding prices on a Base Index price list. However, items on a linked price list cannot be linked to items on a Standard price list. 

Linked price lists function differently. Linked price lists can also have multiple items, however, the items on Linked price lists can be either linked to an item on another price list or un-linked. Linking an item to another price list inherits the item's price from the linked source as well as the price date ranges. However, linked price lists also allow the user to create complex formulas that adjust the price inherited from a linked item. These formulas can be configured either at the header or line item level. Configuring a formula at the header level acts as a default that is inherited to all linked line items added to the price list after the header formula is configured. Once a header formula is inherited to line items, the header formula can be edited at the line item level. If a header formula is not configured or a line item is added after the header formula is configured (and therefore does not inherit the header formula), the user can configure a formula at the line item level. Configuring a formula at the line item level applies the formula only to the selected item. The available formula operations include Multiply, Divide, Subtract, Add, Round, and Convert. 

Step 1: Creating a new price list.

To create a new price list, first expand the Sales Order module in NorthScope and select Price Lists from the navigation menu. This will open the Sales Order: Price Lists list view. From the list view, click the New toolbar icon and select Sales Order Price List. This will open the New Price List record view window with the following header fields for data entry:

...

Once all data has been entered in the header, click the Save toolbar icon.

Step 2: Configuring a header formula. (Optional - Linked price lists only)

To configure a header formula that will be inherited to all linked line items added after the configuration, click the Linked Formula 'Configure' header hyperlink. This will open the Linked Item Formula window. From this window, click the New grid toolbar icon to open 5 lines for data entry. These lines allow the user to select an operation to adjust the price by (i.e. Multiply) and the factor by which the operation is done (i.e. 2). Once all formula steps have been added, click Save. Then, exit the Linked Item Formula window to return to the Price List record view.

...

Note: Edits made to the header formula will only be inherited by line items added after the edits are made. 

Step 3: Adding items to the price list.

Click here to view the Items tab online help page for more information on the fields that display.

...

Once all line items have been added with all information, click the Save toolbar icon.

Step 4: Configuring or editing a line item formula. (Optional - Linked price lists only)

To configure or edit a line item formula, click either the 'Configure' or 'Edit' Linked Formula line item hyperlink. This will open the Linked Item Formula window. If a header formula was inherited by the item, the user can add, edit, or remove the inherited formula steps in this window. If no formula was inherited by the item, the user can create a formula by clicking the New grid toolbar icon to open 5 lines for data entry. Once all formula steps have been configured and/or edited, click Save. Then, exit the Linked Item Formula window to return to the Price List record view. 

...

If a formula was configured for a line item that previously did not have a formula and the formula saved properly, the line item's Linked Formula hyperlink will display 'Edit' instead of 'Configure'. If all formula steps for a line item are deleted, the line item's Linked Formula hyperlink will display 'Configure' instead of 'Edit'.

Step 5: Assigning the price list to addresses.

By assigning a price list to an address, when a new sales order or invoice is created for that address with an item from the assigned price list, all corresponding price information will default for that item, expediting the process. The maximum number of price lists that can be assigned to an address is 5. Click here to view the Addresses tab online help page for more information on the fields that display.

...