Inventory Question: counting, not subtracting, kind of

[dml]

We paint some of our items. This is something itemized on the invoice.

I have it set so that PAINT OPTION is an assembly that I build from the item paint.

Now, we don't want to inventory paint from 100 gallons to 5 gallons, we only want to see how much paint has been used (e.g. 40 gallons this month).

Currently, I have adjusted paint inventory to 100,000 and build each PAINT OPTION assembly when we paint a door (which is, e.g. 720 units of .00175 quantity of paint @ $.50/sqft).

All of these numbers are going down, is it feasible to have them count going up? I would just do negative quanities in the assembly, but that isn't allowed.

Is there another tree I should be barking up?

Thanks in advance.

[Joe Williams]

For the Inventory Assembly to go up you must do Build Assembly for that assembly.
Doing an assembly build just moves the inventory from on e item to the other one. I do not know of any report that reports on that type of usage.