Report 99001023 Get Action Messages

Base Application, Microsoft.Inventory.Requisition

src/Layers/W1/BaseApp/Inventory/Requisition/GetActionMessages.Report.al398 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.Requisition;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using Microsoft.Inventory.Planning;using Microsoft.Inventory.Setup;using Microsoft.Inventory.Tracking;using Microsoft.Inventory.Transfer;using Microsoft.Purchases.Document;report 99001023 "Get Action Messages"{    Caption = 'Get Action Messages';    ProcessingOnly = true;    dataset    {        dataitem(Item; Item)        {            DataItemTableView = sorting("Low-Level Code") where("Order Tracking Policy" = const("Tracking & Action Msg."));            RequestFilterFields = "No.", "Search Description";            trigger OnAfterGetRecord()            begin                Window.Update(1, Text001);                Window.Update(2, "No.");                if "Order Tracking Policy" <> "Order Tracking Policy"::"Tracking & Action Msg." then                    CurrReport.Skip();                ReqLineExtern.SetRange(Type, ReqLineExtern.Type::Item);                ReqLineExtern.SetRange("No.", "No.");                if ReqLineExtern.FindFirst() then begin                    TempItemInOtherWksh := Item;                    TempItemInOtherWksh.Insert();                    CurrReport.Skip();                end;                ActionMessageEntry.SetRange("Item No.", "No.");                if ActionMessageEntry.Find('-') then                    repeat                        ActionMessageEntry.SetSourceFilterFromActionEntry(ActionMessageEntry);                        ActionMessageEntry.SetRange("Location Code", ActionMessageEntry."Location Code");                        ActionMessageEntry.SetRange("Bin Code", ActionMessageEntry."Bin Code");                        ActionMessageEntry.SetRange("Variant Code", ActionMessageEntry."Variant Code");                        if ActionMessageEntry."Source ID" = '' then begin                            TempNewActionMsgEntry.DeleteAll();                            repeat                                TrkgReservEntry.Get(ActionMessageEntry."Reservation Entry", false);                                if TempNewActionMsgEntry.Get(                                     TrkgReservEntry."Shipment Date" - 19000101D)                                then begin // Generate Entry No. in date order.                                    TempNewActionMsgEntry.Quantity += ActionMessageEntry.Quantity;                                    TempNewActionMsgEntry.Modify();                                end else begin                                    TempNewActionMsgEntry := ActionMessageEntry;                                    TempNewActionMsgEntry."Entry No." := TrkgReservEntry."Shipment Date" - 19000101D;                                    TempNewActionMsgEntry."New Date" := TrkgReservEntry."Shipment Date";                                    TempNewActionMsgEntry.Insert();                                end;                            until ActionMessageEntry.Next() = 0;                            TempNewActionMsgEntry.Find('-');                            repeat                                TempActionMsgEntry := TempNewActionMsgEntry;                                NextEntryNo := NextEntryNo + 1;                                TempActionMsgEntry."Entry No." := NextEntryNo;                                TempActionMsgEntry.Insert();                            until TempNewActionMsgEntry.Next() = 0;                        end else                            if ActionMessageEntry.Find('+') then                                UpdateActionMessageList(                                    ActionMessageEntry."Source Type", ActionMessageEntry."Source Subtype",                                    ActionMessageEntry."Source ID", ActionMessageEntry."Source Batch Name",                                    ActionMessageEntry."Source Prod. Order Line", ActionMessageEntry."Source Ref. No.",                                    ActionMessageEntry."Location Code", ActionMessageEntry."Bin Code",                                    ActionMessageEntry."Variant Code", ActionMessageEntry."Item No.", 0D);                        ActionMessageEntry.ClearSourceFilter();                        ActionMessageEntry.SetRange("Location Code");                        ActionMessageEntry.SetRange("Bin Code");                        ActionMessageEntry.SetRange("Variant Code");                    until ActionMessageEntry.Next() = 0;            end;            trigger OnPostDataItem()            begin                if TempItemInOtherWksh.FindFirst() then begin                    Window.Close();                    if Confirm(Text002) then                        PAGE.RunModal(0, TempItemInOtherWksh);                    if not Confirm(Text005) then                        Error(Text006);                    Window.Open(                      '#1##########################\\' +                      Text000);                end;                Window.Update(1, Text007);                TempActionMsgEntry.Reset();                PlanningLinesInserted := false;                if not TempActionMsgEntry.Find('-') then                    Error(Text008);                repeat                    GetActionMessages(TempActionMsgEntry);                until TempActionMsgEntry.Next() = 0;                if not PlanningLinesInserted then                    Error(Text008);                // Dynamic tracking is run for the handled Planning Lines:                if TempReqLineList.Find('-') then                    repeat                        ReservMgt.SetReservSource(TempReqLineList);                        ReservMgt.AutoTrack(TempReqLineList."Net Quantity (Base)");                    until TempReqLineList.Next() = 0;                // Dynamic tracking is run for the handled Planning Components:                if TempPlanningCompList.Find('-') then                    repeat                        ReservMgt.SetReservSource(TempPlanningCompList);                        ReservMgt.AutoTrack(TempPlanningCompList."Net Quantity (Base)");                    until TempPlanningCompList.Next() = 0;            end;            trigger OnPreDataItem()            begin                CopyFilter("Variant Filter", ActionMessageEntry."Variant Code");                CopyFilter("Location Filter", ActionMessageEntry."Location Code");                CopyFilter("Bin Filter", ActionMessageEntry."Bin Code");                ReqLineExtern.SetCurrentKey(Type, "No.", "Variant Code", "Location Code");                ReqLineExtern.SetRange(Type, ReqLineExtern.Type::Item);                CopyFilter("Variant Filter", ReqLineExtern."Variant Code");                CopyFilter("Location Filter", ReqLineExtern."Location Code");                ActionMessageEntry.SetCurrentKey("Source Type", "Source Subtype", "Source ID", "Source Batch Name",                  "Source Prod. Order Line", "Source Ref. No.");                ActionMessageEntry2.SetCurrentKey("Reservation Entry");                TempItemInOtherWksh.DeleteAll();                TempActionMsgEntry.DeleteAll();                TempReqLineList.DeleteAll();                TempPlanningCompList.DeleteAll();                InventorySetup.Get();            end;        }    }    requestpage    {        SaveValues = true;        layout        {        }        actions        {        }    }    labels    {    }    trigger OnPreReport()    begin        Window.Open(          '#1##########################\\' +          Text000);    end;    var        ReqLineExtern: Record "Requisition Line";        TrkgReservEntry: Record "Reservation Entry";        TempItemInOtherWksh: Record Item temporary;        TempActionMsgEntry: Record "Action Message Entry" temporary;        TempNewActionMsgEntry: Record "Action Message Entry" temporary;        ActionMessageEntry: Record "Action Message Entry";        ActionMessageEntry2: Record "Action Message Entry";        InventorySetup: Record "Inventory Setup";        TempPlanningCompList: Record "Planning Component" temporary;        TempReqLineList: Record "Requisition Line" temporary;        SKU: Record "Stockkeeping Unit";        InvtProfileOffsetting: Codeunit "Inventory Profile Offsetting";        ReservMgt: Codeunit "Reservation Management";        GetPlanningParameters: Codeunit "Planning-Get Parameters";        UOMMgt: Codeunit "Unit of Measure Management";        Window: Dialog;        NextEntryNo: Integer;        CurrTemplateName: Code[10];        CurrWorksheetName: Code[10];        PlanningLinesInserted: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'Item No.  #2##################';#pragma warning restore AA0470        Text001: Label 'Building action message list...';        Text002: Label 'Some items within the filter already exist on the planning lines.\Action messages that are related to these items will not be processed.\\Do you want to see a list of the unprocessed items?';        Text005: Label 'Do you want to continue?';        Text006: Label 'The process has been canceled.';        Text007: Label 'Processing action messages...';        Text008: Label 'No action messages exist.';        Text009: Label 'GetActionMessages: Illegal Action Message relation.';#pragma warning restore AA0074    procedure SetTemplAndWorksheet(TemplateName: Code[10]; WorksheetName: Code[10])    begin        CurrTemplateName := TemplateName;        CurrWorksheetName := WorksheetName;    end;#if not CLEAN27    [Obsolete('Replaced by UpdateActionMessageList due to extending ForBin to Code20', '27.0')]    procedure UpdateActionMsgList(ForType: Integer; ForSubtype: Integer; ForID: Code[20]; ForBatchName: Code[10]; ForProdOrderLine: Integer; ForRefNo: Integer; ForLocation: Code[10]; ForBin: Code[10]; ForVariant: Code[10]; ForItem: Code[20]; OrderDate: Date)    begin        UpdateActionMessageList(ForType, ForSubtype, ForID, ForBatchName, ForProdOrderLine, ForRefNo, ForLocation, ForBin, ForVariant, ForItem, OrderDate);    end;#endif    procedure UpdateActionMessageList(ForType: Integer; ForSubtype: Integer; ForID: Code[20]; ForBatchName: Code[10]; ForProdOrderLine: Integer; ForRefNo: Integer; ForLocation: Code[10]; ForBin: Code[20]; ForVariant: Code[10]; ForItem: Code[20]; OrderDate: Date)    begin        TempActionMsgEntry.SetSourceFilter(ForType, ForSubtype, ForID, ForRefNo, false);        TempActionMsgEntry.SetSourceFilter(ForBatchName, ForProdOrderLine);        TempActionMsgEntry.SetRange(TempActionMsgEntry."Location Code", ForLocation);        TempActionMsgEntry.SetRange(TempActionMsgEntry."Bin Code", ForBin);        TempActionMsgEntry.SetRange(TempActionMsgEntry."Variant Code", ForVariant);        TempActionMsgEntry.SetRange(TempActionMsgEntry."Item No.", ForItem);        TempActionMsgEntry.SetRange(TempActionMsgEntry."New Date", OrderDate);        if TempActionMsgEntry.Find('-') then            exit;        TempActionMsgEntry.SetSource(ForType, ForSubtype, ForID, ForRefNo, ForBatchName, ForProdOrderLine);        TempActionMsgEntry."Location Code" := ForLocation;        TempActionMsgEntry."Bin Code" := ForBin;        TempActionMsgEntry."Variant Code" := ForVariant;        TempActionMsgEntry."Item No." := ForItem;        TempActionMsgEntry."New Date" := OrderDate;        NextEntryNo := NextEntryNo + 1;        TempActionMsgEntry."Entry No." := NextEntryNo;        TempActionMsgEntry.Insert();    end;    procedure GetActionMessages(ActionMsgEntry: Record "Action Message Entry")    var        ReqLine: Record "Requisition Line";        InsertNew: Boolean;    begin        if ActionMsgEntry."Source ID" = '' then // Not related to existing order.            ActionMessageEntry := ActionMsgEntry        else begin            ActionMessageEntry.SetSourceFilterFromActionEntry(ActionMsgEntry);            ActionMessageEntry.SetRange("Location Code", ActionMsgEntry."Location Code");            ActionMessageEntry.SetRange("Bin Code", ActionMsgEntry."Bin Code");            ActionMessageEntry.SetRange("Variant Code", ActionMsgEntry."Variant Code");            ActionMessageEntry.SetRange("Item No.", ActionMsgEntry."Item No.");            if not ActionMessageEntry.Find('-') then                exit;        end;        GetPlanningParameters.AtSKU(SKU, ActionMessageEntry."Item No.", ActionMessageEntry."Variant Code", ActionMessageEntry."Location Code");        InsertNew := false;        ReqLine."Worksheet Template Name" := CurrTemplateName;        ReqLine."Journal Batch Name" := CurrWorksheetName;        ReqLine."Line No." += 10000;        while not ReqLine.Insert() do            ReqLine."Line No." += 10000;        InsertNew := InitReqFromSource(ActionMsgEntry, ReqLine);        Window.Update(2, ReqLine."No.");        if ActionMsgEntry."Source ID" = '' then begin            ActionMessageEntry.Quantity := ActionMsgEntry.Quantity;            ActionMessageEntry.Type := ActionMessageEntry.Type::New;            ReqLine."Due Date" := ActionMsgEntry."New Date";            ReqLine."Ending Date" := ReqLine."Due Date" - 1;        end else            ActionMessageEntry.SumUp(ActionMessageEntry);        if ActionMessageEntry.Quantity < 0 then            if SKU."Lot Size" > 0 then                if InventorySetup."Default Dampener %" > 0 then                    if InventorySetup."Default Dampener %" * SKU."Lot Size" / 100 >= Abs(ActionMessageEntry.Quantity) then                        ActionMessageEntry.Quantity := 0;        if (ActionMessageEntry.Quantity = 0) and (ActionMessageEntry."New Date" = 0D) then            exit;        ReqLine."Original Quantity" := ReqLine.Quantity;        ReqLine."Quantity (Base)" += ActionMessageEntry.Quantity;        ReqLine.Quantity := Round(ReqLine."Quantity (Base)" / ReqLine."Qty. per Unit of Measure", UOMMgt.QtyRndPrecision());        ReqLine."Remaining Quantity" := ReqLine.Quantity - ReqLine."Finished Quantity";        ReqLine."Remaining Qty. (Base)" :=          Round(ReqLine."Remaining Quantity" / ReqLine."Qty. per Unit of Measure", UOMMgt.QtyRndPrecision());        if InsertNew then            ActionMessageEntry.Type := ActionMessageEntry.Type::New;        if ActionMessageEntry."New Date" <> 0D then begin            if ActionMessageEntry.Type <> ActionMessageEntry.Type::New then                ReqLine."Original Due Date" := ReqLine."Due Date";            ReqLine."Due Date" := ActionMessageEntry."New Date";            ReqLine."Starting Date" := 0D;            if ActionMessageEntry.BoundToComponent() then begin                ReqLine."Ending Date" := ActionMessageEntry.ComponentDueDate();                ReqLine."Ending Time" := ActionMessageEntry.ComponentDueTime();            end else                ReqLine."Ending Date" := 0D;        end;        if ReqLine.Quantity = 0 then            ReqLine."Action Message" := ReqLine."Action Message"::Cancel        else            ReqLine."Action Message" := ActionMessageEntry.Type;        ReqLine."Planning Line Origin" := ReqLine."Planning Line Origin"::"Action Message";        ReqLine."Accept Action Message" := true;        ReqLine.Modify();        if ReqLine."Starting Date" = 0D then            ReqLine."Starting Date" := ReqLine."Due Date";        if ReqLine."Ending Date" = 0D then            ReqLine."Ending Date" := ReqLine."Due Date" - 1;        ReqLine.BlockDynamicTracking(true);        GetRoutingAndComponents(ReqLine);        if ReqLine."Original Due Date" <> 0D then            if not (ReqLine."Action Message" in [ReqLine."Action Message"::Reschedule,                                                 ReqLine."Action Message"::"Resched. & Chg. Qty."])            then                ReqLine."Original Due Date" := 0D;        if ReqLine."Original Quantity" = ReqLine.Quantity then            if ReqLine."Action Message" = ReqLine."Action Message"::"Resched. & Chg. Qty." then                ReqLine."Action Message" := ReqLine."Action Message"::Reschedule;        ReqLine.Validate(Quantity);        if ReqLine."Action Message" = ReqLine."Action Message"::Reschedule then            ReqLine."Original Quantity" := 0;        ReqLine.Modify();        Clear(ReqLineExtern);        // Retrieve temporary list of Planning Components handled:        InvtProfileOffsetting.GetPlanningCompList(TempPlanningCompList);        // Save inserted Planning Line in temporary list:        TempReqLineList := ReqLine;        TempReqLineList.Insert();        PlanningLinesInserted := true;    end;    local procedure InitReqFromSource(ActionMsgEntry: Record "Action Message Entry"; var ReqLine: Record "Requisition Line"): Boolean    var        PurchOrderLine: Record "Purchase Line";        TransLine: Record "Transfer Line";        IsHandled: Boolean;        ShouldExit: Boolean;    begin        case ActionMsgEntry."Source Type" of            Database::"Purchase Line":                if PurchOrderLine.Get(ActionMsgEntry."Source Subtype", ActionMsgEntry."Source ID", ActionMsgEntry."Source Ref. No.") then begin                    ReqLine.GetPurchOrderLine(PurchOrderLine);                    exit(false);                end;            Database::"Transfer Line":                if TransLine.Get(ActionMsgEntry."Source ID", ActionMsgEntry."Source Ref. No.") then begin                    ReqLine.GetTransLine(TransLine);                    exit(false);                end;            else begin                IsHandled := false;                OnInitReqFromSourceBySource(ReqLine, ActionMsgEntry, ShouldExit, IsHandled);                if ShouldExit then                    exit(false);                if not IsHandled then                    Error(Text009)            end;        end;        ReqLine.TransferFromActionMessage(ActionMsgEntry);        exit(true);    end;    local procedure GetRoutingAndComponents(var ReqLine: Record "Requisition Line")    var        Direction: Option Forward,Backward;    begin        InvtProfileOffsetting.GetRouting(ReqLine);        InvtProfileOffsetting.GetComponents(ReqLine);        InvtProfileOffsetting.Recalculate(ReqLine, Direction::Backward, true);    end;    [IntegrationEvent(false, false)]    local procedure OnInitReqFromSourceBySource(var ReqLine: Record "Requisition Line"; ActionMessageEntry: Record "Action Message Entry"; var ShouldExit: Boolean; var IsHandled: Boolean)    begin    end;}