There are occasions when a decision is made to start using Item Tracking for existing Items. Unfortunately It is not possible to add Item Tracking to Items that already have associated Ledger Entries.
Best Practice to handle this scenario.
Old Item
Use a Item Journal to remove all Inventory of the old Item - negative adjustment
Run the Adjust Cost job for the old Item
Run the Item Valuation Report. The Item should be Qty = 0 and Value = 0
Block the Old Item to prevent further transactions
New Item With Tracking
Create a new Item with the required Tracking information added
Use an Item Journal of Type = Purchase to populate the Inventory of the new item with the proper Cost and Tracking Information
Run the Adjust Cost job for the new Item
Run the Item Valuation Report for the new Item.
- Quantity should be Qty purchased in the Item Journal
- Value should be the Qty purchased in the Item Journal * Cost