Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Item Serial/Lot Tr...
Microsoft Dynamics GP (Archived)

Item Serial/Lot Track Type

(0) ShareShare
ReportReport
Posted on by Don L 740 
I am using GP 10 and have inventory items that I am unable to change the 
Track Type. When I go to Cards>Inventory>Item, Options button, the Track Type 
(None, Serial, Lot) is greyed out. I looked up the related information on 
changing the tracking and it said as follows:

To change from tracking serial or lot numbers to none or vice-versa, the 
item cannot have any current quantities. Current quantities include Quantity 
on Hand, Returned, In Use, In Service and Damaged. A Quantity On Order in 
Purchase Order Processing will also prevent the change of Tracking Serial 
Numbers.

I have run an allocation SQL script from MS and it shows no quanties 
allocated. I have looked to ensure the item is not on a BOM as well. Any 
thoughts on what is the root cause would be appreciated.

Thanks!

Don

*This post is locked for comments

  • soma Profile Picture
    soma 24,406 on at
    RE: Item Serial/Lot Track Type

    NHI,

    If my code is working fine, then mark this post as verified.

  • NHI Profile Picture
    NHI 1,600 on at
    RE: Item Serial/Lot Track Type

    Thank you so much Soma. It works.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Item Serial/Lot Track Type

    Here is code for changing the item tracking option.

    UPDATE IV00101 SET ITMTRKOP = 2(Serial Number) or 3(Lot Number) where ITEMNMBR='Enter ItemNumber'

    Note:

    Before running this code,

    1. Make a backup of your company DB.

    2. Make sure the "Quantity On Hand" and "Quantity On Order" is 0 for that item.

    3. Complete the process of any purchase orders pending with that items.

    4. After cmpleted above the 3 steps, run this code in test server.

    5. Please check and do the above steps in live sever.

  • NHI Profile Picture
    NHI 1,600 on at
    RE: Item Serial/Lot Track Type

    Hi Frank,

    Could you please give me the script to change the Track option? Thanks a lot.

  • callen Profile Picture
    callen 4,595 on at
    Re: Item Serial/Lot Track Type

    Make sure that the quantity on hand is 0.

    Make sure the quantity on order is 0.

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Item Serial/Lot Track Type

    Hi Guys,

    Maybe try a check links and inventory reconcile first and see if it does any good...you never know!

    Best regards,

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Item Serial/Lot Track Type

    I don't know why you're seeing this behavior but if you can't find a solution you can run a script against IV00101 to change the values in the ITTRKOP field to '2' or '3' for serial tracking or lot tracking, respectively.

    Make sure you backup your database beforehand.

    Hope this helps,

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans