I have some items that I need to maintain an inventory of, but I need to track the individual items’ serial #s and their condition.
For example, I might have several Ubiquiti Dream Machine routers in stock, and all of them have unique serial numbers, and some may be ‘used’ ‘refurbished’ or ‘new’.
If I create each Item as it’s own individual item, then I can’t easily track how many of them are in stock.
Does the ERPNext Item DocType support this? What’s a good way to handle this? Would item variants work for this?
Since you want to track the condition (‘used’ ‘refurbished’ or ‘new’) of an Item at Serial No level, adding a custom field (Condition) to “Serial No” doctype might help.
Inventory Dimensions come to mind. Have you tried creating an inventory dimension for tagging the item as Used or Refurbished?
Check this for more info Inventory Dimension
Looks like system does not allow Inventory Dimension to be used against a Serial No. It can be used at Item level, e.g when an item is added to Purchase Receipt, I can assign that item to a particular Inventory Dimension, but I couldn’t find a way to tag a Serial No to an Inventory Dimension.
I thought tagging the item with the inventory dimension would show it segregated under that dimension in the reports. But does serial number not show in any stock reports?
Yes, tagging the item with the inventory dimension would show it segregated under that dimension in the reports. Using Inventory Dimension could work in this case. Thank you for the suggestion
