Lot No Description gets lost after Posting Receipt

knm

Hi,

I'm currently testing out NAV 2009 R2, and I have a quesion with regards to Lot Tracking Entries.

When receiving items into Warehouse, I manually assigned a lot number, and then assigned a Description in the "Item Tracking Lines" page.
Something like below.
Lot No. = Lot 1-1
Description = Lot Line 1 Part 1

And after posting the receiving, I tried to retrieve the "Description" that I entered in NAV, but I'm having trouble where to find it.

I couldn't find it on "Item Ledger" table, and "LOt No Information" table, does this mean that the "Description" that I entered doesn't get saved in the database after posting?

Please let me know.

Thank you.

Kenji

kapil4dynamics

I remember I did get it customized to retrieve it for reporting, that means it hasn't been changed.

knm

So does this mean that "Description" in the "Item Tracking Lines" table doesn't get saved in any of the tables in NAV 2009 R2 once it gets posted?

Kenji

kapil4dynamics

I am sure about Item Ledger table but for "any table" I am not sure.

Deep

The description is stored in "Tracking Specification" table and can be retrieved from there for the order.

kapil4dynamics

Deep wrote:

The description is stored in "Tracking Specification" table and can be retrieved from there for the order.

Sure, I mean, have you ever retrieved data from this table after posting :shock: ?

Deep

Never got such requirement till date.

kapil4dynamics

Deep wrote:

Never got such requirement till date.

That means u just answered for sake of it ?

Deep

kapil4dynamics wrote:

Deep wrote:

Never got such requirement till date.

That means u just answered for sake of it ?

I believe that my answer is surely regarding the question which was asked, and was correct in terms of information.
Requesting you not to clutter this place by posting comments unnecessarily, and let it have what is supposed to be here.

knm

OK, in "Tracking Specification" once the Transaction is posted the entries that were saved in "Tracking Specification" will get removed from the table, and will be lost forever. (doesn't get transferred to anywhere)

That being said, is this true that I have to create a customization so that the "Description" entered in "Tracking Specification" table be transferred to somewhere else?

Thank you.

Kenji

kapil4dynamics

X

Deep

For sure you need to store the lot description, if the invoiced purchase order is also deleted.
You can store the lot description in the Item Ledger, or purchase receipt line, as per your requirement.