Slow Journal Writeback for a large number of transactions

Created by Damien Zwillinger, Modified on Tue, 16 Jul at 9:34 AM by Gabriel Michaud

Applies to:

  • Velixo NX
  • Velixo Classic
  • Acumatica, MYOB Acumatica, Cegid XRP Flex


TABLE OF CONTENTS


Overview

Performing a Journal Writeback of a large number of transactions (1000+) can take a longer-than-expected time.

 

Details

The upload time for a Journal Writeback increases non-linearly with the number of transactions in the worksheet:

 

performance_graph.png

Cause

The root cause of this is a performance issue in Acumatica, apparently related to subaccount validation. When data is coming from a source other than Acumatica's Journal Transactions screen, Acumatica appears to perform subaccount defaulting (something that - within Acumatica - is already done while on that Journal Transactions screen). If the number of transactions is small, the issue is not observed, but for lists of more than 1000 transactions, it can take a very long time.

 

Acumatica has acknowledged the issue (case 176646).

 


 

Acumatica has fixed the issue in 2022 R1 Update 4. 


We recommend that you upgrade your ERP system to the specified version, or newer. 

 

 

If upgrading to the latest Acumatica version is not an option at this point of time, you can publish a hotfix that significantly improves the upload performance on your website.

 

Download customization package


❗There is a caveat: after publishing the customization, you will have to always explicitly fill the Subaccount column in the Journal writeback template (e.g. using the default subaccount such as 000-000 if you do not otherwise use subaccounts).

 

wb_gl_performance02.png


The reason for this is that this customization turns off the computationally expensive subaccount defaulting logic in Acumatica's Journal Transactions screen for external tools such as Velixo (workflows happening directly from the Journal Transactions screen will not be affected)


How to Import and Publish a customization project

  • For information on how to import a customization project, see Import a Project in the Acumatica documentation.

  • For information on how to publish a customization project, see Publish a Project in the Acumatica documentation.



Alternative workaround 2 

If you experience this issue and do not wish to install the Acumatica customization, as a workaround, you can use the Load Records from File functionality in the Journal Transactions screen in Acumatica:

 

wb_gl_performance03.png

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article