For some reason my query, now that Ive populated real data, is counting allocated stock incorrectly.
I know that 2 of one item is allocated, but it counts 4. The dB has some confidential bits in at the moment - somewhere I can host or put it for you to have a look please RainLover?