Information Systems:Auditors - Sales Order Shipping - Revision history

Norwinu at 17:09, 15 July 2016

2016-07-15T17:09:43Z

New page

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.

[[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.

[[File:Audit-10.jpg]]

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?

[[File:Audit-11.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.

Sheilav at 21:59, 28 January 2016

2016-01-28T21:59:15Z

Sheilav at 21:13, 28 January 2016

2016-01-28T21:13:40Z

Sheilav at 21:11, 28 January 2016

2016-01-28T21:11:20Z

Sheilav at 21:10, 28 January 2016

2016-01-28T21:10:51Z

Sheilav: 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...."

2016-01-28T21:06:02Z

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...."

New page

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.

[[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.

[[File:audit-10.jpg]]

You can see that there were enough transactions selected. Click on 'Detail to Excel'. Sort by 'time' to find about 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 this is invoiced separately, does it matter?

[[File:audit-11.jpg]]

← Older revision		Revision as of 21:59, 28 January 2016
Line 14:		Line 14:

	[[File:audit-11.jpg]]		[[File:audit-11.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.

← Older revision		Revision as of 21:11, 28 January 2016
Line 10:		Line 10:


−	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 ~~this~~ is invoiced separately, does it matter?	+	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?

	[[File:audit-11.jpg]]		[[File:audit-11.jpg]]

← Older revision		Revision as of 21:13, 28 January 2016
Line 11:		Line 11:

	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?		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?
		+

	[[File:audit-11.jpg]]		[[File:audit-11.jpg]]

@@ Line 9: / Line 9: @@
 [[File:audit-10.jpg]]
-You can see that there were enough transactions selected.  Click on 'Detail to Excel'. Sort by 'time' to find about 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 this is invoiced separately, does it matter?
+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 this is invoiced separately, does it matter?
 [[File:audit-11.jpg]]