This process will create customer-specific pricing based on the Customer levels and inventory category discounts (defined within the customer category discounts screen).
Select the Customer account range, customer pricing levels and product categories to create pricing for. The store, rounding and expiry date can also be adjusted as required.
The Create Pricing button will start creating customer-specific product pricing based on the discount percentages and the selected selection range.
Once the process has been completed a second screen will appear giving the user the option to create a pricing file for the selected accounts and customer levels. The file created is a simple CSV (Comma separated values) file, containing the customer account number, item code, discount percentage, exclusive and inclusive pricing and the expiry date of the price (as shown below). This has been used in some cases for uploading to a web site store front that requires customer specific pricing.
"Account","Item_Code","Discount_%","Discounted_Excl","Discounted_Incl","Expire_Date"
"ABB029","ACC/LOC",5.0000,2850.0000,3249.0000,20120418
"ABB029","SOHO/200",5.0000,4626.5000,5274.2100,20120418
"ABB029","VEC/400",5.0000,3633.7500,4142.4800,20120418