web
You’re offline. This is a read only version of the page.
close
Skip to main content

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) / Lot generation while r...
Microsoft Dynamics GP (Archived)

Lot generation while reconciliation

(0) ShareShare
ReportReport
Posted on by Jitendra Verma 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

I have the same question (0)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    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

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,627 Moderator on at

    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.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans