I am looking for a way to report on changes to sales orders, specifically the row shipping date and quantity.
I can see that the data is apparently in tables ADOC and ADO1 but am having trouble getting useful results. What I need is a report that, for sales orders only and for a date range, shows all changes to row quantities or row shipping dates. The type of output that would be useful is:
Change date - document # - row# - Item code - old shipping date - new shipping date - old qty - new qty
filtered on change date for sales orders only. This seems beyond my preferred option of XL-Reporter and I'm getting lost in the history tables in creating a query.