I hope this community can help us...
What is the best practices in uploading prices? We have ~30k customers and ~30k items and quantity break or column pricing for each item: e.g. Item12345 Qty 1 List price $100, Qty 5 List price $90, Qty 10 List price $80, Qty 20 List price $70, etc.
We have hundreds of different trade agreements and we would like to use our NAV ERP correctly to change prices. Is there a pricing module for NAV?
Thank you very much for your insights into this! Currently we have to upload .txt files...
Current pain points
§Manual price files maintenance & cumbersome inefficient Excel spreadsheet/txt uploads into NAV
1.items in a trade agreement = Price Assignment table in NAV
2.Specific item prices for all quantity breaks = Specific Item Prices table in NAV
3.Customers belonging to a trade agreement = Sales Type Assignment table in NAV
§Manual upload process prone to errors.
§Uploading prices with (negative or) low margins
§Discounting done in trade agreements, not correlated to list prices.
§Having to potentially upload millions of rows in some major trade agreements is slowing us down for up-to-date price setting (monthly or only quarterly adjustments possible only to add, change price of items, add or remove (about 5x per year and year-end) customers from a trade agreement).
§Use of a pricing server for millions of records after hours not to slow down NAV production
§History of a custom-developed NAV pricing system “on-the-fly within 2 weeks” prior to NAV implementation
§Quantity breaks pricing
Ideal or Best practices in pricing system – wish list, needed features etc.
ØOne system of record. Do all pricing in NAV. Limited excel uploads
ØWorkflow and approval process in pricing system
ØNeed list prices, discounts, customer pricing, gross to net analysis, mass maintenance capabilities, freight?
ØWe need to incorporate quantity breaks
ØAutomatic calculation of prices based on business rules, e.g. formula calculations such as minimum margin %, discount off list, customer segmented pricing based on a variety of factors
ØCreate a command and control center for all of our pricing-related information:
ØBecome smarter about how/when/why we price the way we do
ØCreate price-setting logic that makes sense to our bottom line and customers!
ØCapture customers’ willingnesses-to-pay, price-to-win and don’t leave money on the table
ØSpeed and agility to quickly change multiple price points based on above criteria & rules
ØWish list:
Øcommodity pricing (pass on material cost increases, e.g. aluminum +10%, paper, ink) eventually sales cost as commission floor?
Øprice optimization (ceilings, target, floor)
Øprice elasticity calculations
-List prices view
-competitor prices shown next to list price, margin, margin %
-Highlight variations in margin % traffic light colors
-Discounts by customer or material with ability to set target margins at material groups
-Change effective dates
-Ability to define rules and formulas in pricing system as in Excel-like format
-% change, add margin $
-Gross-To-Net from list to Customer discounts, (Sales Cost), Invoice Price, Additional Rebates, Volume Rebates
-By material, material group, department DIM
-By customer segment, industry, channel
-By commodity (aluminum cost increase of +10%)
-What percentage of commodity goes into cost of finished good?
-By vendor
-Sales Cost = cost + freight + upcharges (if we need commission base)
-Built-in approval process from Sales reviews to pricing reviews with routing back comments to approvers
