Dynamics Community Forum Thread Details

Auto Lot RECONCILE:0000000001 Generated and Stock Increased

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

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

Quick Links

Leaderboard