Lot No updation in old ILEs

Pandian_Nav

Hai all,

We are using NAV 5.0 SP1,and now we needs to create a New report for the Old Item ledger entries which are all not having the Lot no and having the Item Tracking code in the Item card currently.

This is because during the OB importing the client was not having the Lot no information for all the Items but will be using it in future hence we have removed the Lot specific tracking in the Item Tracking card so that whenever they wants to activate they can activate the Tracking.

Now some of the Items were not having the Lot no in the ILEs but later activated with tracking,so while it tries to consume the lot it needs lot no where as the old ILEs are not having the Lot no hence throws an error "Item Tracking can not be matched".

So Now we need to update the old ILEs with out Lot no by creating a New report but similarly we needs to update the relative tables like Table 336 (Tracking specification),Table 337 (Reservation entry) & Item application entry (Table 339)...
I do not have a clear cut idea on updating the table 336 & 337 and what will be the implication if these tables were not updated properly.

So kindly give us your suggestions that what are all the points to be considered during the developement of this report so that it will be greater help for me.

Thanks in Advance.

Sunset

Don't do it on the same items that you started up with. There is a reason why TestNoEntriesExist is called over and over again!


Instead make a item journals to adjust the old items down to 0, and make new items that you adjust to the level of the old item. Before posting the new items you add the itemtracking that you want for that specific item.

rajatkalia

HI

The system does not allow to activate or deactivate Item tracking if there are any ILE for the Items, so how r u able to activate the lot tracking after posting the op. bal.

As Sunset suggested u will hav to first get the Invent of those Items as 0 and then create new Items with Lot tracking enabled and then post op. bal.

Regards,
Rajat.

David_Singleton

Pandian_Nav wrote:

This is because during the OB importing the client was not having the Lot no information for all the Items but will be using it in future hence we have removed the Lot specific tracking in the Item Tracking card so that whenever they wants to activate they can activate the Tracking.

At the point of Go-Live when you made this decision, you should have thought of this. During the Go-Live process you don't say "Hmm that looks complex we will handle that later" unless you have a FULLY TESTED plan on how you will handle it later.

Now is "later" and its time to pay for the earlier mistakes.