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)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

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,698 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 101,416 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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