adding fields to tracking specification

BeliasBelias Member Posts: 2,998
hi everyone, i am trying to add a field in the tracking specification table, let's say a code10.
If i add it to its form and evaluate it, it's all ok, but if i exit/reenter the form, the value is no more there. The "problem" is that the tracking specification is sent to the reservation entry table (tracking specification is used as a temporary table), and when the tracking specification form is opened, the relative reservation entry is re-read and the tracking specification repopulated.
Where in the hell are the values flushed? i can't find the exact place! do someone have some hints?
P.S.: there's another post from me about item tracking, but it became huge, and i think noone will have the time to read it, so i have posted this little question in a new topic :roll:
-Mirko-
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog

Comments

  • matttraxmatttrax Member Posts: 2,309
    I literally wondered for years how to do this. One day I found this great tutorial:

    http://www.nextequalzero.com/2007/12/ho ... ines-form/

    Worked like a charm. I can never quite remember all of the places you have to add code so I refer back to it often. Good luck.
  • lyotlyot Member Posts: 202
    Look at the OnCloseForm trigger of the tracking specifications form.
    There codeunit 99000830 Create Reserv. Entry. is called, thsi codeunit writes the temporary Tracking specifiactions to the table reservation entry.

    The other way around, populating tracking specification form, I stil need to look into myself.
  • lyotlyot Member Posts: 202
    matttrax wrote:
    I literally wondered for years how to do this. One day I found this great tutorial:

    http://www.nextequalzero.com/2007/12/ho ... ines-form/

    Worked like a charm. I can never quite remember all of the places you have to add code so I refer back to it often. Good luck.

    Man this is pure gold!

    Many thanx, =D> =D> =D>
  • BeliasBelias Member Posts: 2,998
    lyot wrote:
    The other way around, populating tracking specification form, I stil need to look into myself.
    that's what i'm doing, but it doesn't work!!
    this procedure is crazy, i'll try mattrax method, i have banged my head against similar tables in these days...but i've never have been sure on how to make it work...i'll let you know if the tutorial is ok, but i believe mattrax it will work..
    hopefully, it will work for nav2009, too [-o<
    thanks for now! :thumbsup:
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • matttraxmatttrax Member Posts: 2,309
    lyot wrote:
    Man this is pure gold!

    I won't lie, I did a little dance the first time I read it and everything worked \:D/
  • BeliasBelias Member Posts: 2,998
    i think that hell's gate is nearly open under me in these days for how much i "swear" for this...
    I took a fast read to the topic and i was damn near to the solution!!i was just looking for a way to call the reservationentryfor...
    that topic is directly pull into my favourites...
    Another big thing i discovered about the item tracking is that they are passed to the journals by simply changing the source type field (and some others) of reservation entry of the document from 37 to 83 (for example)
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • lyotlyot Member Posts: 202
    http://mibuso.com/blogs/lyot/2010/04/08 ... nal-lines/

    Works in the same way for Purchase Lines, Sales Lines, Transfer Lines, ...

    :wink:
  • BeliasBelias Member Posts: 2,998
    lyot wrote:
    http://mibuso.com/blogs/lyot/2010/04/08/create-reservation-entries-for-item-journal-lines/

    Works in the same way for Purchase Lines, Sales Lines, Transfer Lines, ...

    :wink:
    =D> =D>
    But i meant the TransferReservEntry function, that is called just a moment before the item journal line posting...i meant to say the way that tracking lines are flushed from the document to the journal...it took me some time and multiple clients open to understand this b******d

    about the modification as suggested in the blog...NO WORDS..."Just dance" \:D/ \:D/ \:D/
    Oh! i just noticed that this is my best century post! (the (16th))
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • BeliasBelias Member Posts: 2,998
    i found 2 more places under item tracking lines form/page where we have to populate our fields, so i wanted to share them:
    functions
    CollectPostedTransferEntries
    and
    CollectPostedTransferEntries
    it's easy to understand what to add, here's the sample for the collectpostedtransferentries:
    ...    
        TempTrackingSpecification."Item No." := ItemLedgerEntry."Item No.";
        TempTrackingSpecification."Serial No." := ItemLedgerEntry."Serial No.";
        //-@MHC1.MM 19.05.10        //MM
        TempTrackingSpecification."Vendor Warranty Date" := ItemLedgerEntry."Vendor Warranty Date";
        TempTrackingSpecification."Vendor Lot No." := ItemLedgerEntry."Vendor Lot No.";
        TempTrackingSpecification."Vendor Serial No." := ItemLedgerEntry."Vendor Serial No.";
        TempTrackingSpecification."Test Date" := ItemLedgerEntry."Test Date";
        //+@MHC1.MM 19.05.10
        TempTrackingSpecification."Lot No." := ItemLedgerEntry."Lot No.";
        TempTrackingSpecification."Quantity (Base)" := ItemLedgerEntry.Quantity;
    ...
    
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • meto89meto89 Member Posts: 10
    matttrax wrote:
    I literally wondered for years how to do this. One day I found this great tutorial:

    http://www.nextequalzero.com/2007/12/ho ... ines-form/

    Worked like a charm. I can never quite remember all of the places you have to add code so I refer back to it often. Good luck.

    Hi there,

    i know this post is pretty old, but that is exactly the thing i need to do at the moment. Sadly the tutorial seems to be gone.

    I tried for a few hours to get it working, but i would say i somewhat failed, cause some things aren't working right (guess i missed some of those places).

    Could someone please guide me through the procedure of adding those fields? I would really appreciate it.


    Regards Alex
  • BeliasBelias Member Posts: 2,998
    OMG, that article is gone! :cry:
    i added it to the documentation trigger as a guide for further modification :(
    i'll write it here and in my blog when i'll have some time (i have to recheck my code).
    We can also hope that mattrax or someone else have a cache copy or a copy/paste of that page!
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • teptep Member Posts: 9
    I had just upload a word document, and i believe is the missing part

    (Category: General Downloads)
  • tinoruijstinoruijs Member Posts: 1,226
    Just to make this nice post complete. :-)
    The download: http://www.mibuso.com/dlinfo.asp?FileID=1383

    Tino Ruijs
    Microsoft Dynamics NAV specialist
Sign In or Register to comment.