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

Former Member
Former Member 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