How To: Remove On-Hand Quantities from Removed Items

Use this process to clear on-hand quantities from items marked as Removed. This ensures accurate inventory reporting and prevents removed items from appearing in inventory valuations.

You must have permission to create Manual Adjustments.

Identify removed items with on-hand quantities

1. Go to Reports > Standard Reports.
2. Run the On-Hand Inventory Report.
3. Apply filters to show Removed Items only.
4. Export the report to Excel.  

Prepare adjustment values

1. Open the exported file.
2. Locate the On Hand column.
3. Multiply all values by -1 to reverse the quantities.
   • Example: 10 → -10

Create a manual adjustment

1. Go to Physical Inventory > Manual Adjustments.
2. Select Create New Manual Adjustment.
3. Select the appropriate Store.
4. Add any active (not removed) item.
   • This is required to create the adjustment.

Bring removed items into adjustment editor 

1. Use the Add Items From function in the Manual Adjustment editor.
2. Select Add items from an Excel or CSV or text file 
3. Upload the modified Excel file.
   
4. Confirm all removed items and quantities are included.
5. Delete the temporary active item added earlier.
6. Click Submit.

Note: Repeat this process for each store if managing multiple locations.

Figure: Example of the Add Items From feature in the manual adjustment editor 

Verify results

1. Re-run the On-Hand Inventory Report.
2. Filter for Removed Items.
3. Confirm all removed items show zero on-hand.

FAQs: What's the difference between inactive and removed items?

• Related Articles

• How To: View On-Hand Quantities

  Quick access to on-hand quantities ensures speed, accuracy, and alignment across operation, making it easier to manage stock and support sound business decisions. All client types Access to the Item Management > Inventory Items screen and the ability ...

• FAQs: What's the difference between inactive and removed items?

  Q: What's the difference between inactive and removed items? A: When managing your item catalog in Yellow Dog Inventory, you may need to retire products that are not currently in use. The system provides two distinct options for doing this: Inactive ...

• Tips and Tricks: Removing Items with On-Hand Quantity (Decimal)

  You might encounter difficulty removing specific inventory items due to an error indicating that the item cannot be removed since its on-hand quantity is not zero, possibly because the decimal point is not properly adjusted. Removing Items with ...

• Feature Overview: Merging Items

  Merging items allows you to combine two or more duplicate items into a single item. This helps maintain clean, accurate inventory data. Note: Merges cannot be undone. Use this feature with caution. Open the Inventory Items screen. Select both items. ...

• Tips & Tricks: Searching for Items

  These tips will help you quickly locate the inventory items you need on the Item Management > Inventory Item screen, making your workflows faster, easier, and more efficient than ever. <br> Use AND to match ...

• Popular Articles

• How To: Find Your Yellow Dog Inventory Version

  Understanding which version of Yellow Dog Inventory you're using is essential when exploring new features, as some enhancements and functionalities are specific to certain versions. All client types can benefit from knowing their Yellow Dog Inventory ...

• Feature Overview: Par & Re-Order Points

  Par levels and reorder points help streamline purchasing in Yellow Dog. Par level is the ideal quantity to keep on hand. Reorder point is the minimum quantity that triggers reordering. You can update par and reorder points in the following locations: ...

• Tips & Tricks: How do I download and install drivers for my Zebra Printer?

  **As a note: Admin rights will be required to complete this task. If you do not have admin rights on your PC, please contact your IT for assistance** ZD410 Desktop Printer Support Site 1. Navigate to Drivers: 2. Select Zdesigner V. 5 Driver for ...

• How To: Swap the On-Hand/Parent Size (Edit Base Unit)

  When managing items with multiple sizes, it’s essential to configure them correctly. The on-hand/parent size should always represent the base unit or smallest measurement, while additional sizes should be created for purchasing or counting sizes. If ...

• FAQs: What are Bins?

  Question: What are Bins? Answer: Bins are optional location identifiers that specify exactly where an item is stored. You don’t need to create bins in advance. You can assign them: In the Stores tab of the item editor Through a Balto import Bins ...