Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Lot generation while reconciliation

Posted on by 1,240

Hi,

After reconciliation, new lots are generated by the name RECONCILE:000000001,RECONCILE:000000002 and so on. Is there any way to rename the lots or change the lot name prior reconciliation.

*This post is locked for comments

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Lot generation while reconciliation

    Simplicity has always been the secret, quite simple and to the point ...

    Now you get plenty of options to choose from, either the hard way or the short cut.

    Keep us posted Jitendra

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Lot generation while reconciliation

    As is always the case, Mahmoud's advice is spot on.  Another option, if it's only a few records, is to adjust the 'RECONCILE' lots out and adjust the correct lot numbers in using Item Transaction Adjustment.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Lot generation while reconciliation

    Items with lot number tracking option and open balance in (IV10200), will have reconciliation lot records created in associated lot tables (Primarily IV00300)

    I have came across such case before and manually updated the LOTNUMBR field on the database level level, with no reported issues. I would consider the following steps to get your lot updated:

    1. There is stored procedure to search all database, It can do a great job for such case, you can get it from here
    2. After running the script above, a new stored procedure will be created named spSearchOnAllDB
    3. Use the stored procedure above to look for a specific lot number in all GP Tables, suppose you want to look for (RECONCILE:000000001)  . Type the following command exec  spSearchOnAllDB 'RECONCILE:0000000001 %', 1
    4. The result pane will show you all the records in your database which have a corresponding value of (RECONCILE:000000001) as shown below;                                                                          
    5. In most lot cases, you will have records in IV00300 primarily (this is the open table for open lots). Now you can proceed with the update statement to update the lot number as shown below
        UPDATE dbo.IV00300 SET LOTNUMBR = 'XXX' WHERE  DEX_ROW_ID = '123444'

    Furthermore, you can run inventory reconciliation and make sure that updated lot numbers in associated tables are not affected after the reconciliation.

    Important Note !

    In case you don't have the proper knowledge, you may discuss this with your partner. Since improper deployment could be critical. Never forget to take a back up or play on the test initially.

    Your feedback is highly appreciated,

    Never forget to close the case by verifying the answer if it meets you inquiry

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans