Codeunit 132203 Library - Planning

Application Test Library

src/Layers/W1/Tests/ApplicationTestLibrary/LibraryPlanning.Codeunit.al468 lines, Copyright (c) Microsoft Corporation. MIT

/// <summary>/// Provides utility functions for creating and managing planning-related entities in test scenarios, including requisition worksheets and planning components./// </summary>codeunit 132203 "Library - Planning"{    trigger OnRun()    begin    end;    var        InventorySetup: Record "Inventory Setup";        LibraryUtility: Codeunit "Library - Utility";#if not CLEAN27#pragma warning disable AL0801    [Obsolete('Moved to codeunit LibraryManufacturing', '27.0')]    procedure CreateProdOrderUsingPlanning(var ProductionOrder: Record "Production Order"; Status: Enum "Production Order Status"; DocumentNo: Code[20]; SourceNo: Code[20])    var        LibraryManufacturing: Codeunit "Library - Manufacturing";    begin        LibraryManufacturing.CreateProdOrderUsingPlanning(ProductionOrder, Status, DocumentNo, SourceNo);    end;#pragma warning restore AL0801#endif    [Normal]    procedure CreateRequisitionWkshName(var RequisitionWkshName: Record "Requisition Wksh. Name"; WorksheetTemplateName: Code[10])    begin        // Create Requisition Wksh. Name with a random Name of String length less than 10.        RequisitionWkshName.Init();        RequisitionWkshName.Validate("Worksheet Template Name", WorksheetTemplateName);        RequisitionWkshName.Validate(          Name,          CopyStr(            LibraryUtility.GenerateRandomCode(RequisitionWkshName.FieldNo(Name), DATABASE::"Requisition Wksh. Name"),            1, LibraryUtility.GetFieldLength(DATABASE::"Requisition Wksh. Name", RequisitionWkshName.FieldNo(Name))));        RequisitionWkshName.Insert(true);    end;    procedure CreatePlanningWkshName(var PlanningWkshName: Record "Requisition Wksh. Name"; WorksheetTemplateName: Code[10])    begin        PlanningWkshName.Init();        PlanningWkshName.Validate("Worksheet Template Name", WorksheetTemplateName);        PlanningWkshName.Validate(          Name,          CopyStr(            LibraryUtility.GenerateRandomCode(PlanningWkshName.FieldNo(Name), DATABASE::"Requisition Wksh. Name"),            1, LibraryUtility.GetFieldLength(DATABASE::"Requisition Wksh. Name", PlanningWkshName.FieldNo(Name))));        PlanningWkshName.Insert(true);    end;    procedure CalculateLowLevelCode()    var        LowLevelCodeCalculator: Codeunit "Low-Level Code Calculator";    begin        Clear(LowLevelCodeCalculator);        LowLevelCodeCalculator.Run();    end;    procedure CalculateOrderPlanProduction(var RequisitionLine: Record "Requisition Line")    var        OrderPlanningMgt: Codeunit "Order Planning Mgt.";    begin        OrderPlanningMgt.SetDemandType("Demand Order Source Type"::"Production Demand");        OrderPlanningMgt.GetOrdersToPlan(RequisitionLine);    end;    procedure CalculateOrderPlanAssembly(var RequisitionLine: Record "Requisition Line")    var        OrderPlanningMgt: Codeunit "Order Planning Mgt.";    begin        OrderPlanningMgt.SetDemandType("Demand Order Source Type"::"Assembly Demand");        OrderPlanningMgt.GetOrdersToPlan(RequisitionLine);    end;    procedure CalculateOrderPlanSales(var RequisitionLine: Record "Requisition Line")    var        OrderPlanningMgt: Codeunit "Order Planning Mgt.";    begin        OrderPlanningMgt.SetDemandType("Demand Order Source Type"::"Sales Demand");        OrderPlanningMgt.GetOrdersToPlan(RequisitionLine);    end;    procedure CalculateOrderPlanService(var RequisitionLine: Record "Requisition Line")    var        OrderPlanningMgt: Codeunit "Order Planning Mgt.";    begin        OrderPlanningMgt.SetDemandType("Demand Order Source Type"::"Service Demand");        OrderPlanningMgt.GetOrdersToPlan(RequisitionLine);    end;    procedure CalculateOrderPlanJob(var RequisitionLine: Record "Requisition Line")    var        OrderPlanningMgt: Codeunit "Order Planning Mgt.";    begin        OrderPlanningMgt.SetDemandType("Demand Order Source Type"::"Job Demand");        OrderPlanningMgt.GetOrdersToPlan(RequisitionLine);    end;    procedure CalculatePlanForReqWksh(var Item: Record Item; TemplateName: Code[10]; WorksheetName: Code[10]; StartDate: Date; EndDate: Date)    var        TmpItem: Record Item;        CalculatePlanReqWksh: Report "Calculate Plan - Req. Wksh.";    begin        CalculatePlanReqWksh.SetTemplAndWorksheet(TemplateName, WorksheetName);        CalculatePlanReqWksh.InitializeRequest(StartDate, EndDate);        if Item.HasFilter then            TmpItem.CopyFilters(Item)        else begin            Item.Get(Item."No.");            TmpItem.SetRange("No.", Item."No.");        end;        CalculatePlanReqWksh.SetTableView(TmpItem);        CalculatePlanReqWksh.UseRequestPage(false);        CalculatePlanReqWksh.RunModal();    end;    procedure CalcRequisitionPlanForReqWksh(var Item: Record Item; StartDate: Date; EndDate: Date)    var        RequisitionWkshName: Record "Requisition Wksh. Name";    begin        SelectRequisitionWkshName(RequisitionWkshName, RequisitionWkshName."Template Type"::"Req.");        CalculatePlanForReqWksh(Item, RequisitionWkshName."Worksheet Template Name", RequisitionWkshName.Name, StartDate, EndDate);    end;    procedure CalcRequisitionPlanForReqWkshAndGetLines(var RequisitionLine: Record "Requisition Line"; var Item: Record Item; StartDate: Date; EndDate: Date)    var        RequisitionWkshName: Record "Requisition Wksh. Name";    begin        SelectRequisitionWkshName(RequisitionWkshName, RequisitionWkshName."Template Type"::"Req.");        CalculatePlanForReqWksh(Item, RequisitionWkshName."Worksheet Template Name", RequisitionWkshName.Name, StartDate, EndDate);        FindRequisitionLine(RequisitionLine, RequisitionWkshName, Item."No.");    end;    local procedure CalculatePlanOnPlanningWorksheet(var ItemRec: Record Item; OrderDate: Date; ToDate: Date; RespectPlanningParameters: Boolean; Regenerative: Boolean)    var        TmpItemRec: Record Item;        RequisitionWkshName: Record "Requisition Wksh. Name";        CalculatePlanPlanWksh: Report "Calculate Plan - Plan. Wksh.";    begin        SelectRequisitionWkshName(RequisitionWkshName, RequisitionWkshName."Template Type"::Planning);  // Find Requisition Worksheet Name to Calculate Plan.        Commit();        CalculatePlanPlanWksh.InitializeRequest(OrderDate, ToDate, RespectPlanningParameters);        CalculatePlanPlanWksh.SetTemplAndWorksheet(RequisitionWkshName."Worksheet Template Name", RequisitionWkshName.Name, Regenerative);        if ItemRec.HasFilter then            TmpItemRec.CopyFilters(ItemRec)        else begin            ItemRec.Get(ItemRec."No.");            TmpItemRec.SetRange("No.", ItemRec."No.");        end;        CalculatePlanPlanWksh.SetTableView(TmpItemRec);        CalculatePlanPlanWksh.UseRequestPage(false);        CalculatePlanPlanWksh.RunModal();    end;    procedure CalcRegenPlanForPlanWksh(var ItemRec: Record Item; OrderDate: Date; ToDate: Date)    begin        CalcRegenPlanForPlanWkshPlanningParams(ItemRec, OrderDate, ToDate, false);    end;    procedure CalcRegenPlanForPlanWkshPlanningParams(var ItemRec: Record Item; OrderDate: Date; ToDate: Date; RespectPlanningParameters: Boolean)    begin        CalculatePlanOnPlanningWorksheet(ItemRec, OrderDate, ToDate, RespectPlanningParameters, true);  // Passing True for Regenerative Boolean.    end;    procedure CalcNetChangePlanForPlanWksh(var ItemRec: Record Item; OrderDate: Date; ToDate: Date; RespectPlanningParameters: Boolean)    begin        CalculatePlanOnPlanningWorksheet(ItemRec, OrderDate, ToDate, RespectPlanningParameters, false);  // Passing False for Regenerative Boolean.    end;    procedure CarryOutActionMsgPlanWksh(var ReqLineRec: Record "Requisition Line")    var        TmpReqLineRec: Record "Requisition Line";        CarryOutActionMsgPlan: Report "Carry Out Action Msg. - Plan.";    begin        Commit();        CarryOutActionMsgPlan.InitializeRequest(2, 1, 1, 1);        if ReqLineRec.HasFilter then            TmpReqLineRec.CopyFilters(ReqLineRec)        else begin            ReqLineRec.Get(ReqLineRec."Worksheet Template Name",              ReqLineRec."Journal Batch Name", ReqLineRec."Line No.");            TmpReqLineRec.SetRange("Worksheet Template Name", ReqLineRec."Worksheet Template Name");            TmpReqLineRec.SetRange("Journal Batch Name", ReqLineRec."Journal Batch Name");            TmpReqLineRec.SetRange("Line No.", ReqLineRec."Line No.");        end;        CarryOutActionMsgPlan.SetReqWkshLine(ReqLineRec);        CarryOutActionMsgPlan.SetTableView(TmpReqLineRec);        CarryOutActionMsgPlan.UseRequestPage(false);        CarryOutActionMsgPlan.RunModal();    end;    procedure CarryOutPlanWksh(var RequisitionLine: Record "Requisition Line"; NewProdOrderChoice: Option; NewPurchOrderChoice: Option; NewTransOrderChoice: Option; NewAsmOrderChoice: Option; NewReqWkshTemp: Code[10]; NewReqWksh: Code[10]; NewTransWkshTemp: Code[10]; NewTransWkshName: Code[10])    var        CarryOutActionMsgPlan: Report "Carry Out Action Msg. - Plan.";    begin        CarryOutActionMsgPlan.SetReqWkshLine(RequisitionLine);        CarryOutActionMsgPlan.InitializeRequest2(          NewProdOrderChoice, NewPurchOrderChoice, NewTransOrderChoice, NewAsmOrderChoice,          NewReqWkshTemp, NewReqWksh, NewTransWkshTemp, NewTransWkshName);        CarryOutActionMsgPlan.SetTableView(RequisitionLine);        CarryOutActionMsgPlan.UseRequestPage(false);        CarryOutActionMsgPlan.Run();    end;    procedure CarryOutReqWksh(var RequisitionLine: Record "Requisition Line"; ExpirationDate: Date; OrderDate: Date; PostingDate: Date; ExpectedReceiptDate: Date; YourRef: Text[50])    var        CarryOutActionMsgReq: Report "Carry Out Action Msg. - Req.";    begin        CarryOutActionMsgReq.SetReqWkshLine(RequisitionLine);        CarryOutActionMsgReq.InitializeRequest(ExpirationDate, OrderDate, PostingDate, ExpectedReceiptDate, YourRef);        CarryOutActionMsgReq.UseRequestPage(false);        CarryOutActionMsgReq.Run();        CarryOutActionMsgReq.GetReqWkshLine(RequisitionLine);    end;    procedure CarryOutAMSubcontractWksh(var RequisitionLine: Record "Requisition Line")    var        CarryOutActionMsgReq: Report "Carry Out Action Msg. - Req.";    begin        CarryOutActionMsgReq.SetReqWkshLine(RequisitionLine);        CarryOutActionMsgReq.UseRequestPage(false);        CarryOutActionMsgReq.RunModal();    end;    procedure CreateManufUserTemplate(var ManufacturingUserTemplate: Record "Manufacturing User Template"; UserID: Code[50]; MakeOrders: Option; CreatePurchaseOrder: Enum "Planning Create Purchase Order"; CreateProductionOrder: Enum "Planning Create Prod. Order"; CreateTransferOrder: Enum "Planning Create Transfer Order")    begin        ManufacturingUserTemplate.Init();        ManufacturingUserTemplate."User ID" := UserID;        ManufacturingUserTemplate.Insert(true);        ManufacturingUserTemplate.Validate("Make Orders", MakeOrders);        ManufacturingUserTemplate.Validate("Create Purchase Order", CreatePurchaseOrder);        ManufacturingUserTemplate.Validate("Create Production Order", CreateProductionOrder);        ManufacturingUserTemplate.Validate("Create Transfer Order", CreateTransferOrder);        ManufacturingUserTemplate.Modify(true);    end;    procedure CreateRequisitionLine(var RequisitionLine: Record "Requisition Line"; WorksheetTemplateName: Code[10]; JournalBatchName: Code[10])    var        RecRef: RecordRef;    begin        RequisitionLine.Init();        RequisitionLine.Validate("Worksheet Template Name", WorksheetTemplateName);        RequisitionLine.Validate("Journal Batch Name", JournalBatchName);        RecRef.GetTable(RequisitionLine);        RequisitionLine.Validate("Line No.", LibraryUtility.GetNewLineNo(RecRef, RequisitionLine.FieldNo("Line No.")));        RequisitionLine.Insert(true);    end;    procedure CreatePlanningComponent(var PlanningComponent: Record "Planning Component"; var RequisitionLine: Record "Requisition Line")    var        RecRef: RecordRef;    begin        PlanningComponent.Init();        PlanningComponent.Validate("Worksheet Template Name", RequisitionLine."Worksheet Template Name");        PlanningComponent.Validate("Worksheet Batch Name", RequisitionLine."Journal Batch Name");        PlanningComponent.Validate("Worksheet Line No.", RequisitionLine."Line No.");        RecRef.GetTable(PlanningComponent);        PlanningComponent.Validate("Line No.", LibraryUtility.GetNewLineNo(RecRef, PlanningComponent.FieldNo("Line No.")));        PlanningComponent.Insert(true);    end;#if not CLEAN27#pragma warning disable AL0801    [Obsolete('Moved to codeunit LibraryManufacturing', '27.0')]    procedure CreatePlanningRoutingLine(var PlanningRoutingLine: Record "Planning Routing Line"; var RequisitionLine: Record "Requisition Line"; OperationNo: Code[10])    var        LibraryManfacturing: Codeunit "Library - Manufacturing";    begin        LibraryManfacturing.CreatePlanningRoutingLine(PlanningRoutingLine, RequisitionLine, OperationNo);    end;#pragma warning restore AL0801#endif    local procedure FindRequisitionLine(var RequisitionLine: Record "Requisition Line"; RequisitionWkshName: Record "Requisition Wksh. Name"; ItemNo: Code[20])    begin        RequisitionLine.SetRange("Worksheet Template Name", RequisitionWkshName."Worksheet Template Name");        RequisitionLine.SetRange("Journal Batch Name", RequisitionWkshName.Name);        RequisitionLine.SetRange("No.", ItemNo);        RequisitionLine.FindFirst();    end;    procedure GetActionMessages(var Item: Record Item)    var        TmpItem: Record Item;        RequisitionWkshName: Record "Requisition Wksh. Name";        GetActionMessagesReport: Report "Get Action Messages";    begin        SelectRequisitionWkshName(RequisitionWkshName, RequisitionWkshName."Template Type"::Planning);        GetActionMessagesReport.SetTemplAndWorksheet(RequisitionWkshName."Worksheet Template Name", RequisitionWkshName.Name);        GetActionMessagesReport.UseRequestPage(false);        if Item.HasFilter then            TmpItem.CopyFilters(Item)        else begin            Item.Get(Item."No.");            TmpItem.SetRange("No.", Item."No.");        end;        GetActionMessagesReport.SetTableView(TmpItem);        GetActionMessagesReport.Run();    end;    procedure GetSalesOrders(SalesLine: Record "Sales Line"; RequisitionLine: Record "Requisition Line"; RetrieveDimensionsFrom: Option)    var        GetSalesOrdersReport: Report "Get Sales Orders";    begin        SalesLine.SetRange("Document Type", SalesLine."Document Type");        SalesLine.SetRange("Document No.", SalesLine."Document No.");        Clear(GetSalesOrdersReport);        GetSalesOrdersReport.SetTableView(SalesLine);        GetSalesOrdersReport.InitializeRequest(RetrieveDimensionsFrom);        GetSalesOrdersReport.SetReqWkshLine(RequisitionLine, 0);        GetSalesOrdersReport.UseRequestPage(false);        GetSalesOrdersReport.RunModal();    end;    procedure GetSpecialOrder(var RequisitionLine: Record "Requisition Line"; No: Code[20])    var        SalesLine: Record "Sales Line";        GetSalesOrdersReport: Report "Get Sales Orders";        NewRetrieveDimensionsFrom: Option Item,SalesLine;    begin        SalesLine.SetRange("No.", No);        GetSalesOrdersReport.SetReqWkshLine(RequisitionLine, 1);  // Value required.        GetSalesOrdersReport.SetTableView(SalesLine);        GetSalesOrdersReport.InitializeRequest(NewRetrieveDimensionsFrom::Item);        GetSalesOrdersReport.UseRequestPage(false);        GetSalesOrdersReport.Run();    end;    procedure MakeSupplyOrders(var ManufacturingUserTemplate: Record "Manufacturing User Template"; var RequisitionLine: Record "Requisition Line")    var        MakeSupplyOrdersYesNo: Codeunit "Make Supply Orders (Yes/No)";    begin        MakeSupplyOrdersYesNo.SetManufUserTemplate(ManufacturingUserTemplate);        MakeSupplyOrdersYesNo.Run(RequisitionLine);    end;    procedure RefreshPlanningLine(var RequisitionLine: Record "Requisition Line"; SchDirection: Option; CalcRouting: Boolean; CalcCompNeed: Boolean)    var        TmpRequisitionLine: Record "Requisition Line";        RefreshPlanningDemand: Report "Refresh Planning Demand";    begin        RefreshPlanningDemand.InitializeRequest(SchDirection, CalcRouting, CalcCompNeed);        if RequisitionLine.HasFilter then            TmpRequisitionLine.CopyFilters(RequisitionLine)        else begin            RequisitionLine.Get(RequisitionLine."Worksheet Template Name",              RequisitionLine."Journal Batch Name", RequisitionLine."Line No.");            TmpRequisitionLine.SetRange("Worksheet Template Name", RequisitionLine."Worksheet Template Name");            TmpRequisitionLine.SetRange("Journal Batch Name", RequisitionLine."Journal Batch Name");            TmpRequisitionLine.SetRange("Line No.", RequisitionLine."Line No.");        end;        RefreshPlanningDemand.SetTableView(TmpRequisitionLine);        RefreshPlanningDemand.UseRequestPage(false);        RefreshPlanningDemand.RunModal();    end;    procedure SelectRequisitionTemplateName(): Code[10]    var        ReqWkshTemplate: Record "Req. Wksh. Template";    begin        ReqWkshTemplate.SetRange(Type, ReqWkshTemplate.Type::Planning);        ReqWkshTemplate.SetRange(Recurring, false);        if not ReqWkshTemplate.FindFirst() then begin            ReqWkshTemplate.Init();            ReqWkshTemplate.Validate(              Name, LibraryUtility.GenerateRandomCode(ReqWkshTemplate.FieldNo(Name), DATABASE::"Req. Wksh. Template"));            ReqWkshTemplate.Insert(true);            ReqWkshTemplate.Validate(Type, ReqWkshTemplate.Type::Planning);            ReqWkshTemplate.Modify(true);        end;        exit(ReqWkshTemplate.Name);    end;    procedure SelectRequisitionWkshName(var RequisitionWkshName: Record "Requisition Wksh. Name"; TemplateType: Enum "Req. Worksheet Template Type")    begin        RequisitionWkshName.SetRange("Template Type", TemplateType);        RequisitionWkshName.SetRange(Recurring, false);        if not RequisitionWkshName.FindFirst() then            CreateRequisitionWkshName(RequisitionWkshName, SelectRequisitionTemplateName());    end;    procedure SetDemandForecast(CurrentDemandForecast: Code[10])    begin        InventorySetup.Get();        InventorySetup.Validate("Current Demand Forecast", CurrentDemandForecast);        InventorySetup.Modify();    end;    procedure SetUseForecastOnVariants(UseForecastOnVariants: Boolean)    begin        InventorySetup.Get();        InventorySetup.Validate("Use Forecast on Variants", UseForecastOnVariants);        InventorySetup.Modify();    end;    procedure SetUseForecastOnLocations(UseForecastOnLocations: Boolean)    begin        InventorySetup.Get();        InventorySetup.Validate("Use Forecast on Locations", UseForecastOnLocations);        InventorySetup.Modify();    end;    procedure SetDefaultDampenerPercent(DampenerPercent: Decimal)    begin        InventorySetup.Get();        InventorySetup.Validate("Default Dampener %", DampenerPercent);        InventorySetup.Modify();    end;    procedure SetDefaultDampenerPeriod(DampenerPeriod: Text)    begin        InventorySetup.Get();        Evaluate(InventorySetup."Default Dampener Period", DampenerPeriod);        InventorySetup.Modify();    end;    procedure SetDefaultSafetyLeadTime(SafetyLeadTime: DateFormula)    begin        InventorySetup.Get();        InventorySetup.Validate("Default Safety Lead Time", SafetyLeadTime);        InventorySetup.Modify();    end;    procedure SetDefaultSafetyLeadTime(SafetyLeadTime: Text)    begin        InventorySetup.Get();        Evaluate(InventorySetup."Default Safety Lead Time", SafetyLeadTime);        InventorySetup.Modify();    end;    procedure SetSafetyWorkDate(): Date    begin        InventorySetup.Get();        exit(CalcDate(InventorySetup."Default Safety Lead Time", WorkDate()));    end;    procedure SetBlankOverflowLevel(BlankOverflowLevel: Option)    begin        InventorySetup.Get();        InventorySetup.Validate("Blank Overflow Level", BlankOverflowLevel);        InventorySetup.Modify();    end;    procedure SetCombinedMPSMRPCalculation(CombinedMPSMRPCalculation: Boolean)    begin        InventorySetup.Get();        InventorySetup.Validate("Combined MPS/MRP Calculation", CombinedMPSMRPCalculation);        InventorySetup.Modify();    end;#if not CLEAN27#pragma warning disable AL0801    [Obsolete('Moved to codeunit LibraryManufacturing', '27.0')]    procedure SetComponentsAtLocation(LocationCode: Code[10])    var        LibraryManufacturing: Codeunit "Library - Manufacturing";    begin        LibraryManufacturing.SetComponentsAtLocation(LocationCode);    end;#pragma warning restore AL0801#endif}