Need to create a report of Items sold= last sale date report
There is an column of last sale date in OITM but that doesnt gives any data when you run a query. Basicaly client need to generate a report of Items with last sale date, is this possible SAP Business One?
Yes it is possible if you use GROUP BY in a query with MAX(T0.DocDate).
An example would be:
SELECT T0.ItemCode, MAX(T0.DocDate) AS 'Last Sale Date', SUM(T0.LineTotal)
FROM INV1 T0
GROUP BY T0.ItemCode