What also has to be determined is:
1. Does each Customer receive a special price on all products? i.e. a "volume
discount" type of customer price structure that applies to ALL products.
CustDiscountLvl 1 - 5%
CustDiscountLvl 2 - 10%
CustDiscountLvl 3 - 15%
2. Is each product price sensitive to the Customer Price level? i.e.
STD. Price 'A' Price 'B' Price 'C' Price
10.00 9.50 9.25 8.75
Or is it a combination of the two? So much to think about, isn't there!
Hope this helps out and gets you thinking in the right direction.
Director, Technical Services
Canadian Digital Photo/Graphics Inc.
> . I've been trying to customize the Invoice template, and I want to
> . auto-insert unit pricing per item based on customer
> . example :
> . Customer Product normal price special Price
> . A 0333 20 10
> . B 0333 20 11
> . C 0333 20 12
> . d 0333 20 13
> . Each customer has a different price.
> . Product must have a unique code to track the inventory system.
> . Is it possible ?????
> . I use Mac and File maker 4.0
> I suggest that you need an additional file: "SPECIAL PRICES". Each record
> in this file would contain a relation to a product by product number, and
> a relation to a customer by customer number/ID/whatever.
> These relations let you examine all of the special prices for a product
> from the product information record, and all of the special prices for a
> customer from the customer record. This is useful, but doesn't yet solve
> your problem.
> This record should also contain a stored, calculated field that composites
> the customerID and product ID in a standardized manner. (Using your
> example data above, you might have something like "0333B").
> Then you can always find a customer's "special" price (if applicable) by
> attempting to relate from anywhere to this field. To determine if the
> price exists, use count(the relation) -- the result should be 0 or 1. If
> it is more than one, (IE, duplicate "special prices", it is an error
> This solves your problem.
> Kirk and Diane Kerekes/Red Gate Ranch
> X-Face by "Saving Face" <http://www.santafe.edu/~smfr/utils.html>