How To: Resolve Duplicate Items

How To: Resolve Duplicate Items

End user  ·  Yellow Dog Inventory 2026

 WHY IT'S IMPORTANT

Duplicate items split an item's true quantity and history across two records, which makes on-hand counts, sales history, and purchasing data unreliable. Resolving duplicates consolidates the quantity onto the record you want to keep and removes the one you don't, so your inventory reflects a single accurate count.

 PREREQUISITES

•     Permission to edit manual adjustments

•     Permission to remove items

•     Access to the Activity View

•     Two or more records you have confirmed are duplicates of the same item

 STEP BY STEP

Decide which item to keep

1.   In the Inventory Items screen, switch to the Activity View for each duplicate to review when the item was created, last sold, and last purchased.

2.   Use that information to decide which record to keep and which to discard.

Adjust the on-hand quantities

1.   Highlight both items. To select both, hold Ctrl while clicking each item.

2.   In the Physical Inventory module, select Adjust On Hand Quantity.

3.   Select the correct store.

4.   Enter your manual adjustments so the quantity moves from the record you are discarding to the record you are keeping:

a.    Adjust the item you are keeping up by the duplicate's on-hand quantity.

b.    Adjust the item you are discarding down to zero by the same quantity.

5.   Enter a note in the Reference field.

6.   Select Submit to commit the manual adjustment.

Remove the duplicate

1.   Confirm the on-hand quantities have updated on both records.

2.   Remove the item that now has a zero on-hand quantity. Select Remove Item from the right-side navigation of the Inventory Items screen, or right-click the item and select Remove Item.

Note: The example in the source video adjusts the kept item up by three and the discarded item down by three. Use the actual on-hand quantity of the record you are discarding, not a fixed number.

 RELATED ARTICLES

  1. How To: Adjust the on hand values of items manually

 

Last reviewed: June 2026  ·  Applies to: Yellow Dog Inventory 2026



    • Related Articles

    • How to Process New Items Created by an EDI

      Proper management of new items created by an EDI ensures purchases are properly recorded and inventory items are accurately maintained. This article is for Yellow Dog Inventory version 376 and prior What is an EDI? An EDI integration allow invoices ...

    • Troubleshooting: Resolving 'Locked' Items

      You cannot update an item’s vendor because the item is locked by a purchasing document. Figure: An item displayed with the Locked status The item appears on one or more purchase orders (POs) that have not been fully received or invoiced. Use the ...

    • How To: Create Items Within Invoice Staging

      End user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT When you process a staged invoice, line items automatically link to your inventory items using the vendor part number (PN) and vendor size abbreviation. If an invoice line has no matching item, ...

    • Troubleshooting: Items reverting assignment in Invoice Staging after saving

      This article helps you identify and resolve the issue of mapping items in invoice staging reverting back to previously mapped items after saving a staged invoice. Issue Items are mapped in the Invoice Staging editor, but when the editor is saved the ...

    • Troubleshooting: Items unassigned invoice staging

      Items in Invoice Staging appear as Unassigned. Figure: Example of unassigned items in a staged invoice One or more of the following conditions apply: Vendor size abbreviations aren’t assigned. Vendor size abbreviations in Yellow Dog don’t exactly ...

    • 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 (Base Unit) Size

      End user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT The on-hand (parent) size is the base unit—the unit Yellow Dog Inventory uses to track on-hand quantity and to convert every purchasing and counting size. When an item with multiple sizes is set ...

    • 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 ...