Why is importing inventory adjustment incredibly slow?
Hi
We have around 10-15,000 inventory adjustements every year and have an Excel macro to get data from MYOB, create CSV files and import the adjustments (we buy lots of individual stock items, build this into equipment hence easier to adjust in Excel). Before we had to go to cloud based MYOB we could import 10,000 in a few minutes. Now it can only import 100 adjustments before it times out. We have broken the data into files each of 100 records, each now takes over an hour to import which is incredibly slow for a few brief records. This was frustrating enough, but now for example it will import say 12 records with no errors, 20 with errors, 1 skipped and then says it is finished despite there being 100 records in the file. When we click the log hyperlink nothing happens and there is no log on our drive we can look at. Sometimes it will import the full 100, other times just a fraction.