Difference between revisions of "Information Systems:Auditors - Inventory"

From uniWIKI
Jump to navigation Jump to search
(Created page with "Go to InfoNet / Inventory / Summarize/Extract Item Transactions. Item balances can be calculated for any period by summarizing all transactions up to that point. File:aud...")
 
m
 
(11 intermediate revisions by one other user not shown)
Line 1: Line 1:
−
Go to InfoNet / Inventory / Summarize/Extract Item Transactions.
 +
Go to InfoNet / Inventory / Year End Inventory.
   
−
Item balances can be calculated for any period by summarizing all transactions up to that point.
+
Item balances can be calculated for any calendar or fiscal year end, using files that are saved by the End of Month processing for December and January.
   
−
[[File:audit-6.jpg]]
 +
[[File:Audit-8.jpg]]
   
−
Key in a starting fiscal period that is older than any inventory transaction, and for ending period, the period for which you want the balance. Summarize by warehouse and item. Click on the search button.
+
The 'file' drop down box will display any calendar and fiscal year end files we have; as well as the current one. Click on the one for the fiscal year that has just closed. Summarize by warehouse, and make sure 'exclude zero quantities' is yes - otherwise a record will be written for all items for all warehouses in the warehouse/item file (SROSRO); active or not. Click on the search button.
   
−
[[File:audit-7.jpg]]
 +
[[File:Audit-14.jpg]]
   
−
The total 'Amount' should agree with the G/L.
+
If all the year end adjustments have been made, the total 'Amount' should agree with the G/L. This example doesn't, so adjustments will have to made to the G/L.
   
  +
*VA/480B* G/L transaction enquiry 2/01/16 14:47:18 FMR01702
  +
-------------------------------------------------------------------------------
  +
Rec. Bal.per/amount 1612 11634422.49 CAD Total sel.
  +
-------------------------------------------------------------------------------
  +
Main Grou Subg Cost Pro Vou no Vou dt Vt System Amount Per
  +
130000 8000060 040208 80 589546.75- 0903
  +
130000 8200042 040208 82 106.37- 0903
  +
130000 8200042 040208 82 999529.33 0903
  +
130000 8300041 040208 83 225.30- 0903
  +
130000 8400043 040208 84 916.74- 0903
   
  +
*VA/480B* G/L transaction enquiry 2/01/16 14:47:50 FMR01702
  +
-------------------------------------------------------------------------------
  +
Rec. Bal.per/amount 1612 560829.87 CAD Total sel.
  +
-------------------------------------------------------------------------------
  +
Main Grou Subg Cost Pro Vou no Vou dt Vt System Amount Per
  +
135000 8000060 040208 80 4493.87 0903
  +
135000 8400043 040208 84 11987.52- 0903
  +
135000 8400043 040208 84 282.68 0903
  +
135000 8500042 040208 85 538.74- 0903
  +
135000 8500042 040208 85 7161.44 0903
   
  +
Click on 'Detail to Excel'.
−  
−
If it doesn't, an adjustment will have to made to the G/L.
  
−  
−
Click on 'Summary to Excel' - be careful NOT to click on 'Detail to Excel'; as of January 2016 that would be almost 27 million records!
  

Latest revision as of 10:57, 13 July 2016

Go to InfoNet / Inventory / Year End Inventory.

Item balances can be calculated for any calendar or fiscal year end, using files that are saved by the End of Month processing for December and January.

Audit-8.jpg

The 'file' drop down box will display any calendar and fiscal year end files we have; as well as the current one. Click on the one for the fiscal year that has just closed. Summarize by warehouse, and make sure 'exclude zero quantities' is yes - otherwise a record will be written for all items for all warehouses in the warehouse/item file (SROSRO); active or not. Click on the search button.

Audit-14.jpg

If all the year end adjustments have been made, the total 'Amount' should agree with the G/L. This example doesn't, so adjustments will have to made to the G/L. 

*VA/480B*  G/L transaction enquiry                   2/01/16 14:47:18 FMR01702 
-------------------------------------------------------------------------------
Rec.    Bal.per/amount 1612     11634422.49  CAD    Total sel.                 
-------------------------------------------------------------------------------
  Main   Grou Subg Cost Pro             Vou  no Vou dt Vt  System Amount   Per 
  130000                                8000060 040208 80      589546.75-  0903
  130000                                8200042 040208 82         106.37-  0903
  130000                                8200042 040208 82      999529.33   0903
  130000                                8300041 040208 83         225.30-  0903
  130000                                8400043 040208 84         916.74-  0903

*VA/480B*  G/L transaction enquiry                   2/01/16 14:47:50 FMR01702 
-------------------------------------------------------------------------------
Rec.    Bal.per/amount 1612       560829.87  CAD    Total sel.                 
-------------------------------------------------------------------------------
  Main   Grou Subg Cost Pro             Vou  no Vou dt Vt  System Amount   Per 
  135000                                8000060 040208 80        4493.87   0903
  135000                                8400043 040208 84       11987.52-  0903
  135000                                8400043 040208 84         282.68   0903
  135000                                8500042 040208 85         538.74-  0903
  135000                                8500042 040208 85        7161.44   0903

Click on 'Detail to Excel'.

Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Auditors_-_Inventory&oldid=4147"