Difference between revisions of "Information Systems:Auditors - Purchase Order Receiving"
m |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
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. |
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: |
+ | [[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. |
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: |
+ | [[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. |
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. |
||
| Line 13: | Line 13: | ||
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: |
+ | [[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. |
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: |
+ | [[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. |
This should agree with the extracted item transactions. Click on 'search', then 'Detail to Excel'. Consolidate all the downloads into one spreadsheet. |
||
Latest revision as of 10:10, 15 July 2016
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.
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.
This should agree with the extracted item transactions. Click on 'search', then 'Detail to Excel'. Consolidate all the downloads into one spreadsheet.