QB Inventory problem I cannot figure out

It sounds like you would like to track all of the items that are sold in a particular lot.

QB does have a group feature, but, you have to set up all of the items ahead of time, and then group them together to create Lot #6503. However, I'm not sure that this would actually give you any functionality since the intention was to place the group on the invoice. I'm not sure QB can give you the particular information you are looking for, but an Excel spreadsheet could easily be set up to do it.

Gary

I am noy exactly sure what you are trying to do..but maybe as a suggestion you could:

use the lot # as a sub category and the item # when you biuld it have it fall under the sub category of the lot#

lot#6503 would be the main heading and then everything from that lot would have its own item# (the ebay item#)

Is this what you are looking 4 it 2 do?

These are lots of all the same item? Surely you know how many you have after you receive them. QB inventory is pretty basic, not allowing much room for "flexibility". If all the lots are composed of one item (236 widgets, type A) then using inventory would be easy. If the lots comprise a variety of items, QB won't handle it in any easy way.

and, since I sell the

Best,

Peter

I am actually using Excel to do this right now but I was hoping to be able to configure QB to do this.

As for the question regarding the lot content, each lot contains all dissimilar items of varying sizes and which I end up selling for different price.

So, lot 6503, for example, contains 10 items and it cost me $100. I sell the first item for $5, the second for $12, the third for $7, etc. I would like QB to be able to tally the total sales from lot 6503 as I sell from the lot. When all items from the lot have been sold, I'd like to be able to see how much profit, if any, I made on the lot. It sounds as it I am asking too much from QB. As I said, I currently do this all by hand in an Excel spreadhseet and I was hoping to get away from that and have QB take care of it.

I may be missing something here, but using your example, why can't you set up lot 6503 as an inventory item and show the purchase of 10 for $100. As you sell each item, you use that inventory item on your invoice. If you sold the first item for $5, QB would record a sale of $5 with a cost of $10 ($100 lot / 10 items), you lost $5. You sell the second item for $12, QB records a sale of $12 and a cost of $10, you made $2.

After the entire lot is sold, one of the canned reports should tell you your profit or loss for the entire lot.

Larry Stinson Stinson Solutions Inc.