Information Systems:Auditors - Sales Comparison

From uniWIKI
Revision as of 10:09, 15 July 2016 by Norwinu (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Go to InfoNet / Finance / Summarize/Extract G/L Transactions.

Run this for the last sales order picking day of the last three fiscal years.

Audit-19.jpg

This range of main account numbers may give you a couple of extra. But it is easier to delete a line or two than to run extra searches.

Audit-20.jpg

Click on 'Summary to Excel' for each of these, then consolidate into one spreadsheet.