Small and medium business | Business Central, N...

Time of posting an invoice

(0) Share

Report

Posted on by Karsten_JR

We have an API that imports journal lines into a journal for later posting.

One invoice could be at about 3000 lines, and it will take about 35 minutes to post it, during which period no futher import of lines is possible and no other users can post anything.

Is this normal, the time it takes to post - I meen?

Currently we are developing a solution that imports in one journal and prior to posting BC copies the line to a different journal, so that posting will not prevent new lines in beeing imported.

But still all posting is blocked for 30 minutes or so, while posting on journal at 3000 lines.

Is it normal that only one user can post journal lines at a time or are there a "work around" like using different jounals, sales, finance, etc.

Categories:

Dynamics 365 Business Central

All responses (7)

Answers (0)

Karsten_JR 15 on at

Like (0)

Report

RE: Time of posting an invoice

I am only aware of customization when importing the data (API) - the posting it selves should not be customized.
Suggested answer

YUN ZHU 85,845 Super User 2025 Season 1 on at

Like (0)

Report

RE: Time of posting an invoice

Hi, This situation is normal, because the table will be locked when posting.
But what confuses me is does it take 35 minutes to post 3000 lines? Is there any customization here?

Also I think you should execute this API outside working hours.

Hope this helps.

Thanks.

ZHU
Suggested answer

Inge M. Bruvik 1,029 Moderator on at

Like (0)

Report

RE: Time of posting an invoice

[quote user="Karsten_JR"]
Thanks for answers.

I have a quite good knowledge around locked tables etc. so I will take it from her - with my developers...

But the other half of the question? Is it normal to spend around 30 minutes on posting 3000 lines?
[/quote]
Are you on prem or on BC online?
Suggested answer

Amit Baru 3,029 on at

Like (0)

Report

RE: Time of posting an invoice

Hi,

It depends upon your server configuration and Internet seed.

But i have felt same issue in many clients. So according to me its normal.

Regards

Amit Sharma

www.erpconsultors.com
Karsten_JR 15 on at

Like (0)

Report

RE: Time of posting an invoice

Thanks for answers.

I have a quite good knowledge around locked tables etc. so I will take it from her - with my developers...

But the other half of the question? Is it normal to spend around 30 minutes on posting 3000 lines?
Suggested answer

Amit Baru 3,029 on at

Like (0)

Report

RE: Time of posting an invoice

Hi,

The above is not issue. It is standard, You are facing lock table issue. When bulk entries posted then this type of error is coming. It is normal. Because while posting, System locks posted table.

As per mu suggestion. Enter the Bulk entries in Buffer table and create on batch job which will post these entries one by one with time interval. So locking issue reduce at some extent.,

Regards

Amit Sharma

www.erpconsultors.com

www.linkedin.com/.../
Suggested answer

Nitin Verma 21,569 Moderator on at

Like (0)

Report

RE: Time of posting an invoice

Hi,

You can introduce Job queue concept with Codeunit, so that It execute all your process at back end.

Thanks.