Additionally...
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.
Lyle Chamney
Director, Technical Services
Canadian Digital Photo/Graphics Inc.
www.advics.com
> . 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
> condition.
> This solves your problem.
> --
> Kirk and Diane Kerekes/Red Gate Ranch
> X-Face by "Saving Face" <http://www.santafe.edu/~smfr/utils.html>
by