Information Systems:Auditors - Inventory
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.
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 once 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.
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'.