We have a client with the following pricing
A base price list with volume pricing for all items
Pricing contracts for pricing by customer
Pricing contracts for a group of customers.
All customers are basically on the base pricelist with volume pricing but occassionally contracts are creates for specific customers for specific items. If the customer is part of a group contract then when one customer is in teh group buys the item for the firist time, it locks in the price as a fixed price for the entire group (all customers in the group get that price from then on).
I thought about different pricelists for each contract but then if they add a new item they have to set the price for every pricelist in every contract and that slows things down incredibly (200 contracts/groups). I thought about pricing by customer but then there needs to be way to update the price by customer for each customer in the group.
There is also issue that they need to record custom costs as well since they have billback to to vendors. they have special costs when they sell items to specific customers that they bill the vendor for difference between cost item came into inventory at and special cost if they sell the item to the customer on that contract.
Has anyone done anything like this?
Right now I am looking at group price lists and programming a SQL server script to run periodically to distribute group price changes to customers (special prices by business partner) in the group by UDF.on the customer record to store the pricing group. It would be nice if there was a better way.