I'm looking for ideas as to the best way to consume packaging in work orders.

We sell products in various packaging....totes, drums, pails, etc.

Currently the packaging is relieved from inventory at time of sales invoicing.....packaging codes are listed in sales order.

But we may have product sitting on the floor waiting to ship so our packaging stock quantities will not be a true number for empty available to use packaging.

In otherwords if I was to look up out tote stock quantity the number will include all the empty totes plus any filled totes sitting on the floor waiting to ship.

If we consume the packaging through the work order then the stock quanitity will be a true number of empty available totes.

So for example say a tote holds 1000 kgs.  How do I change my BOM so that if the work order calls for 5000kgs it will automatically consume 5 totes.  

Also is there a way for the Stock Valuation Report to list the packaging quantities instead of total kgs?

Thank you.