Report 5871 Item - Able to Make (Timeline)

Base Application, Microsoft.Inventory.Reports

src/Layers/W1/BaseApp/Inventory/Reports/ItemAbletoMakeTimeline.Report.al318 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.Reports;using Microsoft.Inventory.Availability;using Microsoft.Inventory.BOM;using Microsoft.Inventory.BOM.Tree;using Microsoft.Inventory.Item;using System.Utilities;report 5871 "Item - Able to Make (Timeline)"{    DefaultRenderingLayout = ExcelLayout;    AdditionalSearchTerms = 'assembly availability';    ApplicationArea = Planning;    Caption = 'Item - Able to Make (Timeline)';    PreviewMode = PrintLayout;    UsageCategory = ReportsAndAnalysis;    dataset    {        dataitem(Item; Item)        {            DataItemTableView = sorting("No.");            RequestFilterFields = "No.", "Location Filter", "Variant Filter";            column(COMPANYNAME; COMPANYPROPERTY.DisplayName())            {            }            column(Item__No__; "No.")            {                IncludeCaption = true;            }            column(Item_Description; Description)            {                IncludeCaption = true;            }            dataitem(BOMBufferLoop; "Integer")            {                DataItemTableView = sorting(Number);                column(TotalQty; TotalQty)                {                    DecimalPlaces = 0 : 5;                }                column(GrossReqQty; GrossReqQty)                {                    DecimalPlaces = 0 : 5;                }                column(SchRcptQty; SchRcptQty)                {                    DecimalPlaces = 0 : 5;                }                column(InvtQty; InvtQty)                {                    DecimalPlaces = 0 : 5;                }                column(AbleToMakeQty; AbleToMakeQty)                {                    DecimalPlaces = 0 : 5;                }                column(AsOfPeriod; Format(AsOfPeriod))                {                }                column(ShowDetails; ShowDetails)                {                }                trigger OnAfterGetRecord()                begin                    if Number <> 1 then begin                        CurrDate := CalcDate(DateFormula, CurrDate);                        GenerateAvailTrend(CurrDate);                    end;                end;                trigger OnPreDataItem()                begin                    SetRange(Number, 1, NoOfIntervals);                end;            }            trigger OnAfterGetRecord()            begin                CurrDate := StartDate;                if not GenerateAvailTrend(CurrDate) then                    CurrReport.Skip();            end;            trigger OnPreDataItem()            begin                Evaluate(DateFormula, GetDateFormulaInterval());            end;        }    }    requestpage    {        AboutTitle = 'About Item - Able to Make (Timeline)';        AboutText = 'Provides an overview on the dynamic BOM availability. Visualise key inventory figures and forecast production capabilities to meet demand efficiently. Stay ahead with real-time insights into your assembly and production schedules.';        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(StartDate; StartDate)                    {                        ApplicationArea = Planning;                        Caption = 'Starting Date';                        ToolTip = 'Specifies the first date on the X-axis.';                    }                    field(DateInterval; DateInterval)                    {                        ApplicationArea = Planning;                        Caption = 'Date Interval';                        ToolTip = 'Specifies the length of each period on the x-axis. You can select from Day, Week, Month, Quarter, or Year.';                    }                    field(NoOfIntervals; NoOfIntervals)                    {                        ApplicationArea = Planning;                        Caption = 'No. of Intervals';                        MaxValue = 31;                        MinValue = 1;                        ToolTip = 'Specifies how many date intervals are shown on the x-axis.';                        trigger OnValidate()                        begin                            if NoOfIntervals > 31 then                                Error(Text000)                        end;                    }                    field(ShowDetails; ShowDetails)                    {                        ApplicationArea = Planning;                        Caption = 'Show Details';                        ToolTip = 'Specifies a table under the graph with the quantities that the lines in the graph are based on.';                    }                }            }        }        actions        {        }        trigger OnInit()        begin            if NoOfIntervals = 0 then                NoOfIntervals := 7;        end;    }    rendering    {        layout(ExcelLayout)        {            Caption = 'Item - Able to Make (Timeline) Excel';            Type = Excel;            LayoutFile = './Inventory/Reports/ItemAbletoMakeTimeline.xlsx';            Summary = 'Report layout primarily made for data analysis. Use an Excel editor to modify the layout.';        }        layout(RDLCLayout)        {            Caption = 'Item - Able to Make (Timeline) RDLC';            Type = RDLC;            LayoutFile = './Inventory/Reports/ItemAbletoMakeTimeline.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {        ItemAbleToMakeProjectionCaption = 'Item - Able to Make (Timeline)';        AsOfPeriodCaption = 'As of Period';        CurrReport_PAGENOCaption = 'Page';        TotalQtyCaption = 'Total';        GrossReqQtyCaption = 'Gross Requirement';        SchRcptQtyCaption = 'Scheduled Receipts';        InvtQtyCaption = 'Inventory';        AbleToMakeQtyCaption = 'Able to Make';        StartDateCaption = 'Starting Date:';        ItemAbleToMakePrintLabel = 'Item Able to Make - (Print)', MaxLength = 31, Comment = 'Excel worksheet name.';        ItemAbleToMakeAnalysisLabel = 'Item Able to Make - (Analysis)', MaxLength = 31, Comment = 'Excel worksheet name.';        DataRetrieved = 'Data retrieved:';        // 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';    }    trigger OnInitReport()    begin        StartDate := WorkDate();    end;    var        TempBOMBuffer: Record "BOM Buffer" temporary;        CalcBOMTree: Codeunit "Calculate BOM Tree";        SourceRecordVar: Variant;        DateFormula: DateFormula;        DateInterval: Option Day,Week,Month,Quarter,Year;        NoOfIntervals: Integer;        StartDate: Date;        AbleToMakeQty: Decimal;        InvtQty: Decimal;        SchRcptQty: Decimal;        GrossReqQty: Decimal;        TotalQty: Decimal;        AsOfPeriod: Date;        CurrDate: Date;        ShowDetails: Boolean;        ShowBy: Enum "BOM Structure Show By";#pragma warning disable AA0074        Text000: Label 'The number of intervals cannot be greater than 31.';#pragma warning restore AA0074    local procedure GenerateAvailTrend(CurrDate: Date): Boolean    var        IsHandled: Boolean;    begin        CalcBOMTree.SetShowTotalAvailability(true);        case ShowBy of            ShowBy::Item:                begin                    IsHandled := false;                    OnGenerateAvailTrendOnBeforeGenerateTreeForItem(Item, TempBOMBuffer, CurrDate, IsHandled);                    if not IsHandled then                        CalcBOMTree.GenerateTreeForOneItem(Item, TempBOMBuffer, CurrDate, "BOM Tree Type"::Availability);                end;            else                CalcBOMTree.GenerateTreeForSource(SourceRecordVar, TempBOMBuffer, "BOM Tree Type"::Availability, ShowBy, CurrDate);        end;        if not TempBOMBuffer.FindFirst() then            exit(false);        AbleToMakeQty := TempBOMBuffer."Able to Make Top Item";        TotalQty := TempBOMBuffer."Able to Make Top Item" + TempBOMBuffer."Available Quantity";        CalcQuantities(Item, InvtQty, SchRcptQty, GrossReqQty, CurrDate);        AsOfPeriod := CurrDate;        exit(true);    end;    local procedure GetDateFormulaInterval(): Text[10]    begin        case DateInterval of            DateInterval::Day:                exit('<+1D>');            DateInterval::Week:                exit('<CW+1D>');            DateInterval::Month:                exit('<CM+1D>');            DateInterval::Quarter:                exit('<CQ+1D>');            DateInterval::Year:                exit('<CY+1D>');        end;    end;    procedure Initialize(NewStartingDate: Date; NewDateInterval: Option; NewNoOfIntervals: Integer; NewShowDetails: Boolean)    begin        StartDate := NewStartingDate;        DateInterval := NewDateInterval;        NoOfIntervals := NewNoOfIntervals;        ShowDetails := NewShowDetails;    end;    procedure InitSource(NewSourceRecordVar: Variant; NewShowBy: Enum "BOM Structure Show By")    begin        SourceRecordVar := NewSourceRecordVar;        ShowBy := NewShowBy;    end;#if not CLEAN27    [Obsolete('Replaced by procedure InitSource()', '27.0')]    procedure InitAsmOrder(NewAsmHeader: Record Microsoft.Assembly.Document."Assembly Header")    begin        SourceRecordVar := NewAsmHeader;        ShowBy := ShowBy::Assembly;    end;#endif#if not CLEAN27    [Obsolete('Replaced by procedure InitSource()', '27.0')]    procedure InitProdOrder(NewProdOrderLine: Record Microsoft.Manufacturing.Document."Prod. Order Line")    begin        SourceRecordVar := NewProdOrderLine;        ShowBy := ShowBy::Production;    end;#endif    local procedure CalcQuantities(var Item: Record Item; var InvtQty: Decimal; var SchRcptQty: Decimal; var GrossReqQty: Decimal; Date: Date)    var        Item2: Record Item;        ItemAvailFormsMgt: Codeunit "Item Availability Forms Mgt";        PlannedOrderReceipt: Decimal;        PlannedOrderReleases: Decimal;    begin        Item2.Copy(Item);        Item2.CalcFields(Inventory);        InvtQty := Item2.Inventory;        Item2.SetRange("Date Filter", 0D, Date);        ItemAvailFormsMgt.CalculateNeed(Item2, GrossReqQty, PlannedOrderReceipt, SchRcptQty, PlannedOrderReleases);    end;    [IntegrationEvent(false, false)]    local procedure OnGenerateAvailTrendOnBeforeGenerateTreeForItem(var Item: Record "Item"; var BOMBuffer: Record "BOM Buffer" temporary; CurrDate: Date; var IsHandled: Boolean)    begin    end;}