Item Tracking Entry vs. Reservation Entry

Fisherman

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.

giulio.cipo

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

Fisherman

336 and 337...

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

I don't have access to partner source.

Fisherman

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?

kine

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.

darshanm

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

kine

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