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 2: | Line 2: | ||
*NOTE* If you are tracking inventory quantities in QuickBooks, any adjustments made to SME inventory using reconciliation will also need to be made in QuickBooks inventory. Only invoices from SME automatically deplete inventory in QuickBooks. Only POs or Bills from SME automatically increase inventory in QuickBooks. | *NOTE* If you are tracking inventory quantities in QuickBooks, any adjustments made to SME inventory using reconciliation will also need to be made in QuickBooks inventory. Only invoices from SME automatically deplete inventory in QuickBooks. Only POs or Bills from SME automatically increase inventory in QuickBooks. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | '''To adjust inventory quantities in SME based on your physical count:''' | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
<br>1. Go to Inventory module and select the item you need to adjust. | <br>1. Go to Inventory module and select the item you need to adjust. | ||
Line 201: | Line 42: | ||
<br>14. Click '''Yes''' to message in Information window. | <br>14. Click '''Yes''' to message in Information window. | ||
<br>15. When the screen clears, click '''Close'''. The quantities will be adjusted. | <br>15. When the screen clears, click '''Close'''. The quantities will be adjusted. | ||
+ | |||
+ | |||
+ | == Alternative to manage stock adjustments == | ||
+ | |||
+ | Another option for adjusting stock quantities for inventory items is to setup a separate warehouse in SME to move the excess stock to. This way, if the adjustment was done in error, it is very simply to move the stock back to your working warehouse location. When you do your usual physical count, set the ‘Stock Adjustment’ warehouse counts to zero using the inventory reconciliation utility. | ||
+ | |||
+ | <u>'''Set up a new warehouse and name it Stock Adjustment or something similar:'''</u> | ||
+ | <br>1. Go to the Setup Module and click '''Company''' | ||
+ | <br>2. Select '''Lists'''. | ||
+ | <br>3. Locate Warehouses in the Lookup Lists. | ||
+ | <br>4. Click '''New''' in the lower right corner. | ||
+ | <br>5. Enter the new '''warehouse''' name such as Stock Adjustment. | ||
+ | <br>6. Click '''OK''' | ||
+ | |||
+ | <u>'''To move stock out of working warehouses into Stock Adjustment warehouse:'''</u> | ||
+ | <br>1. Locate the inventory item with wrong stock quantities. | ||
+ | <br>2. Select the '''Material Details''' tab. | ||
+ | <br>3. Click '''Move Stock'''. | ||
+ | <br>4. Enter the quantity to move and select the new warehouse from the '''Destination''' drop down. | ||
+ | <br>5. Click '''OK'''. | ||
+ | |||
+ | [[File:MoveStockAdjustment.jpg]] | ||
+ | |||
+ | |||
+ | You will now have a detail line showing the stock adjustment. You will need to inform users to not use the stock in the ‘Stock Adjustments’ warehouse. |