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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Auto Lot RECONCILE:0000000001 Generated and Stock Increased

(0) ShareShare
ReportReport
Posted on by 487

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

Categories:
I have the same question (0)
  • Suggested answer
    Pam Peterson Profile Picture
    on at

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans