Codeunit 99000886 Capable to Promise
src/Layers/W1/BaseApp/Inventory/Availability/CapabletoPromise.Codeunit.al478 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.Availability;using Microsoft.Foundation.Company;using Microsoft.Foundation.Enums;using Microsoft.Foundation.NoSeries;using Microsoft.Foundation.UOM;using Microsoft.Inventory;using Microsoft.Inventory.Item;using Microsoft.Inventory.Planning;using Microsoft.Inventory.Requisition;using Microsoft.Inventory.Tracking;using Microsoft.Sales.Document;codeunit 99000886 "Capable to Promise"{ trigger OnRun() begin end; var OrderPromisingSetup: Record "Order Promising Setup"; CompanyInfo: Record "Company Information"; UOMMgt: Codeunit "Unit of Measure Management"; OrderPromisingID: Code[20]; LastEarlyDate: Date; LastLateDate: Date; OrderPromisingEnd: Date; OrderPromisingStart: Date; GrossRequirement: Decimal; ScheduledReceipt: Decimal; OrderPromisingLineNo: Integer; OrderPromisingLineToSave: Integer; SourceLineNo: Integer;#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'Calculation with date #1######';#pragma warning restore AA0470#pragma warning restore AA0074 local procedure ValidateCapableToPromise(var ReqLine: Record "Requisition Line"; ItemNo: Code[20]; VariantCode: Code[10]; LocationCode: Code[10]; NeededDate: Date; NeededQty: Decimal; UnitOfMeasure: Code[10]; PeriodType: Enum "Analysis Period Type"; var DueDateOfReqLine: Date) Result: Boolean var CumulativeATP: Decimal; ReqQty: Decimal; Ok: Boolean; IsHandled: Boolean; begin IsHandled := false; OnBeforeValidateCapableToPromise(ReqLine, ItemNo, VariantCode, LocationCode, NeededDate, NeededQty, UnitOfMeasure, PeriodType, DueDateOfReqLine, Result, IsHandled); if IsHandled then exit(Result); Clear(ReqLine); CumulativeATP := GetCumulativeATP(ItemNo, VariantCode, LocationCode, NeededDate, UnitOfMeasure, PeriodType); if CumulativeATP < 0 then begin if CumulativeATP + NeededQty <= 0 then ReqQty := NeededQty else ReqQty := -CumulativeATP; CreateReqLine(ItemNo, VariantCode, LocationCode, ReqQty, UnitOfMeasure, NeededDate, 1, ReqLine); OrderPromisingLineNo := OrderPromisingLineNo + 1; if ReqLine."Starting Date" < OrderPromisingStart then exit(false); end; Ok := CheckDerivedDemandCTP(ReqLine, PeriodType); if ReqLine."No." <> '' then begin if Ok then DueDateOfReqLine := ReqLine."Due Date" end else DueDateOfReqLine := NeededDate; exit(Ok); end; procedure CalcCapableToPromiseDate(ItemNo: Code[20]; VariantCode: Code[10]; LocationCode: Code[10]; NeededDate: Date; NeededQty: Decimal; UnitOfMeasure: Code[10]; var LocOrderPromisingID: Code[20]; LocSourceLineNo: Integer; var LastValidLine: Integer; PeriodType: Enum "Analysis Line Type"; PeriodLengthFormula: DateFormula) Result: Date var RequisitionLine: Record "Requisition Line"; CalculationDialog: Dialog; CalculationStartDate: Date; CapableToPromiseDate: Date; IsValid: Boolean; StopCalculation: Boolean; DueDateOfReqLine: Date; IsHandled: Boolean; begin IsHandled := false; OnBeforeCalcCapableToPromiseDate(ItemNo, VariantCode, LocationCode, NeededDate, NeededQty, UnitOfMeasure, LocOrderPromisingID, LocSourceLineNo, LastValidLine, PeriodType, PeriodLengthFormula, Result, IsHandled); if IsHandled then exit(Result); if NeededQty = 0 then exit(NeededDate); RemoveReqLines(LocOrderPromisingID, LocSourceLineNo, LastValidLine, false); SetOrderPromisingParameters(LocOrderPromisingID, LocSourceLineNo, PeriodLengthFormula); OnCalcCapableToPromiseDateOnAfterSetOrderPromisingParameters(ItemNo, VariantCode, LocationCode, PeriodLengthFormula, OrderPromisingStart, OrderPromisingEnd); CapableToPromiseDate := 0D; CalculationStartDate := NeededDate; if CalculationStartDate = 0D then CalculationStartDate := OrderPromisingStart; OrderPromisingLineToSave := OrderPromisingLineNo; if not ValidateCapableToPromise( RequisitionLine, ItemNo, VariantCode, LocationCode, CalculationStartDate, NeededQty, UnitOfMeasure, PeriodType, DueDateOfReqLine) then begin StopCalculation := false; LastEarlyDate := CalculationStartDate; LastLateDate := OrderPromisingEnd; CalculationStartDate := OrderPromisingEnd; CalculationDialog.Open(Text000); repeat CalculationDialog.Update(1, Format(CalculationStartDate)); RemoveReqLines(LocOrderPromisingID, LocSourceLineNo, OrderPromisingLineToSave, false); IsValid := ValidateCapableToPromise( RequisitionLine, ItemNo, VariantCode, LocationCode, CalculationStartDate, NeededQty, UnitOfMeasure, PeriodType, DueDateOfReqLine); if IsValid then begin CapableToPromiseDate := CalculationStartDate; StopCalculation := GetNextCalcStartDate(CalculationStartDate, 0); end else StopCalculation := GetNextCalcStartDate(CalculationStartDate, 1); until StopCalculation; if not IsValid and (CapableToPromiseDate > 0D) then begin RemoveReqLines(LocOrderPromisingID, LocSourceLineNo, OrderPromisingLineToSave, false); ValidateCapableToPromise( RequisitionLine, ItemNo, VariantCode, LocationCode, CapableToPromiseDate, NeededQty, UnitOfMeasure, PeriodType, DueDateOfReqLine); end; CalculationDialog.Close(); end else CapableToPromiseDate := CalculationStartDate; if CapableToPromiseDate <> DueDateOfReqLine then CapableToPromiseDate := DueDateOfReqLine; LastValidLine := GetNextOrderPromisingLineNo(); if CapableToPromiseDate = 0D then RemoveReqLines(LocOrderPromisingID, LocSourceLineNo, OrderPromisingLineNo, false); exit(CapableToPromiseDate); end; local procedure GetNextCalcStartDate(var CalculationStartDate: Date; Direction: Option Backwards,Forwards): Boolean var BestResult: Boolean; begin BestResult := false; if Direction = Direction::Backwards then begin LastLateDate := CalculationStartDate; if LastLateDate - LastEarlyDate > 1 then CalculationStartDate := CalculationStartDate - Round((LastLateDate - LastEarlyDate) / 2, 1, '>') else BestResult := true; end else begin LastEarlyDate := CalculationStartDate; if LastLateDate - LastEarlyDate > 1 then CalculationStartDate := CalculationStartDate + Round((LastLateDate - LastEarlyDate) / 2, 1, '>') else BestResult := true; end; exit(BestResult); end; local procedure CreateReqLine(ItemNo: Code[20]; VariantCode: Code[10]; LocationCode: Code[10]; Quantity: Decimal; Unit: Code[10]; DueDate: Date; Direction: Option Forward,Backward; var ReqLine: Record "Requisition Line") var SalesHeader: Record "Sales Header"; SalesLine: Record "Sales Line"; LeadTimeMgt: Codeunit "Lead-Time Management"; PlngLnMgt: Codeunit "Planning Line Management"; begin ReqLine.Init(); ReqLine."Order Promising ID" := OrderPromisingID; ReqLine."Order Promising Line ID" := SourceLineNo; ReqLine."Order Promising Line No." := OrderPromisingLineNo; ReqLine."Worksheet Template Name" := OrderPromisingSetup."Order Promising Template"; ReqLine."Journal Batch Name" := OrderPromisingSetup."Order Promising Worksheet"; GetNextReqLineNo(ReqLine); ReqLine.SetDoNotUpdateOrderReceiptDate(true); ReqLine.Type := ReqLine.Type::Item; ReqLine."Location Code" := LocationCode; ReqLine.Validate("No.", ItemNo); ReqLine.Validate("Variant Code", VariantCode); ReqLine."Action Message" := ReqLine."Action Message"::New; ReqLine."Accept Action Message" := false; ReqLine.Validate("Ending Date", LeadTimeMgt.GetPlannedEndingDate( ItemNo, LocationCode, VariantCode, DueDate, ReqLine."Vendor No.", ReqLine."Ref. Order Type")); ReqLine."Ending Time" := 235959T; ReqLine.Validate("Unit of Measure Code", Unit); ReqLine.Validate(Quantity, Quantity); if ReqLine."Starting Date" = 0D then ReqLine."Starting Date" := WorkDate(); OnBeforeReqLineInsert(ReqLine); ReqLine.Insert(true); PlngLnMgt.Calculate(ReqLine, Direction, true, true, 0); if SalesLine.Get(SalesLine."Document Type"::Order, ReqLine."Order Promising ID", ReqLine."Order Promising Line ID") then if SalesLine."Drop Shipment" then begin ReqLine."Sales Order No." := SalesLine."Document No."; ReqLine."Sales Order Line No." := SalesLine."Line No."; ReqLine."Sell-to Customer No." := SalesLine."Sell-to Customer No."; ReqLine."Purchasing Code" := SalesLine."Purchasing Code"; SalesHeader.Get(Enum::"Sales Document Type"::Order, ReqLine."Order Promising ID"); ReqLine."Ship-to Code" := SalesHeader."Ship-to Code"; end; OnBeforeReqLineModify(ReqLine); ReqLine.Modify(); end; local procedure CheckDerivedDemandCTP(ReqLine: Record "Requisition Line"; PeriodType: Enum "Analysis Period Type"): Boolean begin if ReqLine."Replenishment System" = ReqLine."Replenishment System"::Transfer then exit(CheckTransferShptCTP(ReqLine, PeriodType)); exit(CheckCompsCapableToPromise(ReqLine, PeriodType)); end; local procedure CheckCompsCapableToPromise(ReqLine: Record "Requisition Line"; PeriodType: Enum "Analysis Period Type") Result: Boolean var PlanningComponent: Record "Planning Component"; ReqLine2: Record "Requisition Line"; CompReqLine: Record "Requisition Line"; IsValidDate: Boolean; DueDateOfReqLine: Date; IsHandled: Boolean; begin IsHandled := false; OnBeforeCheckCompsCapableToPromise(ReqLine, PeriodType, Result, IsHandled); if IsHandled then exit(Result); PlanningComponent.SetRange("Worksheet Template Name", ReqLine."Worksheet Template Name"); PlanningComponent.SetRange("Worksheet Batch Name", ReqLine."Journal Batch Name"); PlanningComponent.SetRange("Worksheet Line No.", ReqLine."Line No."); PlanningComponent.SetFilter(Quantity, '<>%1', 0); if PlanningComponent.FindSet() then repeat if (PlanningComponent."Supplied-by Line No." = 0) and PlanningComponent.Critical then begin if ValidateCapableToPromise( CompReqLine, PlanningComponent."Item No.", PlanningComponent."Variant Code", PlanningComponent."Location Code", PlanningComponent."Due Date", PlanningComponent."Expected Quantity", PlanningComponent."Unit of Measure Code", PeriodType, DueDateOfReqLine) then BindToRequisition(PlanningComponent, CompReqLine) else begin OrderPromisingLineNo := OrderPromisingLineNo - 1; exit(false); end; end else if PlanningComponent."Supplied-by Line No." > 0 then if ReqLine2.Get(ReqLine."Worksheet Template Name", ReqLine."Journal Batch Name", PlanningComponent."Supplied-by Line No.") then begin IsValidDate := CheckDerivedDemandCTP(ReqLine2, PeriodType); if not IsValidDate or (ReqLine2."Starting Date" < OrderPromisingStart) then exit(false); end; until PlanningComponent.Next() = 0; exit(true); end; local procedure BindToRequisition(PlanningComponent: Record "Planning Component"; CompReqLine: Record "Requisition Line") var TrackingSpecification: Record "Tracking Specification"; PlngComponentReserve: Codeunit "Plng. Component-Reserve"; begin if PlanningComponent."Location Code" <> CompReqLine."Location Code" then exit; TrackingSpecification.InitTrackingSpecification( DATABASE::"Requisition Line", 0, CompReqLine."Worksheet Template Name", CompReqLine."Journal Batch Name", 0, CompReqLine."Line No.", CompReqLine."Variant Code", CompReqLine."Location Code", CompReqLine."Qty. per Unit of Measure"); PlngComponentReserve.BindToTracking( PlanningComponent, TrackingSpecification, CompReqLine.Description, CompReqLine."Ending Date", CompReqLine.Quantity, CompReqLine."Quantity (Base)") end; local procedure CheckTransferShptCTP(ReqLine: Record "Requisition Line"; PeriodType: Enum "Analysis Period Type") Result: Boolean var Item: Record Item; RequisitionLine: Record "Requisition Line"; DueDateOfReqLine: Date; IsHandled: Boolean; begin IsHandled := false; OnBeforeCheckTransferShptCTP(ReqLine, PeriodType, Result, IsHandled); if IsHandled then exit(Result); ReqLine.TestField("Replenishment System", ReqLine."Replenishment System"::Transfer); Item.Get(ReqLine."No."); if Item.Critical then if not ValidateCapableToPromise( RequisitionLine, ReqLine."No.", ReqLine."Variant Code", ReqLine."Transfer-from Code", ReqLine."Transfer Shipment Date", ReqLine.Quantity, ReqLine."Unit of Measure Code", PeriodType, DueDateOfReqLine) then begin OrderPromisingLineNo := OrderPromisingLineNo - 1; exit(false); end; exit(true); end; local procedure GetNextReqLineNo(var ReqLine: Record "Requisition Line") var ReqLine2: Record "Requisition Line"; begin ReqLine2.SetRange("Worksheet Template Name", ReqLine."Worksheet Template Name"); ReqLine2.SetRange("Journal Batch Name", ReqLine."Journal Batch Name"); if ReqLine2.FindLast() then ReqLine."Line No." := ReqLine2."Line No." + 10000 else ReqLine."Line No." := 10000; end; local procedure SetOrderPromisingParameters(var LocOrderPromisingID: Code[20]; LocSourceLineNo: Integer; PeriodLengthFormula: DateFormula) var NoSeries: Codeunit "No. Series"; begin CompanyInfo.Get(); OrderPromisingSetup.Get(); OrderPromisingSetup.TestField("Order Promising Template"); OrderPromisingSetup.TestField("Order Promising Worksheet"); if LocOrderPromisingID = '' then begin LocOrderPromisingID := NoSeries.GetNextNo(OrderPromisingSetup."Order Promising Nos.", WorkDate()); OrderPromisingLineNo := 1; end else OrderPromisingLineNo := GetNextOrderPromisingLineNo(); OrderPromisingID := LocOrderPromisingID; SourceLineNo := LocSourceLineNo; OrderPromisingStart := CalcDate(OrderPromisingSetup."Offset (Time)", WorkDate()); OrderPromisingEnd := CalcDate(PeriodLengthFormula, OrderPromisingStart); end; procedure RemoveReqLines(OrderPromisingID: Code[20]; SourceLineNo: Integer; LastGoodLineNo: Integer; FilterOnNonAccepted: Boolean) var ReqLine: Record "Requisition Line"; begin ReqLine.SetCurrentKey("Order Promising ID", ReqLine."Order Promising Line ID", ReqLine."Order Promising Line No."); ReqLine.SetRange("Order Promising ID", OrderPromisingID); if SourceLineNo <> 0 then ReqLine.SetRange("Order Promising Line ID", SourceLineNo); if LastGoodLineNo <> 0 then ReqLine.SetFilter("Order Promising Line No.", '>=%1', LastGoodLineNo); if FilterOnNonAccepted then ReqLine.SetRange("Accept Action Message", false); if ReqLine.Find('-') then repeat ReqLine.DeleteMultiLevel(); ReqLine.Delete(true); until ReqLine.Next() = 0; end; local procedure GetCumulativeATP(ItemNo: Code[20]; VariantCode: Code[10]; LocationCode: Code[10]; DueDate: Date; UnitOfMeasureCode: Code[10]; PeriodType: Enum "Analysis Period Type") Result: Decimal var Item: Record Item; ItemUnitOfMeasure: Record "Item Unit of Measure"; AvailToPromise: Codeunit "Available to Promise"; CumulativeATP: Decimal; IsHandled: Boolean; begin IsHandled := false; OnBeforeGetCumulativeATP(ItemNo, VariantCode, LocationCode, DueDate, UnitOfMeasureCode, PeriodType, Result, IsHandled); if IsHandled then exit(Result); Item.Get(ItemNo); Item.SetRange("Variant Filter", VariantCode); Item.SetRange("Location Filter", LocationCode); Item.SetRange("Date Filter", 0D, DueDate); CumulativeATP := AvailToPromise.CalcQtyAvailableToPromise( Item, GrossRequirement, ScheduledReceipt, DueDate, PeriodType, CompanyInfo."Check-Avail. Period Calc."); if UnitOfMeasureCode = Item."Base Unit of Measure" then exit(CumulativeATP); ItemUnitOfMeasure.Get(ItemNo, UnitOfMeasureCode); exit(Round(CumulativeATP / ItemUnitOfMeasure."Qty. per Unit of Measure", UOMMgt.QtyRndPrecision())); end; local procedure GetNextOrderPromisingLineNo(): Integer var ReqLine: Record "Requisition Line"; begin ReqLine.SetCurrentKey("Order Promising ID"); ReqLine.SetRange("Order Promising ID", OrderPromisingID); if ReqLine.FindLast() then exit(ReqLine."Order Promising Line No." + 1); exit(1); end;#if not CLEAN27 [Obsolete('Moved to codeunit ProdOrderAvailabilityMgt', '27.0')] procedure ReassignRefOrderNos(OrderPromisingID: Code[20]) var ProdOrderAvailabilityMgt: Codeunit Microsoft.Manufacturing.Document."Prod. Order Availability Mgt."; begin ProdOrderAvailabilityMgt.ReassignRefOrderNos(OrderPromisingID); end;#endif [IntegrationEvent(false, false)] local procedure OnBeforeReqLineInsert(var RequisitionLine: Record "Requisition Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeReqLineModify(var RequisitionLine: Record "Requisition Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeGetCumulativeATP(ItemNo: Code[20]; VariantCode: Code[10]; LocationCode: Code[10]; DueDate: Date; UnitOfMeasureCode: Code[10]; PeriodType: Enum "Analysis Period Type"; var Result: Decimal; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCheckCompsCapableToPromise(RequisitionLine: Record "Requisition Line"; PeriodType: Enum "Analysis Period Type"; var Result: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeValidateCapableToPromise(var RequisitionLine: Record "Requisition Line"; ItemNo: Code[20]; VariantCode: Code[10]; LocationCode: Code[10]; NeededDate: Date; NeededQty: Decimal; UnitOfMeasure: Code[10]; PeriodType: Enum "Analysis Period Type"; var DueDateOfReqLine: Date; var Result: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCalcCapableToPromiseDate(ItemNo: Code[20]; VariantCode: Code[10]; LocationCode: Code[10]; NeededDate: Date; NeededQty: Decimal; UnitOfMeasure: Code[10]; var LocOrderPromisingID: Code[20]; LocSourceLineNo: Integer; var LastValidLine: Integer; PeriodType: Enum "Analysis Line Type"; PeriodLengthFormula: DateFormula; var Result: Date; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCheckTransferShptCTP(RequisitionLine: Record "Requisition Line"; PeriodType: Enum "Analysis Period Type"; var Result: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(true, false)] local procedure OnCalcCapableToPromiseDateOnAfterSetOrderPromisingParameters(ItemNo: Code[20]; VariantCode: Code[10]; LocationCode: Code[10]; PeriodLengthFormula: DateFormula; var OrderPromisingStart: Date; var OrderPromisingEnd: Date); begin end;#if not CLEAN27 internal procedure RunOnBeforeReassignRefOrderNos(OrderPromisingID: Code[20]; var IsHandled: Boolean); begin OnBeforeReassignRefOrderNos(OrderPromisingID, IsHandled); end; [Obsolete('Moved to codeunit ProdOrderAvailabilityMgt', '27.0')] [IntegrationEvent(false, false)] local procedure OnBeforeReassignRefOrderNos(OrderPromisingID: Code[20]; var IsHandled: Boolean); begin end;#endif#if not CLEAN27 internal procedure RunOnReassignRefOrderNosOnAfterRequisitionLineModifyAll(var RequisitionLine: Record "Requisition Line"); begin OnReassignRefOrderNosOnAfterRequisitionLineModifyAll(RequisitionLine); end; [Obsolete('Moved to codeunit ProdOrderAvailabilityMgt', '27.0')] [IntegrationEvent(false, false)] local procedure OnReassignRefOrderNosOnAfterRequisitionLineModifyAll(var RequisitionLine: Record "Requisition Line"); begin end;#endif}