Check Lot No

xrivo

Hi..

I have to do some ajustements for inventory part from Navision and now I have a problem: How can I test if a Lot No is in system.? ..

Thx

ara3n

go to the item. lookup on quantity on hand. click on showall. Filter on the lot you are looking for.

bbrown

From Item Card:

Item - Entries - Lots

ara3n

What version bbrown? Don't see that on my item card v4.0.

Basically the data is in item ledger. you can get to that table from a lot of places.

bbrown

Sorry, that is one of our customizations.

However, the data is in table 6505 (Lot No. Information):

Key = Item No, Variant Code, Lot No.

ara3n

Table 6505 can be empty based on Item tracking setup. Most client don't fill that field. It a setup in Item trackign whether the user has to fill the Lot No. Information table. Plus the quantity field in that table looks back in Item ledger. So the item ledger has the historical data on a lot. Also if you use warehouse management, the warehouse entry will have addition data.

Fi

Hi there,

Could someone tell me what setting on the Item Tracking Code ensures the Lot No. Information table is populated?

I have everything set on Lot No. tab on my Item Tracking Code, apart from Warehouse Tracking and it still does not get populated for me.

It only seems to get populated when I view the Lot No. Information for an item from the Item Card - Entries - Item Tracking Lines menu option.

I need to implement a change whereby lots are not eligible to be reserved for an item if the status is blocked. To implement this I obviously need to guarantee that there will always be an entry in this table for ALL lots. Has anybody implemented this change before, whereby Lot No. Information table always contains an entry for all lots generated?

I am running Version 5.0.

Thanks,

Fi