Items sold based on date and supplier


B

Brent

I am wanting to get a report or create a query that shows items sold based
on Suppliers and Date (from x to y).

What tables are involved and how are they joined?

Any canned reports created to do this?
thanks
brent
 
N

Nashat

find below a query to get sales by supplier
*******************************
select Suppliername,Itemlookupcode,description,sum(te.quantity*te.price) as
Sales
from item left join supplier on item.supplierid=supplier.id
left join transactionentry te on item.id=te.itemid
inner join [transaction] tr on tr.transactionnumber=te.transactionnumber
where time between '2007-01-01 00:00:00' and '2007-02-01 00:00:00'
and supplier.code='xx'
group by Suppliername,Itemlookupcode,description
order by Suppliername,Itemlookupcode,description
*******************************
please note that this query show u sales for the primary supplier only
 
Ad

Advertisements

C

Craig

Nashat,
Would you have a query to see sales by customer within a specific time
frame?
Craig

Nashat said:
find below a query to get sales by supplier
*******************************
select Suppliername,Itemlookupcode,description,sum(te.quantity*te.price)
as Sales
from item left join supplier on item.supplierid=supplier.id
left join transactionentry te on item.id=te.itemid
inner join [transaction] tr on tr.transactionnumber=te.transactionnumber
where time between '2007-01-01 00:00:00' and '2007-02-01 00:00:00'
and supplier.code='xx'
group by Suppliername,Itemlookupcode,description
order by Suppliername,Itemlookupcode,description
*******************************
please note that this query show u sales for the primary supplier only

Brent said:
I am wanting to get a report or create a query that shows items sold based
on Suppliers and Date (from x to y).

What tables are involved and how are they joined?

Any canned reports created to do this?
thanks
brent
 

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