Anyone have these reports?


G

Gaz

Value and quantity of Items purchased by supplier over a defined period and
by department or category
Average spend per customer per register
 
Ad

Advertisements

C

convoluted

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.description, avg([transaction].total) as AVG_TRANSACTION
from [transaction]
inner join batch on [transaction].batchnumber = batch.batchnumber
inner join register on batch.registerid = register.id
where [transaction].time between '12/01/2007' and '12/05/2007'
group by register.description
 
G

Gaz

Thanks convoluted

I actually wanted the average sale per tranasction and not per customer,
sometimes forget to use the Americanised versions of everything! :)

convoluted said:
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.description, avg([transaction].total) as AVG_TRANSACTION
from [transaction]
inner join batch on [transaction].batchnumber = batch.batchnumber
inner join register on batch.registerid = register.id
where [transaction].time between '12/01/2007' and '12/05/2007'
group by register.description

Gaz said:
Value and quantity of Items purchased by supplier over a defined period and
by department or category
Average spend per customer per register
 
J

Jen Losch

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 -
http://www.profad.com/files/RAMP Movie/RADemoProfessionalAdvantage.wmv

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 said:
Thanks convoluted

I actually wanted the average sale per tranasction and not per customer,
sometimes forget to use the Americanised versions of everything! :)

convoluted said:
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.description, avg([transaction].total) as AVG_TRANSACTION
from [transaction]
inner join batch on [transaction].batchnumber = batch.batchnumber
inner join register on batch.registerid = register.id
where [transaction].time between '12/01/2007' and '12/05/2007'
group by register.description

Gaz said:
Value and quantity of Items purchased by supplier over a defined period and
by department or category
Average spend per customer per register
 
G

Gaz

Jen the link is not working, nor can you access it from your website

Jen Losch said:
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 -
http://www.profad.com/files/RAMP Movie/RADemoProfessionalAdvantage.wmv

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 said:
Thanks convoluted

I actually wanted the average sale per tranasction and not per customer,
sometimes forget to use the Americanised versions of everything! :)

convoluted said:
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.description, avg([transaction].total) as AVG_TRANSACTION
from [transaction]
inner join batch on [transaction].batchnumber = batch.batchnumber
inner join register on batch.registerid = register.id
where [transaction].time between '12/01/2007' and '12/05/2007'
group by register.description

:

Value and quantity of Items purchased by supplier over a defined period and
by department or category
Average spend per customer per register
 
Ad

Advertisements

J

Jen Losch

Hi Gaz,

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

http://www.profad.com/files/RAMP Movie/RADemoProfessionalAdvantage.wmv

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

Thanks,

Jen

Gaz said:
Jen the link is not working, nor can you access it from your website

Jen Losch said:
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 -
http://www.profad.com/files/RAMP Movie/RADemoProfessionalAdvantage.wmv

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 said:
Thanks convoluted

I actually wanted the average sale per tranasction and not per customer,
sometimes forget to use the Americanised versions of everything! :)

:

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.description, avg([transaction].total) as AVG_TRANSACTION
from [transaction]
inner join batch on [transaction].batchnumber = batch.batchnumber
inner join register on batch.registerid = register.id
where [transaction].time between '12/01/2007' and '12/05/2007'
group by register.description

:

Value and quantity of Items purchased by supplier over a defined period and
by department or category
Average spend per customer per register
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top