Forum Discussion

Leon1973's avatar
Leon1973
Experienced Cover User
2 years ago

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.

 

 

 

 

 

  • Hi Leon1973 

     

    Unfortunately the 'slowness' of importing in AR2023 is not limited to Inventory Adjustments, all importing is considerably slower than v19 importing. Moderators often recommend the user takes the file offline for such processes and then restore online when you are done. Importing offline is marginally faster and less likely to timeout. Look into applying the timeout extender as well.

     

    There is a way to significantly increase import speeds however only when the file is local, not online.

     

    Regards

    Gavin

    • Mike_James's avatar
      Mike_James
      Ultimate Cover User

      Hi Leon1973 , to add to Gavin's comments, it sounds like your file is very large. Posting transactions to the file via the API is an alternative approach. Results would be less dependent on file size. We do a lot of similar work for clients, highly customized

       

      Reducing your file size by purging (via a 3rd party service) is another very worthwhile avenue to pursue.

      • Leon1973's avatar
        Leon1973
        Experienced Cover User

        Thank you both for your replies. I take it there is no fix in sight? We have asked support previously but nothing resolved several years later. Gavin - importing payroll every fortnight takes 20 mins, new items several minutes but still manageable compared to inventory.

        We will look at offline but we can only do on weekends. Mike, we don't notice the file size for other things like opending reports, creating orders - it is laggy compared to running offline but only a second or two, nothing crazy. Will consider a custom interface from you in future but we are hesitant to pay for an alternative to a feature that used to work perfectly fine and is now broken.

         

        Thanks

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.