RMS Store Ops 2.0- Points balance SQL trigger

Nov 16, 2007 0 Replies

Hi, is anyone using the Purchase Limits feature in Store Ops 2.0? We'd like to allocate points to various items and then set limits on what employees can purchase in a month. For various reasons, when it comes to purchase limits we're going for points as opposed to item value. Anyway, setting up the Purchase Limits with points is the easy part. The hard part is to keep track of the points balance. There's nothing within the Customer Properties for this, but I'm wondering if someone has an idea on how to utilise one of the other useless fields, possibly with an SQL trigger. I'm no SQL genius and could do with some help! Thanks!


Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required