Scenario
User's item continues to display a negative inventory despite using Smart Count, which suggests an issue with inventory tracking. A reason for this is that multiple inventory adjustments have been made, causing discrepancies that result in negative stock levels at the affected location.
Solution
Below is a clear solution to correct this issue and prevent it from recurring:
1. Go to Transactions > Inventory > Adjust Inventory Worksheet in your system.
2. Enter the following details:
- Subsidiary: Select the appropriate subsidiary for the item.
- Adjustment Account: Choose the account where the adjustment will be recorded.
- Transaction Order: Specify the order of this transaction.
- Location: Indicate the location where the inventory issue occurred.
3. Search for the affected item within the worksheet.
4. Update Values:
- Enter the New Qty: Input the correct quantity the item should reflect.
- Enter the New Value: Input the correct value for the inventory.
5. Populate the Inventory Detail section to specify how this adjustment impacts the inventory (e.g., bin or lot details, if applicable).
6. Save the worksheet to apply the changes.
7. Check the item record afterward to confirm that the inventory quantity and value are now accurate.
Creating an Inventory Worksheet allows you to manually correct the stock levels and values, overriding the discrepancies caused by prior adjustments.
-----
If you find this information useful, let us know by reacting or commenting on this post!
