web

You’re offline. This is a read only version of the page.

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 CU27040946-4

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

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

ManishS 86 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,242 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Please try with the Sales Invoice Line. Amount field.

Was this reply helpful? Yes No
BB-27040929-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Exchange CALCSUM to CALCFIELDS.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 649 Super User 2026 Season 1

#2

Gerardo Rentería Ga... 447 Most Valuable Professional

#3

YUN ZHU 388 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans