Skip to Content
0
Former Member
Jun 02, 2008 at 01:11 PM

total sales to date per item

38 Views

Hello folks i need some help with SQL code i think. I need to get a report showing our best selling items, but the sales analysis is only showing recent stock (even if i specify 01.01.07 - 02.06.08).

in theory this is a simple report. i just need ItemCode, ItemName and Total Sales.

What is the table that contains total sales?