<< Click to Display Table of Contents >> Navigation: Process Guide > Setting Prices |
Important Notices:
•Price refers to the price your customer will be billed when purchasing from you.
•Customers will receive the lowest price they qualify for if they qualify for multiple pricing options.
Enable the last price posted option by navigating to:
System > Config > Config Maint > Search: computer price last price
One of the easiest pricing models to implement and a common starting point for clients new to sales automation. Food Connex Cloud will prefill the pricing column during order entry with the last posted price that particular customer paid for the item.
An unlimited number of price lists can be created. Each customer can be assigned to a single price list. Price lists accept a single price per list per item.
Price lists can be created by navigating to:
Pricing > Price Lists
Once a price list has been created assign customers to the price list by navigating to:
Customers > Master Maintenance > Select Customer > Pricing Tab
Prices for each item can be set for the price list by navigating to:
Inventory > Files > Master Maintenance > Select Item > More Tabs > Price Lists Tab
•Before setting the initial prices be sure to click the New button and set an effective and ending date. Failing to set an effecting and ending date will result in a permissions error when attempting to set price.
•Price lists can also be updated using the cost load feature.
An unlimited number of price formulas can be created. Each price formula is attached to a price list level and an item. Price formulas can be calculated by percentage markup, gross profit margin, or straight dollar markup. Price formulas can be based on the following cost options Market, Invoice, True, Salesperson, or Average cost.
Create a price list by navigating to:
Pricing > Price Lists
Once a price list has been created assign customers to the price list by navigating to:
Customers > Master Maintenance > Select Customer > Pricing Tab
The formulas can now be created by navigating to:
Pricing > Formulas
•Click +Add to create a new formula.
•Enter a Formula Code and Description.
•Select a Cost Basis from the cost options.
•Select a Calculation Method
Dollar: A straight dollar value markup.
Percent: Markup based on straight percentage of cost.
Margin: Margin uses the following formula
Price = Cost / (100%-Markup Value)
•Click +Add to choose a price list level for the formula.
•Enter the dollar, percent or margin amount.
•To Charge for Broken Case click the checkbox
Choose Method and Broken Case Charge Amount
This upcharge is cumulative with standard pricing.
Select the formula to be used for each item by navigating to:
Inventory > Files > Master Maintenance > Select Item > More Tabs > Formula Prices
Once selected refreshing the screen will display the calculated formula prices.
Price keys allow for the greatest degree of flexibility in pricing, but also take the largest amount of time to setup and maintain. Price keys allow for individual items to have individual pricing calculations for a set time frame and can be assigned to one or multiple customers. A single customer can also have multiple price keys assigned to them.
Create a price key by navigating to:
Pricing > Pricekey
•Click the +Add button in the bottom right corner to create a new price key
•Fill in a Price Key Code and Description
•On the Pricekey Items Tab click +Add to add a new item to the price key
Price Key Item Fields |
General |
Item |
Select an item, F5 lookup enabled |
Effective |
Required: Starting date for pricing |
Expire |
Required: Ending date for pricing |
Retail Price |
Information field only, does not affect price |
Price Key Item Fields |
Price Calculation |
Base |
This is the cost pricing will be based on. The base cost can be entered manually if the Cost field below is left blank. The unit of measure field to the right indicates what UOM the cost will be based on. |
Cost |
System Cost Options to base the calculation on: Invoice, True, Salesperson, Average, Market, <None>. |
Markup |
The markup value. |
Type |
Dollar: A straight dollar value markup. Margin: Margin uses the following formula Price = Cost / (100%-Markup Value) |
Price Key Item Fields |
Broken Case Price Calculation |
Amount |
Markup Value in addition to standard markup if an item is a broken case, sold as an each when a case quantity is available. This markup is cumulative. |
Type |
Dollar: A straight dollar value markup. Margin: Margin uses the following formula Price = Cost / (100%-Markup Value) |