Codeunit 99000752 Check Routing Lines
src/Layers/W1/BaseApp/Manufacturing/Routing/CheckRoutingLines.Codeunit.al533 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.Routing;using Microsoft.Foundation.UOM;using Microsoft.Manufacturing.MachineCenter;using Microsoft.Manufacturing.WorkCenter;using Microsoft.Utilities;codeunit 99000752 "Check Routing Lines"{ trigger OnRun() begin end; var UOMMgt: Codeunit "Unit of Measure Management"; ErrList: Text[50];#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'Circular reference in routing %1 when calculating %2. Counted sequences %3. Max. lines %4.';#pragma warning restore AA0470 Text001: Label 'back';#pragma warning disable AA0470 Text002: Label 'Actual number of termination processes in route %1 is %2. They should be 1. Check %3.'; Text003: Label 'Actual number of start processes in route %1 is %2. They should be 1. Check %3.'; Text004: Label 'Not all routing lines are sequenced backwards on routing %1. Check %2.'; Text005: Label 'Not all routing lines are sequenced forward on routing %1. Check %2.'; Text006: Label 'Previous operations for %1 cannot be found.'; Text007: Label 'Next operations for %1 cannot be found.'; Text008: Label 'Operation %1 does not have a work center or a machine center defined.';#pragma warning restore AA0470#pragma warning restore AA0074 WorkMachineCenterNotExistErr: Label 'Operation no. %1 uses %2 no. %3 that no longer exists.', Comment = '%1 - Routing Line Operation No.; %2 - Work Center or Machine Center table caption; %3 - Work or Machine Center No.'; local procedure ErrorInRouting(RoutingCode: Code[20]; Direction: Text[20]; ActualSequence: Integer; MaxSequences: Integer) begin Error( Text000, RoutingCode, Direction, ActualSequence, MaxSequences); end; local procedure InsertInErrList(RtngLine: Record "Routing Line") begin if (StrLen(ErrList) + StrLen(RtngLine."Operation No.") + 1) > MaxStrLen(ErrList) then exit; if StrLen(ErrList) > 0 then ErrList := ErrList + ',' + RtngLine."Operation No." else ErrList := RtngLine."Operation No."; end; procedure SetNextOperations(RtngHeader: Record "Routing Header"; VersionCode: Code[20]) var RtngLine: Record "Routing Line"; RtngLine2: Record "Routing Line"; begin RtngLine.SetRange("Routing No.", RtngHeader."No."); RtngLine.SetRange("Version Code", VersionCode); RtngLine.ModifyAll("Next Operation No.", ''); if RtngLine.Find('-') then repeat RtngLine2 := RtngLine; RtngLine2.SetRange("Routing No.", RtngHeader."No."); RtngLine2.SetRange("Version Code", VersionCode); if RtngLine2.Find('>') then begin RtngLine."Next Operation No." := RtngLine2."Operation No."; RtngLine.Modify(); end; until RtngLine.Next() = 0; end; local procedure CalcPreviousOperations(RtngHeader: Record "Routing Header"; VersionCode: Code[20]) var RtngLine: Record "Routing Line"; RtngLine2: Record "Routing Line"; IsHandled: Boolean; begin IsHandled := false; OnBeforeCalcPreviousOperations(RtngHeader, VersionCode, IsHandled); if IsHandled then exit; RtngLine.SetRange("Routing No.", RtngHeader."No."); RtngLine.SetRange("Version Code", VersionCode); RtngLine.ModifyAll("Previous Operation No.", ''); if RtngLine.Find('-') then repeat if RtngLine."Next Operation No." <> '' then begin RtngLine2.SetRange("Routing No.", RtngHeader."No."); RtngLine2.SetRange("Version Code", VersionCode); RtngLine2.SetFilter("Operation No.", RtngLine."Next Operation No."); if RtngLine2.Find('-') then repeat if RtngLine2."Previous Operation No." <> '' then RtngLine2."Previous Operation No." := RtngLine2."Previous Operation No." + '|'; RtngLine2."Previous Operation No." := RtngLine2."Previous Operation No." + RtngLine."Operation No."; RtngLine2.Modify(); until RtngLine2.Next() = 0; end; until RtngLine.Next() = 0; end; local procedure CheckCircularReference(ActSequences: Integer; MaxSequences: Integer; RoutingNo: Code[20]) begin if ActSequences > MaxSequences then ErrorInRouting( RoutingNo, Text001, ActSequences, MaxSequences); end; local procedure SetRtngLineSequenceBack(RoutingType: Option Serial,Parallel; RoutingNo: Code[20]; VersionCode: Code[20]; Maxsequences: Integer) var RoutingLine: Record "Routing Line"; RtngLine: Record "Routing Line"; TempNameValueBuffer: Record "Name/Value Buffer" temporary; SequenceNo: Integer; QueueCount: Integer; i: Integer; begin SequenceNo := 1; if RoutingType = RoutingType::Parallel then begin NameValueBufferEnqueue(TempNameValueBuffer, GetTerminalOperationNo(RoutingNo, VersionCode), Format(SequenceNo)); while not TempNameValueBuffer.IsEmpty() do begin CheckCircularReference(SequenceNo, MaxSequences, RoutingNo); QueueCount := TempNameValueBuffer.Count(); for i := 1 to QueueCount do begin SetSequenceNoBackwardOnOperation(RoutingLine, RoutingNo, VersionCode, NameValueBufferDequeue(TempNameValueBuffer), SequenceNo); if RoutingLine."Previous Operation No." <> '' then begin RtngLine.SetRange("Routing No.", RoutingNo); RtngLine.SetRange("Version Code", VersionCode); RtngLine.SetFilter("Operation No.", RoutingLine."Previous Operation No."); if RtngLine.FindSet() then repeat if not FindNameValueBufferRec(TempNameValueBuffer, RtngLine."Operation No.", Format(SequenceNo + 1)) then NameValueBufferEnqueue(TempNameValueBuffer, RtngLine."Operation No.", Format(SequenceNo + 1)); until RtngLine.Next() = 0; end; end; SequenceNo += 1; end; end else begin RoutingLine.SetRange("Routing No.", RoutingNo); RoutingLine.SetRange("Version Code", VersionCode); if RoutingLine.Find('+') then repeat RoutingLine."Sequence No. (Backward)" := SequenceNo; RoutingLine.Modify(); SequenceNo += 1; until RoutingLine.Next(-1) = 0; end; end; procedure SetRtngLineSequenceForward(RoutingType: Option Serial,Parallel; RoutingNo: Code[20]; VersionCode: Code[20]; MaxSequences: Integer) var RoutingLine: Record "Routing Line"; RtngLine: Record "Routing Line"; TempNameValueBuffer: Record "Name/Value Buffer" temporary; SequenceNo: Integer; QueueCount: Integer; i: Integer; begin SequenceNo := 1; if RoutingType = RoutingType::Parallel then begin NameValueBufferEnqueue(TempNameValueBuffer, GetStartingOperationNo(RoutingNo, VersionCode), Format(SequenceNo)); while not TempNameValueBuffer.IsEmpty() do begin CheckCircularReference(SequenceNo, MaxSequences, RoutingNo); QueueCount := TempNameValueBuffer.Count(); for i := 1 to QueueCount do begin SetSequenceNoForwardOnOperation(RoutingLine, RoutingNo, VersionCode, NameValueBufferDequeue(TempNameValueBuffer), SequenceNo); if RoutingLine."Next Operation No." <> '' then begin RtngLine.SetRange("Routing No.", RoutingNo); RtngLine.SetRange("Version Code", VersionCode); RtngLine.SetFilter("Operation No.", RoutingLine."Next Operation No."); if RtngLine.FindSet() then repeat if not FindNameValueBufferRec(TempNameValueBuffer, RtngLine."Operation No.", Format(SequenceNo + 1)) then NameValueBufferEnqueue(TempNameValueBuffer, RtngLine."Operation No.", Format(SequenceNo + 1)); until RtngLine.Next() = 0; end; end; SequenceNo += 1; end; end else begin RoutingLine.SetRange("Routing No.", RoutingNo); RoutingLine.SetRange("Version Code", VersionCode); if RoutingLine.Find('-') then repeat RoutingLine."Sequence No. (Forward)" := SequenceNo; RoutingLine.Modify(); SequenceNo += 1; until RoutingLine.Next() = 0; end; end; local procedure GetStartingOperationNo(RoutingNo: Code[20]; VersionCode: Code[20]): Code[10] var RoutingLine: Record "Routing Line"; begin RoutingLine.SetRange("Routing No.", RoutingNo); RoutingLine.SetRange("Version Code", VersionCode); RoutingLine.SetFilter("Previous Operation No.", '%1', ''); RoutingLine.FindFirst(); exit(RoutingLine."Operation No."); end; local procedure GetTerminalOperationNo(RoutingNo: Code[20]; VersionCode: Code[20]): Code[10] var RoutingLine: Record "Routing Line"; begin RoutingLine.SetRange("Routing No.", RoutingNo); RoutingLine.SetRange("Version Code", VersionCode); RoutingLine.SetFilter("Next Operation No.", '%1', ''); RoutingLine.FindFirst(); exit(RoutingLine."Operation No."); end; local procedure SetSequenceNoForwardOnOperation(var RoutingLine: Record "Routing Line"; RoutingNo: Code[20]; VersionCode: Code[20]; OperationNo: Text; SequenceNo: Integer) begin RoutingLine.Get(RoutingNo, VersionCode, OperationNo); RoutingLine."Sequence No. (Forward)" := SequenceNo; RoutingLine.Modify(); end; local procedure SetSequenceNoBackwardOnOperation(var RoutingLine: Record "Routing Line"; RoutingNo: Code[20]; VersionCode: Code[20]; OperationNo: Text; SequenceNo: Integer) begin RoutingLine.Get(RoutingNo, VersionCode, OperationNo); RoutingLine."Sequence No. (Backward)" := SequenceNo; RoutingLine.Modify(); end; local procedure NameValueBufferEnqueue(var TempNameValueBuffer: Record "Name/Value Buffer" temporary; Name: Text[250]; Value: Text) begin TempNameValueBuffer.AddNewEntry(Name, Value); end; local procedure NameValueBufferDequeue(var TempNameValueBuffer: Record "Name/Value Buffer" temporary) Name: Text[250] begin TempNameValueBuffer.Reset(); TempNameValueBuffer.FindFirst(); Name := TempNameValueBuffer.Name; TempNameValueBuffer.Delete(); end; local procedure FindNameValueBufferRec(var TempNameValueBuffer: Record "Name/Value Buffer" temporary; Name: Text[250]; Value: Text) Found: Boolean begin TempNameValueBuffer.Reset(); TempNameValueBuffer.SetRange(Name, Name); TempNameValueBuffer.SetRange(Value, Value); Found := TempNameValueBuffer.FindFirst(); TempNameValueBuffer.Reset(); end; local procedure CalcSequenceBack(RtngHeader: Record "Routing Header"; VersionCode: Code[20]) var RtngLine: Record "Routing Line"; MaxSeq: Integer; begin RtngLine.SetRange("Routing No.", RtngHeader."No."); RtngLine.SetRange("Version Code", VersionCode); if RtngLine.Find('-') then repeat RtngLine."Sequence No. (Backward)" := 0; RtngLine."Fixed Scrap Qty. (Accum.)" := 0; RtngLine."Scrap Factor % (Accumulated)" := 0; RtngLine.Modify(); until RtngLine.Next() = 0; MaxSeq := RtngLine.Count(); SetRtngLineSequenceBack(RtngHeader.Type, RtngHeader."No.", VersionCode, MaxSeq); end; local procedure CalcSequenceForward(RtngHeader: Record "Routing Header"; VersionCode: Code[20]) var RtngLine: Record "Routing Line"; MaxSeq: Integer; begin RtngLine.SetRange("Routing No.", RtngHeader."No."); RtngLine.SetRange("Version Code", VersionCode); RtngLine.ModifyAll("Sequence No. (Forward)", 0); MaxSeq := RtngLine.Count(); SetRtngLineSequenceForward(RtngHeader.Type, RtngHeader."No.", VersionCode, MaxSeq); end; procedure NeedsCalculation(RtngHeader: Record "Routing Header"; VersionCode: Code[20]): Boolean var RtngLine: Record "Routing Line"; begin RtngLine.SetRange("Routing No.", RtngHeader."No."); RtngLine.SetRange("Version Code", VersionCode); RtngLine.SetRange(Recalculate, true); exit(not RtngLine.IsEmpty()); end; procedure Calculate(RtngHeader: Record "Routing Header"; VersionCode: Code[20]) var RtngVersion: Record "Routing Version"; RtngLine: Record "Routing Line"; RtngLine2: Record "Routing Line"; CalcScrapFactor: Decimal; CalcScrapQty: Decimal; ScrapFactorThis: Decimal; ScrapQtyThis: Decimal; begin OnBeforeCalculate(RtngHeader, VersionCode); RtngLine.SetCurrentKey("Routing No.", "Version Code", "Sequence No. (Backward)"); RtngLine.SetRange("Routing No.", RtngHeader."No."); RtngLine.SetRange("Version Code", VersionCode); if RtngLine.IsEmpty() then exit; if VersionCode <> '' then begin RtngVersion.Get(RtngHeader."No.", VersionCode); RtngHeader.Type := RtngVersion.Type; end; if RtngHeader.Type = RtngHeader.Type::Serial then SetNextOperations(RtngHeader, VersionCode); CalcPreviousOperations(RtngHeader, VersionCode); CalcSequenceBack(RtngHeader, VersionCode); CalcSequenceForward(RtngHeader, VersionCode); OnBeforeFindRoutingLines(RtngHeader, VersionCode); if RtngLine.Find('-') then repeat if RtngLine."Next Operation No." <> '' then begin RtngLine2.SetRange("Routing No.", RtngLine."Routing No."); RtngLine2.SetRange("Version Code", VersionCode); RtngLine2.SetFilter("Operation No.", RtngLine."Next Operation No."); CalcScrapFactor := 0; CalcScrapQty := 0; if RtngLine2.Find('-') then repeat ScrapFactorThis := RtngLine2."Scrap Factor % (Accumulated)"; ScrapQtyThis := Round(RtngLine2."Fixed Scrap Qty. (Accum.)", UOMMgt.QtyRndPrecision()); if CalcScrapFactor < ScrapFactorThis then CalcScrapFactor := ScrapFactorThis; if CalcScrapQty < ScrapQtyThis then CalcScrapQty := ScrapQtyThis; until RtngLine2.Next() = 0; end; if CalcScrapFactor <> 0 then begin if RtngLine."Scrap Factor %" <> 0 then CalcScrapFactor := Round( (1 + CalcScrapFactor) * (1 + RtngLine."Scrap Factor %" / 100), 0.00001) - 1; end else CalcScrapFactor := Round(1 + RtngLine."Scrap Factor %" / 100, 0.00001) - 1; CalcScrapQty := CalcScrapQty * (1 + RtngLine."Scrap Factor %" / 100) + RtngLine."Fixed Scrap Quantity"; OnCalculateOnAfterCalcScrapQtyAndFactor(RtngLine, CalcScrapQty, CalcScrapFactor); RtngLine."Fixed Scrap Qty. (Accum.)" := CalcScrapQty; RtngLine."Scrap Factor % (Accumulated)" := CalcScrapFactor; RtngLine.Modify(); until RtngLine.Next() = 0; RtngLine.ModifyAll(Recalculate, false); Check(RtngHeader, VersionCode); end; local procedure Check(RtngHeader: Record "Routing Header"; VersionCode: Code[20]) var RtngLine: Record "Routing Line"; RtngLine2: Record "Routing Line"; WorkCenter: Record "Work Center"; MachineCenter: Record "Machine Center"; IsHandled: Boolean; NoOfProcesses: Integer; begin IsHandled := false; OnBeforeCheck(RtngHeader, VersionCode, IsHandled); if IsHandled then exit; ErrList := ''; RtngLine.SetRange("Routing No.", RtngHeader."No."); RtngLine.SetRange("Version Code", VersionCode); RtngLine.SetRange("No.", ''); if RtngLine.FindFirst() then Error(Text008, RtngLine."Operation No."); RtngLine.SetRange("No."); if RtngLine.FindSet() then repeat if RtngLine.Type = RtngLine.Type::"Work Center" then begin if not WorkCenter.Get(RtngLine."No.") then Error(WorkMachineCenterNotExistErr, RtngLine."Operation No.", WorkCenter.TableCaption(), RtngLine."No."); WorkCenter.TestField(Blocked, false); end; if RtngLine.Type = RtngLine.Type::"Machine Center" then begin if not MachineCenter.Get(RtngLine."No.") then Error(WorkMachineCenterNotExistErr, RtngLine."Operation No.", MachineCenter.TableCaption(), RtngLine."No."); MachineCenter.TestField(Blocked, false); end; until RtngLine.Next() = 0; RtngLine.SetFilter("Next Operation No.", '%1', ''); NoOfProcesses := RtngLine.Count(); if NoOfProcesses <> 1 then begin repeat InsertInErrList(RtngLine); until RtngLine.Next() = 0; Error( Text002, RtngHeader."No.", NoOfProcesses, ErrList); end; RtngLine.SetFilter("Previous Operation No.", '%1', ''); RtngLine.SetRange("Next Operation No."); NoOfProcesses := RtngLine.Count(); if NoOfProcesses <> 1 then begin repeat InsertInErrList(RtngLine); until RtngLine.Next() = 0; Error( Text003, RtngHeader."No.", NoOfProcesses, ErrList); end; RtngLine.SetRange("Previous Operation No."); RtngLine.SetRange("Sequence No. (Backward)", 0); if RtngLine.Find('-') then begin repeat InsertInErrList(RtngLine); until RtngLine.Next() = 0; Error( Text004, RtngLine."Routing No.", ErrList); end; RtngLine.SetRange("Sequence No. (Backward)"); RtngLine.SetRange("Sequence No. (Forward)", 0); if RtngLine.Find('-') then begin repeat InsertInErrList(RtngLine); until RtngLine.Next() = 0; Error( Text005, RtngLine."Routing No.", ErrList); end; RtngLine.SetRange("Sequence No. (Forward)"); RtngLine.SetCurrentKey("Routing No.", "Version Code", "Sequence No. (Backward)"); RtngLine.SetFilter("Previous Operation No.", '<>%1', ''); if RtngLine.Find('-') then repeat RtngLine2.SetRange("Routing No.", RtngLine."Routing No."); RtngLine2.SetRange("Version Code", VersionCode); RtngLine2.SetFilter("Operation No.", RtngLine."Previous Operation No."); if RtngLine2.IsEmpty() then Error( Text006, RtngLine."Routing No."); until RtngLine.Next() = 0; RtngLine.SetCurrentKey("Routing No.", "Version Code", "Sequence No. (Forward)"); RtngLine.SetFilter("Next Operation No.", '<>%1', ''); RtngLine.SetRange("Operation No."); if RtngLine.Find('-') then repeat RtngLine2.SetRange("Routing No.", RtngLine."Routing No."); RtngLine2.SetRange("Version Code", VersionCode); RtngLine2.SetFilter("Operation No.", RtngLine."Next Operation No."); if RtngLine2.IsEmpty() then Error( Text007, RtngLine."Routing No."); until RtngLine.Next() = 0; end; [IntegrationEvent(false, false)] local procedure OnBeforeCalcPreviousOperations(var RoutingHeader: Record "Routing Header"; VersionCode: Code[20]; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCalculate(RoutingHeader: Record "Routing Header"; VersionCode: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCheck(var RoutingHeader: Record "Routing Header"; VersionCode: Code[20]; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeFindRoutingLines(var RoutingHeader: Record "Routing Header"; VersionCode: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnCalculateOnAfterCalcScrapQtyAndFactor(var RoutingLine: Record "Routing Line"; var ScrapQty: Decimal; var ScrapFactor: Decimal) begin end;}