Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Duplicate Item Number
Finance | Project Operations, Human Resources, ...
Suggested answer

Duplicate Item Number

(0) ShareShare
ReportReport
Posted on by RR-07061806-0 45
Good day,
 
//
//
 
I have this item number, which appears to be duplicated the differences are the short description and the quantity on hand. On checking the Item quantities the item is assigned to two locations and the 508 is all sites, 496 plus 12. The IV00101 table has the item number with the short description as 5W30 only once. The user who would primarily make changes is at a remote location and possibly the connection dropped when the change of the short description was being made.
 
But my question is how do I fix this, the stock is currently being verified and I have not done a check links and/or reconcile as yet, any insight would be appreciated I need to provide a plausible reason for this occurrence.
 
Thanks
 
Regards
Rosemary
Categories:
Microsoft Dynamics GP
  • RR-07061806-0 Profile Picture
    RR-07061806-0 45 on at
    Duplicate Item Number
    Good day Beat,
     
    My apologies for the late reply, when I ran the script, the item can up twice, as you can see, one was discontinued. 
     
    Before trying to recreate the scenario, I printed a HITB and the 144 quantity was not there, so I did a return with a credit to remove that value, and then re-entered the transaction, did a HITB and the quantity was added as per location.
     
    The description was changed on the PO before receipt, there is a modification on this form but I'm not sure if it has to do with the entering of non-Inventory items. With the screenshot should the 'Add Item' be ticked?
     
     
    ITEMNMBR ITEMDESC ITMSHNAM ITEMTYPE ITMGEDSC CURRCOST
    SHL550046650                    SHELL HELIX ULTRA PRO AF 5W30 - 1 GAL                                                                 5W30            1 Lubricants  167.52
    SHL550046650                    SHELL HELIX ULTRA PRO AF 5W30 - 4L                                                                    HELIX 5W30      2 Lubricants  167.52
     
     
    Regards
    Rosemary
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Duplicate Item Number
    Rosemary,
    have you tried to run a reconcile on this single Item ID in GP ?  it sounds weird that changing the Item Description in the POP Line would have created this kind of chaos in GP..  I agree with Lisa too, run a query on IV00101 with a  LIKE clause and a "%" towards the last digit of that item and see what SQL returns
     
    i.e. SELECT * FROM IV00101 WHERE ITEMNMBR LIKE 'LSH55004665%'
     
    Beat
  • RR-07061806-0 Profile Picture
    RR-07061806-0 45 on at
    Duplicate Item Number
    Question, a PO was created with this item number, the description was changed on the PO, a receipt was done as per the PO can this create a scenario as this? I'm guessing right now but changing the description should not impact the SKU. 
     
    Regards
    Rosemary
  • RR-07061806-0 Profile Picture
    RR-07061806-0 45 on at
    Duplicate Item Number
    Lisa, 
     
    SQL has only one instance and that is what is strange it was allowed, not sure what else to check. It's assigned to two locations quantities 496 and 12 which would give the 508 overall.
     
     
    Regards 
  • RR-07061806-0 Profile Picture
    RR-07061806-0 45 on at
    Duplicate Item Number
    Thank you Sandip for your response, the item number comes up once.
     
    ITEMNMBR ITEMDESC NOTEINDX ITMSHNAM ITEMTYPE ITMGEDSC STNDCOST CURRCOST UOMSCHDL
    SHL550046650                    SHELL HELIX ULTRA PRO AF 5W30 - 1 GAL                                                                 9416654 5W30            1 Lubricants  0 167.52 CASE 4S    
     
    There were just changes to the description.
  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Duplicate Item Number
    Hello Rosemary,
    What you see it in SQL Query ? Can you run below sql statement and see the details.  
     
    Select * from IV00101 where ItemNmbr ='xxx'   Your Item Number in place of xxx
     
    Thanks much
    Sandip
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,141 on at
    Duplicate Item Number
    Hi Rosemary - 
     
    Do you possibly have any add-ins/customizations to GP that could allow this?  If it is truly the same item number, the primary key constraint on Item Master table should have prevented it.

    Sometimes it looks like a duplicate but there is something - like a space - that is differentiating the number.  Using SQL/SmartList to export the data and then display it in a fixed pitch font (like Courier) often helps identify it.  (Or in SQL you can have a where ITEMNMBR='SHL550046650' clause on the table to see if it truly returns two values.)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans