Difference between revisions of "Information Systems:Auditors - Inventory"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | Go to InfoNet / Inventory / |
+ | Go to InfoNet / Inventory / Stock Status. |
| − | Item balances can be calculated for any |
+ | Item balances can be calculated for any date by summarizing all transactions up to that point. |
| − | |||
| ⚫ | |||
| − | |||
| − | 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. Be warned that this could take a long time; long enough to give you an [[Websmart Internal Server Error|Internal Server Error]]. |
||
| ⚫ | |||
| + | Key in the year end date, warehouse (run MAI and RET separately), and do not include zeros. Click on the search button. Then click on 'Export to Excel'. Be warned that this could take a long time; around 10 minutes. |
||
The total 'Amount' should agree with the G/L. |
The total 'Amount' should agree with the G/L. |
||
Revision as of 12:56, 28 January 2016
Go to InfoNet / Inventory / Stock Status.
Item balances can be calculated for any date by summarizing all transactions up to that point.
Key in the year end date, warehouse (run MAI and RET separately), and do not include zeros. Click on the search button. Then click on 'Export to Excel'. Be warned that this could take a long time; around 10 minutes.
The total 'Amount' should agree with the G/L.
*VA/480B* G/L transaction enquiry 1/27/16 14:47:18 FMR01702 ------------------------------------------------------------------------------- Rec. Bal.per/amount 1512 11186556.15 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 1/27/16 14:47:50 FMR01702 ------------------------------------------------------------------------------- Rec. Bal.per/amount 1512 492763.00 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
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!