Open Forum

Expand all | Collapse all

Item Journal Upload Functionality - Tracking Lines Included

  • 1.  Item Journal Upload Functionality - Tracking Lines Included

    Posted 9 days ago
    Hello,

    I am a Dynamics NAV 2016 user and I'm curious to know if this version has the ability to upload an item journal or physical inventory journal from excel that *includes* tracking lines.  I'm aware that I'm able to upload from excel to the journal without tracking lines, but I need to be able to include the tracking lines to make the process a bit faster.

    All insight is greatly appreciated.

    Thank you!

    #Functional ​​

    ------------------------------
    Michelle Cahall
    TGS Global
    Denver CO
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Item Journal Upload Functionality - Tracking Lines Included

    Posted 8 days ago
      |   view attached
    Hi Michelle,

    If you are going to upload via configuration packages into the item journal WITH lot tracking, then you need to load up Table 83 first, then for those lines that need item tracking, load additionally reservation entry table 337.  I've attached an example of this...because NAV partners have propriety fields, if you don't see one, likely shouldn't be necessary for you to have, but you should have nearly all these fields identical.  This is typically used for loading in opening inventory on initial implementations...

    Hope this helps!  Warm Regards,  Steven

    ------------------------------
    Steven Filipiak
    Business Consultant
    Columbus Global
    ------------------------------

    Attachment(s)

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role