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 actually wondering if deactivating item codes we no longer use could speed things up at all?
Does company file size still have an impact on speed now that the file is cloud-hosted? Should we be doing things to try and shrink the size?
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
Hi pdranken,
We hope this message finds you well. We just want to check back with you regarding your concern with your Inventory Report. If you still need assistance with this or if you have other questions or concerns, please do not hesitate to contact us again or you can create a new post. We are happy to assist.
Kind Regards,
Cel
