Adding Inventory Pricing Levels
The following steps will explain in detail how to add a new Inventory Pricing Levels.
1.From the Main Menu, click on Inventory, then Inventory Items. This will open up the Find form for Inventory items. Click on the Inventory Item you wish to add pricing levels to. This will open up the Inventory Item form with that Inventory Item's related data. If you need to add new inventory items see the Adding Inventory Items topic. Click the Pricing tab at the top of the Inventory Item form. You will notice that the top portion of this form will display the Item No, Vendor Item No and Vendor ID. These fields are on each tab of the form for easy reference as you review each tab. The middle section of the form contains Inventory Pricing topics such as Sell Price and Purchase Cost for the selected inventory item. The lower portion of this form is a Line Item Detail where you can add an unlimited number of pricing levels for each inventory item. Click your mouse in the Level combo box field on the next available line to enter a new pricing level.
2.The Level combo box field can be used to enter the level number you want to assign to the pricing level. It will default to 1, which you can leave or change. You can select up to 20 different pricing levels each of, which can be setup with any Minimum and Maximum quantity settings. When you have finished entering data for each field, press the TAB or ENTER key to move your cursor to the next field.
3.The Unit Measure combo box field is used to enter the Unit Measure you want to assign a pricing level to. You may have anywhere from one to several Unit Measures available to choose from in the combo box depending on how many were created for the selected inventory item.
4.The Units field will be automatically entered based on the Unit Measure you selected. If you used the default Unit Measure of 'Each' then a 1 will appear in the Units field. The Units field is important to pay attention to because it will multiply itself by the Unit Price to give you the Sales Price for this level.
5.The Min field is used to enter the minimum quantity a customer has to order of the selected Item No to get the discounted sales price. Default value is 0.
6.The Max field is used to enter the maximum quantity a customer can order of the selected Item No to get the discounted sales price. Default value is 999,999.
7.The Pricing Method combo box field is used to pick from a preset number of pricing discounts. There are six different Pricing Methods you can choose from and each are described below in more detail.
Fixed Dollar Amount - In the Percent / Amount field enter the exact amount you want to add to the Standard Cost field of the inventory item. For example, if the Standard Cost is 150.00 and you enter 25.00 in the Percent / Amount field, the Unit Price will automatically change to display 175.00.
Markup Standard Cost - In the Percent / Amount field enter the exact percent you want to use to calculate the Unit Price field. The formula used to determine the Unit Price will be the Standard Cost amount plus the Percent amount you entered in the Percent / Amount field. For example, if the Standard Cost amount is 150.00 and you enter 25 in the Percent / Amount field (25%), the Unit Price will automatically change to display 187.50. That is 150.00 plus 37.50 or (25%) equals 187.50.
Percent of Margin - In the Percent / Amount field enter the exact percent you want to use to calculate the Unit Price field. The formula used to determine the Unit Price will be the Standard Cost amount divided by (1 minus the Percent amount you entered in the Percent / Amount field). For example, if the Standard Cost amount is 150.00 and you enter 25 in the Percent / Amount field (25%), the Unit Price will automatically change to display 200.00. That is 150.00 divided by .75 or (1 - 25% = .75) equals 200.00.
Discount Sales Price - In the Percent / Amount field enter the exact percent you want to use to calculate the Unit Price field of the inventory item. The formula used to determine the Unit Price will be the Sales Price amount minus the Percent amount you entered in the Percent / Amount field. For example, if the Sales Price amount is 250.00 and you enter 10 in the Percent / Amount field (10%), the Unit Price will automatically change to display 225.00. That is 250.00 minus 25.00 or (10%) equals 225.00.
MSRP Discount - In the Percent / Amount field enter the exact percent you want to use to calculate the Unit Price field of the inventory item. The formula used to determine the Unit Price will be the MSRP amount minus the Percent amount you entered in the Percent / Amount field. For example, if the MSRP amount is 16.50 and you enter 10 in the Percent / Amount field (10%), the Unit Price will automatically change to display 14.85. That is 16.50 minus 1.65 or (10%) equals 14.85. See also How MSRP Discount pricing method works
Percent of Margin (MSRP) - In the Percent/ Amount field enter the exact percent you want to use to calculate the Unit Price field of the inventory item. The formula used to determine the Unit Price is [(MSRP - Standard Cost) x Percent] + Standard Cost. For example, if the MSRP amount is 99.99, the Standard Cost amount is 75, and you entered 10 in the Percent/ Amount field, the Unit Price will automatically compute and change to 77.499. See: Percent of Margin (MSRP)
None - This will not affect the Unit Price at all. You will be able to manually enter the Unit Price to any amount you choose. The Percent / Amount field will display zero and you will not be able to change it.
8.In the Commission Percent field you may enter the Commission Percentage you would like for the selected pricing level.
9.The Percent / Amount field is used in conjunction with the selected Pricing Method field. You either enter an amount or a percent in this field to be calculated with the Standard Cost, Sales Price or MSRP to give you the Unit Price.
10.The Unit Price is the price that will be charged for the item if the customer falls into all the parameters. You can view the selected inventory items Sales Price and Standard Cost at the top of this form. This can give you a guide line for what you want the Unit Price to be if the customer falls within the parameters that you set.
11.The Unit Total is the price based on the Unit Price multiplied by the Units field. Unless you are using special Unit Measures the Unit Price and Unit Total will be the same. The Unit Price basically becomes the add Sales Price the customer will receive if they fall into the pricing level you set.
12.The Warehouse field will list all the warehouses plus the 'All Warehouse'. Each time a new pricing level is created, this field will be defaulted to 'All Warehouse', which means that the pricing level is applied to all warehouses. If a particular warehouse is selected then the pricing level will only be applied to the line items having that warehouse. See also How Warehouse field is used in Pricing Level
13.The X button next to the Pricing Level will delete whichever line you click that button on.
Very Important: Keep in mind that in order for a customer to receive one of the Sales Prices setup in the Pricing Level form they must be purchasing the exact Item No, Unit Measure and order between the Min and Max quantities. If they order more than the Max set for one price level they will not get that price. So make sure if you want a price level to be between 5 and anything higher you enter a very large number in the Max field like 99999999.
Related Topics