This was in another thread [https://usergroup.netsuite.com/users/showthread.php?t=5533] but thought I should open a new one specific to my issue.
I just performed some imports of inventory items for a client. A handful (small amount, maybe 5 or 10) were realized after the fact to be items with serial numbers. Oops, they got imported as normal Inventory Items.
The quantities of these items varies from a few to many but they have no transactions against them at the moment. I was hoping there was a way to convert these to a different type but reading this thread, got very discouraged. Hoping newer versions of NetSuite have some course you can take but the help pages don't show anything I can find.
...
Anyone have any good ideas how I can correct this for them. We are not opposed to journal entry corrections after the fact, just want to get it corrected.
1. Does anyone have a recommendation on how to directly convert an inventory item with no transactions against it, to a serialized inventory item? 2. If not able to do a direct conversion, can someone offer the best practice for converting this through inventory adjustment, or other method? Was thinking will probably change the name of the items, write them down to an expense account, using inventory adjustment to reduce the quantities to 0, then creating the new serialized items, and use inventory adjust to add in the same quantities and costs with serial numbers into a Opening Balance/equity account (which I think balances out the two accounts to put us back to correct value). Is the above the right approach or is there a better method? And, can I delete the old items from the system once they have no quantities or can I only inactivate. Appreciate any insight to help me plan this out correctly. Thanks.-Steve