Information Systems:Auditors - Purchase Order Receiving

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.

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

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.