Item Serial/Lot Track Type

(0) Share

Report

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

I have the same question (0)

All responses (7)

Answers (0)

soma 24,410 on at

Like (0)

Report

RE: Item Serial/Lot Track Type

NHI,

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

Was this reply helpful? Yes No
NHI 1,600 on at

Like (0)

Report

RE: Item Serial/Lot Track Type

Thank you so much Soma. It works.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
NHI 1,600 on at

Like (0)

Report

RE: Item Serial/Lot Track Type

Hi Frank,

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

Was this reply helpful? Yes No
callen 4,595 on at

Like (0)

Report

Re: Item Serial/Lot Track Type

Make sure that the quantity on hand is 0.

Make sure the quantity on order is 0.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,613 Super User 2025 Season 2 on at

Like (1)

Report

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,

Was this reply helpful? Yes No