Information Systems:Auditors - Inventory - Revision history

Norwinu at 17:57, 13 July 2016

2016-07-13T17:57:55Z

New page

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.

[[File: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.

[[File: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'.

Sheilav at 21:35, 1 February 2016

2016-02-01T21:35:30Z

Sheilav at 21:35, 1 February 2016

2016-02-01T21:35:14Z

Sheilav at 21:34, 1 February 2016

2016-02-01T21:34:21Z

Sheilav at 21:21, 1 February 2016

2016-02-01T21:21:39Z

Sheilav at 19:56, 28 January 2016

2016-01-28T19:56:20Z

Sheilav at 23:55, 27 January 2016

2016-01-27T23:55:05Z

Sheilav at 23:54, 27 January 2016

2016-01-27T23:54:08Z

Sheilav at 23:52, 27 January 2016

2016-01-27T23:52:58Z

Sheilav at 23:08, 27 January 2016

2016-01-27T23:08:48Z

@@ Line 5: / Line 5: @@
 [[File: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 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.
+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-14.jpg]]

@@ Line 5: / Line 5: @@
 [[File: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 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.
+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.
 [[File:audit-14.jpg]]

@@ Line 1: / Line 1: @@
-Go to InfoNet / Inventory / Stock Status.
+Go to InfoNet / Inventory / Year End Inventory.
-Item balances can be calculated for any date 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-8.jpg]]

@@ Line 1: / Line 1: @@
-Go to InfoNet / Inventory / Summarize/Extract Item Transactions.
+Go to InfoNet / Inventory / Stock Status.
-Item balances can be calculated for any period by summarizing all transactions up to that point.
+Item balances can be calculated for any date by summarizing all transactions up to that point.
 The total 'Amount' should agree with the G/L.

← Older revision		Revision as of 23:55, 27 January 2016
Line 5:		Line 5:
	[[File:audit-6.jpg]]		[[File:audit-6.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. Be warned that this could take a long time; long enough to give you an [[Websmart Internal Server Error\| Internal Server Error]].	+	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]].

@@ Line 5: / Line 5: @@
 [[File:audit-8.jpg]]
  -------------------------------------------------------------------------------
- Rec.    Bal.per/amount 1512     11186556.15  CAD    Total sel.
+ Rec.    Bal.per/amount 1612     11634422.49  CAD    Total sel.
  -------------------------------------------------------------------------------
    Main   Grou Subg Cost Pro             Vou  no Vou dt Vt  System Amount   Per
@@ Line 20: / Line 22: @@
 8400043 040208 84         916.74-  0903
- *VA/480B*  G/L transaction enquiry                   1/27/16 14:47:50 FMR01702
+ *VA/480B*  G/L transaction enquiry                   2/01/16 14:47:50 FMR01702
  -------------------------------------------------------------------------------
- Rec.    Bal.per/amount 1512       492763.00  CAD    Total sel.
+ Rec.    Bal.per/amount 1612       560829.87  CAD    Total sel.
  -------------------------------------------------------------------------------
    Main   Grou Subg Cost Pro             Vou  no Vou dt Vt  System Amount   Per
@@ Line 31: / Line 33: @@
 8500042 040208 85        7161.44   0903

← Older revision		Revision as of 23:54, 27 January 2016
Line 5:		Line 5:
	[[File:audit-6.jpg]]		[[File:audit-6.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. Be warned that this could take	+	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]].

@@ Line 3: / Line 3: @@
 Item balances can be calculated for any period by summarizing all transactions up to that point.
-[[File:audit-7.jpg]]
+[[File:audit-6.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. Be warned that this could take
 The total 'Amount' should agree with the G/L.