NAV 2013 Change Item's Variant


I have a bunch of items in our system that currently have no variant assigned and I would like to change them to have an assigned variant. I would have expected the Item Reclass. Journal to be able to handle this (and in fact the help documents do suggest that it would (see here, , where one of the “To” items in that table is: “Change item attributes, such as serial/lot numbers and variant codes.”)). But as far as I can see there is no way to do it. To complicate matters further, several of the items I would like to reclassify are also lot and serial number tracked.

The only way I can see to do this is to do a regular item journal to remove the existing items from inventory (with a negative adjustment) and then do another positive adjustment to add them back in. The major problem with this is that because these items are lot and serial number tracked I need to first go in and select all of the items on the Item Tracking Lines and then on the positive adjustment go in and re-assign the lot and serial numbers. This will be a HUGE pain to do. I figure there HAS to be a better way to do this where I can simply change the variant code without having to re-do all of the lot/serial number information.

Why is there no “New Variant” column on the Item Reclass. Journal? It seems only natural that it would exist along with the “New Lot” and “New Serial” columns.



You are right, the item journal line does not have a “New Variant Code” field - so no way of “reclassifying” an item with a variant.

There is no legal way to do this.
The option with neg/pos adjustment will cause the system to loose track of the item costs.

Anyway what you can do - and that keeps the item costs - is to run this through the BOM Assmbly (Assembly Order).

For Serial Numbers and Lot Numbers the reclassification just works fine.

Or just write a processing only report to update the variant field. Don’t do this unless you have a thorough understanding of what you are doing. Your VAR can do this for you. It is probably worth the cost.

Thanks for the reply Thomas. I never thought of using an assembly order to do this. I just tried it and it works perfectly. It’s just a bit of a pain to have to select the lot/serial number to be consumed and then assign it again for the posted version. But that’s no different than doing an item journal so no loss there. I would say this is a bit more elegant of a solution than using an item journal.

Thanks for the reply Jerry. I will talk to my VAR and see what they say - we’re a pretty small company and are trying to save costs everywhere we can by using the default functionality everywhere we can so unless it’s pretty simple for the VAR to do (1 hour of time?) then we will likely just live with it as it is.

It is not just to update the item ledger entries, but also the shipments, receipts, invoices, credit memos, Phys. Inventory Ledger and so on.
So I would be very careful with such a report.

Anyway - if the suggestions we provided helped you to solve your issue, please click the “Verify Solution” button in those posts.

Yeah I’ve decided that the assembly order method is the way to go. It will be too much work for our VAR to make up this report for the small amount we will use it.

Thanks again for the responses!