adding fields to tracking specification

Belias

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:

matttrax

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.

lyot

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.

lyot

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>

Belias

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:

matttrax

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/

Belias

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)

lyot

http://mibuso.com/blogs/lyot/2010/04/08 ... nal-lines/

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

Belias

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, ...

=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))

Belias

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;
...

meto89

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

Belias

OMG, that article is gone!
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!

tep

I had just upload a word document, and i believe is the missing part

(Category: General Downloads)

tinoruijs

Just to make this nice post complete. :-)
The download: http://www.mibuso.com/dlinfo.asp?FileID=1383