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

Copy Pasting is taking So long in Business Central 19.5 On prem

(0) Share

Report

Posted on by riya patel

Hello experts,

We have one client who is copy pasting data from Excel to Purchase Journal , 180 lines is taking approx 4 hours in copy pasting, we have also checked the system configuration but it seems fine.

Please help as this is creating so much issue.

Regards,

Patel Riya

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

you can use Configuration Package instead to insert bulk data into Purchase Journal.

There is a Table 81 is behind you can use this table while designing config. package.

Thanks

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,681 Super User 2025 Season 2 on at

Like (0)

Report

This looks like a security settings issue other than performance.
Will copying directly on the server have this problem?

Was this reply helpful? Yes No
riya patel 82 on at

Like (0)

Report

Thanks for the reply but while using config package the gst and tds are not auto calculated so than we have a problem that's why we opted for copy pasting.

Was this reply helpful? Yes No
riya patel 82 on at

Like (0)

Report

Thanks for the reply,

Yes we have the same code in UAT too but that is performing just fine, but prod is taking so much time could you please tell us more about security settings how we can find it?

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

Does this issue happen within a CRONUS company and is there customization in place? Last does this issue also happen within other parts of the application?

Thank you.

Was this reply helpful? Yes No
riya patel 82 on at

Like (0)

Report

Hello Marco,

Thanks for the reply.

We have tried removing all the customization but still it was the same. No other parts like sales journal is working fine like for 100 lines it is taking approx. 30 seconds.

Thanks,

Riya Patel

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

It looks like there is still some customization in place. What happens if you only add the mandatory fields that are included out of the box via Excel?

Thank you,

Was this reply helpful? Yes No