415
Hi all, 3 months after a go live, we have found some parts in stock that have not had a lot number assigned to them, how can I do this to an item that is in inventory?
Thanks
*This post is locked for comments
Hi Jaideep, I will give this a try.
Thanks
Hi,
Even if you transfer to a new location the item ledger entry would change only for transfer to the new location you need to change the item tracking and then do reclassification OR close the existing item(i.e. make negative adjustment for the same) and create a new item and make positive adjustment with lot no. for all the previously open entries.
Hi Miguel, that was what I was after really, just thought I could move the stock to a new location but give it a new lot number in the new location?
You cannot achieve this without a customization but below are the steps with customization to assign lot no.
1. Make sure this item is not on any open purchase, sales or transfer orders
2. Change the item tracking code, for that open the table in designer mode and for the item tracking code field onValidate Trigger comment the code which says TestNoEntriesExists (You need development License, if you don't have it ask your partner to make the change)
3. Change the Item Tracking Code
4. Revert your changes from Step 2. i.e. Uncomment the code change
5. Use Reclassification journal to assign Lot No.
Do you need a solution without customizations?? Because I supposed that you cannot change the item tracking setup, right?
Hi, the item tracking has no records against it on this item, as it was originally entered without a lot number
Hi Marley,
You must edit the Item (not ledger entries). Once in the item card, you must go to "Item tracking" tab, and there you should edit the tracking setup :-)
No, if I go into the ledger entry, the lot no. field is blank, so nothing on the card etc to change!!!!
Hi,
What you would need to do is First change the Item tracking for the Item(You will not be able to do that first attempt since Item Leger exists. You would need to comment the code behind that.) then go to the Item Reclassification Journal and go to Item Tracking and assign the new Lot No. to the open item ledger entries for that item.
So, you can't change the tracking setup... right?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (