same product differnt serial no.

[Benet]

Im looking for ideas to streamline a customer/stock/job/invoice type solution.

My stock db contains every individual item of stock available.

clearly there are multiples of same stock items.

Item A serial no 1

Item A serial no 2

Item B serial no 1

Item B serial no 2 etc.

When it comes to invoicing i would clearly rather have the invoice say customer .. buys 20 x Item A and 10 x Item B rather than listing each item one by one with its serial. However item serial numbers must be logged into the sale so that items can be tracked both to customers and removed from stock accurately.

Im sure this problem has been addressed on many occasions. Im not looking for a complete answer just maybe some suggestions as to how to approach this or examples of how people have dealt with it in the past.

Any ideas would be much appreciated.

Thanks

Ben