Dynamics Community Forum Thread Details

Error "FlowField in the xxxxxx table must be Decimal" after server Runtime update to 13.1

Hi all.

I have a BC extension that has been installed and working for a couple of years now. Recently our cloud server was updated to runtime version 13.1.

After that, all attempts to push data using our API fails with multiple errors such as:

{"error":{"code":"Unknown","message":"The type of the Supplier Name FlowField in the xxxxxx table must be Decimal. CorrelationId: adab4751-3614-46a5-932b-fcc14f1bf20f."}} | Microsoft.OData.Client.DataServiceClientException: {"error":{"code":"Unknown","message":"The type of the Supplier Name FlowField in the xxxxxx table must be Decimal. CorrelationId: adab4751-3614-46a5-932b-fcc14f1bf20f."}}

Here's how the Supplier Name field is declared:

        field(9; "Supplier Code"; Code[20])

{

            DataClassification = CustomerContent;

            TableRelation = Vendor;

}

        field(10; "Supplier Name"; Text[100])
        {
            Editable = false;
            FieldClass = FlowField;
            CalcFormula = lookup(Vendor.Name where("No." = field("Supplier Code")));
        }
 
In table Vendor, fields "No." and "Name" are declared as:
 
        field(1; "No."; Code[20])
        {
            Caption = 'No.';
            trigger OnValidate()
            begin
               // some validation code here
            end;
        }
        field(2; Name; Text[100])
        {
            Caption = 'Name';
            trigger OnValidate()
            begin
               // some validation code here
            end;
        }
 

This always worked correctly and except when pushing the data through the API, everything works as expected. It started failing after server update to 13.1 and I have no idea why....

Any ideas what is causing this issue and how to resolve it?

Thanks in advance.

Categories:

Dynamics 365 Business Central

Quick Links