Why is importing inventory adjustment incredibly slow?

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Leon1973
Experienced Cover User
21 Posts
Experienced Cover User
Australia
Experienced Cover User

21Posts

1Kudos

0Solutions

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.

 

 

 

 

 

3 REPLIES 3
gavin12345
Ultimate User
4,953 Posts
Ultimate User
Australia
Ultimate User

4,953Posts

1,000Kudos

633Solutions

Re: Why is importing inventory adjustment incredibly slow?

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

(gavinw222@gmail.com)
Mike_James
Ultimate Partner
5,839 Posts
Ultimate Partner
New Zealand
Ultimate Partner

5,839Posts

1,080Kudos

755Solutions

Re: Why is importing inventory adjustment incredibly slow?

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.


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)

Bulk download of attachments (more details...)

Leon1973
Experienced Cover User
21 Posts
Experienced Cover User
Australia
Experienced Cover User

21Posts

1Kudos

0Solutions

Re: Why is importing inventory adjustment incredibly slow?

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

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post