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 | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
* Note: This functionality is requires data to be entered through an external program. At this time, no external program has been created so this functionality is not available without addition work. | * Note: This functionality is requires data to be entered through an external program. At this time, no external program has been created so this functionality is not available without addition work. | ||
* View Physical Counts will load the physical count data table to be used for reconcile. | * View Physical Counts will load the physical count data table to be used for reconcile. | ||
* Update Physical Counts will update the data table. | * Update Physical Counts will update the data table. | ||
− | |||
− | |||
− | |||
− | |||
* Physical Count Table Structure. Note this is technical since it would most likely be populated by software developer from external system or uploaded from excel. | * Physical Count Table Structure. Note this is technical since it would most likely be populated by software developer from external system or uploaded from excel. | ||
** Table name: InvenRecon | ** Table name: InvenRecon | ||
− | ** Serialized items: Load process for Serialized items is to just load the serial numbers | + | ** Serialized items: Load process for Serialized items is to just load the serial numbers. SME logic will find the location and item information. So you can just upload a bunch of serial numbers that you have in stock |
*** SerialNumber | *** SerialNumber | ||
*** LocationUID: The location of where the serialized part is currently located. If SME reconcile finds this part in another location, it will MOVE it to this location during reconcile. | *** LocationUID: The location of where the serialized part is currently located. If SME reconcile finds this part in another location, it will MOVE it to this location during reconcile. | ||
Line 120: | Line 56: | ||
*** 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 == |