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>2. Copy the Item Number. | ||
+ | [[File:ItemNumber.jpg]] | ||
+ | '''NOTE''' – If your Item Names are unique, you can use that and substitute Name for Number for the remainder of the procedure. | ||
+ | |||
+ | <br>3. Go to '''Utilities''' > '''Utilities''' '''(1)''' | ||
+ | <br>4. Select '''Inventory'''. '''(2)''' | ||
+ | <br>5. Select '''Inventory Reconciliation''' '''(3)''' and click '''Run It (4'''). | ||
+ | |||
+ | [[File:ReconciliationSteps.jpg]] | ||
+ | |||
+ | The''' Inventory Reconciliation''' window will open listing all of your inventory items. | ||
+ | |||
+ | <br>6. Click [[File:DownArrow.jpg]] in the Number column header and select '''(Custom..)'''. | ||
+ | |||
+ | [[File:FilterByNumber.jpg]] | ||
+ | |||
+ | <br>7. In the Custom Filter window, enter the Item Number in the field circled in the image below. | ||
+ | |||
+ | [[File:EnterNumber.jpg]] | ||
+ | |||
+ | <br>8. Click '''OK'''. | ||
+ | |||
+ | Notice the inventory list filtered down to the item you need to adjust. | ||
+ | <br>9. Click [[File:PlusSign.jpg]] on the inventory item row (1 in image below). The editing window will expand. | ||
+ | <br>10. Click [[File:PlusSign.jpg]] to expand the warehouse locations. (2) | ||
+ | <br>11. Enter the accurate inventory count in the '''Physical Count''''''Bold text''' column (3). | ||
+ | <br>12. Check the box in the '''Accept''' column. | ||
+ | <br>13. Click '''Post Changes''' (4). | ||
+ | |||
+ | [[File:PhysicalCount.jpg]] | ||
+ | <br>14. Click '''Yes''' to message in Information window. | ||
+ | <br>15. When the screen clears, click '''Close'''. The quantities will be adjusted. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== Adjusting a single inventory item == | == Adjusting a single inventory item == | ||
If you are adjusting a single inventory item, you can open the Inventory Reconciliation window from the inventory item.<br> | If you are adjusting a single inventory item, you can open the Inventory Reconciliation window from the inventory item.<br> | ||
Line 129: | Line 51: | ||
3. Inventory Reconciliation window opens for that item only.<br> | 3. Inventory Reconciliation window opens for that item only.<br> | ||
<br> | <br> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== Alternative to manage stock adjustments == | == Alternative to manage stock adjustments == | ||
Line 161: | Line 76: | ||
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. | 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. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |