160
Hi, I'm using NAV 5.0 and we have some items that were not setup correctly. They needed an "Item Tracking Code" and after the item has ledger entries this field cannot be changed. Is there a way to change the "Item Tracking Code"???
Thanks,
Paul
*This post is locked for comments
What I have done in the past is to change that check on the item tracking code to only check for 'open' item ledger entries. This way you can adjust the inventory out, change the item tracking code manually, and then put the inventory back in with the lot numbers.
It should only be a workaround, since a closed item ledger entry can be reopened through the application worksheet (so if you do that and apply an item ledger entry without a lot number to one with a lot number you might get into trouble).
This is a 'one line code change' in the item table, something like this:
IF (ItemTrackingCode."SN Specific Tracking" <> ItemTrackingCode2."SN Specific Tracking") OR
(ItemTrackingCode."Lot Specific Tracking" <> ItemTrackingCode2."Lot Specific Tracking")
THEN
//>> Olof
//orginal code: TestNoEntriesExist(FIELDCAPTION("Item Tracking Code"));
TestNoOpenEntriesExist(FIELDCAPTION("Item Tracking Code"));
//<< Olof
Hi,
The process is not simple as you have to check (and delete) if there are sales lines and purchase lines for the Items that needs to be set up with Item Tracking. Post an item journal negative adjustment to remove the inventory of these items.
If you require that the item have the same no. then you first have to rename the block item for example ITEM to ITEMX. And have the new item as ITEM.
Block the item, recreate the item then bring back the inventory through item journal positive adjustment. Re-create the sales lines and purchase lines for that item.
Thank you.
Thanks for the response. I was hoping I could avoid recreating the parts since there is a good number we need to fix. Also we are running "native", not SQL, so I assume those commands would not help in this case. Looks like I'm probably stuck recreating parts. Thanks for you help.
-Thanks
Probably the best solution is to block the item and recreate it in a correct manner.
If this is not possible you can update Item Tracking Code directly from SQL commands.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
