On Thu, 10 Jun 2010 06:39:39 +0100, Steve Cassidy <[email protected]> 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.
