We are a manufacturing company that offers a wide variety of products. Within the parameters of Parts (Inventory Control>Maintain Parts), I can build just about anything I want, as a singular item and then associate pricing levels to that part, based on our customer base and what their respective costs would be. This means the pricing for each part is customer specific and therefore impacted solely by the customer pricing level. 

What I am wanting to do is create variables at the part level.

Currently, when a new order is being written (Order Entry>Maintain Sales Orders), there are parts that each have a pre-determined (by me) pricing level, which is assigned at the customer level. In our case, we have parts that are associated to other parts.

EX: Part A has Parts 1-25 that are associated with it. Each part has a singular price, as dictated by the customer level. But what if I wanted to create variables for Parts 1-25, where each one had 3 (or more) prices, dependent on product type?

Explaining it another way, when a new order is started, the order writer is required to immediately start by choosing the customer, which then dictates the price level. This means that all parts that are selected for that order will be priced (assigned) accordingly. One can always override a pre-determined price but there are no variables other than the customer level pricing ones. I want to have variables within the parts level...

EX: Part 1 (shiny widget) is assigned a pricing level of "retail", "contractor", and "wholesaler" as 3 different price levels. Retail = $20.00. Contractor = $16.00. Wholesaler = $12.00.

But what if part 1 is available in 3 different finishes? And there are 65 different widgets that each have 3 different finishes? I know that a separate part could be created for each option, but this makes the parts list massive, which is what I am trying to avoid. Anyone have any thoughts?

Thanks in advance!