Inventory questions

[tlh675]

I have Peachtree Accounting and we sell automotive paint. The end product is paint that is mixed from a bunch of different containers. How do I inventory this? When mixed, the paint has a bunch of different prices. I am so confused, please help!!! I have Accounting 2006.

[Taiwanese]

I suggest keeping inventory as how you receive them.

black 1qt
black 1pt
black 1 gallon
etc

When you sell just invoice what you use to mix up that color.

white 1 gallon
red 1qt
(2 items but you gave out 1 large can)

This is the simpliest way.

[avdistribution]

If you want PT to accurately track inventory you are going to have to think of your inventory in terms of lots of small "ingredient" quantities rather than big old one color paint cans-and have a list of those individual ingredients that go into each end product paint. Set up items id's for both those ingredient quantities and the paint in gallons or however you order it. When you receive it you will have to manually delete the ordering id and receive in the smaller ingredient amounts. (Ie if you order a gallon of red and the smallest ingredient quantity you use in mixing is a pint, you receive it as 8 pints of red)
Now your inventory consists of the ingredient quantities.
When you invoice, either invoice the ingredient id's if you can, or reverse the process and build selling id's that will have to be replaced by the ingredients after you've invoiced the customer.
You should be able to use the assembly feature to help with this but I've found it doesn't decrement inventory of individual items when assemblies are sold.
You're in for some trial and error-the good thing is just about everything you do can fairly easily be undone provided you keep at it!
G'luck!

[Markr1306]

The reason it does not reduce the individual items when sold is that you must build that assembly. If you look at your inventory doesn't the qty for assembled item show negative. If it does that means you have sold an assembly which was never "built" first

[avdistribution]

I built separate assemblies for "kits" comprised of individual item id's that together rolled up to the purchase cost and selling price. I wanted PT to do the work of tracking inventory of the components. Everything received ok as individual components but when I invoiced a kit, the inventory of the components was not decremented. So I went back to invoicing each piece. This is not ideal because my customers buy the kits not the pieces and want to be invoiced that way.
Am I doing something wrong?

[Markr1306]

I am in Mass I see you are form Northeast, why don't you contact me off list and maybe I can help
mromboli@webbresearch.com