Portal | Homepage | Blog

How do I generate a report in RMS for discounts given to customers?


#1

I need to know how to generate a report in RMS that will show discounts given to customer over a quarterly and annually basis. How do I generate a report in RMS for discounts given to customers?


#2

After searching online I was able to find a query that I altered a bit due to an error.

select sum((fullprice - price)quantity) from [transactionentry] where quantity >0 and TransactionNumber > '********’

Where it shows ********* I put in the first transaction of the first day and it calculated the full price minus the price sold.


#3

select sum((fullprice - price)quantity) from [transactionentry] where quantity >0 and transactionnumber >= ‘********’ and transactionnumber <= '******’

Listed above gives me the exact dating. The earlier one gives me up to today. Remember ***** are the actual transaction numbers.