I am trying to analyze how we are discounting in a given month. How do I query in the database for the following?
I would also like to see the above broken down by supplier.
I only use Regular Price and Sale Price.
Sammm,
There are a couple of discount reports available in the Reports Library, but they do not do what you are asking, they just provide a Total Discount. In order to the information you are looking for you are going to have to customize one of the reports. If SQL and coding make you nervous, maybe someone has already created this type of report and is willing to share it with you, otherwise I would suggest contacting your MS RMS Partner and see if they can produce the results you are looking for. If that is not an option, many other RMS Partners are more than willing to help you, for a fee of course. Usually it costs between $100 to $150 for a report or some bill by the hour.
If you have access to the CustomerSource website, you can download the two reports from the l> I am trying to analyze how we are discounting in a given month. How do I
Have something to add? Share your thoughts — no account required.
Ask the community — no account required