Difference between revisions of "Information Systems:Auditors - Sales Order Shipping"
(Created page with "Go to InfoNet / Inventory / Item Transaction Detail. You can extract all sales orders picked on the last day of the year, then manually select the ones with the latest time....") |
m |
||
| (5 intermediate revisions by one other user not shown) | |||
| Line 3: | Line 3: | ||
You can extract all sales orders picked on the last day of the year, then manually select the ones with the latest time. |
You can extract all sales orders picked on the last day of the year, then manually select the ones with the latest time. |
||
| − | [[File: |
+ | [[File:Audit-9.jpg]] |
In this example, because the last day of the fiscal year was a Saturday (the warehouse is not open), include the previous day as well. Select event code 'SO', and the main warehouse. Summarize by pick list and sales order, then click on search. |
In this example, because the last day of the fiscal year was a Saturday (the warehouse is not open), include the previous day as well. Select event code 'SO', and the main warehouse. Summarize by pick list and sales order, then click on search. |
||
| − | [[File: |
+ | [[File:Audit-10.jpg]] |
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| + | |||
| + | |||
| ⚫ | |||
| + | |||
| + | |||
| + | To get the first 10 invoices of the new year, use the same process, except extract item transactions for the first working day of the year, and find the picks lists on the spreadsheet with the earliest times. |
||
Latest revision as of 10:09, 15 July 2016
Go to InfoNet / Inventory / Item Transaction Detail.
You can extract all sales orders picked on the last day of the year, then manually select the ones with the latest time.
In this example, because the last day of the fiscal year was a Saturday (the warehouse is not open), include the previous day as well. Select event code 'SO', and the main warehouse. Summarize by pick list and sales order, then click on search.
You can see that there were enough transactions selected. Click on 'Detail to Excel'. Sort by 'time' to find the last 10 pick lists of the year. The same order can be listed here more than once, as it could have multiple pick lists. But as each of them is invoiced separately, does it matter?
To get the first 10 invoices of the new year, use the same process, except extract item transactions for the first working day of the year, and find the picks lists on the spreadsheet with the earliest times.