We need to track partial inventory stock accurately. For example, if we purchase 10 sheets (NOS) and sell 50 square feet from two different sheets, ERPNext will show 900 square feet and 9 sheets in stock. However, in reality, we have 8 full sheets and two half sheets. We need a system that accurately reflects stock quantities in both square feet and the number of sheets, including partial sheets.
We are purchasing sheets in NOS (number of sheets) as the UOM, with each sheet containing 100 square feet. For sales, we sell in square feet. We would like to track the batch/serial number for each purchase (NOS), but our default UOM is square feet. How can we manage this in ERPNext?
Here is the conversion:
Square Foot = 100
NOS = 1 sheet