Nigel Titley wrote:
I'm intrigued by your comment "The balance should be the items on hand (although this isn't true if you use the shipping function for sales orders...)." What is different about the shipping function. We do indeed use this when shipping. Is it a bug or a feature that it gets the inventory wrong?
Shipping decreases the inventory in the order stage. Otherwise you just tot up the invoices to get stock. So you really need to sum invoices, plus "shipped" units to get current stock (or something like that - not investigated the ship bit - gave up using it when I found it buggy)
Good luck Ed W