AnsweredAssumed Answered

Formula for Discount Bonus Points?

Question asked by petropix on Sep 17, 2013
Latest reply on Sep 29, 2013 by petropix



I'm working in FM-Pro 12 Starter Solution: INVOICES.


I need to assign a field that will allocate a discount based on a customer's repeated purchases (loyalty points). The Discount happens on the 5th, 10th and 15th purchase -- 10%, 20% and 30% respectively.

Old customers (archived on file cards and about to enter the database are at various levels 1-15-- I have created a field indicating the respective level in the Customer table). New customers will start at purchase #1. After the 15th purchase, the cycle begins again.


How might I formulate such a discount set-up?


Thank you.