Table 7114 Analysis Line

Base Application, Microsoft.Inventory.Analysis

src/Layers/W1/BaseApp/Inventory/Analysis/AnalysisLine.Table.al529 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Inventory.Analysis;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.Enums;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using Microsoft.Inventory.Setup;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Setup;table 7114 "Analysis Line"{    Caption = 'Analysis Line';    DrillDownPageID = "Inventory Analysis Lines";    LookupPageID = "Inventory Analysis Lines";    DataClassification = CustomerContent;    fields    {        field(1; "Analysis Area"; Enum "Analysis Area Type")        {            Caption = 'Analysis Area';        }        field(2; "Analysis Line Template Name"; Code[10])        {            Caption = 'Analysis Line Template Name';            TableRelation = "Analysis Line Template".Name where("Analysis Area" = field("Analysis Area"));        }        field(3; "Line No."; Integer)        {            Caption = 'Line No.';        }        field(4; "Row Ref. No."; Code[20])        {            Caption = 'Row Ref. No.';            ToolTip = 'Specifies a row reference number for the analysis line.';            trigger OnValidate()            begin                if "Row Ref. No." <> xRec."Row Ref. No." then                    SubstRowRefNo(xRec."Row Ref. No.", "Row Ref. No.");            end;        }        field(5; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies a description for the analysis line.';        }        field(6; Type; Enum "Analysis Line Type")        {            Caption = 'Type';            ToolTip = 'Specifies the type of totaling for the analysis line. The type determines which items within the totaling range that you specify in the Range field will be totaled.';            trigger OnValidate()            var                InventorySetup: Record "Inventory Setup";                SalesSetup: Record "Sales & Receivables Setup";            begin                if Type <> xRec.Type then                    Range := '';                Validate(Range);                case Type of                    Type::"Item Group":                        begin                            InventorySetup.Get();                            InventorySetup.TestField("Item Group Dimension Code");                            "Group Dimension Code" := InventorySetup."Item Group Dimension Code";                        end;                    Type::"Customer Group":                        begin                            SalesSetup.Get();                            SalesSetup.TestField("Customer Group Dimension Code");                            "Group Dimension Code" := SalesSetup."Customer Group Dimension Code";                        end;                    Type::"Sales/Purchase person":                        begin                            SalesSetup.Get();                            SalesSetup.TestField("Salesperson Dimension Code");                            "Group Dimension Code" := SalesSetup."Salesperson Dimension Code";                        end;                    else                        "Group Dimension Code" := '';                end;            end;        }        field(7; Range; Text[250])        {            Caption = 'Range';            ToolTip = 'Specifies the number or formula of the type to use to calculate the total for this line.';            TableRelation = if (Type = const(Item)) Item            else            if (Type = const(Customer)) Customer            else            if (Type = const(Vendor)) Vendor            else            if (Type = const("Item Group")) "Dimension Value".Code where("Dimension Code" = field("Group Dimension Code"), Blocked = const(false))            else            if (Type = const("Customer Group")) "Dimension Value".Code where("Dimension Code" = field("Group Dimension Code"), Blocked = const(false))            else            if (Type = const("Sales/Purchase person")) "Dimension Value".Code where("Dimension Code" = field("Group Dimension Code"), Blocked = const(false));            ValidateTableRelation = false;            trigger OnValidate()            var                Item: Record Item;                Cust: Record Customer;                Vend: Record Vendor;                ItemStatisticBuf: Record "Item Statistics Buffer";            begin                case Type of                    Type::Item:                        Item.SetFilter("No.", Range);                    Type::Customer:                        Cust.SetFilter("No.", Range);                    Type::Vendor:                        Vend.SetFilter("No.", Range);                    Type::"Item Group", Type::"Customer Group", Type::"Sales/Purchase person":                        ItemStatisticBuf.SetFilter("Dimension 1 Filter", Range);                    Type::Formula:                        begin                            Range := UpperCase(Range);                            CheckFormula(Range);                        end;                end;            end;        }        field(8; "New Page"; Boolean)        {            Caption = 'New Page';            ToolTip = 'Specifies if you want a page break after the current line when you print the analysis report.';        }        field(9; Show; Option)        {            Caption = 'Show';            ToolTip = 'Specifies whether you want the analysis line to be included when you print the report.';            OptionCaption = 'Yes,No,If Any Column Not Zero';            OptionMembers = Yes,No,"If Any Column Not Zero";        }        field(10; Bold; Boolean)        {            Caption = 'Bold';            ToolTip = 'Specifies if you want the amounts on this line to be printed in bold.';        }        field(11; Italic; Boolean)        {            Caption = 'Italic';            ToolTip = 'Specifies if you want the amounts in this line to be printed in italics.';        }        field(12; Underline; Boolean)        {            Caption = 'Underline';            ToolTip = 'Specifies if you want the amounts in this line to be underlined when printed.';        }        field(13; "Show Opposite Sign"; Boolean)        {            Caption = 'Show Opposite Sign';            ToolTip = 'Specifies if you want sales and negative adjustments to be shown as positive amounts and purchases and positive adjustments to be shown as negative amounts.';        }        field(14; "Source Type Filter"; Enum "Analysis Source Type")        {            Caption = 'Source Type Filter';            FieldClass = FlowFilter;        }        field(15; "Date Filter"; Date)        {            Caption = 'Date Filter';            FieldClass = FlowFilter;        }        field(16; "Item Budget Filter"; Code[10])        {            Caption = 'Item Budget Filter';            FieldClass = FlowFilter;            TableRelation = "Item Budget Name".Name where("Analysis Area" = field("Analysis Area"));        }        field(17; "Location Filter"; Code[10])        {            Caption = 'Location Filter';            FieldClass = FlowFilter;            TableRelation = Location;        }        field(18; "Dimension 1 Filter"; Code[20])        {            CaptionClass = GetCaptionClass(1);            Caption = 'Dimension 1 Filter';            FieldClass = FlowFilter;        }        field(19; "Dimension 2 Filter"; Code[20])        {            CaptionClass = GetCaptionClass(2);            Caption = 'Dimension 2 Filter';            FieldClass = FlowFilter;        }        field(20; "Dimension 3 Filter"; Code[20])        {            CaptionClass = GetCaptionClass(3);            Caption = 'Dimension 3 Filter';            FieldClass = FlowFilter;        }        field(21; "Dimension 1 Totaling"; Text[80])        {            AccessByPermission = TableData Dimension = R;            CaptionClass = GetCaptionClass(4);            Caption = 'Dimension 1 Totaling';            ToolTip = 'Specifies which dimension value amounts will be totaled on this line.';            //The property 'ValidateTableRelation' can only be set if the property 'TableRelation' is set            //ValidateTableRelation = false;        }        field(22; "Dimension 2 Totaling"; Text[80])        {            AccessByPermission = TableData Dimension = R;            CaptionClass = GetCaptionClass(5);            Caption = 'Dimension 2 Totaling';            ToolTip = 'Specifies which dimension value amounts will be totaled on this line. If the type on the line is Formula, this field must be blank. Also, if you do not want the amounts on the line to be filtered by dimensions, this field must be blank.';            //The property 'ValidateTableRelation' can only be set if the property 'TableRelation' is set            //ValidateTableRelation = false;        }        field(23; "Dimension 3 Totaling"; Text[80])        {            AccessByPermission = TableData "Dimension Combination" = R;            CaptionClass = GetCaptionClass(6);            Caption = 'Dimension 3 Totaling';            ToolTip = 'Specifies which dimension value amounts will be totaled on this line. If the type on the line is Formula, this field must be blank. Also, if you do not want the amounts on the line to be filtered by dimensions, this field must be blank.';            //The property 'ValidateTableRelation' can only be set if the property 'TableRelation' is set            //ValidateTableRelation = false;        }        field(24; "Source No. Filter"; Code[20])        {            Caption = 'Source No. Filter';            FieldClass = FlowFilter;            TableRelation = if ("Source Type Filter" = const(Customer)) Customer            else            if ("Source Type Filter" = const(Vendor)) Vendor            else            if ("Source Type Filter" = const(Item)) Item;        }        field(25; "Group Dimension Code"; Code[20])        {            Caption = 'Group Dimension Code';            TableRelation = Dimension;        }        field(26; Indentation; Integer)        {            Caption = 'Indentation';            ToolTip = 'Specifies the indentation of the line.';            MinValue = 0;            trigger OnValidate()            begin                if Indentation < 0 then                    Indentation := 0;            end;        }    }    keys    {        key(Key1; "Analysis Area", "Analysis Line Template Name", "Line No.")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnInsert()    var        AnalysisLineTemplate: Record "Analysis Line Template";    begin        LockTable();        AnalysisLineTemplate.Get("Analysis Area", "Analysis Line Template Name");        if Indentation < 0 then            Indentation := 0;    end;    trigger OnModify()    begin        if Indentation < 0 then            Indentation := 0;    end;    var        GLSetup: Record "General Ledger Setup";        ItemAnalysisView: Record "Item Analysis View";        HasGLSetup: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470        Text001: Label 'The parenthesis at position %1 is misplaced.';        Text002: Label 'You cannot have two consecutive operators. The error occurred at position %1.';        Text003: Label 'There is an operand missing after position %1.';#pragma warning restore AA0470        Text004: Label 'There are more left parentheses than right parentheses.';        Text005: Label 'There are more right parentheses than left parentheses.';#pragma warning disable AA0470        Text009: Label '1,6,,Dimension %1 Filter';#pragma warning restore AA0470        Text010: Label ',, Totaling';#pragma warning disable AA0470        Text011: Label '1,5,,Dimension %1 Totaling';#pragma warning restore AA0470#pragma warning restore AA0074    procedure CheckFormula(Formula: Code[250])    var        i: Integer;        ParenthesesLevel: Integer;        HasOperator: Boolean;    begin        ParenthesesLevel := 0;        for i := 1 to StrLen(Formula) do begin            if Formula[i] = '(' then                ParenthesesLevel := ParenthesesLevel + 1            else                if Formula[i] = ')' then                    ParenthesesLevel := ParenthesesLevel - 1;            if ParenthesesLevel < 0 then                Error(Text001, i);            if Formula[i] in ['+', '-', '*', '/', '^'] then begin                if HasOperator then                    Error(Text002, i);                HasOperator := true;                if i = StrLen(Formula) then                    Error(Text003, i);                if Formula[i + 1] = ')' then                    Error(Text003, i);            end else                HasOperator := false;        end;        if ParenthesesLevel > 0 then            Error(Text004);        if ParenthesesLevel < 0 then            Error(Text005);    end;    local procedure SubstRowRefNo(OldRowRefNo: Code[20]; NewRowRefNo: Code[20])    var        FormulaAnalysisLine: Record "Analysis Line";        OriginalRange: Text[250];        NewRange: Text[250];        Token: Text[250];        TheChar: Text[1];        i: Integer;        TheLength: Integer;    begin        if (OldRowRefNo = '') or (NewRowRefNo = '') then            exit;        FormulaAnalysisLine.SetRange("Analysis Area", "Analysis Area");        FormulaAnalysisLine.SetRange("Analysis Line Template Name", "Analysis Line Template Name");        FormulaAnalysisLine.SetRange(Type, Type::Formula);        if not FormulaAnalysisLine.Find('-') then            exit;        repeat            OriginalRange := FormulaAnalysisLine.Range;            TheLength := StrLen(FormulaAnalysisLine.Range);            NewRange := '';            for i := 1 to TheLength do begin                TheChar := CopyStr(FormulaAnalysisLine.Range, i, 1);                if TheChar in ['0' .. '9', 'A' .. 'Z'] then begin                    Token := Token + TheChar;                    if i = TheLength then begin                        if Token = OldRowRefNo then                            NewRange := NewRange + NewRowRefNo                        else                            NewRange := NewRange + Token;                        Token := '';                    end;                end else begin                    if Token = OldRowRefNo then                        NewRange := NewRange + NewRowRefNo                    else                        NewRange := NewRange + Token;                    NewRange := NewRange + TheChar;                    Token := '';                end;            end;            if NewRange <> OriginalRange then                if "Line No." = FormulaAnalysisLine."Line No." then                    Range := NewRange                else begin                    FormulaAnalysisLine.Range := NewRange;                    FormulaAnalysisLine.Modify();                end;        until FormulaAnalysisLine.Next() = 0;    end;    procedure LookupTotalingRange(var Text: Text) Result: Boolean    var        InventorySetup: Record "Inventory Setup";        SalesSetup: Record "Sales & Receivables Setup";        ItemList: Page "Item List";        CustList: Page "Customer List";        VendList: Page "Vendor List";    begin        case Type of            Type::Item:                begin                    ItemList.LookupMode(true);                    if ItemList.RunModal() = ACTION::LookupOK then begin                        Text := ItemList.GetSelectionFilter();                        exit(true);                    end;                end;            Type::Customer:                begin                    CustList.LookupMode(true);                    if CustList.RunModal() = ACTION::LookupOK then begin                        Text := CustList.GetSelectionFilter();                        exit(true);                    end;                end;            Type::Vendor:                begin                    VendList.LookupMode(true);                    if VendList.RunModal() = ACTION::LookupOK then begin                        Text := VendList.GetSelectionFilter();                        exit(true);                    end;                end;            Type::"Item Group":                begin                    InventorySetup.Get();                    InventorySetup.TestField("Item Group Dimension Code");                    exit(LookupDimTotalingRange(Text, InventorySetup."Item Group Dimension Code"));                end;            Type::"Customer Group":                begin                    SalesSetup.Get();                    SalesSetup.TestField("Customer Group Dimension Code");                    exit(LookupDimTotalingRange(Text, SalesSetup."Customer Group Dimension Code"));                end;            Type::"Sales/Purchase person":                begin                    SalesSetup.Get();                    SalesSetup.TestField("Salesperson Dimension Code");                    exit(LookupDimTotalingRange(Text, SalesSetup."Salesperson Dimension Code"));                end;            else                OnLookupTotalingRangeOnElse(Rec, Text, Result);        end;    end;    procedure LookupDimTotalingRange(var Text: Text; GroupDimCode: Code[20]): Boolean    var        DimVal: Record "Dimension Value";        DimValList: Page "Dimension Value List";    begin        DimVal.FilterGroup := 2;        DimVal.SetRange("Dimension Code", GroupDimCode);        DimVal.FilterGroup := 0;        DimValList.SetTableView(DimVal);        DimValList.LookupMode(true);        if DimValList.RunModal() = ACTION::LookupOK then begin            Text := DimValList.GetSelectionFilter();            exit(true);        end;    end;    procedure GetCaptionClass(DimNo: Integer): Text[250]    begin        GetItemAnalysisView();        case DimNo of            1:                if ItemAnalysisView."Dimension 1 Code" <> '' then                    exit('1,6,' + ItemAnalysisView."Dimension 1 Code");            2:                if ItemAnalysisView."Dimension 2 Code" <> '' then                    exit('1,6,' + ItemAnalysisView."Dimension 2 Code");            3:                if ItemAnalysisView."Dimension 3 Code" <> '' then                    exit('1,6,' + ItemAnalysisView."Dimension 3 Code");            4:                if ItemAnalysisView."Dimension 1 Code" <> '' then                    exit('1,5,' + ItemAnalysisView."Dimension 1 Code" + Text010);            5:                if ItemAnalysisView."Dimension 2 Code" <> '' then                    exit('1,5,' + ItemAnalysisView."Dimension 2 Code" + Text010);            6:                if ItemAnalysisView."Dimension 3 Code" <> '' then                    exit('1,5,' + ItemAnalysisView."Dimension 3 Code" + Text010);        end;        if DimNo <= 3 then            exit(StrSubstNo(Text009, DimNo));        exit(StrSubstNo(Text011, DimNo - 3));    end;    local procedure GetItemAnalysisView()    var        AnalysisLineTemplate: Record "Analysis Line Template";    begin        if (AnalysisLineTemplate."Analysis Area" = "Analysis Area") and           (AnalysisLineTemplate.Name = "Analysis Line Template Name")        then            exit;        if AnalysisLineTemplate.Get("Analysis Area", "Analysis Line Template Name") then            if AnalysisLineTemplate."Item Analysis View Code" <> '' then                ItemAnalysisView.Get("Analysis Area", AnalysisLineTemplate."Item Analysis View Code")            else begin                Clear(ItemAnalysisView);                if not HasGLSetup then                    GLSetup.Get();                HasGLSetup := true;                ItemAnalysisView."Dimension 1 Code" := GLSetup."Global Dimension 1 Code";                ItemAnalysisView."Dimension 2 Code" := GLSetup."Global Dimension 2 Code";            end;    end;    [IntegrationEvent(false, false)]    local procedure OnLookupTotalingRangeOnElse(var AnalysisLine: Record "Analysis Line"; var Text: Text; var Result: Boolean)    begin    end;}