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
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
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
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.