Inventory Report - Duplicating Items

SOLVED

I have ran the inventory report multiple times for multiple reasons and have the same issue.  When I ran the inventory report and downloaded into excel I am finding that it is duplicating many of the items.  I am updating list pricing and am checking for duplicates as I go.  The report will show the same item two or more times, but in Sage I only see it once.  I am worried that when printing an inventory report to backup Balance Sheet and Financials I will have to search for duplicates each time because if I don't it will not tie.

Is anyone else having this issue?  I read that when doing an item search in Sage that it will duplicate, but most often the item is only in there once.

  • +1
    verified answer

    Here is SAGE's Knowledge base information surrounding this issues.  Sure would be great if this known issue could be resolved verse having to enter in multiple Purchase/Receive documents to address the various reasons why items are listed multiple times on a given Purchase Order that must appear on the vendors purchase history as separate purchases each listing the correct unit price verse a consolidated entry with a combined unit cost.

    Duplicate items on the inventory list

    Products
    Sage 50—U.S. Edition

    Description
    • There are duplicate items on the Inventory List
    • When going to Lists, Inventory & Services, Inventory & Services, some of the Inventory Items are listed twice or more times
    • On the list view of Inventory Items, some of the Inventory Items are listed twice or more times
    • Each listing is the same inventory item with the same Item ID
    • When you drill down on any one of them, it takes you to the same Maintain, Inventory Items record
    Cause
    • This is caused by entering the same item on multiple lines on a purchase invoice
    • Enter purchase orders in such a way that you have multiple line distributions for the same item, versus having just one line distribution with a Quantity great than 1
    • Having multiple transactions like ones listed above at in the system with differing unit prices
    Resolution
    1. Open the purchase invoice that contains the multiple lines for one of the duplicate Item IDs
    2. Remove all but 1 line for that item
    3. Change the quantity to reflect the total ordered of that item on that purchase invoice
    4. Click Save
    5. Repeat steps 1-4 for each purchase invoice for each item that is showing a duplicate Item ID