Solved

# Prices from product list change with different customer

Posted on 2005-04-12
Medium Priority
274 Views
I have four Tables, Clients, Inventory, Invoice, OrderItems. Using a portal for line items in the Invoice. All items in the inventory have different prices for two special clients. A single discount formula won't work because there are too many variables. The problem is: How can I choose from two different price lists in the portal located on the invoice?
thanks, Mike
0
Question by:mlharding
• 3
• 2
• 2

LVL 19

Accepted Solution

billmercer earned 136 total points
ID: 13777548
Create a calculated field that displays the appropriate price based on who the client is, and use this field wherever you'd use the price.
something like this:

Case(  Client = "Special1",  SpecialPrice1,
Client = "Special2",  SpecialPrice2,
DefaultPrice )

0

LVL 28

Assisted Solution

lesouef earned 132 total points
ID: 13777557
you could create a rebate % in the client table.
then get the price = pricelist:price * client::rebate
this is valid only if the rebate is the same for a given client. If it varies, then you should have 2 prices/item, and have a flag in the clients table which says which "colomn" should be applied
0

LVL 1

Assisted Solution

criss_mce earned 132 total points
ID: 13783649
We had the same type of problem.
We fixed it by haveing a field in our customer DB called CustomerMarkupPercent or something along that line.
we would select the regular markup for most customers but for special ones they would get more or less.

then in our invoices DB. the calculation would reference that field via Relationship and calculate customer cost.
works like a charm. And its super easy to change in the future.

0

LVL 19

Expert Comment

ID: 13786620
mlharding, you mentioned that a simple discount formula wouldn't work. If your pricing differences for the special clients are completely arbitrary, then storing alternate prices per item is really your only option. However, if the issue is just that there are multiple or complex formulae, here's a neat solution you could use to work around this IF you have FileMaker 7.

For each customer, add a Formula field to contain the formula for your price modification. Give each item a base price. Then use the Evaluate() function to compute the actual price for that customer and that item. The advantage is that the formula can be edited by an end user, without having to edit scripts or field definitions. You can even make a value list with a variety of commonly used discounts.
The formula can be a simple percentage, or something quite complex with multiple pricing levels or date ranges, etc.
0

LVL 28

Expert Comment

ID: 14228562
share > all 3
0

LVL 19

Expert Comment

ID: 14344453
OK by me
0

LVL 1

Expert Comment

ID: 14348591
yep im happy
0

## Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.