Hi,
We have natural stone business. We buy random size slabs which are serialized at the vendor place and a measurement sheet is attached to check and record the size of each slabs. The UOM for slabs is generally “square foot”.
We want to use serialization while using the UOM as “square foot”. Is that possible?
For example we get 3 slabs of size 48"x72" (inch), 48"x70" and 42"x72". Now the total quantity in square feet of these three slabs is 68.33 . While receiving this quantity we also want to use the serial numbers to track the size of each slab and then use these serials in the inventory tracking.
Serialized Inventory needs the UOM to be a whole number. Your best bet is to use Batch Numbers and have a separate Batch Number for each item/dimension. Like ItemA4872 and ItemA4260 and so on. This way you can minimize the number of batches you have to create as you can reuse existing created batch numbers when deaing with that item/dimension again. Plus Batched Items can have SqFt as the UOM.
The only downside, you have to manage Batch Numbers manually. And you can sell part of a Batched Item. Like if you are dealing with ItemA batch: ItemA48*72 which resolves into 24 SqFt, you can make a transaction on ERPNext for 12SqFt of this item. You may not want that.
And even if you want that you will have to make a “Manufacturing” transaction and break up ItemA Batch ItemA4872 into 2 nos of ItemA Batch ItemA4836 or Batch ItemA24*72.
You can also do this with Serial Numbers but you will need medium level intensity customisation to be able to achieve this.
If you want to get started quickly and, a little inelegantly, I’d suggest Item-Dimension based batch numbers as the way to go for you!