Codeunit 378 Transfer Extended Text

Base Application, Microsoft.Foundation.ExtendedText

src/Layers/W1/BaseApp/Foundation/ExtendedText/TransferExtendedText.Codeunit.al921 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.Foundation.ExtendedText;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Inventory.Item;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Project.Planning;using Microsoft.Projects.Resources.Resource;using Microsoft.Purchases.Document;using Microsoft.Purchases.History;using Microsoft.Sales.Document;using Microsoft.Sales.FinanceCharge;using Microsoft.Sales.History;using Microsoft.Sales.Reminder;codeunit 378 "Transfer Extended Text"{    trigger OnRun()    begin    end;    var        GLAcc: Record "G/L Account";        Item: Record Item;        Res: Record Resource;        TempExtTextLine: Record "Extended Text Line" temporary;        NextLineNo: Integer;        LineSpacing: Integer;        MakeUpdateRequired: Boolean;        AutoText: Boolean;    procedure SalesCheckIfAnyExtText(var SalesLine: Record "Sales Line"; Unconditionally: Boolean): Boolean    var        SalesHeader: Record "Sales Header";    begin        exit(SalesCheckIfAnyExtText(SalesLine, Unconditionally, SalesHeader));    end;    procedure SalesCheckIfAnyExtText(var SalesLine: Record "Sales Line"; Unconditionally: Boolean; SalesHeader: Record "Sales Header") Result: Boolean    var        ExtTextHeader: Record "Extended Text Header";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeSalesCheckIfAnyExtText(SalesLine, SalesHeader, Unconditionally, MakeUpdateRequired, AutoText, Result, IsHandled);        if IsHandled then            exit(Result);        MakeUpdateRequired := false;        if IsDeleteAttachedLines(SalesLine."Line No.", SalesLine."No.", SalesLine."Attached to Line No.") and not SalesLine.IsExtendedText() then            MakeUpdateRequired := DeleteSalesLines(SalesLine);        AutoText := false;        if Unconditionally then            AutoText := true        else            case SalesLine.Type of                SalesLine.Type::" ":                    AutoText := true;                SalesLine.Type::"G/L Account":                    if GLAcc.Get(SalesLine."No.") then                        AutoText := GLAcc."Automatic Ext. Texts";                SalesLine.Type::Item:                    if Item.Get(SalesLine."No.") then                        AutoText := Item."Automatic Ext. Texts";                SalesLine.Type::Resource:                    if Res.Get(SalesLine."No.") then                        AutoText := Res."Automatic Ext. Texts";            end;        OnSalesCheckIfAnyExtTextOnBeforeSetFilters(SalesLine, AutoText, Unconditionally);        if AutoText then begin            SalesLine.TestField("Document No.");            if SalesHeader."No." = '' then                SalesHeader.Get(SalesLine."Document Type", SalesLine."Document No.");            ExtTextHeader.SetRange("Table Name", SalesLine.Type);            ExtTextHeader.SetRange("No.", SalesLine."No.");            case SalesLine."Document Type" of                SalesLine."Document Type"::Quote:                    ExtTextHeader.SetRange("Sales Quote", true);                SalesLine."Document Type"::"Blanket Order":                    ExtTextHeader.SetRange("Sales Blanket Order", true);                SalesLine."Document Type"::Order:                    ExtTextHeader.SetRange("Sales Order", true);                SalesLine."Document Type"::Invoice:                    ExtTextHeader.SetRange("Sales Invoice", true);                SalesLine."Document Type"::"Return Order":                    ExtTextHeader.SetRange("Sales Return Order", true);                SalesLine."Document Type"::"Credit Memo":                    ExtTextHeader.SetRange("Sales Credit Memo", true);            end;            OnSalesCheckIfAnyExtTextAutoText(ExtTextHeader, SalesHeader, SalesLine, Unconditionally, MakeUpdateRequired);            exit(ReadExtTextLines(ExtTextHeader, SalesHeader."Document Date", SalesHeader."Language Code"));        end;    end;    procedure ReminderCheckIfAnyExtText(var ReminderLine: Record "Reminder Line"; Unconditionally: Boolean): Boolean    var        ReminderHeader: Record "Reminder Header";        ExtTextHeader: Record "Extended Text Header";    begin        MakeUpdateRequired := false;        if IsDeleteAttachedLines(ReminderLine."Line No.", ReminderLine."No.", ReminderLine."Attached to Line No.") then            MakeUpdateRequired := DeleteReminderLines(ReminderLine);        if Unconditionally then            AutoText := true        else            case ReminderLine.Type of                ReminderLine.Type::" ":                    AutoText := true;                ReminderLine.Type::"G/L Account":                    if GLAcc.Get(ReminderLine."No.") then                        AutoText := GLAcc."Automatic Ext. Texts";            end;        OnReminderCheckIfAnyExtTextOnBeforeSetFilters(ReminderLine, AutoText, Unconditionally);        if AutoText then begin            ReminderLine.TestField("Reminder No.");            ReminderHeader.Get(ReminderLine."Reminder No.");            ExtTextHeader.SetRange("Table Name", ReminderLine.Type);            ExtTextHeader.SetRange("No.", ReminderLine."No.");            ExtTextHeader.SetRange(Reminder, true);            OnReminderCheckIfAnyExtTextAutoText(ExtTextHeader, ReminderHeader, ReminderLine, Unconditionally, MakeUpdateRequired);            exit(ReadExtTextLines(ExtTextHeader, ReminderHeader."Document Date", ReminderHeader."Language Code"));        end;    end;    procedure FinChrgMemoCheckIfAnyExtText(var FinChrgMemoLine: Record "Finance Charge Memo Line"; Unconditionally: Boolean): Boolean    var        FinChrgMemoHeader: Record "Finance Charge Memo Header";        ExtTextHeader: Record "Extended Text Header";    begin        MakeUpdateRequired := false;        if IsDeleteAttachedLines(FinChrgMemoLine."Line No.", FinChrgMemoLine."No.", FinChrgMemoLine."Attached to Line No.") then            MakeUpdateRequired := DeleteFinChrgMemoLines(FinChrgMemoLine);        if Unconditionally then            AutoText := true        else            case FinChrgMemoLine.Type of                FinChrgMemoLine.Type::" ":                    AutoText := true;                FinChrgMemoLine.Type::"G/L Account":                    if GLAcc.Get(FinChrgMemoLine."No.") then                        AutoText := GLAcc."Automatic Ext. Texts";            end;        OnFinChrgMemoCheckIfAnyExtTextOnBeforeSetFilters(FinChrgMemoLine, AutoText, Unconditionally);        if AutoText then begin            FinChrgMemoLine.TestField("Finance Charge Memo No.");            FinChrgMemoHeader.Get(FinChrgMemoLine."Finance Charge Memo No.");            ExtTextHeader.SetRange("Table Name", FinChrgMemoLine.Type);            ExtTextHeader.SetRange("No.", FinChrgMemoLine."No.");            ExtTextHeader.SetRange("Finance Charge Memo", true);            OnFinChrgMemoCheckIfAnyExtTextAutoText(ExtTextHeader, FinChrgMemoHeader, FinChrgMemoLine, Unconditionally, MakeUpdateRequired);            exit(ReadExtTextLines(ExtTextHeader, FinChrgMemoHeader."Document Date", FinChrgMemoHeader."Language Code"));        end;    end;    procedure PurchCheckIfAnyExtText(var PurchaseLine: Record "Purchase Line"; Unconditionally: Boolean): Boolean    var        PurchaseHeader: Record "Purchase Header";    begin        exit(PurchCheckIfAnyExtText(PurchaseLine, Unconditionally, PurchaseHeader));    end;    procedure PurchCheckIfAnyExtText(var PurchLine: Record "Purchase Line"; Unconditionally: Boolean; PurchaseHeader: Record "Purchase Header") Result: Boolean    var        ExtTextHeader: Record "Extended Text Header";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforePurchCheckIfAnyExtText(PurchLine, PurchaseHeader, Unconditionally, MakeUpdateRequired, AutoText, Result, IsHandled);        if IsHandled then            exit(Result);        MakeUpdateRequired := false;        if IsDeleteAttachedLines(PurchLine."Line No.", PurchLine."No.", PurchLine."Attached to Line No.") and not PurchLine.IsExtendedText() then            MakeUpdateRequired := DeletePurchLines(PurchLine);        AutoText := false;        if Unconditionally then            AutoText := true        else            case PurchLine.Type of                PurchLine.Type::" ":                    AutoText := true;                PurchLine.Type::"G/L Account":                    if GLAcc.Get(PurchLine."No.") then                        AutoText := GLAcc."Automatic Ext. Texts";                PurchLine.Type::Item:                    if Item.Get(PurchLine."No.") then                        AutoText := Item."Automatic Ext. Texts";                PurchLine.Type::Resource:                    if Res.Get(PurchLine."No.") then                        AutoText := Res."Automatic Ext. Texts";            end;        OnPurchCheckIfAnyExtTextOnBeforeSetFilters(PurchLine, AutoText, Unconditionally);        if AutoText then begin            PurchLine.TestField("Document No.");            if PurchaseHeader."No." = '' then                PurchaseHeader.Get(PurchLine."Document Type", PurchLine."Document No.");            ExtTextHeader.SetRange("Table Name", PurchLine.Type);            ExtTextHeader.SetRange("No.", PurchLine."No.");            case PurchLine."Document Type" of                PurchLine."Document Type"::Quote:                    ExtTextHeader.SetRange("Purchase Quote", true);                PurchLine."Document Type"::"Blanket Order":                    ExtTextHeader.SetRange("Purchase Blanket Order", true);                PurchLine."Document Type"::Order:                    ExtTextHeader.SetRange("Purchase Order", true);                PurchLine."Document Type"::Invoice:                    ExtTextHeader.SetRange("Purchase Invoice", true);                PurchLine."Document Type"::"Return Order":                    ExtTextHeader.SetRange("Purchase Return Order", true);                PurchLine."Document Type"::"Credit Memo":                    ExtTextHeader.SetRange("Purchase Credit Memo", true);            end;            OnPurchCheckIfAnyExtTextAutoText(ExtTextHeader, PurchaseHeader, PurchLine, Unconditionally, MakeUpdateRequired);            exit(ReadExtTextLines(ExtTextHeader, PurchaseHeader."Document Date", PurchaseHeader."Language Code"));        end;    end;    procedure PrepmtGetAnyExtText(GLAccNo: Code[20]; TabNo: Integer; DocumentDate: Date; LanguageCode: Code[10]; var ExtTextLine: Record "Extended Text Line" temporary)    var        GLAcc: Record "G/L Account";        ExtTextHeader: Record "Extended Text Header";    begin        ExtTextLine.DeleteAll();        GLAcc.Get(GLAccNo);        if not GLAcc."Automatic Ext. Texts" then            exit;        ExtTextHeader.SetRange("Table Name", ExtTextHeader."Table Name"::"G/L Account");        ExtTextHeader.SetRange("No.", GLAccNo);        case TabNo of            Database::"Sales Invoice Line":                ExtTextHeader.SetRange("Prepmt. Sales Invoice", true);            Database::"Sales Cr.Memo Line":                ExtTextHeader.SetRange("Prepmt. Sales Credit Memo", true);            Database::"Purch. Inv. Line":                ExtTextHeader.SetRange("Prepmt. Purchase Invoice", true);            Database::"Purch. Cr. Memo Line":                ExtTextHeader.SetRange("Prepmt. Purchase Credit Memo", true);        end;        OnPrepmtGetAnyExtTextBeforeReadLines(ExtTextHeader, DocumentDate, LanguageCode);        if ReadExtTextLines(ExtTextHeader, DocumentDate, LanguageCode) then begin            OnPrepmtGetAnyExtTextAfterReadLines(ExtTextHeader, TempExtTextLine);            TempExtTextLine.Find('-');            repeat                ExtTextLine := TempExtTextLine;                ExtTextLine.Insert();            until TempExtTextLine.Next() = 0;        end;    end;    procedure InsertSalesExtText(var SalesLine: Record "Sales Line")    var        DummySalesLine: Record "Sales Line";    begin        InsertSalesExtTextRetLast(SalesLine, DummySalesLine);    end;    procedure InsertSalesExtTextRetLast(var SalesLine: Record "Sales Line"; var LastInsertedSalesLine: Record "Sales Line")    var        ToSalesLine: Record "Sales Line";        IsHandled: Boolean;    begin        OnBeforeInsertSalesExtText(SalesLine, TempExtTextLine, IsHandled, MakeUpdateRequired, LastInsertedSalesLine);        if IsHandled then            exit;        LineSpacing := 10; // New fixed Line Spacing method        OnInsertSalesExtTextRetLastOnAfterSetLineSpacing(LineSpacing);        ToSalesLine.Reset();        ToSalesLine.SetRange("Document Type", SalesLine."Document Type");        ToSalesLine.SetRange("Document No.", SalesLine."Document No.");        ToSalesLine := SalesLine;        OnInsertSalesExtTextRetLastOnBeforeToSalesLineFind(ToSalesLine);        NextLineNo := SalesLine."Line No." + LineSpacing;        TempExtTextLine.Reset();        OnInsertSalesExtTextRetLastOnBeforeFindTempExtTextLine(TempExtTextLine, SalesLine);        if TempExtTextLine.Find('-') then begin            repeat                ToSalesLine.Init();                ToSalesLine."Document Type" := SalesLine."Document Type";                ToSalesLine."Document No." := SalesLine."Document No.";                ToSalesLine."Line No." := NextLineNo;                NextLineNo := NextLineNo + LineSpacing;                ToSalesLine.Description := TempExtTextLine.Text;                ToSalesLine."Attached to Line No." := SalesLine."Line No.";                IsHandled := false;                OnInsertSalesExtTextRetLastOnBeforeToSalesLineInsert(ToSalesLine, SalesLine, TempExtTextLine, NextLineNo, LineSpacing, IsHandled);                if not IsHandled then                    ToSalesLine.Insert();            until TempExtTextLine.Next() = 0;            MakeUpdateRequired := true;        end;        TempExtTextLine.DeleteAll();        LastInsertedSalesLine := ToSalesLine;    end;    procedure InsertReminderExtText(var ReminderLine: Record "Reminder Line")    var        ToReminderLine: Record "Reminder Line";        IsHandled: Boolean;    begin        OnBeforeInsertReminderExtText(ReminderLine, TempExtTextLine, IsHandled, MakeUpdateRequired);        if IsHandled then            exit;        LineSpacing := 10; // New fixed Line Spacing method        NextLineNo := ReminderLine."Line No." + LineSpacing;        TempExtTextLine.Reset();        OnInsertReminderExtTextOnBeforeFindTempExtTextLine(TempExtTextLine, ReminderLine);        if TempExtTextLine.Find('-') then begin            repeat                ToReminderLine.Init();                ToReminderLine."Reminder No." := ReminderLine."Reminder No.";                ToReminderLine."Line No." := NextLineNo;                NextLineNo := NextLineNo + LineSpacing;                ToReminderLine.Description := TempExtTextLine.Text;                ToReminderLine."Attached to Line No." := ReminderLine."Line No.";                ToReminderLine."Line Type" := ReminderLine."Line Type";                IsHandled := false;                OnBeforeToReminderLineInsert(ToReminderLine, ReminderLine, TempExtTextLine, NextLineNo, LineSpacing, IsHandled);                if not IsHandled then                    ToReminderLine.Insert();            until TempExtTextLine.Next() = 0;            MakeUpdateRequired := true;        end;        TempExtTextLine.DeleteAll();    end;    procedure InsertFinChrgMemoExtText(var FinChrgMemoLine: Record "Finance Charge Memo Line")    var        ToFinChrgMemoLine: Record "Finance Charge Memo Line";        IsHandled: Boolean;    begin        OnBeforeInsertFinChrgMemoExtText(FinChrgMemoLine, TempExtTextLine, IsHandled, MakeUpdateRequired);        if IsHandled then            exit;        LineSpacing := 10; // New fixed Line Spacing method        NextLineNo := FinChrgMemoLine."Line No." + LineSpacing;        TempExtTextLine.Reset();        if TempExtTextLine.Find('-') then begin            repeat                ToFinChrgMemoLine.Init();                ToFinChrgMemoLine."Finance Charge Memo No." := FinChrgMemoLine."Finance Charge Memo No.";                ToFinChrgMemoLine."Line No." := NextLineNo;                NextLineNo := NextLineNo + LineSpacing;                ToFinChrgMemoLine.Description := TempExtTextLine.Text;                ToFinChrgMemoLine."Attached to Line No." := FinChrgMemoLine."Line No.";                IsHandled := false;                OnInsertFinChrgMemoExtTextOnBeforeToFinChrgMemoLineInsert(ToFinChrgMemoLine, FinChrgMemoLine, TempExtTextLine, NextLineNo, LineSpacing, IsHandled);                if not IsHandled then                    ToFinChrgMemoLine.Insert();            until TempExtTextLine.Next() = 0;            MakeUpdateRequired := true;        end;        TempExtTextLine.DeleteAll();    end;    procedure InsertPurchExtText(var PurchLine: Record "Purchase Line")    var        DummyPurchLine: Record "Purchase Line";    begin        InsertPurchExtTextRetLast(PurchLine, DummyPurchLine);    end;    procedure InsertPurchExtTextRetLast(var PurchLine: Record "Purchase Line"; var LastInsertedPurchLine: Record "Purchase Line")    var        ToPurchLine: Record "Purchase Line";        IsHandled: Boolean;    begin        OnBeforeInsertPurchExtText(PurchLine, TempExtTextLine, IsHandled, MakeUpdateRequired, LastInsertedPurchLine);        if IsHandled then            exit;        LineSpacing := 10; // New fixed Line Spacing method        ToPurchLine.Reset();        ToPurchLine.SetRange("Document Type", PurchLine."Document Type");        ToPurchLine.SetRange("Document No.", PurchLine."Document No.");        ToPurchLine := PurchLine;        InsertPurchExtTextRetLastOnBeforeToPurchLineFind(ToPurchLine);        NextLineNo := PurchLine."Line No." + LineSpacing;        TempExtTextLine.Reset();        OnInsertPurchExtTextRetLastOnBeforeFindTempExtTextLine(TempExtTextLine, PurchLine);        if TempExtTextLine.Find('-') then begin            repeat                ToPurchLine.Init();                ToPurchLine."Document Type" := PurchLine."Document Type";                ToPurchLine."Document No." := PurchLine."Document No.";                ToPurchLine."Line No." := NextLineNo;                NextLineNo := NextLineNo + LineSpacing;                ToPurchLine.Description := TempExtTextLine.Text;                ToPurchLine."Attached to Line No." := PurchLine."Line No.";                IsHandled := false;                OnBeforeToPurchLineInsert(ToPurchLine, PurchLine, TempExtTextLine, NextLineNo, LineSpacing, IsHandled);                if not IsHandled then                    ToPurchLine.Insert();            until TempExtTextLine.Next() = 0;            MakeUpdateRequired := true;        end;        TempExtTextLine.DeleteAll();        LastInsertedPurchLine := ToPurchLine;    end;    local procedure DeleteSalesLines(var SalesLine: Record "Sales Line"): Boolean    var        SalesLine2: Record "Sales Line";        IsHandled: Boolean;        Found: Boolean;    begin        SalesLine2.SetRange("Document Type", SalesLine."Document Type");        SalesLine2.SetRange("Document No.", SalesLine."Document No.");        SalesLine2.SetRange("Attached to Line No.", SalesLine."Line No.");        OnDeleteSalesLinesOnAfterSetFilters(SalesLine2, SalesLine);        SalesLine2 := SalesLine;        Found := false;        if SalesLine2.Find('>') then begin            repeat                IsHandled := false;                OnDeleteSalesLinesOnBeforeDelete(SalesLine, SalesLine2, IsHandled);                if not IsHandled then begin                    SalesLine2.Delete(true);                    Found := true;                end;            until SalesLine2.Next() = 0;            exit(Found);        end;    end;    local procedure DeleteReminderLines(var ReminderLine: Record "Reminder Line"): Boolean    var        ReminderLine2: Record "Reminder Line";    begin        ReminderLine2.SetRange("Reminder No.", ReminderLine."Reminder No.");        ReminderLine2.SetRange("Attached to Line No.", ReminderLine."Line No.");        OnDeleteReminderLinesOnAfterReminderLine2SetFilters(ReminderLine2, ReminderLine);        ReminderLine2 := ReminderLine;        if ReminderLine2.Find('>') then begin            repeat                ReminderLine2.Delete(true);            until ReminderLine2.Next() = 0;            exit(true);        end;    end;    local procedure DeleteFinChrgMemoLines(var FinChrgMemoLine: Record "Finance Charge Memo Line"): Boolean    var        FinChrgMemoLine2: Record "Finance Charge Memo Line";    begin        FinChrgMemoLine2.SetRange("Finance Charge Memo No.", FinChrgMemoLine."Finance Charge Memo No.");        FinChrgMemoLine2.SetRange("Attached to Line No.", FinChrgMemoLine."Line No.");        OnDeleteFinChrgMemoLinesOnAfterFinChrgMemoLine2SetFilters(FinChrgMemoLine2, FinChrgMemoLine);        FinChrgMemoLine2 := FinChrgMemoLine;        if FinChrgMemoLine2.Find('>') then begin            repeat                FinChrgMemoLine2.Delete(true);            until FinChrgMemoLine2.Next() = 0;            exit(true);        end;    end;    local procedure DeletePurchLines(var PurchLine: Record "Purchase Line"): Boolean    var        PurchLine2: Record "Purchase Line";    begin        PurchLine2.SetRange("Document Type", PurchLine."Document Type");        PurchLine2.SetRange("Document No.", PurchLine."Document No.");        PurchLine2.SetRange("Attached to Line No.", PurchLine."Line No.");        OnDeletePurchLinesOnAfterSetFilters(PurchLine2, PurchLine);        PurchLine2 := PurchLine;        if PurchLine2.Find('>') then begin            repeat                PurchLine2.Delete(true);            until PurchLine2.Next() = 0;            exit(true);        end;    end;    procedure MakeUpdate(): Boolean    begin        exit(MakeUpdateRequired);    end;    procedure SetMakeUpdateRequired(NewMakeUpdateRequired: Boolean)    begin        MakeUpdateRequired := NewMakeUpdateRequired;    end;    procedure ReadExtTextLines(var ExtTextHeader: Record "Extended Text Header"; DocDate: Date; LanguageCode: Code[10]) Result: Boolean    var        ExtTextLine: Record "Extended Text Line";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeReadLines(ExtTextHeader, DocDate, LanguageCode, IsHandled, Result, TempExtTextLine);        if IsHandled then            exit(Result);        ExtTextHeader.SetCurrentKey(          "Table Name", "No.", "Language Code", "All Language Codes", "Starting Date", "Ending Date");        ExtTextHeader.SetRange("Starting Date", 0D, DocDate);        OnReadExtTextLinesOnBeforeSetFilters(ExtTextHeader);        ExtTextHeader.SetFilter("Ending Date", '%1..|%2', DocDate, 0D);        if LanguageCode = '' then begin            ExtTextHeader.SetRange("Language Code", '');            if not ExtTextHeader.FindSet() then                exit;        end else begin            ExtTextHeader.SetRange("Language Code", LanguageCode);            if not ExtTextHeader.FindSet() then begin                ExtTextHeader.SetRange("All Language Codes", true);                ExtTextHeader.SetRange("Language Code", '');                if not ExtTextHeader.FindSet() then                    exit;            end;        end;        TempExtTextLine.DeleteAll();        repeat            ExtTextLine.SetRange("Table Name", ExtTextHeader."Table Name");            ExtTextLine.SetRange("No.", ExtTextHeader."No.");            ExtTextLine.SetRange("Language Code", ExtTextHeader."Language Code");            ExtTextLine.SetRange("Text No.", ExtTextHeader."Text No.");            if ExtTextLine.FindSet() then begin                repeat                    TempExtTextLine := ExtTextLine;                    OnReadExtTextLinesOnBeforeTempExtTextLineInsert(TempExtTextLine, ExtTextHeader);                    TempExtTextLine.Insert();                until ExtTextLine.Next() = 0;                Result := true;            end;        until ExtTextHeader.Next() = 0;        OnAfterReadLines(TempExtTextLine, ExtTextHeader, LanguageCode);    end;    procedure GetTempExtTextLine(var ToTempExtendedTextLine: Record "Extended Text Line" temporary)    begin        ToTempExtendedTextLine.Copy(TempExtTextLine, true);    end;    procedure JobCheckIfAnyExtText(var JobPlanningLine: Record "Job Planning Line"; Unconditionally: Boolean): Boolean    var        Job: Record Job;    begin        exit(JobCheckIfAnyExtText(JobPlanningLine, Unconditionally, Job));    end;    procedure JobCheckIfAnyExtText(var JobPlanningLine: Record "Job Planning Line"; Unconditionally: Boolean; Job: Record Job) Result: Boolean    var        ExtTextHeader: Record "Extended Text Header";        IsHandled: Boolean;        DocumentDate: Date;    begin        IsHandled := false;        OnBeforeJobCheckIfAnyExtText(JobPlanningLine, Unconditionally, MakeUpdateRequired, AutoText, Result, IsHandled);        if IsHandled then            exit(Result);        MakeUpdateRequired := false;        if IsDeleteAttachedLines(JobPlanningLine."Line No.", JobPlanningLine."No.", JobPlanningLine."Attached to Line No.") and not JobPlanningLine.IsExtendedText() then            MakeUpdateRequired := DeleteJobPlanningLines(JobPlanningLine);        AutoText := false;        if Unconditionally then            AutoText := true        else            case JobPlanningLine.Type of                JobPlanningLine.Type::Text:                    AutoText := true;                JobPlanningLine.Type::"G/L Account":                    if GLAcc.Get(JobPlanningLine."No.") then                        AutoText := GLAcc."Automatic Ext. Texts";                JobPlanningLine.Type::Item:                    if Item.Get(JobPlanningLine."No.") then                        AutoText := Item."Automatic Ext. Texts";                JobPlanningLine.Type::Resource:                    if Res.Get(JobPlanningLine."No.") then                        AutoText := Res."Automatic Ext. Texts";            end;        OnJobCheckIfAnyExtTextOnAfterCheckAutoText(JobPlanningLine, AutoText, Unconditionally);        if not AutoText then            exit;        JobPlanningLine.TestField("Job No.");        if Job."No." = '' then            Job.Get(JobPlanningLine."Job No.");        case JobPlanningLine.Type of            JobPlanningLine.Type::Text:                ExtTextHeader.SetRange("Table Name", ExtTextHeader."Table Name"::"Standard Text");            JobPlanningLine.Type::Item:                ExtTextHeader.SetRange("Table Name", ExtTextHeader."Table Name"::Item);            JobPlanningLine.Type::Resource:                ExtTextHeader.SetRange("Table Name", ExtTextHeader."Table Name"::Resource);            JobPlanningLine.Type::"G/L Account":                ExtTextHeader.SetRange("Table Name", ExtTextHeader."Table Name"::"G/L Account");        end;        ExtTextHeader.SetRange("No.", JobPlanningLine."No.");        ExtTextHeader.SetRange(Job, true);        DocumentDate := JobPlanningLine."Document Date";        OnJobCheckIfAnyExtTextOnBeforeReadExtTextLines(ExtTextHeader, Job, JobPlanningLine, Unconditionally, MakeUpdateRequired, DocumentDate);        exit(ReadExtTextLines(ExtTextHeader, DocumentDate, Job."Language Code"));    end;    local procedure DeleteJobPlanningLines(var JobPlanningLine: Record "Job Planning Line"): Boolean    var        JobPlanningLine2: Record "Job Planning Line";    begin        JobPlanningLine2.SetRange("Job No.", JobPlanningLine."Job No.");        JobPlanningLine2.SetRange("Job Task No.", JobPlanningLine."Job Task No.");        JobPlanningLine2.SetRange("Attached to Line No.", JobPlanningLine."Line No.");        OnDeleteJobPlanningLinesOnAfterSetFilters(JobPlanningLine2, JobPlanningLine);        JobPlanningLine2 := JobPlanningLine;        if JobPlanningLine2.Find('>') then begin            repeat                JobPlanningLine2.Delete(true);            until JobPlanningLine2.Next() = 0;            exit(true);        end;    end;    procedure InsertJobExtText(var JobPlanningLine: Record "Job Planning Line")    var        DummyJobPlanningLine: Record "Job Planning Line";    begin        InsertJobExtTextRetLast(JobPlanningLine, DummyJobPlanningLine);    end;    procedure InsertJobExtTextRetLast(var JobPlanningLine: Record "Job Planning Line"; var LastInsertedJobPlanningLine: Record "Job Planning Line")    var        ToJobPlanningLine: Record "Job Planning Line";        IsHandled: Boolean;    begin        OnBeforeInsertJobExtTextRetLast(JobPlanningLine, TempExtTextLine, MakeUpdateRequired);        LineSpacing := 10; // New fixed Line Spacing method        NextLineNo := JobPlanningLine."Line No." + LineSpacing;        TempExtTextLine.Reset();        if TempExtTextLine.Find('-') then begin            repeat                ToJobPlanningLine.Init();                ToJobPlanningLine.Validate("Line Type", JobPlanningLine."Line Type");                ToJobPlanningLine.Type := ToJobPlanningLine.Type::Text;                ToJobPlanningLine."Job No." := JobPlanningLine."Job No.";                ToJobPlanningLine."Job Task No." := JobPlanningLine."Job Task No.";                ToJobPlanningLine."Line No." := NextLineNo;                NextLineNo := NextLineNo + LineSpacing;                ToJobPlanningLine."Planning Date" := JobPlanningLine."Planning Date";                ToJobPlanningLine."Planned Delivery Date" := JobPlanningLine."Planned Delivery Date";                ToJobPlanningLine."Document No." := JobPlanningLine."Document No.";                ToJobPlanningLine.Description := TempExtTextLine.Text;                ToJobPlanningLine."Attached to Line No." := JobPlanningLine."Line No.";                IsHandled := false;                OnInsertJobExtTextRetLastOnBeforeToJobPlanningLineInsert(ToJobPlanningLine, JobPlanningLine, TempExtTextLine, NextLineNo, LineSpacing, IsHandled);                if not IsHandled then                    ToJobPlanningLine.Insert(true);            until TempExtTextLine.Next() = 0;            MakeUpdateRequired := true;        end;        TempExtTextLine.DeleteAll();        LastInsertedJobPlanningLine := ToJobPlanningLine;    end;    procedure IsDeleteAttachedLines(LineNo: Integer; No: Code[20]; AttachedToLineNo: Integer): Boolean    begin        exit((LineNo <> 0) and (AttachedToLineNo = 0) and (No <> ''));    end;    [IntegrationEvent(false, false)]    local procedure OnAfterReadLines(var TempExtendedTextLine: Record "Extended Text Line" temporary; var ExtendedTextHeader: Record "Extended Text Header"; LanguageCode: Code[10])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeReadLines(var ExtendedTextHeader: Record "Extended Text Header"; DocDate: Date; LanguageCode: Code[10]; var IsHandled: Boolean; var Result: Boolean; var TempExtTextLine: Record "Extended Text Line" temporary)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeToPurchLineInsert(var ToPurchLine: Record "Purchase Line"; var PurchLine: Record "Purchase Line"; TempExtTextLine: Record "Extended Text Line" temporary; var NextLineNo: Integer; LineSpacing: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertSalesExtTextRetLastOnBeforeToSalesLineInsert(var ToSalesLine: Record "Sales Line"; var SalesLine: Record "Sales Line"; TempExtTextLine: Record "Extended Text Line" temporary; var NextLineNo: Integer; LineSpacing: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeToReminderLineInsert(var ToReminderLine: Record "Reminder Line"; ReminderLine: Record "Reminder Line"; TempExtTextLine: Record "Extended Text Line" temporary; var NextLineNo: Integer; LineSpacing: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDeleteFinChrgMemoLinesOnAfterFinChrgMemoLine2SetFilters(var FinChrgMemoLine2: Record "Finance Charge Memo Line"; var FinChrgMemoLine: Record "Finance Charge Memo Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDeletePurchLinesOnAfterSetFilters(var ToPurchaseLine: Record "Purchase Line"; FromPurchaseLine: Record "Purchase Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDeleteSalesLinesOnAfterSetFilters(var ToSalesLine: Record "Sales Line"; FromSalesLine: Record "Sales Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDeleteReminderLinesOnAfterReminderLine2SetFilters(var ReminderLine2: Record "Reminder Line"; var ReminderLine: Record "Reminder Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFinChrgMemoCheckIfAnyExtTextAutoText(var ExtendedTextHeader: Record "Extended Text Header"; var FinanceChargeMemoHeader: Record "Finance Charge Memo Header"; var FinanceChargeMemoLine: Record "Finance Charge Memo Line"; Unconditionally: Boolean; var MakeUpdateRequired: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnPrepmtGetAnyExtTextAfterReadLines(var ExtendedTextHeader: Record "Extended Text Header"; var TempExtendedTextLine: Record "Extended Text Line" temporary)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnPrepmtGetAnyExtTextBeforeReadLines(var ExtendedTextHeader: Record "Extended Text Header"; DocumentDate: Date; LanguageCode: Code[10])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnPurchCheckIfAnyExtTextAutoText(var ExtendedTextHeader: Record "Extended Text Header"; var PurchaseHeader: Record "Purchase Header"; var PurchaseLine: Record "Purchase Line"; Unconditionally: Boolean; var MakeUpdateRequired: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnReminderCheckIfAnyExtTextAutoText(var ExtendedTextHeader: Record "Extended Text Header"; var ReminderHeader: Record "Reminder Header"; var ReminderLine: Record "Reminder Line"; Unconditionally: Boolean; var MakeUpdateRequired: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnSalesCheckIfAnyExtTextAutoText(var ExtendedTextHeader: Record "Extended Text Header"; var SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line"; Unconditionally: Boolean; var MakeUpdateRequired: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertSalesExtText(var SalesLine: Record "Sales Line"; var TempExtTextLine: Record "Extended Text Line" temporary; var IsHandled: Boolean; var MakeUpdateRequired: Boolean; var LastInsertedSalesLine: Record "Sales Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertReminderExtText(var ReminderLine: Record "Reminder Line"; var TempExtTextLine: Record "Extended Text Line" temporary; var IsHandled: Boolean; var MakeUpdateRequired: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertFinChrgMemoExtText(var FinChrgMemoLine: Record "Finance Charge Memo Line"; var TempExtTextLine: Record "Extended Text Line" temporary; var IsHandled: Boolean; var MakeUpdateRequired: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertPurchExtText(var PurchLine: Record "Purchase Line"; var TempExtTextLine: Record "Extended Text Line" temporary; var IsHandled: Boolean; var MakeUpdateRequired: Boolean; var LastInsertedPurchLine: Record "Purchase Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure InsertPurchExtTextRetLastOnBeforeToPurchLineFind(var PurchLine: Record "Purchase Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertSalesExtTextRetLastOnBeforeToSalesLineFind(var SalesLine: Record "Sales Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnPurchCheckIfAnyExtTextOnBeforeSetFilters(var PurchaseLine: Record "Purchase Line"; var AutoText: Boolean; Unconditionally: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnSalesCheckIfAnyExtTextOnBeforeSetFilters(var SalesLine: Record "Sales Line"; var AutoText: Boolean; Unconditionally: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnReminderCheckIfAnyExtTextOnBeforeSetFilters(var ReminderLine: Record "Reminder Line"; var AutoText: Boolean; Unconditionally: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFinChrgMemoCheckIfAnyExtTextOnBeforeSetFilters(var FinChrgMemoLine: Record "Finance Charge Memo Line"; var AutoText: Boolean; Unconditionally: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnReadExtTextLinesOnBeforeSetFilters(var ExtTextHeader: Record "Extended Text Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertFinChrgMemoExtTextOnBeforeToFinChrgMemoLineInsert(var ToFinanceChargeMemoLine: Record "Finance Charge Memo Line"; FinanceChargeMemoLine: Record "Finance Charge Memo Line"; TempExtendedTextLine: Record "Extended Text Line" temporary; var NextLineNo: Integer; LineSpacing: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnReadExtTextLinesOnBeforeTempExtTextLineInsert(var TempExtendedTextLine: Record "Extended Text Line" temporary; ExtendedTextHeader: Record "Extended Text Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertSalesExtTextRetLastOnBeforeFindTempExtTextLine(var TempExtendedTextLine: Record "Extended Text Line" temporary; SalesLine: Record "Sales Line");    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertReminderExtTextOnBeforeFindTempExtTextLine(var TempExtendedTextLine: Record "Extended Text Line" temporary; ReminderLine: Record "Reminder Line");    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertPurchExtTextRetLastOnBeforeFindTempExtTextLine(var TempExtendedTextLine: Record "Extended Text Line" temporary; PurchaseLine: Record "Purchase Line");    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeSalesCheckIfAnyExtText(var SalesLine: Record "Sales Line"; SalesHeader: Record "Sales Header"; Unconditionally: Boolean; var MakeUpdateRequired: Boolean; var AutoText: Boolean; var Result: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePurchCheckIfAnyExtText(var PurchLine: Record "Purchase Line"; PurchaseHeader: Record "Purchase Header"; Unconditionally: Boolean; var MakeUpdateRequired: Boolean; var AutoText: Boolean; var Result: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDeleteSalesLinesOnBeforeDelete(var SalesLine: Record "Sales Line"; var SalesLineToDelete: Record "Sales Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertJobExtTextRetLast(var JobPlanningLine: Record "Job Planning Line"; var TempExtendedTextLine: Record "Extended Text Line" temporary; var MakeUpdateRequired: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnJobCheckIfAnyExtTextOnBeforeReadExtTextLines(var ExtendedTextHeader: Record "Extended Text Header"; var Job: Record Job; var JobPlanningLine: Record "Job Planning Line"; Unconditionally: Boolean; var MakeUpdateRequired: Boolean; var DocumentDate: Date)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertJobExtTextRetLastOnBeforeToJobPlanningLineInsert(var ToJobPlanningLine: Record "Job Planning Line"; var JobPlanningLine: Record "Job Planning Line"; TempExtendedTextLine: Record "Extended Text Line" temporary; var NextLineNo: Integer; LineSpacing: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDeleteJobPlanningLinesOnAfterSetFilters(var ToJobPlanningLine: Record "Job Planning Line"; FromJobPlanningLine: Record "Job Planning Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnJobCheckIfAnyExtTextOnAfterCheckAutoText(var JobPlanningLine: Record "Job Planning Line"; var AutoText: Boolean; Unconditionally: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertSalesExtTextRetLastOnAfterSetLineSpacing(var LineSpacing: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeJobCheckIfAnyExtText(var JobPlanningLine: Record "Job Planning Line"; Unconditionally: Boolean; var MakeUpdateRequired: Boolean; var AutoText: Boolean; var Result: Boolean; var IsHandled: Boolean)    begin    end;}