AnsweredAssumed Answered

Customer specific price list

Question asked by duncanbaker on Jan 18, 2014
Latest reply on Jan 18, 2014 by duncanbaker

It might just be too early on the weekend for my brain to have kicked in, so wanted to check on something. It's nothing too complex:

 

Customers table:

Name

Discount (% off the standard prices)

Surcharge (an additional cost per item, if they are located far away)

 

Products table:

Name

Standard price

Customer price (standard price less discount + surcharge)

 

Looking at the Customer layout, I want a portal showing products with that customer's prices. I have something working utilizing a global field in the product table that is set to the customer ID, which is used in the relationship. But, I think I'll need to set this via a script all the time. Wondering if there's a smarter way of achieving this?

 

Thanks

Outcomes