Codeunit 99000771 BOM Matrix Management
src/Layers/W1/BaseApp/Manufacturing/ProductionBOM/BOMMatrixManagement.Codeunit.al290 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.Manufacturing.ProductionBOM;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;codeunit 99000771 "BOM Matrix Management"{ Permissions = TableData Item = r, TableData "Production BOM Header" = r, TableData "Production BOM Version" = r, TableData "Production Matrix BOM Line" = rimd, TableData "Production Matrix BOM Entry" = rimd; trigger OnRun() begin end; var Item: Record Item; ItemAssembly: Record Item; ProdBOMHeader: Record "Production BOM Header"; ProdBOMVersion: Record "Production BOM Version"; ProdBOMVersion2: Record "Production BOM Version"; TempComponentList: Record "Production Matrix BOM Line" temporary; TempComponentEntry: Record "Production Matrix BOM Entry" temporary; ComponentEntry2: Record "Production Matrix BOM Entry"; UOMMgt: Codeunit "Unit of Measure Management"; VersionMgt: Codeunit VersionManagement; GlobalCalcDate: Date; MatrixType: Option Version,Item; MultiLevel: Boolean; procedure FindRecord(Which: Text[30]; var ComponentList2: Record "Production Matrix BOM Line"): Boolean begin TempComponentList := ComponentList2; if not TempComponentList.Find(Which) then exit(false); ComponentList2 := TempComponentList; exit(true); end; procedure NextRecord(Steps: Integer; var ComponentList2: Record "Production Matrix BOM Line"): Integer var CurrentSteps: Integer; begin TempComponentList := ComponentList2; CurrentSteps := TempComponentList.Next(Steps); if CurrentSteps <> 0 then ComponentList2 := TempComponentList; exit(CurrentSteps); end; procedure GetComponentNeed(No: Code[20]; VariantCode: Code[10]; ID: Code[20]): Decimal begin TempComponentEntry.SetRange("Item No.", No); TempComponentEntry.SetRange("Variant Code", VariantCode); TempComponentEntry.SetRange(ID, ID); if not TempComponentEntry.FindFirst() then Clear(TempComponentEntry); exit(TempComponentEntry.Quantity); end; procedure CompareTwoItems(Item1: Record Item; Item2: Record Item; CalcDate: Date; NewMultiLevel: Boolean; var VersionCode1: Code[20]; var VersionCode2: Code[20]; var UnitOfMeasureCode1: Code[10]; var UnitOfMeasureCode2: Code[10]) var IsHandled: Boolean; begin IsHandled := false; OnBeforeCompareTwoItems(Item1, Item2, CalcDate, NewMultiLevel, VersionCode1, VersionCode2, UnitOfMeasureCode1, UnitOfMeasureCode2, IsHandled); if not IsHandled then begin GlobalCalcDate := CalcDate; TempComponentList.DeleteAll(); TempComponentEntry.Reset(); TempComponentEntry.DeleteAll(); MultiLevel := NewMultiLevel; MatrixType := MatrixType::Item; VersionCode1 := VersionMgt.GetBOMVersion( Item1."Production BOM No.", GlobalCalcDate, false); UnitOfMeasureCode1 := VersionMgt.GetBOMUnitOfMeasure( Item1."Production BOM No.", VersionCode1); ItemAssembly := Item1; BuildMatrix( Item1."Production BOM No.", VersionCode1, 1, UOMMgt.GetQtyPerUnitOfMeasure( Item1, UnitOfMeasureCode1) / UOMMgt.GetQtyPerUnitOfMeasure( Item1, Item1."Base Unit of Measure")); VersionCode2 := VersionMgt.GetBOMVersion( Item2."Production BOM No.", GlobalCalcDate, false); UnitOfMeasureCode2 := VersionMgt.GetBOMUnitOfMeasure( Item2."Production BOM No.", VersionCode2); ItemAssembly := Item2; BuildMatrix( Item2."Production BOM No.", VersionCode2, 1, UOMMgt.GetQtyPerUnitOfMeasure( Item2, UnitOfMeasureCode2) / UOMMgt.GetQtyPerUnitOfMeasure( Item2, Item2."Base Unit of Measure")); end; OnAfterCompareTwoItems(Item1, Item2, CalcDate, NewMultiLevel, VersionCode1, VersionCode2, UnitOfMeasureCode1, UnitOfMeasureCode2); end; procedure BOMMatrixFromBOM(ProductionBOMHeader: Record "Production BOM Header"; NewMultiLevel: Boolean) var IsHandled: Boolean; begin IsHandled := false; OnBeforeBOMMatrixFromBOM(ProductionBOMHeader, NewMultiLevel, IsHandled); if not IsHandled then begin TempComponentList.DeleteAll(); TempComponentEntry.Reset(); TempComponentEntry.DeleteAll(); MultiLevel := NewMultiLevel; MatrixType := MatrixType::Version; BuildMatrix(ProductionBOMHeader."No.", '', 1, 1); ProdBOMVersion.SetRange("Production BOM No.", ProductionBOMHeader."No."); if ProdBOMVersion.Find('-') then repeat GlobalCalcDate := ProdBOMVersion."Starting Date"; BuildMatrix(ProductionBOMHeader."No.", ProdBOMVersion."Version Code", 1, 1); until ProdBOMVersion.Next() = 0; end; OnAfterBOMMatrixFromBOM(ProductionBOMHeader, NewMultiLevel); end; local procedure BuildMatrix(ProductionBOMNo: Code[20]; VersionCode: Code[20]; Level: Integer; Quantity: Decimal) var ProductionBOMLine: Record "Production BOM Line"; IsHandled: Boolean; begin IsHandled := false; OnBeforeBuildMatrix(ProductionBOMNo, VersionCode, Level, Quantity, IsHandled); if IsHandled then exit; if Level > 20 then exit; ProductionBOMLine.SetRange("Production BOM No.", ProductionBOMNo); ProductionBOMLine.SetRange("Version Code", VersionCode); if GlobalCalcDate <> 0D then begin ProductionBOMLine.SetFilter("Starting Date", '%1|..%2', 0D, GlobalCalcDate); ProductionBOMLine.SetFilter("Ending Date", '%1|%2..', 0D, GlobalCalcDate); end; if ProductionBOMLine.Find('-') then repeat case ProductionBOMLine.Type of ProductionBOMLine.Type::Item: if Item.Get(ProductionBOMLine."No.") then begin OnBuildMatrixForItemOnAfterGetItem(ProductionBOMLine); if MultiLevel and (Item."Production BOM No." <> '') then begin VersionCode := VersionMgt.GetBOMVersion(Item."Production BOM No.", GlobalCalcDate, false); OnBuildMatrixForItemOnBeforeRecursion(ProductionBOMLine); BuildMatrix( Item."Production BOM No.", VersionCode, Level + 1, Quantity * UOMMgt.GetQtyPerUnitOfMeasure(Item, ProductionBOMLine."Unit of Measure Code") / UOMMgt.GetQtyPerUnitOfMeasure(Item, Item."Base Unit of Measure") / UOMMgt.GetQtyPerUnitOfMeasure( Item, VersionMgt.GetBOMUnitOfMeasure(Item."Production BOM No.", VersionCode)) * ProductionBOMLine.Quantity); end else begin TempComponentList."Item No." := ProductionBOMLine."No."; TempComponentList."Variant Code" := ProductionBOMLine."Variant Code"; TempComponentList.Description := ProductionBOMLine.Description; TempComponentList."Description 2" := ProductionBOMLine."Description 2"; TempComponentList."Unit of Measure Code" := Item."Base Unit of Measure"; OnBuildMatrixForItemOnBeforeComponentListFind(ProductionBOMLine, TempComponentList); if not TempComponentList.Find() then TempComponentList.Insert(); ComponentEntry2.Init(); ComponentEntry2."Item No." := ProductionBOMLine."No."; ComponentEntry2."Variant Code" := ProductionBOMLine."Variant Code"; case MatrixType of MatrixType::Version: ComponentEntry2.ID := ProdBOMVersion."Version Code"; MatrixType::Item: ComponentEntry2.ID := ItemAssembly."No."; end; ComponentEntry2.Quantity := ProductionBOMLine.Quantity * UOMMgt.GetQtyPerUnitOfMeasure(Item, ProductionBOMLine."Unit of Measure Code") / UOMMgt.GetQtyPerUnitOfMeasure(Item, Item."Base Unit of Measure") * Quantity; TempComponentEntry := ComponentEntry2; TempComponentEntry.SetRange("Item No.", ComponentEntry2."Item No."); TempComponentEntry.SetRange("Variant Code", ComponentEntry2."Variant Code"); TempComponentEntry.SetRange(ID, ComponentEntry2.ID); if TempComponentEntry.FindFirst() then begin TempComponentEntry.Quantity := TempComponentEntry.Quantity + ComponentEntry2.Quantity; TempComponentEntry.Modify(); end else TempComponentEntry.Insert(); end; end; ProductionBOMLine.Type::"Production BOM": if ProdBOMHeader.Get(ProductionBOMLine."No.") then begin OnBuildMatrixForProductionBOMOnAfterGetHeader(ProductionBOMLine); BuildMatrix( ProdBOMHeader."No.", GetVersion(ProdBOMHeader."No."), Level + 1, Quantity * ProductionBOMLine.Quantity); end; end; until ProductionBOMLine.Next() = 0; end; local procedure GetVersion(ProdBOMNo: Code[20]): Code[20] begin ProdBOMVersion2.SetRange("Production BOM No.", ProdBOMNo); ProdBOMVersion2.SetFilter("Starting Date", '%1|..%2', 0D, GlobalCalcDate); if ProdBOMVersion2.FindLast() then exit(ProdBOMVersion2."Version Code"); exit(''); end; [IntegrationEvent(false, false)] local procedure OnBuildMatrixForItemOnAfterGetItem(var ProductionBOMLine: Record "Production BOM Line") begin end; [IntegrationEvent(false, false)] local procedure OnBuildMatrixForItemOnBeforeRecursion(var ProductionBOMLine: Record "Production BOM Line") begin end; [IntegrationEvent(false, false)] local procedure OnBuildMatrixForItemOnBeforeComponentListFind(var ProductionBOMLine: Record "Production BOM Line"; var ProductionMatrixBOMLine: Record "Production Matrix BOM Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCompareTwoItems(Item1: Record Item; Item2: Record Item; CalcDate: Date; NewMultiLevel: Boolean; var VersionCode1: Code[20]; var VersionCode2: Code[20]; var UnitOfMeasureCode1: Code[10]; var UnitOfMeasureCode2: Code[10]; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeBOMMatrixFromBOM(ProductionBOMHeader: Record "Production BOM Header"; NewMultiLevel: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeBuildMatrix(ProductionBOMNo: Code[20]; var VersionCode: Code[20]; Level: Integer; Quantity: Decimal; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBuildMatrixForProductionBOMOnAfterGetHeader(var ProductionBOMLine: Record "Production BOM Line") begin end; [IntegrationEvent(false, false)] local procedure OnAfterCompareTwoItems(Item1: Record Item; Item2: Record Item; CalcDate: Date; NewMultiLevel: Boolean; VersionCode1: Code[20]; VersionCode2: Code[20]; UnitOfMeasureCode1: Code[10]; UnitOfMeasureCode2: Code[10]) begin end; [IntegrationEvent(false, false)] local procedure OnAfterBOMMatrixFromBOM(ProductionBOMHeader: Record "Production BOM Header"; NewMultiLevel: Boolean) begin end;}