Report 99000794 Compare Production Cost Shares

Base Application, Microsoft.Manufacturing.Reports

src/Layers/W1/BaseApp/Manufacturing/Reports/CompareProductionCostShares.Report.al239 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.Manufacturing.Reports;using Microsoft.Inventory.BOM;using Microsoft.Inventory.BOM.Tree;using Microsoft.Inventory.Item;report 99000794 "Compare Production Cost Shares"{    ApplicationArea = Manufacturing;    Caption = 'Compare Production Cost Shares';    ToolTip = 'View a comparison of components for two items. The printout compares the components, their unit cost, cost share and cost per component.';    UsageCategory = ReportsAndAnalysis;    DefaultRenderingLayout = CompareProductionCostSharesExcel;    dataset    {        dataitem(CompareCostSharesBuffer; "Compare Cost Shares Buffer")        {            DataItemTableView = sorting(Indentation, Type, "No.");            column(Item1; Item[1]."No." + ' ' + Item[1].Description)            {            }            column(Item2; Item[2]."No." + ' ' + Item[2].Description)            {            }            column(Level; PadStr('', Indentation, ' ') + Format(Indentation))            {            }            column(Type; Type)            {                IncludeCaption = true;            }            column(No; "No.")            {                IncludeCaption = true;            }            column(Description; Description)            {                IncludeCaption = true;            }            column(IsLeaf; "Is Leaf")            {                IncludeCaption = true;            }            column(Item1QtyPerTopItem; "Item 1 Qty. per Top Item")            {                IncludeCaption = true;            }            column(Item2QtyPerTopItem; "Item 2 Qty. per Top Item")            {                IncludeCaption = true;            }            column(Item1UnitCost; "Item 1 Unit Cost")            {                IncludeCaption = true;            }            column(Item2UnitCost; "Item 2 Unit Cost")            {                IncludeCaption = true;            }            column(Item1TotalCost; "Item 1 Total Cost")            {                IncludeCaption = true;            }            column(Item2TotalCost; "Item 2 Total Cost")            {                IncludeCaption = true;            }            column(DifferenceCost; "Difference Cost")            {                IncludeCaption = true;            }        }    }    requestpage    {        AboutTitle = 'About Compare Production Cost Shares';        AboutText = 'Compare the costs of similar final products.';        layout        {            area(Content)            {                group(Options)                {                    Caption = 'Options';                    field(ItemNo1; Item[1]."No.")                    {                        ApplicationArea = Manufacturing;                        Caption = 'Item No. 1';                        DrillDownPageID = "Item List";                        LookupPageID = "Item List";                        NotBlank = true;                        TableRelation = Item;                        ToolTip = 'Specifies the number of the first item you want to compare, when comparing components for two items.';                        trigger OnLookup(var Text: Text): Boolean                        begin                            Item[1].SetCurrentKey("Production BOM No.");                            Item[1].SetFilter("Production BOM No.", '<>%1', '');                            if Page.RunModal(Page::"Item List", Item[1]) = Action::LookupOK then begin                                Text := Item[1]."No.";                                exit(true);                            end;                            exit(false);                        end;                        trigger OnValidate()                        begin                            Item[1].Get(Item[1]."No.");                            Item[1].TestField("Production BOM No.");                            if Item[1]."No." = Item[2]."No." then                                Item[1].FieldError("No.");                        end;                    }                    field(ItemNo2; Item[2]."No.")                    {                        ApplicationArea = Manufacturing;                        Caption = 'Item No. 2';                        LookupPageID = "Item List";                        NotBlank = true;                        TableRelation = Item;                        ToolTip = 'Specifies the number of the second item you want to compare, when comparing components for two items.';                        trigger OnLookup(var Text: Text): Boolean                        begin                            Item[2].SetCurrentKey("Production BOM No.");                            Item[2].SetFilter("Production BOM No.", '<>%1', '');                            if Page.RunModal(Page::"Item List", Item[2]) = Action::LookupOK then begin                                Text := Item[2]."No.";                                exit(true);                            end;                            exit(false);                        end;                        trigger OnValidate()                        begin                            Item[2].Get(Item[2]."No.");                            Item[2].TestField("Production BOM No.");                            if Item[1]."No." = Item[2]."No." then                                Item[2].FieldError("No.");                        end;                    }                }            }        }    }    rendering    {        layout(CompareProductionCostSharesExcel)        {            Caption = 'Compare Production Cost Shares Excel';            Type = Excel;            LayoutFile = './Manufacturing/Reports/CompareProductionCostShares.xlsx';            Summary = 'Report layout primarily made for data analysis. Use an Excel editor to modify the layout.';        }    }    labels    {        CompareProductionCostSharesList = 'Compare Production Cost Shares - List';        CompareProductionCostSharesExploded = 'Compare Production Cost Shares - Exploded';        CompareListPrint = 'Compare List (Print)', MaxLength = 31, Comment = 'Excel worksheet name.';        CompareExplodedPrint = 'Compare Exploded (Print)', MaxLength = 31, Comment = 'Excel worksheet name.';        CompareCostSharesAnalysis = 'Compare Cost Shares (Analysis)', MaxLength = 31, Comment = 'Excel worksheet name.';        DataRetrieved = 'Data retrieved:';        Item1Label = 'Item 1:';        Item2Label = 'Item 2:';        LevelLabel = 'Level';        // About the report labels        AboutTheReportLabel = 'About the report', MaxLength = 31, Comment = 'Excel worksheet name.';        EnvironmentLabel = 'Environment';        CompanyLabel = 'Company';        UserLabel = 'User';        RunOnLabel = 'Run on';        ReportNameLabel = 'Report name';        DocumentationLabel = 'Documentation';    }    trigger OnPreReport()    begin        GenerateTreeForItems(TempBOMBuffer1, Item[1]."No.");        GenerateTreeForItems(TempBOMBuffer2, Item[2]."No.");        BuildDataSet(TempBOMBuffer1, true);        BuildDataSet(TempBOMBuffer2, false);    end;    var        TempBOMBuffer1: Record "BOM Buffer" temporary;        TempBOMBuffer2: Record "BOM Buffer" temporary;        ItemNoBOMLbl: Label 'Item %1 does not have a BOM.', Comment = '%1 = Item No.';        TopItemDescriptionLbl: Label '%1 - %2', Comment = '%1 = Item No. 1, %2 = Item No. 2';    protected var        Item: array[2] of Record Item;    local procedure GenerateTreeForItems(var BOMBuffer: Record "BOM Buffer" temporary; ItemNo: Code[20])    var        Item2: Record Item;        CalcBOMTree: Codeunit "Calculate BOM Tree";        HasBOM: Boolean;    begin        Item2.Get(ItemNo);        HasBOM := Item2.HasBOM() or (Item2."Routing No." <> '');        if not HasBOM then            Error(ItemNoBOMLbl, ItemNo);        CalcBOMTree.GenerateTreeForOneItem(Item2, BOMBuffer, WorkDate(), "BOM Tree Type"::Cost);    end;    local procedure BuildDataSet(var BOMBuffer: Record "BOM Buffer" temporary; Item1: Boolean)    begin        BOMBuffer.Reset();        if BOMBuffer.FindSet() then            repeat                if BOMBuffer.Indentation = 0 then begin                    BOMBuffer."No." := '';                    BOMBuffer.Description := StrSubstNo(TopItemDescriptionLbl, Item[1]."No.", Item[2]."No.");                end;                CompareCostSharesBuffer.TransferFromBOMBuffer(BOMBuffer, Item1);            until BOMBuffer.Next() = 0;    end;    procedure InitializeRequest(NewItem1: Code[20]; NewItem2: Code[20])    begin        Item[1]."No." := NewItem1;        Item[2]."No." := NewItem2;    end;}