web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Auto Lot RECONCILE:000...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Auto Lot RECONCILE:0000000001 Generated and Stock Increased

(0) Share

Report

Report

Posted on by adeel333

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.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Pam Peterson Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

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

#1

André Arnaud de Cal... 410 Super User 2026 Season 1

#2

#3

Martin Dráb 262 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans