Inventory Quantity Reconciliation - Revision history

DavidG: Updating procedure

2020-10-14T20:46:30Z

Updating procedure

DavidG: Removed outdated/inaccurate info on Virtual Warehouse

2020-07-09T17:40:29Z

Removed outdated/inaccurate info on Virtual Warehouse

DavidG at 20:12, 17 January 2018

2018-01-17T20:12:19Z

DavidG at 21:56, 16 January 2018

2018-01-16T21:56:07Z

DavidG: Clarifying instructions on advanced import.

2018-01-16T21:55:32Z

Clarifying instructions on advanced import.

DavidG at 14:17, 1 November 2017

2017-11-01T14:17:12Z

DavidG: Incomplete sentence about template report. Typos in 'Note that the inventory template' sentence.

2017-11-01T14:15:52Z

Incomplete sentence about template report. Typos in 'Note that the inventory template' sentence.

Marks at 14:53, 26 July 2017

2017-07-26T14:53:58Z

DavidG at 21:56, 16 May 2017

2017-05-16T21:56:59Z

DavidG at 17:00, 2 November 2016

2016-11-02T17:00:37Z

@@ Line 23: / Line 23: @@
 == Inventory Reconciliation version 8.1 Operation ==
-# Select Utilities>Utilities>Inventory>Inventory Reconciliation and click Run It
+# Select Utilities>Inventory>Inventory Reconciliation and click Run It
 # [[File:Reconcile1.png]]
-# Column descriptions in Inventory Reconciliation (Note: Your columns may be in different order since SME lets you read just your columns and what shows in that reconcile view):
+# Column descriptions in Inventory Reconciliation (Note: Your columns may be in different order):
 ## CountCycle:  This is an inventory field for setting the cycle count frequency.  This likely will be blank if you are not using this info in SME.  In inventory management you would set CountCycle as a number system or just how often the parts should be counted like monthly, quarterly or annually.
 ## Number:  Inventory number

@@ Line 9: / Line 9: @@
 ** This warehouse should NOT be used for inventory reporting
 ** This warehouse SHOULD be used for reporting of adjustments or scrap of inventory
-** Over time your business may adjust parts both positive and negative.  This warehouse will get added stock counts when you decrease regular stock warehouse and decrease if the parts are found again.
+** Over time your business may adjust parts both positive and negative.  This warehouse will get added stock counts when you decrease regular stock warehouse and increase if the parts are found again.
-** If parts are found again, inventory reconciliation can be used to move back into a warehouse.
+** If parts are found again, inventory reconciliation can be used to move from virtual warehouse back into an actual warehouse.
 ** You do not have to worry about inventory stock "disappearing" from inventory tracking and reconciliation since all inventory is tracked in and out.
 ** This warehouse is forced as inactive so that it's not used in standard inventory reports
 ** Note: If you have a custom inventory report it will need to be updated to NOT count this virtual warehouse.
 * Batching
-** Batches will allow inventory to be snapshoted for adjustments over multiple days.  You can create a batch, make adjustments and then come back later and continue to make adjustments for that batch.
+** Batches will allow inventory to be snapshotted for adjustments over multiple days.  You can create a batch, make adjustments and then come back later and continue to make adjustments for that batch.
 *** For example, you may want to run a quarterly inventory reconcile with the following process:
-*** Get the actual physcial count of all or part of your warehouse
+*** Get the actual physical count of all or part of your warehouse
 *** Create a new Batch.  This should be done at the same time as your physical count so that it can take a snapshot of SME inventory at the same time as your physical count.
 *** Make adjustments in inventory reconcile AT ANY TIME.  Thus you can adjust a couple parts today, couple more tomorrow and so on until done.  You do not need to make all the adjustments in SME since you have the physical and batch snapshot at the same time.  Just don't close the batch if you are still making adjustments and just close the batch when all adjustments are made.

@@ Line 90: / Line 90: @@
 ## Optional:  To see the data you imported into InvenRecon select View Physical Counts
 ## Select Update Physical counts.  This will take the data from InvenRecon imported above and setup the physical counts.  Note that this may take a while with lots of parts.
-## Go through and accept for each part that you want to update for the new physical count.
+## Go through and accept for each part that you want to update for the new physical count. Select 'Accept All Counts' to flag all inventory.
 ## When completed accepting, select Reconcile Batch
 ## [[File:ReconcileBatch.png]]

@@ Line 58: / Line 58: @@
 === Advanced Functionality with Physical Count Data Uploads ===
 New instructions:
-# Export Location table to get the UID's of your warehouse. This is done from The Utilities Module. Select Export Data>Run It. You will want to select Location table. After this move UID and Name to the Destination Fields, and hit start. This will give you your warehouse/location UIDs.
+# Export Location table to get the UID's of your warehouse. This is done from the Utilities Module. Select Export Data>Run It. You will want to select Location table. After this move UID and Name to the Destination Fields, and hit start. This will give you your warehouse/location UIDs.
 # Export Inventory items mainly the following fields:
 ## UID  (Note: You MUST change this to ItemUID in excel after exported)

@@ Line 58: / Line 58: @@
 === Advanced Functionality with Physical Count Data Uploads ===
 New instructions:
-# Export Location table to get the UID's of your warehouse
+# Export Location table to get the UID's of your warehouse. This is done from The Utilities Module. Select Export Data>Run It. You will want to select Location table. After this move UID and Name to the Destination Fields, and hit start. This will give you your warehouse/location UIDs.
 # Export Inventory items mainly the following fields:
 ## UID  (Note: You MUST change this to ItemUID in excel after exported)

@@ Line 52: / Line 52: @@
 ## If you are done with your adjustments for this warehouse or period, click Yes to "Close batch when completed".  If you plan to make additional adjustments select No.
 # Use the top bar for filtering or sorting just like search views
-# Print Reconciliation Report will print the changed done in reconciliation.
+# Print Reconciliation Report will print the changed done during reconciliation.
 ## Note that the inventory template report must be defined in Setup>Company>Printing>Inventory Template
 # Export to Excel to get an excel report of all the adjustments and inventory

@@ Line 33: / Line 33: @@
 ## Live Count:  This is the CURRENT count of inventory for reference only.  Because you are able to save a batch which is a snapshot of the inventory in the past, the live count will be SME's current inventory value.  This will be helpful to see how much change has been made on that part from the point when you created the batch until now.
 ## Phys. Count:  This is where you enter your adjustment values and should be your current physical count.
-## Exp. Count:  TBD???
+## Exp. Count:  Expected Count is the amount you are supposed to have in inventory.  Any difference filled in for the physical count from the expected count will create an adjustment different.
 ## Difference:  When you enter a value in physical count this will be the difference that will be reconciled.  If it's negative, inventory count will be reduced and if it's positive inventory count will be increased.
 ## Accept:  When you run "Reconcile Batch" it will process all items with accept checked.  If you are trying to reconcile to zero, you can manually check accept to make adjustment to zero.

@@ Line 28: / Line 28: @@
 ## CountCycle:  This is an inventory field for setting the cycle count frequency.  This likely will be blank if you are not using this info in SME.  In inventory management you would set CountCycle as a number system or just how often the parts should be counted like monthly, quarterly or annually.
 ## Number:  Inventory number
-## Last Reconcilation:  Last time that part has been reconciled with this tool.
+## Last Reconciliation:  Last time that part has been reconciled with this tool.
 ## Item:  Item name
 ## Location:  Warehouse location
@@ Line 120: / Line 120: @@
 *** Notes:  This will be filled in by the reconcile process, so should not be imported or loaded.
-<H1> Inventory Reconcilation BEFORE SME 8.1  </H1>
+<H1> Inventory Reconciliation BEFORE SME 8.1  </H1>
 Following Section Applies to before SME 8.1
 == Adjusting a single inventory item ==