Dynamics Community Forum Thread Details

Display the field salesLineSystemId from the Sales Line table in the Item API page

Hello ,

I created an API page that get SourceTable=Item, and I try to display the field salesLineSystemId from the Sales Line table in the Item API page. My AL code is below but it seems not working properly.

Could you please help me to review my code? Thanks a lot for your time.

page 50137 ItemAPI
{
    PageType = API;
    SourceTable = Item;
    ODataKeyFields = "systemId";

    layout
    {
        area(content)
        {
            repeater(General)
            {
                ...........................................
                field(salesLineSystemId; salesLineSystemId)
                {
                    Caption = 'Sales Line System Id';
                    ToolTip = 'Sales Line System Id';
                }
            }
        }
    }

    var
        salesLine: Record "Sales Line";
        salesHeader: Record "Sales Header";
        salesLineSystemId: Guid;

    trigger OnAfterGetRecord()
    BEGIN
        SalesLine.SETRANGE(SalesLine."No.", Rec."No.");
        IF SalesLine.FINDSET THEN BEGIN
            REPEAT
                SalesHeader.SETCURRENTKEY("Document Type", "No.");
                SalesHeader.SETRANGE("Document Type", SalesLine."Document Type");
                SalesHeader.SETRANGE("No.", SalesLine."Document No.");
                IF SalesHeader.FINDSET THEN
                    salesLineSystemId := salesLine.SystemId
                ELSE
                    salesLineSystemId := '{00000000-0000-0000-0000-000000000000}'; 
            UNTIL SalesLine.NEXT = 0;
        END;
    END;
}

Categories:

Dynamics 365 Business Central

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS