Codeunit 1797 Data Migration Facade Helper

Base Application, System.Integration

src/Layers/W1/BaseApp/System/DataMigration/DataMigrationFacadeHelper.Codeunit.al431 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.Integration;using Microsoft.Bank.BankAccount;using Microsoft.CRM.BusinessRelation;using Microsoft.CRM.Contact;using Microsoft.CRM.Setup;using Microsoft.CRM.Team;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.SalesTax;using Microsoft.Foundation.Address;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.PaymentTerms;using Microsoft.Foundation.Shipping;using Microsoft.Inventory.Intrastat;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Pricing;using System.Globalization;codeunit 1797 "Data Migration Facade Helper"{    SingleInstance = true;    trigger OnRun()    begin    end;    var        DataMigrationFacadeHelper: Codeunit "Data Migration Facade Helper";    procedure CreateShipmentMethodIfNeeded(CodeToSet: Code[10]; DescriptionToSet: Text[50]): Code[10]    var        ShipmentMethod: Record "Shipment Method";    begin        if ShipmentMethod.Get(CodeToSet) then            exit(CodeToSet);        ShipmentMethod.Validate(Code, CodeToSet);        ShipmentMethod.Validate(Description, DescriptionToSet);        ShipmentMethod.Insert(true);        exit(ShipmentMethod.Code);    end;    procedure CreateSalespersonPurchaserIfNeeded(CodeToSet: Code[20]; NameToSet: Text[50]; PhoneNoToSet: Text[30]; EmailToSet: Text[80]): Code[20]    var        SalespersonPurchaser: Record "Salesperson/Purchaser";    begin        if SalespersonPurchaser.Get(CodeToSet) then            exit(CodeToSet);        SalespersonPurchaser.Init();        SalespersonPurchaser.Validate(Code, CodeToSet);        SalespersonPurchaser.Validate(Name, NameToSet);        SalespersonPurchaser.Validate("Phone No.", PhoneNoToSet);        SalespersonPurchaser.Validate("E-Mail", EmailToSet);        SalespersonPurchaser.Validate("Search E-Mail", EmailToSet);        SalespersonPurchaser.Insert(true);        exit(SalespersonPurchaser.Code);    end;    procedure CreateCustomerPriceGroupIfNeeded(CodeToSet: Code[10]; DescriptionToSet: Text[50]; PriceIncludesVatToSet: Boolean): Code[10]    var        CustomerPriceGroup: Record "Customer Price Group";    begin        if CustomerPriceGroup.Get(CodeToSet) then            exit(CodeToSet);        CustomerPriceGroup.Init();        CustomerPriceGroup.Validate(Code, CodeToSet);        CustomerPriceGroup.Validate(Description, DescriptionToSet);        CustomerPriceGroup.Validate("Price Includes VAT", PriceIncludesVatToSet);        CustomerPriceGroup.Insert(true);        exit(CustomerPriceGroup.Code);    end;    procedure CreatePaymentTermsIfNeeded(CodeToSet: Code[10]; DescriptionToSet: Text[50]; DueDateCalculationToSet: DateFormula): Code[10]    var        PaymentTerms: Record "Payment Terms";    begin        if PaymentTerms.Get(CodeToSet) then            exit(CodeToSet);        PaymentTerms.Init();        PaymentTerms.Validate(Code, CodeToSet);        PaymentTerms.Validate(Description, DescriptionToSet);        PaymentTerms.Validate("Due Date Calculation", DueDateCalculationToSet);        PaymentTerms.Insert(true);        exit(PaymentTerms.Code);    end;    procedure CreateTerritoryIfNeeded(CodeToSet: Code[10]; Name: Text[50]): Code[10]    var        Territory: Record Territory;    begin        if Territory.Get(CodeToSet) then            exit(CodeToSet);        Territory.Init();        Territory.Validate(Code, CodeToSet);        Territory.Validate(Name, Name);        Territory.Insert(true);        exit(Territory.Code);    end;    procedure CreateTaxAreaIfNeeded(CodeToSet: Code[20]; Description: Text[50]): Code[20]    var        TaxArea: Record "Tax Area";    begin        if TaxArea.Get(CodeToSet) then            exit(CodeToSet);        TaxArea.Init();        TaxArea.Validate(Code, CodeToSet);        TaxArea.Validate(Description, Description);        TaxArea.Insert(true);        exit(TaxArea.Code);    end;    procedure CreatePaymentMethodIfNeeded(CodeToSet: Code[10]; DescriptionToSet: Text[50]): Code[10]    var        PaymentMethod: Record "Payment Method";    begin        if PaymentMethod.Get(CodeToSet) then            exit(CodeToSet);        PaymentMethod.Init();        PaymentMethod.Validate(Code, CodeToSet);        PaymentMethod.Validate(Description, DescriptionToSet);        PaymentMethod.Insert(true);        exit(PaymentMethod.Code);    end;    procedure DoesPostCodeExist(CodeToSearch: Code[20]; CityToSearch: Text[30]): Boolean    var        PostCode: Record "Post Code";    begin        exit(PostCode.Get(CodeToSearch, CityToSearch));    end;    procedure CreatePostCodeIfNeeded(CodeToSet: Code[20]; CityToSet: Text[30]; CountyToSet: Text[30]; CountryRegionCodeToSet: Code[10]): Boolean    var        PostCode: Record "Post Code";    begin        PostCode.SetRange(Code, CodeToSet);        PostCode.SetRange("Search City", UpperCase(CityToSet));        if PostCode.FindFirst() then            exit(false);        PostCode.Init();        PostCode.Validate(Code, CodeToSet);        PostCode.Validate(City, CityToSet);        PostCode.Validate(County, CountyToSet);        PostCode.Validate("Country/Region Code", CountryRegionCodeToSet);        PostCode.Insert(true);        exit(true);    end;    procedure CreateCountryIfNeeded(CodeToSet: Code[10]; NameToSet: Text[50]; AddressFormatToSet: Option "Post Code+City","City+Post Code","City+County+Post Code","Blank Line+Post Code+City"; ContactAddressFormatToSet: Option First,"After Company Name",Last): Code[10]    var        CountryRegion: Record "Country/Region";    begin        if CountryRegion.Get(CodeToSet) then            exit(CountryRegion.Code);        CountryRegion.Init();        CountryRegion.Validate(Code, CodeToSet);        CountryRegion.Validate(Name, NameToSet);        CountryRegion.Validate("Address Format", AddressFormatToSet);        CountryRegion.Validate("Contact Address Format", ContactAddressFormatToSet);        CountryRegion.Insert(true);        exit(CountryRegion.Code);    end;    procedure SearchCountry(CodeToSearch: Code[10]; NameToSearch: Text[50]; EUCountryRegionCodeToSearch: Code[10]; IntrastatCodeToSet: Code[10]; var CodeToGet: Code[10]): Boolean    var        CountryRegion: Record "Country/Region";    begin        if CodeToSearch <> '' then            CountryRegion.SetRange(Code, CodeToSearch);        if NameToSearch <> '' then            CountryRegion.SetRange(Name, NameToSearch);        if EUCountryRegionCodeToSearch <> '' then            CountryRegion.SetRange("EU Country/Region Code", EUCountryRegionCodeToSearch);        if IntrastatCodeToSet <> '' then            CountryRegion.SetRange("Intrastat Code", IntrastatCodeToSet);        if CountryRegion.FindFirst() then begin            CodeToGet := CountryRegion.Code;            exit(true);        end;    end;    procedure SearchLanguage(AbbreviatedNameToSearch: Code[3]; var CodeToGet: Code[10]): Boolean    var        WindowsLanguageSearch: Record "Windows Language";        Language: Codeunit Language;    begin        WindowsLanguageSearch.SetRange("Abbreviated Name", AbbreviatedNameToSearch);        if WindowsLanguageSearch.FindFirst() then begin            CodeToGet := Language.GetLanguageCode(WindowsLanguageSearch."Language ID");            if CodeToGet <> '' then                exit(true);        end;    end;    procedure FixIfLcyCode(CurrencyCode: Code[10]): Code[10]    var        GeneralLedgerSetup: Record "General Ledger Setup";    begin        GeneralLedgerSetup.FindFirst();        if CurrencyCode = GeneralLedgerSetup."LCY Code" then            exit('');        exit(CurrencyCode);    end;    procedure CreateGeneralJournalBatchIfNeeded(GeneralJournalBatchCode: Code[10]; NoSeriesCode: Code[20]; PostingNoSeriesCode: Code[20])    var        GenJournalBatch: Record "Gen. Journal Batch";        TemplateName: Code[10];    begin        TemplateName := CreateGeneralJournalTemplateIfNeeded(GeneralJournalBatchCode);        GenJournalBatch.SetRange("Journal Template Name", TemplateName);        GenJournalBatch.SetRange(Name, GeneralJournalBatchCode);        GenJournalBatch.SetRange("No. Series", NoSeriesCode);        GenJournalBatch.SetRange("Posting No. Series", PostingNoSeriesCode);        if not GenJournalBatch.FindFirst() then begin            GenJournalBatch.Init();            GenJournalBatch.Validate("Journal Template Name", TemplateName);            GenJournalBatch.SetupNewBatch();            GenJournalBatch.Validate(Name, GeneralJournalBatchCode);            GenJournalBatch.Validate(Description, GeneralJournalBatchCode);            GenJournalBatch."No. Series" := NoSeriesCode;            GenJournalBatch."Posting No. Series" := PostingNoSeriesCode;            GenJournalBatch.Insert(true);        end;    end;    local procedure CreateGeneralJournalTemplateIfNeeded(GeneralJournalBatchCode: Code[10]): Code[10]    var        GenJournalTemplate: Record "Gen. Journal Template";    begin        GenJournalTemplate.SetRange(Type, GenJournalTemplate.Type::General);        GenJournalTemplate.SetRange(Recurring, false);        if not GenJournalTemplate.FindFirst() then begin            GenJournalTemplate.Init();            GenJournalTemplate.Validate(Name, GeneralJournalBatchCode);            GenJournalTemplate.Validate(Type, GenJournalTemplate.Type::General);            GenJournalTemplate.Validate(Recurring, false);            GenJournalTemplate.Insert(true);        end;        exit(GenJournalTemplate.Name);    end;    procedure CreateGeneralJournalLine(var GenJournalLine: Record "Gen. Journal Line"; GeneralJournalBatchCode: Code[10]; DocumentNo: Code[20]; Description: Text[50]; AccountType: Enum "Gen. Journal Account Type"; AccountNo: Code[20]; PostingDate: Date; DueDate: Date; Amount: Decimal; AmountLCY: Decimal; Currency: Code[10]; BalancingAccount: Code[20])    var        GenJournalBatch: Record "Gen. Journal Batch";        GenJournalLineCurrent: Record "Gen. Journal Line";        GenJournalTemplate: Record "Gen. Journal Template";        LineNum: Integer;    begin        GenJournalBatch.Get(CreateGeneralJournalTemplateIfNeeded(GeneralJournalBatchCode), GeneralJournalBatchCode);        GenJournalLineCurrent.SetRange("Journal Template Name", GenJournalBatch."Journal Template Name");        GenJournalLineCurrent.SetRange("Journal Batch Name", GenJournalBatch.Name);        if GenJournalLineCurrent.FindLast() then            LineNum := GenJournalLineCurrent."Line No." + 10000        else            LineNum := 10000;        GenJournalTemplate.Get(GenJournalBatch."Journal Template Name");        GenJournalLine.Init();        GenJournalLine.SetHideValidation(true);        GenJournalLine.Validate("Source Code", GenJournalTemplate."Source Code");        GenJournalLine.Validate("Journal Template Name", GenJournalBatch."Journal Template Name");        GenJournalLine.Validate("Journal Batch Name", GenJournalBatch.Name);        GenJournalLine.Validate("Line No.", LineNum);        GenJournalLine.Validate("Account Type", AccountType);        GenJournalLine.Validate("Document No.", DocumentNo);        GenJournalLine.Validate("Account No.", AccountNo);        GenJournalLine.Validate(Description, Description);        GenJournalLine.Validate("Document Date", PostingDate);        GenJournalLine.Validate("Posting Date", PostingDate);        GenJournalLine.Validate("Due Date", DueDate);        GenJournalLine.Validate(Amount, Amount);        GenJournalLine.Validate("Amount (LCY)", AmountLCY);        GenJournalLine.Validate("Currency Code", DataMigrationFacadeHelper.FixIfLcyCode(Currency));        GenJournalLine.Validate("Bal. Account Type", GenJournalLine."Bal. Account Type"::"G/L Account");        GenJournalLine.Validate("Bal. Account No.", BalancingAccount);        GenJournalLine.Validate("Bal. Gen. Posting Type", GenJournalLine."Bal. Gen. Posting Type"::" ");        GenJournalLine.Validate("Bal. Gen. Bus. Posting Group", '');        GenJournalLine.Validate("Bal. Gen. Prod. Posting Group", '');        GenJournalLine.Validate("Bal. VAT Prod. Posting Group", '');        GenJournalLine.Validate("Bal. VAT Bus. Posting Group", '');        GenJournalLine.Insert(true);    end;    procedure GetOrCreateDimension(DimensionCode: Code[20]; DimensionDescription: Text[50]; var Dimension: Record Dimension)    begin        if Dimension.Get(DimensionCode) then            exit;        Dimension.Init();        Dimension.Validate(Code, DimensionCode);        Dimension.Validate(Description, DimensionDescription);        Dimension.Insert(true);    end;    procedure GetOrCreateDimensionValue(DimensionCode: Code[20]; DimensionValueCode: Code[20]; DimensionValueName: Text[50]; var DimensionValue: Record "Dimension Value")    begin        if DimensionValue.Get(DimensionCode, DimensionValueCode) then            exit;        DimensionValue.Init();        DimensionValue.Validate("Dimension Code", DimensionCode);        DimensionValue.Validate(Code, DimensionValueCode);        DimensionValue.Validate(Name, DimensionValueName);        DimensionValue.Insert(true);    end;    procedure CreateOnlyDefaultDimensionIfNeeded(DimensionCode: Code[20]; DimensionValueCode: Code[20]; TableId: Integer; EntityNo: Code[20])    var        DefaultDimension: Record "Default Dimension";    begin        if DefaultDimension.Get(TableId, EntityNo, DimensionCode) then            exit;        DefaultDimension.Init();        DefaultDimension.Validate("Dimension Code", DimensionCode);        DefaultDimension.Validate("Dimension Value Code", DimensionValueCode);        DefaultDimension.Validate("Table ID", TableId);        DefaultDimension.Validate("No.", EntityNo);        DefaultDimension.Insert(true);    end;    procedure CreateDimensionSetId(OldDimensionSetId: Integer; DimensionCode: Code[20]; DimensionDescription: Text[50]; DimensionValueCode: Code[20]; DimensionValueName: Text[50]): Integer    var        Dimension: Record Dimension;        DimensionValue: Record "Dimension Value";        DimensionSetEntry: Record "Dimension Set Entry";        TempDimensionSetEntry: Record "Dimension Set Entry" temporary;        DimensionManagement: Codeunit DimensionManagement;    begin        if (DimensionCode = '') or (DimensionValueCode = '') then            exit(OldDimensionSetId);        GetOrCreateDimension(DimensionCode, DimensionDescription, Dimension);        GetOrCreateDimensionValue(DimensionCode, DimensionValueCode, DimensionValueName, DimensionValue);        DimensionSetEntry.SetRange("Dimension Set ID", OldDimensionSetId);        DimensionSetEntry.SetFilter("Dimension Code", '<>%1', DimensionCode);        if DimensionSetEntry.FindSet() then            repeat                TempDimensionSetEntry.TransferFields(DimensionSetEntry);                TempDimensionSetEntry.Insert(true);            until DimensionSetEntry.Next() = 0;        TempDimensionSetEntry.Init();        TempDimensionSetEntry.Validate("Dimension Set ID", OldDimensionSetId);        TempDimensionSetEntry.Validate("Dimension Code", DimensionCode);        TempDimensionSetEntry.Validate("Dimension Value Code", DimensionValueCode);        TempDimensionSetEntry.Insert(true);        exit(DimensionManagement.GetDimensionSetID(TempDimensionSetEntry));    end;    procedure CreateSourceCodeIfNeeded(SourceCodeCode: Code[10]): Code[10]    var        SourceCode: Record "Source Code";    begin        if SourceCode.Get(SourceCodeCode) then            exit(SourceCode."Code");        SourceCode.Init();        SourceCode.Validate("Code", SourceCodeCode);        SourceCode.Insert(true);        exit(SourceCode."Code");    end;    procedure SetAlternativeContact(NameToSet: Text[50]; AddressToSet: Text[50]; Address2ToSet: Text[50]; PostCodeToSet: Code[20]; CityToSet: Text[30]; CountryToSet: Code[10]; EmailToset: Text[80]; PhoneNoToSet: Text[30]; FaxToSet: Text[30]; MobileNoToSet: Text[30]; LinkToTable: Integer; EntityNo: Code[20])    var        Contact: Record Contact;        ContactBusinessRelation: Record "Contact Business Relation";        MarketingSetup: Record "Marketing Setup";    begin        if not MarketingSetup.Get() then            exit;        if LinkToTable = DATABASE::Vendor then begin            ContactBusinessRelation.SetRange("Business Relation Code", MarketingSetup."Bus. Rel. Code for Vendors");            ContactBusinessRelation.SetRange("Link to Table", ContactBusinessRelation."Link to Table"::Vendor);            ContactBusinessRelation.SetRange("No.", EntityNo);            if not ContactBusinessRelation.FindFirst() then                exit;        end else            if LinkToTable = DATABASE::Customer then begin                ContactBusinessRelation.SetRange("Business Relation Code", MarketingSetup."Bus. Rel. Code for Customers");                ContactBusinessRelation.SetRange("Link to Table", ContactBusinessRelation."Link to Table"::Customer);                ContactBusinessRelation.SetRange("No.", EntityNo);                if not ContactBusinessRelation.FindFirst() then                    exit;            end else                exit;        Contact.Init();        Contact.Validate(Name, NameToSet);        Contact.Validate(Address, AddressToSet);        Contact.Validate("Address 2", Address2ToSet);        Contact.Validate("Country/Region Code", CountryToSet);        Contact.Validate("Post Code", PostCodeToSet);        Contact.Validate(City, CityToSet);        Contact.Validate("E-Mail", EmailToset);        Contact.Validate("Phone No.", PhoneNoToSet);        Contact.Validate("Fax No.", FaxToSet);        Contact.Validate("Mobile Phone No.", MobileNoToSet);        Contact.Validate(Type, Contact.Type::Person);        Contact.Validate("Company No.", ContactBusinessRelation."Contact No.");        ContactBusinessRelation.CalcFields("Contact Name");        Contact.Validate("Company Name", ContactBusinessRelation."Contact Name");        Contact.Insert(true);    end;}