Originally Posted by
Minty
I don't think there is a correct answer to this. I have seen both approaches used, and personally I don't know what is best.
In a large organisation it seems sensible to keep the two sides of the business separate, if it means duplication then so be it, but your accounts package (assuming you have one in a larger business) will probably end up being the steering force here.
In a large organisation your purchasing department probably don't care about selling stuff and vice versa.
In a small business keeping it together might make more sense.
And yes your customer could be Mr Smith, but he'll still need handling.
One off customers we used to store as a delivery address under a general account of CashSale01.
That way it didn't clutter up our regular customer DB and we could easily search by postcode/name under the Delivery addresses.