Codeunit 9994 API Data Upgrade
src/Layers/W1/BaseApp/System/API/Upgrade/APIDataUpgrade.Codeunit.al1,015 lines, Copyright (c) Microsoft Corporation. MIT
namespace Microsoft.API.Upgrade;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.FixedAssets.FixedAsset;using Microsoft.FixedAssets.Setup;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.Shipping;using Microsoft.HumanResources.Employee;using Microsoft.Integration.Entity;using Microsoft.Integration.Graph;using Microsoft.Inventory.Item;using Microsoft.Purchases.Document;using Microsoft.Purchases.History;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Sales.History;using Microsoft.Upgrade;using System.Environment;using System.Upgrade;codeunit 9994 "API Data Upgrade"{ Permissions = TableData "Sales Shipment Header" = rm, TableData "Sales Shipment Line" = rm, TableData "Purch. Rcpt. Header" = r, TableData "Purch. Rcpt. Line" = rm; trigger OnRun() var APIDataUpgrade: Record "API Data Upgrade"; GraphCollectionMgtItem: Codeunit "Graph Collection Mgt - Item"; GraphMgtCustomer: Codeunit "Graph Mgt - Customer"; GraphMgtCustomerPayments: Codeunit "Graph Mgt - Customer Payments"; GraphMgtJournalLines: Codeunit "Graph Mgt - Journal Lines"; PurchInvAggregator: Codeunit "Purch. Inv. Aggregator"; GraphMgtSalCrMemoBuf: Codeunit "Graph Mgt - Sal. Cr. Memo Buf."; GraphMgtSalesHeader: Codeunit "Graph Mgt - Sales Header"; SalesInvoiceAggregator: Codeunit "Sales Invoice Aggregator"; GraphMgtSalesOrderBuffer: Codeunit "Graph Mgt - Sales Order Buffer"; GraphMgtSalesQuoteBuffer: Codeunit "Graph Mgt - Sales Quote Buffer"; GraphMgtVendor: Codeunit "Graph Mgt - Vendor"; GraphMgtVendorPayments: Codeunit "Graph Mgt - Vendor Payments"; GraphMgtPurchOrderBuffer: Codeunit "Graph Mgt - Purch Order Buffer"; UpgradeTag: Codeunit "Upgrade Tag"; begin APIDataUpgrade.SetRange(Status, APIDataUpgrade.Status::Scheduled); if APIDataUpgrade.FindSet() then repeat case APIDataUpgrade."Upgrade Tag" of 'ITEMS': begin GraphCollectionMgtItem.UpdateIds(true); UpgradeItemPostingGroups(false); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'CUSTOMERS': begin GraphMgtCustomer.UpdateIds(true); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'CUSTOMER PAYMENTS': begin GraphMgtCustomerPayments.UpdateIds(true); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'JOURNALS': begin GraphMgtJournalLines.UpdateIds(true); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'PURCHASE INVOICES': begin PurchInvAggregator.UpdateAggregateTableRecords(); PurchInvAggregator.FixInvoicesCreatedFromOrders(); UpgradePurchInvoiceShortcutDimension(false); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'SALES CREDIT MEMOS': begin GraphMgtSalCrMemoBuf.UpdateBufferTableRecords(); UpgradeSalesCrMemoShortcutDimension(false); UpgradeSalesCreditMemoReasonCode(false); UpgradeSalesCrMemoShipmentMethod(); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'SALES INVOICES': begin SalesInvoiceAggregator.UpdateAggregateTableRecords(); GraphMgtSalesHeader.UpdateIds(true); SalesInvoiceAggregator.FixInvoicesCreatedFromOrders(); UpgradeSalesInvoiceShortcutDimension(false); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'SALES ORDERS': begin GraphMgtSalesOrderBuffer.UpdateBufferTableRecords(); GraphMgtSalesOrderBuffer.DeleteOrphanedRecords(); UpgradeSalesOrderShortcutDimension(false); UpgradeSalesOrderShipmentMethod(); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'SALES QUOTES': begin GraphMgtSalesQuoteBuffer.UpdateBufferTableRecords(); UpgradeSalesQuoteShortcutDimension(false); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'VENDORS': begin GraphMgtVendor.UpdateIds(true); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'VENDOR PAYMENTS': begin GraphMgtVendorPayments.UpdateIds(true); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'SALES SHIPMENTS': begin UpgradeSalesShipmentLineDocumentId(false); UpgradeSalesShipmentCustomerId(); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'PURCHASE ORDERS': begin GraphMgtPurchOrderBuffer.UpdateBufferTableRecords(); GraphMgtPurchOrderBuffer.DeleteOrphanedRecords(); UpgradePurchaseOrderShortcutDimension(false); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'ITEM VARIANTS': begin UpdateItemVariants(); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'DEFAULT DIMENSIONS': begin UpgradeDefaultDimensions(); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'DIMENSION VALUES': begin UpgradeDimensionValues(); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'ACCOUNTS': begin UpgradeGLAccountAPIType(); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'PURCHASE RECEIPTS': begin UpgradePurchRcptLineDocumentId(false); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'PURCHASE CREDIT MEMOS': begin UpgradePurchaseCreditMemoBuffer(); UpgradePurchaseCreditMemoVendorCrMemoNo(); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; 'FIXED ASSETS': begin UpgradeFixedAssetLocationId(); UpgradeFixedAssetResponsibleEmployeeId(); SetStatus(APIDataUpgrade, APIDataUpgrade.Status::Completed); end; else OnAPIDataUpgrade(APIDataUpgrade."Upgrade Tag"); end; until APIDataUpgrade.Next() = 0; APIDataUpgrade.SetFilter(Status, '<>%1', APIDataUpgrade.Status::Completed); if APIDataUpgrade.IsEmpty() then UpgradeTag.SetSkippedUpgrade(GetDisableAPIDataUpgradesTag(), false); end; var UpgradeSkippedDueToManyRecordsLbl: Label 'Upgrade procedure %1 skipped due to %2 number of %3 records.', Comment = '%1 = Procedure name, %2 = Number of records, %3 = Table name', Locked = true; procedure UpgradeSalesCreditMemoReasonCode(CheckRecordCount: Boolean) var SalesCrMemoEntityBuffer: Record "Sales Cr. Memo Entity Buffer"; SalesCrMemoHeader: Record "Sales Cr.Memo Header"; SalesHeader: Record "Sales Header"; EnvironmentInformation: Codeunit "Environment Information"; RecordCount: Integer; begin if CheckRecordCount then if EnvironmentInformation.IsSaaS() then if SalesCrMemoEntityBuffer.Count() > GetSafeRecordCountForSaaSUpgrade() then exit; SalesCrMemoEntityBuffer.SetLoadFields(SalesCrMemoEntityBuffer.Id); if SalesCrMemoEntityBuffer.FindSet(true) then begin repeat if SalesCrMemoEntityBuffer.Posted then begin SalesCrMemoHeader.SetLoadFields(SalesCrMemoHeader."Reason Code"); if SalesCrMemoHeader.GetBySystemId(SalesCrMemoEntityBuffer.Id) then begin UpdateSalesCreditMemoReasonCodeFields(SalesCrMemoHeader."Reason Code", SalesCrMemoEntityBuffer); CountRecordsAndCommit(RecordCount); end; end else begin SalesHeader.SetLoadFields(SalesHeader."Reason Code"); if SalesHeader.GetBySystemId(SalesCrMemoEntityBuffer.Id) then begin UpdateSalesCreditMemoReasonCodeFields(SalesHeader."Reason Code", SalesCrMemoEntityBuffer); CountRecordsAndCommit(RecordCount); end; end; until SalesCrMemoEntityBuffer.Next() = 0; Commit(); end; end; procedure UpgradeSalesInvoiceShortcutDimension(CheckRecordCount: Boolean) var SalesInvoiceEntityAggregate: Record "Sales Invoice Entity Aggregate"; SalesHeader: Record "Sales Header"; SalesInvoiceHeader: Record "Sales Invoice Header"; EnvironmentInformation: Codeunit "Environment Information"; Modified: Boolean; RecordCount: Integer; begin SalesInvoiceEntityAggregate.SetLoadFields(Id, "No.", Posted, "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if SalesInvoiceEntityAggregate.FindSet(true) then begin if CheckRecordCount then if EnvironmentInformation.IsSaaS() then if SalesInvoiceEntityAggregate.Count() > GetSafeRecordCountForSaaSUpgrade() then begin Session.LogMessage('0000GAQ', StrSubstNo(UpgradeSkippedDueToManyRecordsLbl, 'UpgradeSalesInvoiceShortcutDimension', SalesInvoiceEntityAggregate.TableName(), SalesInvoiceEntityAggregate.Count()), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', 'AL SaaS Upgrade'); exit; end; repeat if SalesInvoiceEntityAggregate.Posted then begin SalesInvoiceHeader.SetLoadFields("No.", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if SalesInvoiceHeader.Get(SalesInvoiceEntityAggregate."No.") then begin if SalesInvoiceHeader."Shortcut Dimension 1 Code" <> '' then if SalesInvoiceHeader."Shortcut Dimension 1 Code" <> SalesInvoiceEntityAggregate."Shortcut Dimension 1 Code" then begin SalesInvoiceEntityAggregate."Shortcut Dimension 1 Code" := SalesInvoiceHeader."Shortcut Dimension 1 Code"; Modified := true; end; if SalesInvoiceHeader."Shortcut Dimension 2 Code" <> '' then if SalesInvoiceHeader."Shortcut Dimension 2 Code" <> SalesInvoiceEntityAggregate."Shortcut Dimension 2 Code" then begin SalesInvoiceEntityAggregate."Shortcut Dimension 2 Code" := SalesInvoiceHeader."Shortcut Dimension 2 Code"; Modified := true; end; if Modified then begin SalesInvoiceEntityAggregate.Modify(); CountRecordsAndCommit(RecordCount); end; end; end else begin SalesHeader.SetLoadFields("No.", "Document Type", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if SalesHeader.Get(SalesHeader."Document Type"::Invoice, SalesInvoiceEntityAggregate."No.") then begin if SalesHeader."Shortcut Dimension 1 Code" <> '' then if SalesHeader."Shortcut Dimension 1 Code" <> SalesInvoiceEntityAggregate."Shortcut Dimension 1 Code" then begin SalesInvoiceEntityAggregate."Shortcut Dimension 1 Code" := SalesHeader."Shortcut Dimension 1 Code"; Modified := true; end; if SalesHeader."Shortcut Dimension 2 Code" <> '' then if SalesHeader."Shortcut Dimension 2 Code" <> SalesInvoiceEntityAggregate."Shortcut Dimension 2 Code" then begin SalesInvoiceEntityAggregate."Shortcut Dimension 2 Code" := SalesHeader."Shortcut Dimension 2 Code"; Modified := true; end; if Modified then begin SalesInvoiceEntityAggregate.Modify(); CountRecordsAndCommit(RecordCount); end; end; end; until SalesInvoiceEntityAggregate.Next() = 0; Commit(); end; end; procedure UpgradePurchInvoiceShortcutDimension(CheckRecordCount: Boolean) var PurchInvEntityAggregate: Record "Purch. Inv. Entity Aggregate"; PurchaseHeader: Record "Purchase Header"; PurchInvHeader: Record "Purch. Inv. Header"; EnvironmentInformation: Codeunit "Environment Information"; Modified: Boolean; RecordCount: Integer; begin PurchInvEntityAggregate.SetLoadFields(Id, "No.", Posted, "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if PurchInvEntityAggregate.FindSet(true) then begin if CheckRecordCount then if EnvironmentInformation.IsSaaS() then if PurchInvEntityAggregate.Count() > GetSafeRecordCountForSaaSUpgrade() then begin Session.LogMessage('0000GAR', StrSubstNo(UpgradeSkippedDueToManyRecordsLbl, 'UpgradePurchInvoiceShortcutDimension', PurchInvEntityAggregate.TableName(), PurchInvEntityAggregate.Count()), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', 'AL SaaS Upgrade'); exit; end; repeat if PurchInvEntityAggregate.Posted then begin PurchInvHeader.SetLoadFields("No.", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if PurchInvHeader.Get(PurchInvEntityAggregate."No.") then begin if PurchInvHeader."Shortcut Dimension 1 Code" <> '' then if PurchInvHeader."Shortcut Dimension 1 Code" <> PurchInvEntityAggregate."Shortcut Dimension 1 Code" then begin PurchInvEntityAggregate."Shortcut Dimension 1 Code" := PurchInvHeader."Shortcut Dimension 1 Code"; Modified := true; end; if PurchInvHeader."Shortcut Dimension 2 Code" <> '' then if PurchInvHeader."Shortcut Dimension 2 Code" <> PurchInvEntityAggregate."Shortcut Dimension 2 Code" then begin PurchInvEntityAggregate."Shortcut Dimension 2 Code" := PurchInvHeader."Shortcut Dimension 2 Code"; Modified := true; end; if Modified then begin PurchInvEntityAggregate.Modify(); CountRecordsAndCommit(RecordCount); end; end; end else begin PurchaseHeader.SetLoadFields("No.", "Document Type", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if PurchaseHeader.Get(PurchaseHeader."Document Type"::Invoice, PurchInvEntityAggregate."No.") then begin if PurchaseHeader."Shortcut Dimension 1 Code" <> '' then if PurchaseHeader."Shortcut Dimension 1 Code" <> PurchInvEntityAggregate."Shortcut Dimension 1 Code" then begin PurchInvEntityAggregate."Shortcut Dimension 1 Code" := PurchaseHeader."Shortcut Dimension 1 Code"; Modified := true; end; if PurchaseHeader."Shortcut Dimension 2 Code" <> '' then if PurchaseHeader."Shortcut Dimension 2 Code" <> PurchInvEntityAggregate."Shortcut Dimension 2 Code" then begin PurchInvEntityAggregate."Shortcut Dimension 2 Code" := PurchaseHeader."Shortcut Dimension 2 Code"; Modified := true; end; if Modified then begin PurchInvEntityAggregate.Modify(); CountRecordsAndCommit(RecordCount); end; end; end; until PurchInvEntityAggregate.Next() = 0; Commit(); end; end; procedure UpgradePurchaseOrderShortcutDimension(CheckRecordCount: Boolean) var PurchaseOrderEntityBuffer: Record "Purchase Order Entity Buffer"; PurchaseHeader: Record "Purchase Header"; EnvironmentInformation: Codeunit "Environment Information"; Modified: Boolean; RecordCount: Integer; begin PurchaseOrderEntityBuffer.SetLoadFields(Id, "No.", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if PurchaseOrderEntityBuffer.FindSet(true) then begin if CheckRecordCount then if EnvironmentInformation.IsSaaS() then if PurchaseOrderEntityBuffer.Count() > GetSafeRecordCountForSaaSUpgrade() then begin Session.LogMessage('0000GAS', StrSubstNo(UpgradeSkippedDueToManyRecordsLbl, 'UpgradePurchaseOrderShortcutDimension', PurchaseOrderEntityBuffer.TableName(), PurchaseOrderEntityBuffer.Count()), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', 'AL SaaS Upgrade'); exit; end; repeat PurchaseHeader.SetLoadFields("No.", "Document Type", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if PurchaseHeader.Get(PurchaseHeader."Document Type"::Order, PurchaseOrderEntityBuffer."No.") then begin if PurchaseHeader."Shortcut Dimension 1 Code" <> '' then if PurchaseHeader."Shortcut Dimension 1 Code" <> PurchaseOrderEntityBuffer."Shortcut Dimension 1 Code" then begin PurchaseOrderEntityBuffer."Shortcut Dimension 1 Code" := PurchaseHeader."Shortcut Dimension 1 Code"; Modified := true; end; if PurchaseHeader."Shortcut Dimension 2 Code" <> '' then if PurchaseHeader."Shortcut Dimension 2 Code" <> PurchaseOrderEntityBuffer."Shortcut Dimension 2 Code" then begin PurchaseOrderEntityBuffer."Shortcut Dimension 2 Code" := PurchaseHeader."Shortcut Dimension 2 Code"; Modified := true; end; if Modified then begin PurchaseOrderEntityBuffer.Modify(); CountRecordsAndCommit(RecordCount); end; end; until PurchaseOrderEntityBuffer.Next() = 0; Commit(); end; end; procedure UpgradeSalesOrderShortcutDimension(CheckRecordCount: Boolean) var SalesOrderEntityBuffer: Record "Sales Order Entity Buffer"; SalesHeader: Record "Sales Header"; EnvironmentInformation: Codeunit "Environment Information"; Modified: Boolean; RecordCount: Integer; begin SalesOrderEntityBuffer.SetLoadFields(Id, "No.", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if SalesOrderEntityBuffer.FindSet(true) then begin if CheckRecordCount then if EnvironmentInformation.IsSaaS() then if SalesOrderEntityBuffer.Count() > GetSafeRecordCountForSaaSUpgrade() then begin Session.LogMessage('0000GAT', StrSubstNo(UpgradeSkippedDueToManyRecordsLbl, 'UpgradeSalesOrderShortcutDimension', SalesOrderEntityBuffer.TableName(), SalesOrderEntityBuffer.Count()), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', 'AL SaaS Upgrade'); exit; end; repeat SalesHeader.SetLoadFields("No.", "Document Type", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if SalesHeader.Get(SalesHeader."Document Type"::Order, SalesOrderEntityBuffer."No.") then begin if SalesHeader."Shortcut Dimension 1 Code" <> '' then if SalesHeader."Shortcut Dimension 1 Code" <> SalesOrderEntityBuffer."Shortcut Dimension 1 Code" then begin SalesOrderEntityBuffer."Shortcut Dimension 1 Code" := SalesHeader."Shortcut Dimension 1 Code"; Modified := true; end; if SalesHeader."Shortcut Dimension 2 Code" <> '' then if SalesHeader."Shortcut Dimension 2 Code" <> SalesOrderEntityBuffer."Shortcut Dimension 2 Code" then begin SalesOrderEntityBuffer."Shortcut Dimension 2 Code" := SalesHeader."Shortcut Dimension 2 Code"; Modified := true; end; if Modified then begin SalesOrderEntityBuffer.Modify(); CountRecordsAndCommit(RecordCount); end; end; until SalesOrderEntityBuffer.Next() = 0; Commit(); end; end; procedure UpgradeSalesQuoteShortcutDimension(CheckRecordCount: Boolean) var SalesQuoteEntityBuffer: Record "Sales Quote Entity Buffer"; SalesHeader: Record "Sales Header"; EnvironmentInformation: Codeunit "Environment Information"; Modified: Boolean; RecordCount: Integer; begin SalesQuoteEntityBuffer.SetLoadFields(Id, "No.", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if SalesQuoteEntityBuffer.FindSet(true) then begin if CheckRecordCount then if EnvironmentInformation.IsSaaS() then if SalesQuoteEntityBuffer.Count() > GetSafeRecordCountForSaaSUpgrade() then begin Session.LogMessage('0000GAU', StrSubstNo(UpgradeSkippedDueToManyRecordsLbl, 'UpgradeSalesQuoteShortcutDimension', SalesQuoteEntityBuffer.TableName(), SalesQuoteEntityBuffer.Count()), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', 'AL SaaS Upgrade'); exit; end; repeat SalesHeader.SetLoadFields("No.", "Document Type", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if SalesHeader.Get(SalesHeader."Document Type"::Quote, SalesQuoteEntityBuffer."No.") then begin if SalesHeader."Shortcut Dimension 1 Code" <> '' then if SalesHeader."Shortcut Dimension 1 Code" <> SalesQuoteEntityBuffer."Shortcut Dimension 1 Code" then begin SalesQuoteEntityBuffer."Shortcut Dimension 1 Code" := SalesHeader."Shortcut Dimension 1 Code"; Modified := true; end; if SalesHeader."Shortcut Dimension 2 Code" <> '' then if SalesHeader."Shortcut Dimension 2 Code" <> SalesQuoteEntityBuffer."Shortcut Dimension 2 Code" then begin SalesQuoteEntityBuffer."Shortcut Dimension 2 Code" := SalesHeader."Shortcut Dimension 2 Code"; Modified := true; end; if Modified then begin SalesQuoteEntityBuffer.Modify(); CountRecordsAndCommit(RecordCount); end; end; until SalesQuoteEntityBuffer.Next() = 0; Commit(); end; end; procedure UpgradeSalesCrMemoShortcutDimension(CheckRecordCount: Boolean) var SalesCrMemoEntityBuffer: Record "Sales Cr. Memo Entity Buffer"; SalesHeader: Record "Sales Header"; SalesCrMemoHeader: Record "Sales Cr.Memo Header"; EnvironmentInformation: Codeunit "Environment Information"; Modified: Boolean; RecordCount: Integer; begin SalesCrMemoEntityBuffer.SetLoadFields(Id, "No.", Posted, "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if SalesCrMemoEntityBuffer.FindSet(true) then begin if CheckRecordCount then if EnvironmentInformation.IsSaaS() then if SalesCrMemoEntityBuffer.Count() > GetSafeRecordCountForSaaSUpgrade() then begin Session.LogMessage('0000GAV', StrSubstNo(UpgradeSkippedDueToManyRecordsLbl, 'UpgradeSalesCrMemoShortcutDimension', SalesCrMemoEntityBuffer.TableName(), SalesCrMemoEntityBuffer.Count()), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', 'AL SaaS Upgrade'); exit; end; repeat if SalesCrMemoEntityBuffer.Posted then begin SalesCrMemoHeader.SetLoadFields("No.", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if SalesCrMemoHeader.Get(SalesCrMemoEntityBuffer."No.") then begin if SalesCrMemoHeader."Shortcut Dimension 1 Code" <> '' then if SalesCrMemoHeader."Shortcut Dimension 1 Code" <> SalesCrMemoEntityBuffer."Shortcut Dimension 1 Code" then begin SalesCrMemoEntityBuffer."Shortcut Dimension 1 Code" := SalesCrMemoHeader."Shortcut Dimension 1 Code"; Modified := true; end; if SalesCrMemoHeader."Shortcut Dimension 2 Code" <> '' then if SalesCrMemoHeader."Shortcut Dimension 2 Code" <> SalesCrMemoEntityBuffer."Shortcut Dimension 2 Code" then begin SalesCrMemoEntityBuffer."Shortcut Dimension 2 Code" := SalesCrMemoHeader."Shortcut Dimension 2 Code"; Modified := true; end; if Modified then begin SalesCrMemoEntityBuffer.Modify(); CountRecordsAndCommit(RecordCount); end; end; end else begin SalesHeader.SetLoadFields("No.", "Document Type", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if SalesHeader.Get(SalesHeader."Document Type"::"Credit Memo", SalesCrMemoEntityBuffer."No.") then begin if SalesHeader."Shortcut Dimension 1 Code" <> '' then if SalesHeader."Shortcut Dimension 1 Code" <> SalesCrMemoEntityBuffer."Shortcut Dimension 1 Code" then begin SalesCrMemoEntityBuffer."Shortcut Dimension 1 Code" := SalesHeader."Shortcut Dimension 1 Code"; Modified := true; end; if SalesHeader."Shortcut Dimension 2 Code" <> '' then if SalesHeader."Shortcut Dimension 2 Code" <> SalesCrMemoEntityBuffer."Shortcut Dimension 2 Code" then begin SalesCrMemoEntityBuffer."Shortcut Dimension 2 Code" := SalesHeader."Shortcut Dimension 2 Code"; Modified := true; end; if Modified then begin SalesCrMemoEntityBuffer.Modify(); CountRecordsAndCommit(RecordCount); end; end; end; until SalesCrMemoEntityBuffer.Next() = 0; Commit(); end; end; procedure UpgradeItemPostingGroups(CheckRecordCount: Boolean) var Item: Record "Item"; GenProdPostingGroup: Record "Gen. Product Posting Group"; InventoryPostingGroup: Record "Inventory Posting Group"; EnvironmentInformation: Codeunit "Environment Information"; ItemModified: Boolean; RecordCount: Integer; begin Item.SetLoadFields("Gen. Prod. Posting Group", "Inventory Posting Group"); if Item.FindSet() then begin if CheckRecordCount then if EnvironmentInformation.IsSaaS() then if Item.Count() > GetSafeRecordCountForSaaSUpgrade() then begin Session.LogMessage('0000GWC', StrSubstNo(UpgradeSkippedDueToManyRecordsLbl, 'GenItemPostingGroups', Item.TableName(), Item.Count()), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', 'AL SaaS Upgrade'); exit; end; repeat ItemModified := false; if Item."Gen. Prod. Posting Group" <> '' then if GenProdPostingGroup.Get(Item."Gen. Prod. Posting Group") then begin Item."Gen. Prod. Posting Group Id" := GenProdPostingGroup.SystemId; ItemModified := true; end; if Item."Inventory Posting Group" <> '' then if InventoryPostingGroup.Get(Item."Inventory Posting Group") then begin Item."Inventory Posting Group Id" := InventoryPostingGroup.SystemId; ItemModified := true; end; if ItemModified then begin Item.Modify(false); CountRecordsAndCommit(RecordCount); end; until Item.Next() = 0; Commit(); end; end; local procedure UpdateSalesCreditMemoReasonCodeFields(SourceReasonCode: Code[10]; var SalesCrMemoEntityBuffer: Record "Sales Cr. Memo Entity Buffer"): Boolean var ReasonCode: Record "Reason Code"; NewReasonCodeId: Guid; EmptyGuid: Guid; Changed: Boolean; begin if SalesCrMemoEntityBuffer."Reason Code" <> SourceReasonCode then begin SalesCrMemoEntityBuffer."Reason Code" := SourceReasonCode; Changed := true; end; if SalesCrMemoEntityBuffer."Reason Code" <> '' then begin if ReasonCode.Get(SalesCrMemoEntityBuffer."Reason Code") then NewReasonCodeId := ReasonCode.SystemId else NewReasonCodeId := EmptyGuid; end else NewReasonCodeId := EmptyGuid; if SalesCrMemoEntityBuffer."Reason Code Id" <> NewReasonCodeId then begin SalesCrMemoEntityBuffer."Reason Code Id" := NewReasonCodeId; Changed := true; end; if Changed then exit(SalesCrMemoEntityBuffer.Modify()); end; procedure UpgradeSalesShipmentLineDocumentId(CheckRecordCount: Boolean) var SalesShipmentHeader: Record "Sales Shipment Header"; SalesShipmentLine: Record "Sales Shipment Line"; EnvironmentInformation: codeunit "Environment Information"; RecordCount: Integer; begin if CheckRecordCount then if EnvironmentInformation.IsSaaS() then if SalesShipmentLine.Count() > GetSafeRecordCountForSaaSUpgrade() then exit; SalesShipmentHeader.SetLoadFields(SalesShipmentHeader."No.", SalesShipmentHeader.SystemId); if SalesShipmentHeader.FindSet() then begin repeat SalesShipmentLine.SetRange("Document No.", SalesShipmentHeader."No."); SalesShipmentLine.ModifyAll("Document Id", SalesShipmentHeader.SystemId); CountRecordsAndCommit(RecordCount); until SalesShipmentHeader.Next() = 0; Commit(); end; end; procedure UpgradeSalesShipmentCustomerId() var SalesShipmentHeader: Record "Sales Shipment Header"; SalesShipmentHeader2: Record "Sales Shipment Header"; Customer: Record Customer; Modified: Boolean; RecordCount: Integer; begin SalesShipmentHeader.SetLoadFields("Sell-to Customer No.", "Bill-to Customer No.", "Customer Id", "Bill-to Customer Id"); Customer.SetLoadFields("No.", SystemId); if SalesShipmentHeader.FindSet() then repeat if Customer.Get(SalesShipmentHeader."Sell-to Customer No.") then if SalesShipmentHeader."Customer Id" <> Customer.SystemId then begin SalesShipmentHeader2 := SalesShipmentHeader; SalesShipmentHeader2."Customer Id" := Customer.SystemId; Modified := true; end; if Customer.Get(SalesShipmentHeader."Bill-to Customer No.") then if SalesShipmentHeader."Bill-to Customer Id" <> Customer.SystemId then begin if not Modified then SalesShipmentHeader2 := SalesShipmentHeader; SalesShipmentHeader2."Bill-to Customer Id" := Customer.SystemId; Modified := true; end; if Modified then begin SalesShipmentHeader2.Modify(); CountRecordsAndCommit(RecordCount); Modified := false; end; until SalesShipmentHeader.Next() = 0; end; procedure UpgradeFixedAssetLocationId() var FixedAsset: Record "Fixed Asset"; FixedAsset2: Record "Fixed Asset"; FALocation: Record "FA Location"; RecordCount: Integer; begin FixedAsset.SetLoadFields("FA Location Code", "FA Location Id"); FALocation.SetLoadFields(Code, SystemId); if FixedAsset.FindSet() then repeat if FALocation.Get(FixedAsset."FA Location Code") then if FixedAsset."FA Location Id" <> FALocation.SystemId then begin FixedAsset2 := FixedAsset; FixedAsset2."FA Location Id" := FALocation.SystemId; FixedAsset2.Modify(); CountRecordsAndCommit(RecordCount); end; until FixedAsset.Next() = 0; end; procedure UpgradeFixedAssetResponsibleEmployeeId() var FixedAsset: Record "Fixed Asset"; FixedAsset2: Record "Fixed Asset"; Employee: Record Employee; RecordCount: Integer; begin FixedAsset.SetLoadFields("Responsible Employee", "Responsible Employee Id"); Employee.SetLoadFields("No.", SystemId); if FixedAsset.FindSet() then repeat if Employee.Get(FixedAsset."Responsible Employee") then if FixedAsset."Responsible Employee Id" <> Employee.SystemId then begin FixedAsset2 := FixedAsset; FixedAsset2."Responsible Employee Id" := Employee.SystemId; FixedAsset2.Modify(); CountRecordsAndCommit(RecordCount); end; until FixedAsset.Next() = 0; end; procedure UpdateItemVariants() var Item: Record Item; ItemVariant: Record "Item Variant"; ItemVariant2: Record "Item Variant"; RecordCount: Integer; begin ItemVariant.SetLoadFields("Item No.", "Item Id"); ItemVariant2.SetLoadFields("Item No.", "Item Id"); if ItemVariant.FindSet() then begin repeat if Item.Get(ItemVariant."Item No.") then if ItemVariant."Item Id" <> Item.SystemId then begin ItemVariant2 := ItemVariant; ItemVariant2."Item Id" := Item.SystemId; ItemVariant2.Modify(); CountRecordsAndCommit(RecordCount); end; until ItemVariant.Next() = 0; Commit(); end; end; procedure UpgradeDefaultDimensions() var DefaultDimension: Record "Default Dimension"; RecordCount: Integer; begin if DefaultDimension.FindSet() then repeat DefaultDimension.UpdateReferencedIds(); CountRecordsAndCommit(RecordCount); until DefaultDimension.Next() = 0; end; procedure UpgradeDimensionValues() var Dimension: Record "Dimension"; DimensionValue: Record "Dimension Value"; DimensionValue2: Record "Dimension Value"; RecordCount: Integer; begin if DimensionValue.FindSet() then begin repeat if Dimension.Get(DimensionValue."Dimension Code") then if DimensionValue."Dimension Id" <> Dimension.SystemId then begin DimensionValue2 := DimensionValue; DimensionValue2."Dimension Id" := Dimension.SystemId; DimensionValue2.Modify(); CountRecordsAndCommit(RecordCount); end; until DimensionValue.Next() = 0; Commit(); end; end; procedure UpgradeGLAccountAPIType() var GLAccount: Record "G/L Account"; begin GLAccount.SetRange("Account Type", GLAccount."Account Type"::Posting); GLAccount.ModifyAll("API Account Type", GLAccount."API Account Type"::Posting); GLAccount.Reset(); GLAccount.SetRange("Account Type", GLAccount."Account Type"::Heading); GLAccount.ModifyAll("API Account Type", GLAccount."API Account Type"::Heading); GLAccount.Reset(); GLAccount.SetRange("Account Type", GLAccount."Account Type"::Total); GLAccount.ModifyAll("API Account Type", GLAccount."API Account Type"::Total); GLAccount.Reset(); GLAccount.SetRange("Account Type", GLAccount."Account Type"::"Begin-Total"); GLAccount.ModifyAll("API Account Type", GLAccount."API Account Type"::"Begin-Total"); GLAccount.Reset(); GLAccount.SetRange("Account Type", GLAccount."Account Type"::"End-Total"); GLAccount.ModifyAll("API Account Type", GLAccount."API Account Type"::"End-Total"); Commit(); end; procedure UpgradePurchRcptLineDocumentId(CheckRecordCount: Boolean) var PurchRcptHeader: Record "Purch. Rcpt. Header"; PurchRcptLine: Record "Purch. Rcpt. Line"; EnvironmentInformation: codeunit "Environment Information"; RecordCount: Integer; begin if CheckRecordCount then if EnvironmentInformation.IsSaaS() then if PurchRcptLine.Count() > GetSafeRecordCountForSaaSUpgrade() then exit; PurchRcptHeader.SetLoadFields(PurchRcptHeader."No.", PurchRcptHeader.SystemId); if PurchRcptHeader.FindSet() then begin repeat PurchRcptLine.SetRange("Document No.", PurchRcptHeader."No."); PurchRcptLine.ModifyAll("Document Id", PurchRcptHeader.SystemId); CountRecordsAndCommit(RecordCount); until PurchRcptHeader.Next() = 0; Commit(); end; end; local procedure UpgradePurchaseCreditMemoBuffer() var GraphMgtPurchCrMemo: Codeunit "Graph Mgt - Purch. Cr. Memo"; UpgradeTag: Codeunit "Upgrade Tag"; UpgradeTagDefinitions: Codeunit "Upgrade Tag Definitions"; begin GraphMgtPurchCrMemo.UpdateBufferTableRecords(); if not UpgradeTag.HasUpgradeTag(UpgradeTagDefinitions.GetPurchaseCreditMemoUpgradeTag()) then UpgradeTag.SetUpgradeTag(UpgradeTagDefinitions.GetPurchaseCreditMemoUpgradeTag()); end; internal procedure UpgradePurchaseCreditMemoVendorCrMemoNo() var PurchCrMemoEntityBuffer: Record "Purch. Cr. Memo Entity Buffer"; PurchaseHeader: Record "Purchase Header"; PurchCrMemoHeader: Record "Purch. Cr. Memo Hdr."; RecordCount: Integer; begin if PurchCrMemoEntityBuffer.FindSet() then repeat if PurchCrMemoEntityBuffer.Posted then begin PurchCrMemoHeader.SetLoadFields("No.", "Vendor Cr. Memo No."); if PurchCrMemoHeader.Get(PurchCrMemoEntityBuffer."No.") then if PurchCrMemoHeader."Vendor Cr. Memo No." <> '' then if PurchCrMemoHeader."Vendor Cr. Memo No." <> PurchCrMemoEntityBuffer."Vendor Cr. Memo No." then begin PurchCrMemoEntityBuffer."Vendor Cr. Memo No." := PurchCrMemoHeader."Vendor Cr. Memo No."; PurchCrMemoEntityBuffer.Modify(); CountRecordsAndCommit(RecordCount); end; end else begin PurchaseHeader.SetLoadFields("No.", "Document Type", "Vendor Cr. Memo No."); if PurchaseHeader.Get(PurchaseHeader."Document Type"::"Credit Memo", PurchCrMemoEntityBuffer."No.") then if PurchaseHeader."Vendor Cr. Memo No." <> '' then if PurchaseHeader."Vendor Cr. Memo No." <> PurchCrMemoEntityBuffer."Vendor Cr. Memo No." then begin PurchCrMemoEntityBuffer."Vendor Cr. Memo No." := PurchaseHeader."Vendor Cr. Memo No."; PurchCrMemoEntityBuffer.Modify(); CountRecordsAndCommit(RecordCount); end; end; until PurchCrMemoEntityBuffer.Next() = 0; end; internal procedure UpgradeSalesOrderShipmentMethod() var SalesOrderEntityBuffer: Record "Sales Order Entity Buffer"; SalesHeader: Record "Sales Header"; SourceRecordRef: RecordRef; TargetRecordRef: RecordRef; RecordCount: Integer; begin if SalesOrderEntityBuffer.FindSet() then repeat SalesHeader.SetRange("Document Type", SalesHeader."Document Type"::Order); SalesHeader.SetRange(SystemId, SalesOrderEntityBuffer.Id); if SalesHeader.FindFirst() then begin SourceRecordRef.GetTable(SalesHeader); TargetRecordRef.GetTable(SalesOrderEntityBuffer); UpdateSalesDocumentShipmentMethodFields(SourceRecordRef, TargetRecordRef); end; CountRecordsAndCommit(RecordCount); until SalesOrderEntityBuffer.Next() = 0; end; internal procedure UpgradeSalesCrMemoShipmentMethod() var SalesCrMemoEntityBuffer: Record "Sales Cr. Memo Entity Buffer"; SalesHeader: Record "Sales Header"; SalesCrMemoHeader: Record "Sales Cr.Memo Header"; SourceRecordRef: RecordRef; TargetRecordRef: RecordRef; RecordCount: Integer; begin if SalesCrMemoEntityBuffer.FindSet() then repeat if SalesCrMemoEntityBuffer.Posted then begin SalesCrMemoHeader.SetRange(SystemId, SalesCrMemoEntityBuffer.Id); if SalesCrMemoHeader.FindFirst() then begin SourceRecordRef.GetTable(SalesCrMemoHeader); TargetRecordRef.GetTable(SalesCrMemoEntityBuffer); UpdateSalesDocumentShipmentMethodFields(SourceRecordRef, TargetRecordRef); end; end else begin SalesHeader.SetRange("Document Type", SalesHeader."Document Type"::"Credit Memo"); SalesHeader.SetRange(SystemId, SalesCrMemoEntityBuffer.Id); if SalesHeader.FindFirst() then begin SourceRecordRef.GetTable(SalesHeader); TargetRecordRef.GetTable(SalesCrMemoEntityBuffer); UpdateSalesDocumentShipmentMethodFields(SourceRecordRef, TargetRecordRef); end; end; CountRecordsAndCommit(RecordCount); until SalesCrMemoEntityBuffer.Next() = 0; end; local procedure UpdateSalesDocumentShipmentMethodFields(var SourceRecordRef: RecordRef; var TargetRecordRef: RecordRef) var SalesHeader: Record "Sales Header"; SalesOrderEntityBuffer: Record "Sales Order Entity Buffer"; ShipmentMethod: Record "Shipment Method"; CodeFieldRef: FieldRef; IdFieldRef: FieldRef; EmptyGuid: Guid; OldId: Guid; NewId: Guid; Changed: Boolean; ShipmentMethodCode: Code[10]; begin if CopyFieldValue(SourceRecordRef, TargetRecordRef, SalesHeader.FieldNo("Shipment Method Code")) then Changed := true; CodeFieldRef := TargetRecordRef.Field(SalesOrderEntityBuffer.FieldNo("Shipment Method Code")); IdFieldRef := TargetRecordRef.Field(SalesOrderEntityBuffer.FieldNo("Shipment Method Id")); OldId := IdFieldRef.Value(); ShipmentMethodCode := CodeFieldRef.Value(); if ShipmentMethod.Get(ShipmentMethodCode) then NewId := ShipmentMethod.SystemId else NewId := EmptyGuid; if OldId <> NewId then begin IdFieldRef.Value := NewId; Changed := true; end; if Changed then TargetRecordRef.Modify(); end; local procedure CopyFieldValue(var SourceRecordRef: RecordRef; var TargetRecordRef: RecordRef; FieldNo: Integer): Boolean var SourceFieldRef: FieldRef; TargetFieldRef: FieldRef; begin SourceFieldRef := SourceRecordRef.Field(FieldNo); TargetFieldRef := TargetRecordRef.Field(FieldNo); if TargetFieldRef.Value <> SourceFieldRef.Value then begin TargetFieldRef.Value := SourceFieldRef.Value(); exit(true); end; exit(false); end; local procedure GetSafeRecordCountForSaaSUpgrade(): Integer begin exit(300000); end; procedure GetAPIUpgradeTags(var APIUpgradeTags: Dictionary of [Code[250], Text[250]]) begin OnGetAPIUpgradeTags(APIUpgradeTags); end; procedure SetStatus(var APIDataUpgrade: Record "API Data Upgrade"; Status: Option) begin APIDataUpgrade.Status := Status; APIDataUpgrade.Modify(); end; procedure GetAPIDataUpgradeEntities(var APIDataUpgradeEntities: Dictionary of [Code[250], Text[250]]) begin APIDataUpgradeEntities.Add('Items', 'items'); APIDataUpgradeEntities.Add('Customers', 'customers'); APIDataUpgradeEntities.Add('Customer Payments', 'customerPayments'); APIDataUpgradeEntities.Add('Journals', 'journals, journalLines'); APIDataUpgradeEntities.Add('Purchase Invoices', 'purchaseInvoices, purchaseInvoiceLines'); APIDataUpgradeEntities.Add('Sales Credit Memos', 'salesCreditMemos, salesCreditMemoLines'); APIDataUpgradeEntities.Add('Sales Invoices', 'salesInvoices, salesInvoiceLines'); APIDataUpgradeEntities.Add('Sales Orders', 'salesOrders, salesOrderLines'); APIDataUpgradeEntities.Add('Sales Quotes', 'salesQuotes, salesQuoteLines'); APIDataUpgradeEntities.Add('Vendors', 'vendors'); APIDataUpgradeEntities.Add('Vendor Payments', 'vendorPayments'); APIDataUpgradeEntities.Add('Sales Shipments', 'salesShipments'); APIDataUpgradeEntities.Add('Purchase Orders', 'purchaseOrders'); APIDataUpgradeEntities.Add('Item Variants', 'itemVariants'); APIDataUpgradeEntities.Add('Default Dimensions', 'defaultDimensions'); APIDataUpgradeEntities.Add('Dimension Values', 'dimensionValues'); APIDataUpgradeEntities.Add('Accounts', 'accounts'); APIDataUpgradeEntities.Add('Purchase Receipts', 'purchaseReceipts'); APIDataUpgradeEntities.Add('Purchase Credit Memos', 'purchaseCreditMemos'); APIDataUpgradeEntities.Add('Fixed Assets', 'fixedAssets'); OnGetAPIDataUpgradeEntities(APIDataUpgradeEntities) end; procedure CountRecordsAndCommit(var RecordCount: Integer) begin RecordCount += 1; if RecordCount = 500 then begin Commit(); RecordCount := 0; end; end; internal procedure GetDisableAPIDataUpgradesTag(): Code[250] begin exit('MS-469217-DisableAPIDataUpgrade-20230411'); end; [IntegrationEvent(false, false)] local procedure OnGetAPIUpgradeTags(var APIUpgradeTags: Dictionary of [Code[250], Text[250]]) begin end; [IntegrationEvent(false, false)] local procedure OnGetAPIDataUpgradeEntities(var APIDataUpgradeEntities: Dictionary of [Code[250], Text[250]]) begin end; [IntegrationEvent(false, false)] local procedure OnAPIDataUpgrade(APIUpgradeTag: Code[250]) begin end;}