Improving Inventory Report Speed
Hi, I was wondering if anyone had any tips for improving the speed of generating inventory reports. We have about 17,000 SKUs and running reports on inventory items seem a bit sluggish. We were a...
Forum Discussion
Hi pdranken
Having 17k Items will definitely slow things down. Anything up to 5k is ok, after this performance degrades. Esp if using 'I Inventory' on all the items.
And yes company file size definitely does have an impact - whether the file is held locally or online. And decline is not linear, depends on file specific factors. One user with a file size of 1.5 GB will have minor performance issues, while another user with same file size will have major issues.
De-activating items will make only minor difference, as MYOB often still processes the data, just doesn't display for inactive items. Best to delete items you no longer need.
Get in touch with FGH Tables - they can delete Items in bulk (even if the item has been used), they can also analyse your file for errors, duplicates, balance issues, etc and can reduce your file by purging old transactions. The smaller the file, the better the performance.
Regards
Gavin
Thanks Gavin,
I didn't think it was possible to entirely delete items that have appeared on an invoice or other doctype, is that still the case?
Hi pdranken
It can be done, however only with specialist software, which FGH Tables has access to.
Regards
Gavin
I had a feeling that was the case.
I suppose the best way to check the company file size is to download a backup copy, correct? And then we should assume it's taking up about 30% more space online, correct?
Hi pdranken,
Thanks gavin12345, for sharing insights on this issue. Regarding your concern on the company file size, yes, you make a backup of the online file and restore this to your local Library. We have an Help Article: Deleting or deactivating items, that has more information that you can use as a reference.
Kind Regards,
Cel
