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

How to extend a CalcFormula in a TableExtension

(0) Share

Report

Posted on by A BC Developer

We'd like to set a custom filter on the Field `Acquisition Cost`. The current CalcFormula is

 field(15; "Acquisition Cost"; Decimal)
{
    AutoFormatType = 1;
    CalcFormula = Sum("FA Ledger Entry".Amount WHERE("FA No." = FIELD("FA No."),
                                                      "Depreciation Book Code" = FIELD("Depreciation Book Code"),
                                                      "FA Posting Category" = CONST(" "),
                                                      "FA Posting Type" = CONST("Acquisition Cost"),
                                                      "FA Posting Date" = FIELD("FA Posting Date Filter")));
    Caption = 'Acquisition Cost';
    Editable = false;
    FieldClass = FlowField;
}

We'd like to have it something like this:

 field(15; "Acquisition Cost"; Decimal)
{
    AutoFormatType = 1;
    CalcFormula = Sum("FA Ledger Entry".Amount WHERE("FA No." = FIELD("FA No."),
                                                      "Depreciation Book Code" = FIELD("Depreciation Book Code"),
                                                      "FA Posting Category" = CONST(" "),
                                                      "FA Posting Type" = CONST("Acquisition Cost" | "OUR CUSTOM VALUE"), // <<- Add this
                                                      "FA Posting Date" = FIELD("FA Posting Date Filter")));
    Caption = 'Acquisition Cost';
    Editable = false;
    FieldClass = FlowField;
}

Is there any way to do this? Thanks for your help

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi,

As of now there is no way to customize calcformula, but there is workaround you can use, please refer below link

community.dynamics.com/.../workaround-to-modify-standard-table-field-calcformula

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (0)

Report

Calcformula is a property that can not be extended:

docs.microsoft.com/.../devenv-table-properties

You have to create a new field instead.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, As mentioned by several experts above, the property 'CalcFormula' cannot be customized.

So, please hide the existing field and create a new one.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No