Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Overview

NorthScope allows the user to create 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 differential 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

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. This will open the New Price List record view window with the following header fields for data entry:

  • Currency ID: Displays a drop-down menu for the user to select the currency for the price list prices. This field is required.
  • Description: Displays a text box field for the user to enter a description of the price list.
  • Inactive: Displays a check box determining whether or not the price list is active in the system. IF the check box is checked, the price list is inactive. If the check box is not checked, the price list is active.
  • Linked to Base Price List: Displays a drop-down menu of all base price lists. If the user selects a base price list to link to the current price list, all items on the base price list become available in the line item “Price Line to Item/Item Set” field to determine the line item price information from the base price list. If no base price list is linked, the current price list becomes a base price list available for linking.
  • Price List: Displays a text box field for the user to enter the name of the price list.
  • Prices Include Freight Cost: Displays a check box determining whether or not the prices on the price list include freight costs. If the box is checked, the prices include freight cost. If the box is not checked, the prices do not include freight cost.

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

Step 2: Adding items to the price list.

To add items to the price list, open the Items/Item Sets tab and click the New toolbar icon. This will create a new line for data entry with the following fields:

  • Current Price Date: Displays the effective date of the current price. This field is read-only and updates on save.
  • Current Price: Displays the current price of the line item. This field is read-only and updates on save.
  • Differential Formula: Displays a text box field for the user to enter a formula altering the linked base price list price for the line item. This field is required when linked to base price list and disabled when not linked. To make the line item price the same as the linked base price list item price, enter a differential formula of *1.
    • Note: Formula values are required to include a number before a decimal point. For example, a differential formula to adjust the price to be 75% of the base price list item price must be entered as *0.75.
    • Item Class: Displays the line item’s item class. This field is read-only.
    • Item Type: Displays the line item’s item type. This field is read-only.
    • Item/Item Set: Displays a drop-down menu of all items/item sets for the user to select the item/item set to add to the price list. This field is required.
    • New Effective Date: Displays a text box field for the user to enter the effective date for the new price. This field is required.
    • New Price: For line items on non-linked price lists, this field displays a text box field for the user to enter the new price for the line item and defaults to 0. For line items linked to an item/item set, this field is read-only as it updates based on the differential formula.
    • Next Effective Date: When a new effective date is entered for a future date, this field displays the next effective date for the new price in a read-only field that is updated upon save.
    • Next Price: When a new price is entered with a new effective date set in the future, this field displays the next price in a read-only field that is updated upon save.
    • Price Linked to Item/Item Set: Displays a drop-down menu for the user to select the item/item set from the linked base price list that will be linked to the line item. This field is disabled for price lists that are not linked to a base price list.
    • Price UOM: Displays the line item’s price unit of measure and becomes read-only on save. This field is required.  
    • Seq: Displays the line item sequence number and is a read-only field that updates on save.
    • UOM Schedule: Displays the unit grouping for the line item. This field is read-only and defaults from the item’s UOM Schedule selected in the inventory module. This field updates on save.

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

Step 3: Assigning the price list to customers.

By assigning a price list to a customer, when a new sales order or invoice is created for that customer 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 a customer is 5.

To assign the price list to a customer, open the Customers tab. This will display a list view of all customers, their billing address information, and the number of price lists already assigned to the customer. Select the customer’s check box and click the Save toolbar icon to assign the price list to that customer. All customers can be selected by selecting the check box in the column header. Each column is available for filtering to find specific customers.

Step 4: 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. Moreover, addresses are prioritized over customers for assigned price lists. The maximum number of price lists that can be assigned to an address is 5.

To assign the price list to an address, open the Addresses tab. This will open a list view of all customers, their shipping addresses, and the number of price lists already assigned to the address. Select the address’s check box and click the Save toolbar icon to assign the price list to that address. All addresses can be selected by selecting the check box in the column header. Each column is available for filtering to find specific addresses. 

  • No labels