On Thu, 10 Jun 2010 06:39:39 +0100, Steve Cassidy
<[log in to unmask]> wrote:


>The only comment I would make would be this: don't attempt to
>calculate all of this on the fly (from initial inventory) every time
>you need an inventory figure (such as when entering a sales order line
>item). You will wait while it calculates, and the wait will increase
>as time goes by and more related records have to be summed.

I'm still on design level in this.
Like Richard stated in his post, I'm looking at consolidation moments/methods.

The final version will be a multi-user. So I have to look at all possible
scenarios and their impact.

I have to find the most adequate way to give the user the info he/she needs
at the moment it is needed, without (too much) speed loss.

It's good to have a place to brain storm a little.

Thanks guys.