Hi @kudzaim20 

Please let us know the version and build you are on. When you mention ‘previously’, has there been any maintenance activity / update performed on your instance since then?

Regards,

Running 2021 R2

Build 21.201.0086

The only maintenance work carried out was to truncate the SMPerformanceInfoSQL  Table and shrink my AcumaticaDB database file.

Hi @kudzaim20  Ideally it should NOT take that much time.

Also, have you tried with the “Parallel Processing” option in the import scenario?

Hi @kudzaim20  Ideally it should NOT take that much time.

Also, have you tried with the “Parallel Processing” option in the import scenario?

 

Let me try the “Parallel Processing” route and see what happens

Hi @kudzaim20  Ideally it should NOT take that much time.

Also, have you tried with the “Parallel Processing” option in the import scenario?

 

Let me try the “Parallel Processing” route and see what happens

What does the “Parallel Processing” option do?

Hi @kudzaim20  If we select the “Parallel Processing” checkbox, internally Import Scenario will create the multiple threads and will execute parallelly. 

 Since threads are executing parallelly hence performance will be improved a lot, hence suggested this option.

Parallel Processing should speed up the import if you don’t already have it enabled. You do want to make sure your data has the key(or keys) marked if you are importing details, otherwise you can run into issues where multiple threads are trying to update the same document at the same time.

There are a number of things that could be slowing down the import(though generally not by that much), but here’s a few off the top of my head:

• If you have any new customizations affecting invoices that could be affecting performance.
• If the previous imports you had migration mode on that could affect performance(migration mode would be quicker) though I doubt by that much.
• If you have a recently integrated tax provider that could be slowing the import down. 
• If you have made any changes in the AR Preferences page that could affect performance.

Hi @kudzaim20 

Pease send your import scenario as well. If ‘commit’ is checked on most columns, it will try save the data for each column mapped ( commit enabled). 

Regards,

I have attached the import scenario in xml format

I have also attached a screenshot of the import scenario 

Hi @kudzaim20  Import Scenario looks good to me. @vkumar  Correct me If I’m wrong here.

I have just enabled the “Commit” on the last row that is the <Action: Save> line, I will monitor to see if import speed has improved.

Hi @kudzaim20 were you able to reach resolution on this issue? Thanks!