Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
2 weeks ago
I have just managed to complete the roll over of the financial year but I noticed that our file size has increased substantially from 762MB to 827MB.
Does this pose any threat to our company database in the future or did I skip a process to reduce the file size?
I noticed that when the file size is large, processes are quite slow.
Solved! Go to Solution.
2 weeks ago
MYOB has 2 AccountRight product ranges, the AR2017 (or Live) range and the v19 (or Classic) range. You did not mention which product version you are using.
With the v19 range, the file size grows doing rollover. There is an inbuilt purge function which purges by default. With the v19 range, file size is an issue. As files get bigger, processing is slower. MYOB therefore provided the purge function to keep file size down. What they often fail to point out (and I don't think the financial year rollover process points this out either) is that the file size will not go down even though records are purged, until the file is Optimised (File > Optimise company file). FYI do this locally not over a network, and you will find the file size will reduce.
With the AR2017 range, technically if designed and coded properly, file size should not matter so much due to the design of the database used. Sure when gathering lots of data, the bigger the file the longer it will take, however when processing individual transactions, file size should not be an issue. MYOB therefore decided NOT to include a Purge function. Nor did they design or code it properly, and so larger files struggle in every regard.
The financial year rollover process is very different in AR2017 and the file size should not grow as a result, unlike the v19 files.
My guess is therefore that you are using v19 - in which case optimisation should reduce the file.
a week ago
Thank you so much for the useful information.
I agree with you that it would be best that after the roll-over instructions, an added step included would be to perform the optimisation process.
I can quickly run processes on MYOB as the file size has greatly reduced from a mammoth size of 800MB to now, 200MB.