Maintain stock with serials in nos and kgs with no fixed conversion formula
My client wants to use SAP only for tracking his inventory. He deals primarily in 4-5 items types of packaging material.
He purchases the packaging material in rolls and wants to track them by no. of rolls as well as kgs. Each roll has a unique serial no, so I have enabled Serial Numbers for all the items On Every Transaction.
If I use Kgs as the Inventory Unit, I can track the stock by Kgs as well as no. of rolls as the no. of rolls = no. of serials available in the system.
But the side effect is that while entering the Opening Balance, the system will prompt me to enter as many Serial Nos. as the qty in Kgs, which is wrong, as each roll can be of varying weight or Kgs.
On the other hand, if I use No. of Rolls as the Inventory Unit, how do I track the total stock in Kgs.?
For each serial, how do I specify the weight in Kgs and how do I get a report for each item's stock in no. of rolls as well as Kgs.?
Note that there is no standard weight for each roll. Each roll can have varying weight.