Skip to Content
0
Former Member
Sep 24, 2009 at 07:47 AM

Report on changes to sales orders

31 Views

Hi Experts,

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.

Best Regards

Matthew