Information Systems:Auditors - Purchase Order Receiving - Revision history

Norwinu at 17:10, 15 July 2016

2016-07-15T17:10:16Z

New page

Go to InfoNet / Inventory / Item Transaction Detail.

You can extract all purchase orders received on the last day of the old year, and the first day of the new year, then manually select the last and first five.

[[File:Audit-15.jpg]]

In this example, because January 31 was a Saturday, and February 1 was a Sunday, the dates used were January 30 to February 2.

[[File:Audit-16.jpg]]

You can see that there were enough transactions selected. Click on 'Detail to Excel'. Sort by date and time to identify the last and first 5 purchase orders. Then sort on order number, and delete all transactions not for those 10.

Then you need the G/L transactions for each of these. Go to InfoNet / Finance / Summarise/Extract G/L Transactions.

[[File:Audit-17.jpg]]

For each of the 10 purchase orders, key in the order number, accounting period, and document date from the item transaction. Use the accounting period and date to restrict the extracted transactions; the same PO can be received on multiple shipments on multiple days.

[[File:Audit-18.jpg]]

This should agree with the extracted item transactions. Click on 'search', then 'Detail to Excel'. Consolidate all the downloads into one spreadsheet.

Sheilav at 23:04, 1 February 2016

2016-02-01T23:04:19Z

Sheilav: Created page with "Go to InfoNet / Inventory / Item Transaction Detail. You can extract all purchase orders received on the last day of the old year, and the first day of the new year, then man..."

2016-02-01T22:31:39Z

Created page with "Go to InfoNet / Inventory / Item Transaction Detail. You can extract all purchase orders received on the last day of the old year, and the first day of the new year, then man..."

New page

← Older revision		Revision as of 23:04, 1 February 2016
Line 12:		Line 12:

	Then you need the G/L transactions for each of these. Go to InfoNet / Finance / Summarise/Extract G/L Transactions.		Then you need the G/L transactions for each of these. Go to InfoNet / Finance / Summarise/Extract G/L Transactions.
		+
		+	[[File:audit-17.jpg]]
		+
		+	For each of the 10 purchase orders, key in the order number, accounting period, and document date from the item transaction. Use the accounting period and date to restrict the extracted transactions; the same PO can be received on multiple shipments on multiple days.
		+
		+	[[File:audit-18.jpg]]
		+
		+	This should agree with the extracted item transactions. Click on 'search', then 'Detail to Excel'. Consolidate all the downloads into one spreadsheet.