Why is importing inventory adjustment incredibly slow?

Question

Hi&nbsp;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.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

gavin12345 · Answer

Hi&nbsp;Leon1973&nbsp;&nbsp;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.&nbsp;There is a way to significantly increase import speeds however only when the file is local, not online.&nbsp;RegardsGavin

mike_james · Answer

Hi Leon1973&nbsp;, to add to Gavin's&nbsp;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&nbsp;Reducing your file size by purging (via a 3rd party service) is another very worthwhile avenue to pursue.

leon1973 · Answer

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

Forum Discussion

Why is importing inventory adjustment incredibly slow?

Looking for something else?

Related content

Inventory Adjustment

Adjustment Note

Leave entitlement adjustments

STP adjust

Importing issue

Inventory Adjustments For Trades

Inventory Stock Adjustment.

Adjustment to recorded pay