Codeunit 6474 Serv. Item Substitution

Base Application, Microsoft.Service.Item

src/Layers/W1/BaseApp/Service/Item/ServItemSubstitution.Codeunit.al207 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.Service.Item;using Microsoft.Foundation.Company;using Microsoft.Foundation.Enums;using Microsoft.Inventory.Availability;using Microsoft.Inventory.Item;using Microsoft.Inventory.Item.Catalog;using Microsoft.Inventory.Item.Substitution;using Microsoft.Service.Document;codeunit 6474 "Serv. Item Substitution"{    var        CompanyInfo: Record "Company Information";        Item: Record Item;        ItemSubstitution: Record "Item Substitution";        TempItemSubstitution: Record "Item Substitution" temporary;        InvServiceLine: Record "Service Line";        NonStockItem: Record "Nonstock Item";        ServCatalogItemMgt: Codeunit "Serv. Catalog Item Mgt.";        SaveQty: Decimal;        SaveLocation: Code[10];        OldSalesUOM: Code[10];#pragma warning disable AA0074        Text000: Label 'This substitute item has a different sale unit of measure.';        Text001: Label 'An Item Substitution with the specified variant does not exist for Item No. ''%1''.';#pragma warning disable AA0470    procedure ItemServiceSubstGet(var ServiceLine2: Record "Service Line")    var        ServiceLineReserve: Codeunit "Service Line-Reserve";        ServItemCheckAvail: Codeunit "Serv. Item Check Avail.";    begin        InvServiceLine := ServiceLine2;        if InvServiceLine.Type <> InvServiceLine.Type::Item then            exit;        Item.Get(InvServiceLine."No.");        Item.SetFilter("Location Filter", InvServiceLine."Location Code");        Item.SetFilter("Variant Filter", InvServiceLine."Variant Code");        Item.SetRange("Date Filter", 0D, InvServiceLine."Order Date");        Item.CalcFields(Inventory);        Item.CalcFields("Qty. on Sales Order");        Item.CalcFields("Qty. on Service Order");        OldSalesUOM := Item."Sales Unit of Measure";        ItemSubstitution.Reset();        ItemSubstitution.SetRange("No.", InvServiceLine."No.");        ItemSubstitution.SetRange("Variant Code", InvServiceLine."Variant Code");        ItemSubstitution.SetRange("Location Filter", InvServiceLine."Location Code");        if ItemSubstitution.Find('-') then begin            TempItemSubstitution.DeleteAll();            InsertInSubstServiceList(InvServiceLine."No.", ItemSubstitution, 1);            TempItemSubstitution.Reset();            if TempItemSubstitution.Find('-') then;            if PAGE.RunModal(PAGE::"Service Item Substitutions", TempItemSubstitution) =               ACTION::LookupOK            then begin                if TempItemSubstitution."Substitute Type" =                   TempItemSubstitution."Substitute Type"::"Nonstock Item"                then begin                    NonStockItem.Get(TempItemSubstitution."Substitute No.");                    if NonStockItem."Item No." <> '' then                        TempItemSubstitution."Substitute No." := NonStockItem."Item No."                    else begin                        InvServiceLine."No." := TempItemSubstitution."Substitute No.";                        InvServiceLine."Variant Code" := TempItemSubstitution."Substitute Variant Code";                        ServCatalogItemMgt.NonStockFSM(InvServiceLine);                        TempItemSubstitution."Substitute No." := InvServiceLine."No.";                    end;                end;                InvServiceLine."No." := TempItemSubstitution."Substitute No.";                InvServiceLine."Variant Code" := TempItemSubstitution."Substitute Variant Code";                SaveQty := InvServiceLine.Quantity;                SaveLocation := InvServiceLine."Location Code";                InvServiceLine.Quantity := 0;                InvServiceLine.Validate("No.", TempItemSubstitution."Substitute No.");                InvServiceLine.Validate("Variant Code", TempItemSubstitution."Substitute Variant Code");                InvServiceLine."Location Code" := SaveLocation;                InvServiceLine.Validate(Quantity, SaveQty);                InvServiceLine.Validate("Unit of Measure Code", OldSalesUOM);                Commit();                if ServItemCheckAvail.ServiceInvLineCheck(InvServiceLine) then                    InvServiceLine := ServiceLine2;                if Item.Get(InvServiceLine."No.") and                   (Item."Sales Unit of Measure" <> OldSalesUOM)                then                    Message(Text000);            end;        end else            Error(Text001, InvServiceLine."No.");        if (ServiceLine2."No." <> InvServiceLine."No.") or (ServiceLine2."Variant Code" <> InvServiceLine."Variant Code") then            ServiceLineReserve.DeleteLine(ServiceLine2);        ServiceLine2 := InvServiceLine;    end;    local procedure InsertInSubstServiceList(OrgNo: Code[20]; var ItemSubstitution3: Record "Item Substitution"; RelationsLevel: Integer)    var        ItemSubstitution2: Record "Item Substitution";        AvailToPromise: Codeunit "Available to Promise";        GrossReq: Decimal;        SchedRcpt: Decimal;        RelatLevel: Integer;    begin        ItemSubstitution.Copy(ItemSubstitution3);        RelatLevel := RelationsLevel;        if ItemSubstitution.Find('-') then            repeat                Clear(TempItemSubstitution);                TempItemSubstitution.Type := ItemSubstitution.Type;                TempItemSubstitution."No." := ItemSubstitution."No.";                TempItemSubstitution."Variant Code" := ItemSubstitution."Variant Code";                TempItemSubstitution."Substitute Type" := ItemSubstitution."Substitute Type";                TempItemSubstitution."Substitute No." := ItemSubstitution."Substitute No.";                TempItemSubstitution."Substitute Variant Code" := ItemSubstitution."Substitute Variant Code";                TempItemSubstitution.Description := ItemSubstitution.Description;                TempItemSubstitution.Interchangeable := ItemSubstitution.Interchangeable;                TempItemSubstitution."Location Filter" := ItemSubstitution."Location Filter";                TempItemSubstitution."Relations Level" := RelatLevel;                if TempItemSubstitution."Substitute Type" = TempItemSubstitution.Type::Item then begin                    Item.Get(ItemSubstitution."Substitute No.");                    CompanyInfo.Get();                    OnInsertInSubstServiceListOnBeforeCalcQtyAvail(Item, InvServiceLine, TempItemSubstitution);                    TempItemSubstitution."Quantity Avail. on Shpt. Date" :=                      AvailToPromise.CalcQtyAvailabletoPromise(                        Item, GrossReq, SchedRcpt,                        Item.GetRangeMax("Date Filter"), "Analysis Period Type"::Month,                        CompanyInfo."Check-Avail. Period Calc.");                    Item.CalcFields(Inventory);                    OnInsertInSubstServiceListOnAfterCalcQtyAvail(Item, InvServiceLine, TempItemSubstitution);                    TempItemSubstitution.Inventory := Item.Inventory;                end;                if TempItemSubstitution.Insert() and                   (ItemSubstitution."Substitute No." <> '')                then begin                    ItemSubstitution2.SetRange(Type, ItemSubstitution.Type);                    ItemSubstitution2.SetRange("No.", ItemSubstitution."Substitute No.");                    ItemSubstitution2.SetFilter("Substitute No.", '<>%1&<>%2', ItemSubstitution."No.", OrgNo);                    ItemSubstitution.CopyFilter("Variant Code", ItemSubstitution2."Variant Code");                    ItemSubstitution.CopyFilter("Location Filter", ItemSubstitution2."Location Filter");                    if ItemSubstitution2.FindFirst() then                        InsertInSubstServiceList(OrgNo, ItemSubstitution2, (RelatLevel + 1));                end else begin                    TempItemSubstitution.Find();                    if RelatLevel < TempItemSubstitution."Relations Level" then begin                        TempItemSubstitution."Relations Level" := RelatLevel;                        TempItemSubstitution.Modify();                    end;                end;                if (ItemSubstitution."Substitute Type" = ItemSubstitution."Substitute Type"::"Nonstock Item") and                   (ItemSubstitution."Substitute No." <> '') and                   NonStockItem.Get(ItemSubstitution."Substitute No.") and                   (NonStockItem."Item No." <> '')                then begin                    Clear(TempItemSubstitution);                    TempItemSubstitution.Type := ItemSubstitution.Type;                    TempItemSubstitution."No." := ItemSubstitution."No.";                    TempItemSubstitution."Variant Code" := ItemSubstitution."Variant Code";                    TempItemSubstitution."Substitute Type" := TempItemSubstitution."Substitute Type"::Item;                    TempItemSubstitution."Substitute No." := NonStockItem."Item No.";                    TempItemSubstitution."Substitute Variant Code" := '';                    TempItemSubstitution.Description := ItemSubstitution.Description;                    TempItemSubstitution.Interchangeable := ItemSubstitution.Interchangeable;                    TempItemSubstitution."Location Filter" := ItemSubstitution."Location Filter";                    TempItemSubstitution."Relations Level" := RelatLevel;                    if TempItemSubstitution.Insert() then begin                        ItemSubstitution2.SetRange(Type, ItemSubstitution2.Type::"Nonstock Item");                        ItemSubstitution2.SetRange("No.", NonStockItem."Item No.");                        ItemSubstitution2.SetFilter("Substitute No.", '<>%1&<>%2', NonStockItem."Item No.", OrgNo);                        ItemSubstitution.CopyFilter("Variant Code", ItemSubstitution2."Variant Code");                        ItemSubstitution.CopyFilter("Location Filter", ItemSubstitution2."Location Filter");                        if ItemSubstitution2.FindFirst() then                            InsertInSubstServiceList(OrgNo, ItemSubstitution2, (RelatLevel + 1));                    end else begin                        TempItemSubstitution.Find();                        if RelatLevel < TempItemSubstitution."Relations Level" then begin                            TempItemSubstitution."Relations Level" := RelatLevel;                            TempItemSubstitution.Modify();                        end;                    end;                end;            until ItemSubstitution.Next() = 0;    end;    [IntegrationEvent(false, false)]    local procedure OnInsertInSubstServiceListOnAfterCalcQtyAvail(var Item: Record Item; ServiceLine: Record "Service Line"; var TempItemSubstitution: Record "Item Substitution" temporary)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertInSubstServiceListOnBeforeCalcQtyAvail(var Item: Record Item; ServiceLine: Record "Service Line"; var TempItemSubstitution: Record "Item Substitution" temporary)    begin    end;}