mibuso.com
Home› NAV/Navision Classic Client

Item Tracking Entry vs. Reservation Entry

FishermanFisherman Member Posts: 456
edited 2006-12-18 in NAV/Navision Classic Client
All -

I've not been able to find a clear answer to this, so I'm hoping someone can help.

At what point does a document (Sales Order, Purchase Order, Production Order, etc...) create a Reservation Entry, and at what point does it create and Item Tracking Entry. Also - does a Reservation Entry become an Item Tracking Entry at some point?

We need to export some sales information to an XML File, and we are designing an XML Port to do that, but we are unsure of which table to search (Reservation Entry or Item Tracking Entry) for a particular piece of information (it's a custom field that we've added).

Thanks.

Comments

  • giulio.cipogiulio.cipo Member Posts: 77
    Item Tracking Entry ?? maybe you are speaking about Tracking Specification (table 336)

    if your question refers to lot and serial number the 337 is inserted by the user when insert new line in item tracking line form.
    when you post complitely the line (ship and invoice) the system delete the 337 and create 336.
    337 are created only for docuemnt not for journal.
    when you select item tracking line the system create a temp table with line from 336 and 337 and show them.

    there is a white paper on parter source website about it
  • FishermanFisherman Member Posts: 456
    336 and 337...

    I'm assuming that these are entry types in Tracking Specification?

    I don't have access to partner source.
  • FishermanFisherman Member Posts: 456
    I'm sorry, Giulio - I just read your post more thoroughly.

    So table 336 is Tracking Specification and 337 is Reservation Entry.

    So Tracking Specification is not relevant to journals, but Reservation Entry is?
  • kinekine Member Posts: 12,562
    1) Yes, there are tracking entries and reservations (Reservation status...)
    2) Reservation entries are created when you reserve some items on the document. There is pair-system of the entries - there is one entry with entry no. = XXX and Positive = P and second entry with entry no. = XXX and Positive = not P. One is source of the reservation (from where is reserved) and second one is target of the reservation (for what it is reserved).
    3) Tracking entries in reservations are created for example documents created through Requisition journal to keep tracks for which document, prod. order etc. is the purchase, transfer order etc. created. It is like reservation but is not seen in reservations... :-)
    4) And there are two types used for lot and serial no. tracking - sureplus and Prospect.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • darshanmdarshanm Member Posts: 280
    Hi All,

    I am using Navision4.0 sp2.
    I am facing Reservation etry error while posting warehouse shipments.
    I have gone through all your discussios regarding reservatio etry.

    Its correct that system creates two reservation/tracking entries.
    one +ve and other -ve. But in my case for some entries +ve etry gets
    deleted ad while posting the sales line, System gives error
    Reservation Entry=xyz Positve=Yes not foud.

    is there any Hotfix to overcome this error.

    Regards,

    Darshan
    Darshan Mungekar
    Senior Consultan
  • kinekine Member Posts: 12,562
    Not everytime there is the reservation entry pair... some type of reserv. entry have no oposite entry with same no.! For example when you enter the Lot No. on sales order, but you do not have this on stock or you are not using reservations, there is just one entry that this lot no. is requested on the SO but there is not the part "from where it will be taken...".
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.