Lot Specific Tracking on Items with Item Ledger Entries

Dynamics 365 Business Central/NAV User Forum
1

Hello,

I have several items with entries, that I want to track with lot numbers. How do I specify lot numbers to entries allready posted? Is there any way to do this?

I tried changing the information necessary directly on the item ledger entries, which worked, but I guess this is a bad solution in the long run if an end user is to do it.

Thanks in advance!

/Petan

2

You can not add Lot information (as well as anything else) to posted entries.

Besides:

Lot/Serial info is not stored in ILE table, you would better don’t mess with these tables directly, as this can cause serious trouble.

added/ actually is, but for quick reference only - it’s not the MAIN place of tracing data /added

YES it is a bad solution (actually in this case it is not a solutioan at all) and Enduser should NEVER be allowed to do something in any Tables - their license doesn’t allow it physically, how do you imagine them to do things like this?

3

Hi Petan,

Secondly, it will have an adverse effect on Costing. Generally, in Business companies use Lot Numbers for 3 purposes: Tracking, Costing & Expiry.

If Costing gets messed up, there will be an Huge Impact on Finance. So, the result is Catostrophic.

Suggest your Client to Start with a new Item Numbers for those which Lot Numbers were missed out and Block the old Items.

2 Methods to Suggest:

  1. You can sell out completely and block the Old Item and then start with the New Items.

or

  1. You can do a negative adjustment to the Items without lot Numbers and make it to Zero and then do a positive adjustment by assigning a lot numbers to the New Item Numbers. But then you have to make sure on the Outstanding Orders, Shipped not Invoiced, received not Invoiced, Warehouse Transfers, Production Journals…etc. It’s quite a Tedious job.

I would suggest, follow the 1st method given your Scenario.