Thanks for your help, it doesn't quite resolve the problem and it would be great if your developers could add a stock on hand and a stock in transit columns on the inventory.

I'm going to have to find one of the solutions you mentioned until then.