Anyone have these reports?

Hi Gaz - I don't have them in reports, but oddly I was working on these scenarios for testing purposes using sql queries, maybe you can use these until someone posts the qrp files you need...the second query may not be what you are looking for , I'm setting it up as an average transaction by register (with and without customers assigned to the transaction)

select department.name AS DEPARTMENT, sum(transactionentry.quantity) AS TOTAL_QTY_SOLD, sum(transactionentry.quantity*transactionentry.price) as REVENUE from transactionentry left join [transaction] on transactionentry.transactionnumber [transaction].transactionnumber left join item on transactionentry.itemid = item.id left join department on department.id = item.departmentid where [transaction].time between '12/01/2007' and '12/05/2007' group by department.name

-- date after "and" will not be included in calculations --

select register.descripti> Value and quantity of Items purchased by supplier over a defined period and

Thanks convoluted

I actually wanted the average sale per tranascti> Hi Gaz - I don't have them in reports, but oddly I was working on these

Hi Gaz,

Retail Analytics for Microsoft RMS is designed to help retailers manage their business by delivering analytical reporting on business performance. Easily identify trends, buying patterns, seasonality, and other key performance indicators for your business.

If you enter it in RMS you can report on it in Retail Analytics.

If you would like to take a look at it -

Please let me know if you have any questions or if there is anything that we can do for you.

Thanks,

Jen Bridgeford Professional Advantage

701 235 2363 ext 248

"Gaz" wrote:

Hi Gaz,

That is strange as I just tried it and it worked.

If you want to give me a call, please feel free - 701 235 2363 ext 248

Thanks,

Jen

"Gaz" wrote: