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:
Discount (% off the standard prices)
Surcharge (an additional cost per item, if they are located far away)
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?