We are currently on Navision 4. Over the years our company size has grown and currently stands at around 65GB.
Over the last few years we have a problem with the ‘Calculate inventory’ function while doing the Physical inventory. This process when broken up into several batches takes really long to finish. It takes around 24 hours to complete this before the counting process can start.
It seems like Navision goes through the entire Inventory journal table to calculate the current inventory levels and really takes long. Since I am fairly new to Navision, just need advise from anyone who has experienced similar issues and how can this be improved.
We have looked at deleting data (but which data deletion reports would help in this process). Data compression of Inventory journals (but this report expects all the financial years to be closed! Although the end date was selected as 1 Sep 12, the report was asking to close the current period.).
Is there any way to bypass the calculate inventory process (if yes, is there any flip side to this?).
Any other advice to speed up this process would be appreciated.