News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... An unexpected error oc...

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

Suggested answer

An unexpected error occurred after a database command was cancelled..

(1) Share

Report

Report

Posted on by Community member

4

I'm trying to calculate total amount of amount section of /Posted Sales Invoices/ and put it in cue box.

Here is my code:
Table extension:

Page extension:

I also tried the normal cue layout still got same error. And tried making FieldClass = Normal then adding this to page extension:

And I still keep getting this error.

Categories:

Dynamics 365 Business Central

All responses Img

All responses (3)

Answers Img

Answers (0)

Community member 2 on at

Like (0)

Report

An unexpected error occurred after a database command was cancelled..

Exchange CALCSUM to CALCFIELDS.
Suggested answer

Mohana Yadav 59,194 Super User 2024 Season 2 on at

Like (0)

Report

An unexpected error occurred after a database command was cancelled..

Please try with the Sales Invoice Line. Amount field.
ManishS 6,578 on at

Like (1)

Report

An unexpected error occurred after a database command was cancelled..

Have you added this field in a particular role center, if yes then are you trying to calculate all sales invoice amount or for a specific period.

I don't see any date filter in you calcformula.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans