Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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,410 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,410 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 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... 46,325 Super User 2025 Season 1 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans