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
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
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.
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:
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156