Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Process to Convert Lot...
Microsoft Dynamics GP (Archived)

Process to Convert Lot Items to Serial Tracked

(0) ShareShare
ReportReport
Posted on by Tom Kumagai 35

We have a requirement to change the current Lot tracked items to Serial tracked. Searching quickly across the web it appears that I need to "0" out the inventory for the item. This process works great. Now to do this effectively with thousands of items, this process becomes a pain-staking exercise. Is there another way? Are there scripts or commands that I could forward to my SA to achieve this for my group/line of business? Some thoughts of creating a report and deleting the item and starting fresh might be a good way. I don't think I am alone in this task and just wondering if there were others that achieved something similar.

*This post is locked for comments

  • Tom Kumagai Profile Picture
    Tom Kumagai 35 on at
    Re: Process to Convert Lot Items to Serial Tracked

    Many thanks for the responses.  I have forward this to my SA.  To Mohammad, I believe we had tried to provide a minus adjustment through IM, but the system would not take negative numbers.   We had also tried via SmartConnect and same results.

    To Leslie not sure on the cycle count, but I see what that means and I will give that a try too.

    I appreciate your quick responses.

    Tom

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Process to Convert Lot Items to Serial Tracked

    To create the item transaction that will reduce the inventory to zero, you could use the cycle count functionality. Put the items needing to be changed in a stock count schedule, enter 0 for the counted quantity. This should create a transaction to zero out your inventory.

    Kind regards,

    Leslie

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Process to Convert Lot Items to Serial Tracked

    Hello Tom,

    I can think with several options to get this done, but would first advise not to use SQL to perform this operation, if you forgot a line item you will have to live with unreconciled IV00300 for ever:

    1. Use Integration Manager to draw an integration for doing minus adjustment that zero out all your inventory items that need to be converted including all lot information, post your transaction, create another integration that change the tracking options for the item and finally create an integration to pull out your inventory back with serials.

    2. Use Dynamics GP Excel Paste to copy your transactions from Excel and Paste it directly to transaction entry screen, then do another paste on the item card to change tracking options.

    On both cases, you can query IV00300 (Lot Master table) to get your data into Excel.

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

Product updates

Dynamics 365 release plans