Difference between revisions of "Information Systems:Auditors - Sales Comparison"
Jump to navigation
Jump to search
(Created page with "Go to InfoNet / Finance / Summarize/Extract G/L Transactions. Run this for the last sales order picking day of the last three fiscal years. File:audit-19.jpg This range...") |
m |
||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
Run this for the last sales order picking day of the last three fiscal years. |
Run this for the last sales order picking day of the last three fiscal years. |
||
| − | [[File: |
+ | [[File: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. |
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. |
||
| − | [[File: |
+ | [[File:Audit-20.jpg]] |
Click on 'Summary to Excel' for each of these, then consolidate into one spreadsheet. |
Click on 'Summary to Excel' for each of these, then consolidate into one spreadsheet. |
||
Latest revision as of 10:09, 15 July 2016
Go to InfoNet / Finance / Summarize/Extract G/L Transactions.
Run this for the last sales order picking day of the last three fiscal years.
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.
Click on 'Summary to Excel' for each of these, then consolidate into one spreadsheet.