Finance | Project Operations, Human Resources, ...

Serialize an item after it was created

(0) Share

Report

Posted on by Community member

Hi, there are a few items in GP that were created incorrectly. The items need to be serialized and we can't figure out how to do this after the item was created. There are already orders, backorders, completed orders, and invoices for the items.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (3)

Answers (0)

Judy Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Please hold on to wait answers from others on the community.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Here is a link to an old thread about this.. If I understand you correctly, you have already created the Items but not selected the option for Serial / Lot tracking ?

the flag could be changed behind the scene in the IV00101 table and then run a reconcile to have GP create an auto-generated serial number, then do adjustments as needed.

https://community.dynamics.com/forums/thread/details/?threadid=86cbb75b-3228-485f-8ab1-3e8902096f4e

You may also want to look in ISV add-ons like Willoware that has tools to better handled serial / lot numbers in GP

Contact them and they might be able to help.

Was this reply helpful? Yes No
Suggested answer

Joseph Markovich 3,976 on at

Like (0)

Report
Copy link

Link copied!

The way I've always been told about this (and done this in the past) was you need to get all of the pending transactions finished (open POs waiting to receive or invoice, open sales orders waiting to ship, etc), adjust out any inventory that is on hand or whatever, and then GP will let you change the item tracking option to serialized or lot numbers and set it up.

Then you put your inventory back in (if there was any on hand) -- and going forward everything will be serialized.

Agree with Beat that Willoware has a nice add-on option for more flexibility with serial and lot tracked items.

I hope this helps.

Joe

Was this reply helpful? Yes No