AL problem.

(1) Share

Report

Posted on by CU07101338-0

123

Hello Everyone!

I hope you are doing well.
Does anyone know why 'No.' cannot be recognized by my code? In table sales line, No. is the name of the field for Item No.

pageextension 50124 "Sales Order Subform Ext" extends "Sales Order Subform"
{
    layout
    {
        addafter("Description")
        {
            // This field is on Sales Line (from my "Sales Line Ext")
            field("Four Digit"; Rec."Four Digit")
            {
                ApplicationArea = All;

                trigger OnValidate()
                var
                    itemRef: Record "Item Reference";
                begin
                    // Filter Item Reference by the same 4-digit code
                    itemRef.SetFilter("Four Digit", Rec."Four Digit");
                    if itemRef.FindFirst() then
                        "No." := itemRef."Item No."
                    else
                        Error('No matching reference for "%1".', Rec."Four Digit");
                end;
            }
        }
    }
}

Categories:

Dynamics 365 Business Central

All responses (1)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 10,694 Super User 2024 Season 2 on at

Like (1)

Report
AL problem.

Hi @CU07101338-0,

You need to add Rec. Before No.

Rec."No." := itemRef."Item No."

Best regards,

Mohamed Amine MAHMOUDI