discount for a specific customer

I dont think its possible with RMS 2.0

However there is alot of addon that does that thing

Check out the Retail Hero website

Hi there,

What You are looking for it's not standard, but You can make a small add-on or get some RMS partner to do it for You. It is not that complicated at all.

If You need more info, contact me...

Regards, A.

find the customer's sales for the last 3 months with this view:

create view customer_sales as select c.id, sum(e.price*e.quantity) sales from [transaction] t join transactionentry e on t.storeid=e.storeid and t.transactionnumber=e.transactionnumber join customer c on t.customerid=c.id where time>dateadd(mm,-3,getdate()) group by c.id

then update the customer's discount where sales > 200

update c set currentdiscount% from customer_sales s join customer c on s.id=c.id where sales>200

then clean up the view afterwards:

dr> Hi,