web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Item Tracking
Microsoft Dynamics NAV (Archived)

Item Tracking

(0) ShareShare
ReportReport
Posted on by Paul Blake 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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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.

  • Paul Blake Profile Picture
    Paul Blake 160 on at

    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

  • Vishal Profile Picture
    Vishal 15 on at

    you can have your NAV partner do this for you too, depends whether you want them to or not.

    The safest is to re-create the items

     Vishal

  • Suggested answer
    serendipity Profile Picture
    serendipity 1,010 on at

    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.

  • Alex Chow Profile Picture
    Alex Chow 4,481 on at

    1. Negative adjust all items to 0

    2. Create a process only report and modify the Item Tracking Code on the item table.

        "Item Tracking Code" := 'LOTALL';

        MODIFY;

    3. Positive adjust quantities back in with lot numbers

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans