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
Items sold based on date and supplier
Feb 14, 2007
2 Replies
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 onlyNashat, Would you have a query to see sales by customer within a specific time frame? Craig
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required