Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

Auto Lot RECONCILE:0000000001 Generated and Stock Increased

Posted on by 485

After reconciling inventory, the new LOT has been added as shown in attached image and stock is also increased by 54. How to decrease the stock? Is there any other way than adjustment entry? These Lots RECONCILE will stay here or I can move/remove them from here? Any detail reply and solution will be really helpful.

RECONCILE_2D00_ISSUE.jpg

  • Suggested answer
    Pam Peterson Profile Picture
    Pam Peterson on at
    RE: Auto Lot RECONCILE:0000000001 Generated and Stock Increased

    Thanks for your question!

    The IV Reconcile process will create a new lot number if the quantity on hand in the Purchase Receipts table (IV10200) does not match the quantity in the lot number table (IV00300) or vice versa. Also in your case this appears to be related to a Sales transaction which means that you likely have a partially posted or damaged Sales invoice out there.

    Becky has a couple of great blog posts that might help you with that part.

    https://community.dynamics.com/gp/b/dynamicsgp/posts/troubleshooting-sop-invoices-that-are-in-both-work-and-history

    https://community.dynamics.com/gp/b/dynamicsgp/posts/how-to-use-sql-to-troubleshoot-a-sop-order-that-did-not-move-to-history-when-it-was-fully-invoiced

    In terms of your inventory, you might need to start with a physical count of your item if you are not sure what the correct quantity on hand should be. Then you need to determine if those specific receipts should actually be on hand right now. If they should be, and you would like to use "real" lot numbers, then you will need to do decrease adjustment transactions directly in Inventory to remove those lots from your inventory, and then do corresponding increase adjustment transactions using the "correct/real" lot numbers to bring the quantity back in.

    Alternatively, if those receipts should be sold, then you simply need to do the decrease to take them back out. You could do this with a "fake" SOP transaction, but an Inventory Adjustment would be recommended so a customer isn't involved. Any time you make changes to your quantity on hand, it needs to happen through a transaction.

    I hope this helps!

    Pam

    Microsoft Support

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans