Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need to create a report of Items sold= last sale date report

Hi Guys,

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?

Regards

replied

Hi Joe

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

WHERE ????

GROUP BY T0.ItemCode

Kind regards

Peter Juby

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question