Editing Inventory Quantity Reconciliation
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 9: | Line 9: | ||
** This warehouse should NOT be used for inventory reporting | ** This warehouse should NOT be used for inventory reporting | ||
** This warehouse SHOULD be used for reporting of adjustments or scrap of inventory | ** 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 | + | ** 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. |
− | ** If parts are found again, inventory reconciliation can be used to move | + | ** If parts are found again, inventory reconciliation can be used to move back into a warehouse. |
** You do not have to worry about inventory stock "disappearing" from inventory tracking and reconciliation since all inventory is tracked in and out. | ** 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 | ** 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. | ** Note: If you have a custom inventory report it will need to be updated to NOT count this virtual warehouse. | ||
* Batching | * Batching | ||
− | ** Batches will allow inventory to be | + | ** 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. |
*** For example, you may want to run a quarterly inventory reconcile with the following process: | *** For example, you may want to run a quarterly inventory reconcile with the following process: | ||
− | + | *** Create a new Batch | |
− | *** Create a new Batch | + | *** adjust physical counts on day 1 and click Reconcile Batch but select not to close the batch |
− | *** | + | *** Do additional physical count adjustments on the next day and then close the batch. |
− | *** Do additional physical count adjustments on the | ||
== Inventory Reconciliation version 8.1 Operation == | == Inventory Reconciliation version 8.1 Operation == | ||
− | # Select Utilities>Inventory>Inventory Reconciliation and click Run It | + | # Select Utilities>Utilities>Inventory>Inventory Reconciliation and click Run It |
# [[File:Reconcile1.png]] | # [[File:Reconcile1.png]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
# Batch: Select New for a new batch or if you already created a batch you want to continue then select that batch. | # Batch: Select New for a new batch or if you already created a batch you want to continue then select that batch. | ||
## Select New>All Inclusive to adjust all warehouses. Note: If you have lots of data, this is not recommended. | ## Select New>All Inclusive to adjust all warehouses. Note: If you have lots of data, this is not recommended. | ||
Line 52: | Line 34: | ||
## 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. | ## 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 | # Use the top bar for filtering or sorting just like search views | ||
− | # Print Reconciliation Report will print the | + | # Print Reconciliation Report will print the |
− | ## Note | + | ## Note, and inventory template report bust be defined in Setup>Company>Printing>Inventory Template |
# Export to Excel to get an excel report of all the adjustments and inventory | # Export to Excel to get an excel report of all the adjustments and inventory | ||
− | + | Advanced Functionality with Physical Count Data Uploads | |
New instructions: | New instructions: | ||
− | # Export Location table to get the UID's of your warehouse | + | # Export Location table to get the UID's of your warehouse |
# Export Inventory items mainly the following fields: | # Export Inventory items mainly the following fields: | ||
## UID (Note: You MUST change this to ItemUID in excel after exported) | ## UID (Note: You MUST change this to ItemUID in excel after exported) | ||
Line 71: | Line 53: | ||
## Go to Utilities>Import>Import Data and select Run It | ## Go to Utilities>Import>Import Data and select Run It | ||
## Select the button next to Source Filename and Load the InventoryRecon.csv files from above. Note in the bottom right corner change teh file type from Excel to csv (or All) to find this file. Select Open | ## Select the button next to Source Filename and Load the InventoryRecon.csv files from above. Note in the bottom right corner change teh file type from Excel to csv (or All) to find this file. Select Open | ||
+ | ## For Destination Table select InvenRecon and check include UID fields | ||
## [[File:ReconcileImportFile.png]] | ## [[File:ReconcileImportFile.png]] | ||
− | |||
− | |||
## Set the field mappings as follows: | ## Set the field mappings as follows: | ||
### ItemUID | ### ItemUID | ||
Line 87: | Line 68: | ||
## Select the warehouse you want to reconcile under Filter on Location | ## Select the warehouse you want to reconcile under Filter on Location | ||
## Create a new batch for the warehouse location you want to reconcile by selecting New>For Location Only. Note that this takes a snapshot of inventory and can take a while. | ## Create a new batch for the warehouse location you want to reconcile by selecting New>For Location Only. Note that this takes a snapshot of inventory and can take a while. | ||
− | |||
## Optional: To see the data you imported into InvenRecon select View Physical Counts | ## 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. | ## 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. |
## When completed accepting, select Reconcile Batch | ## When completed accepting, select Reconcile Batch | ||
− | |||
Line 120: | Line 99: | ||
*** Notes: This will be filled in by the reconcile process, so should not be imported or loaded. | *** Notes: This will be filled in by the reconcile process, so should not be imported or loaded. | ||
− | <H1> Inventory | + | <H1> Inventory Reconcilation BEFORE SME 8.1 </H1> |
Following Section Applies to before SME 8.1 | Following Section Applies to before SME 8.1 | ||
== Adjusting a single inventory item == | == Adjusting a single inventory item == |