Condition on CALCSUMS use

Business Central/NAV Developers Forum
1

Hi everyone,

I know may be it is common knowledge but I need to know: if I use CALCSUMS on a field, does that field have to be a flowfield?

Thanks in advance [:)]

2

CALCSUMS calculates the total of a column of SumIndexFields in a C/SIDE table.

Using parameters, you can specify which fields to calculate.

As you can see from the example here: http://msdn.microsoft.com/en-us/library/dd301396.aspx

"Cust. Ledger Entry".SETCURRENTKEY("Customer No.","Date");
"Cust. Ledger Entry".SETRANGE("Customer No.", 'AAA 1050');
"Cust. Ledger Entry".SETRANGE("Date", 010196D, 123196D);
"Cust. Ledger Entry".CALCSUMS("Amount");

Cust.Ledger Entry.Amount is not a flowfield.

CALCFIELDS is used with flowfields.