Sage 100

Someone just reached out to me with this pricing hierarchy issue for client on MAS 200 4.5 PU4. I was scratching my head on this too. Quick background: ""Client originally used Customer/Item price overrides for all items sold. No item prices in the system. Each year they would spend weeks entering price increases for each item, each customer. This year I exported the records, for 3500 items, they had over 18k records; ridiculous!!! So, it was decided to implement Price Codes (they coincide with their existing Customer Price Levels), using a discount from Standard Price. "" * There are Price Codes setup in Inventory / Setup. She created the standard record and price level records using Price Discount %. She used same price levels already found in Customer Maint / Additional / Price Level. * There is no customer/item pricing setup from Customer Maint / Items / Pricing * In Item Maint / Pricing there is no item pricing or Customer Price schedule * In Item Maint / Main the Price Code is left intentionally blank. * The new feature Price Level by Customer Maintenance to base pricing off of Product Line is turned off The goal is during S/O Entry when the item and qty ordered are entered, since the customer price level is known at that point and there is a matching price level in Price Code Maint, to grab that price discount % (from Price Code Maint) and apply to the Unit Price on the order line. But what's happening is since the price code in Item Maint is blank, no discount is being taken off the Std Price. If you select a price code in Item Maint, then it applies that discount. But it doesn't care about the customer price level anymore at that point. Any customer gets that price code for that item. Is there a procedural way to this? I s'pose I can use scripts but looking for a standard way first.

@AlnoorCassim The price code has to be in item maint for it to work. If I understand correctly you could have one price code and with all the price levels or many price code that have the price levels and attach the correct price code to the item.

What I meant to say (little too much wine LOL) is I think it sounds like you could have one price code for all items if the % for each price level is the same for each items .

Makes sense! No need to have multiple price codes in this scenario. Just multiple price levels for a single price code and put that in the item. That worked. Thanks @DianeRuth!

Looks like we have a new OASIS member as a result of the teams' response. Way to go!!!!!