Codeunit 30106 Shpfy Upgrade Mgt.
src/Apps/W1/Shopify/App/src/Base/Codeunits/ShpfyUpgradeMgt.Codeunit.al700 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.Integration.Shopify;using Microsoft.Finance.Dimension;using Microsoft.Inventory.Item;using Microsoft.Sales.Customer;using System.Integration;using System.IO;using System.Reflection;using System.Upgrade;/// <summary>/// Codeunit Shpfy Upgrade Mgt. (ID 30106)./// </summary>codeunit 30106 "Shpfy Upgrade Mgt."{ Access = Internal; Subtype = Upgrade; Permissions = tabledata "Shpfy Shop" = RM, tabledata "Shpfy Tax Area" = rimd, tabledata "Webhook Subscription" = rimd; trigger OnUpgradePerDatabase() begin WebhookSubscriptionUpgrade(); end; trigger OnUpgradePerCompany() begin SetAllowOutgoingRequests(); PriceCalculationUpgrade(); LoggingModeUpgrade(); LocationUpgrade(); SyncPricesWithProductsUpgrade(); SendShippingConfirmationUpgrade(); OrderAttributeValueUpgrade(); CreditMemoCanBeCreatedUpgrade(); ArchiveProcessedOrdersUpgrade(); SetShopifyCatalogsType(); CreateInvoicesFromOrdersUpgrade(); OrderTransactionShopCodeUpgrade(); HasAdvancedShopifyPlanUpgrade(); ItalianSardinianProvinceRenameUpgrade(); ProcessReturnsAsUpgrade(); end; internal procedure UpgradeTemplatesData() var Shop: Record "Shpfy Shop"; ShpfyCustomerTemplate: Record "Shpfy Customer Template"; CustomerTemplCreated: Dictionary of [Code[10], Code[20]]; Modified: Boolean; begin if Shop.FindSet() then repeat Modified := false; if Shop."Customer Template Code" <> '' then if not CustomerTemplCreated.ContainsKey(Shop."Customer Template Code") then begin Shop."Customer Templ. Code" := CreateCustomerTemplate(Shop."Customer Template Code"); CustomerTemplCreated.Add(Shop."Customer Template Code", Shop."Customer Templ. Code"); Modified := true; end; if Shop."Item Template Code" <> '' then begin Shop."Item Templ. Code" := CreateItemTemplate(Shop."Item Template Code"); Modified := true; end; if Modified then Shop.Modify(); until Shop.Next() = 0; ShpfyCustomerTemplate.SetFilter("Customer Template Code", '<> %1', ''); if ShpfyCustomerTemplate.FindSet() then repeat if not CustomerTemplCreated.ContainsKey(ShpfyCustomerTemplate."Customer Template Code") then begin ShpfyCustomerTemplate."Customer Templ. Code" := CreateCustomerTemplate(ShpfyCustomerTemplate."Customer Template Code"); CustomerTemplCreated.Add(ShpfyCustomerTemplate."Customer Template Code", ShpfyCustomerTemplate."Customer Templ. Code"); end else ShpfyCustomerTemplate."Customer Templ. Code" := CustomerTemplCreated.Get(ShpfyCustomerTemplate."Customer Template Code"); ShpfyCustomerTemplate.Modify(); until ShpfyCustomerTemplate.Next() = 0; end; local procedure CopyConfigTemplateLinesToRecordRef(var ConfigTemplateLine: Record "Config. Template Line"; var RecordRef: RecordRef) var Field: Record Field; TypeHelper: Codeunit "Type Helper"; FieldRef: FieldRef; DateFormulaDefaultValue: DateFormula; BoolDefaultValue: Boolean; DateDefaultValue: Date; DateTimeDefaultValue: DateTime; TimeDefaultValue: Time; begin if not ConfigTemplateLine.FindSet() then exit; repeat if (ConfigTemplateLine."Field ID" > 2) and RecordRef.FieldExist(ConfigTemplateLine."Field ID") then begin FieldRef := RecordRef.Field(ConfigTemplateLine."Field ID"); Field.Get(ConfigTemplateLine."Table ID", ConfigTemplateLine."Field ID"); case Field.Type of Field.Type::Option: FieldRef.Value := TypeHelper.GetOptionNo(ConfigTemplateLine."Default Value", FieldRef.OptionMembers); Field.Type::Boolean: if Evaluate(BoolDefaultValue, ConfigTemplateLine."Default Value") then FieldRef.Value := BoolDefaultValue; Field.Type::Date: if Evaluate(DateDefaultValue, ConfigTemplateLine."Default Value") then FieldRef.Value := DateDefaultValue; Field.Type::DateTime: if Evaluate(DateTimeDefaultValue, ConfigTemplateLine."Default Value") then FieldRef.Value := DateTimeDefaultValue; Field.Type::DateFormula: if Evaluate(DateFormulaDefaultValue, ConfigTemplateLine."Default Value") then FieldRef.Value := DateFormulaDefaultValue; Field.Type::Time: if Evaluate(TimeDefaultValue, ConfigTemplateLine."Default Value") then FieldRef.Value := TimeDefaultValue; else FieldRef.Value := ConfigTemplateLine."Default Value"; end; end; until ConfigTemplateLine.Next() = 0; RecordRef.Modify(); end; local procedure CreateCustomerTemplate(TemplateCode: Code[10]): Code[20] var CustomerTempl: Record "Customer Templ."; ConfigTemplateHeader: Record "Config. Template Header"; ConfigTemplateLine: Record "Config. Template Line"; CustomerTemplRecordRef: RecordRef; begin CustomerTempl.SetRange(Code, TemplateCode); if not CustomerTempl.IsEmpty() then exit(TemplateCode); ConfigTemplateHeader.Get(TemplateCode); CustomerTempl.Reset(); CustomerTempl.Code := TemplateCode; CustomerTempl.Description := ConfigTemplateHeader.Description; CustomerTempl.Insert(); CustomerTemplRecordRef.GetTable(CustomerTempl); ConfigTemplateLine.SetRange("Data Template Code", TemplateCode); ConfigTemplateLine.SetRange("Table ID", Database::Customer); ConfigTemplateLine.SetRange(Type, ConfigTemplateLine.Type::Field); CopyConfigTemplateLinesToRecordRef(ConfigTemplateLine, CustomerTemplRecordRef); TransferDimensionsFromTemplate(TemplateCode, Database::Customer, Database::"Customer Templ."); exit(TemplateCode); end; local procedure TransferDimensionsFromTemplate(TemplateCode: Code[10]; TableNo: Integer; TemplTableNo: Integer) var ConfigTemplateHeader: Record "Config. Template Header"; ConfigTemplateLine: Record "Config. Template Line"; DefaultDimension: Record "Default Dimension"; ConfigTemplateManagement: Codeunit "Config. Template Management"; RecordRef: RecordRef; DimensionCode: Code[20]; begin ConfigTemplateLine.SetRange("Data Template Code", TemplateCode); ConfigTemplateLine.SetRange("Table ID", TableNo); ConfigTemplateLine.SetRange(Type, ConfigTemplateLine.Type::"Related Template"); if not ConfigTemplateLine.FindSet() then exit; repeat if ConfigTemplateHeader.Get(ConfigTemplateLine."Template Code") then if ConfigTemplateHeader."Table ID" = Database::"Default Dimension" then begin DimensionCode := GetDimensionCodeFromTemplate(ConfigTemplateHeader.Code); if DimensionCode <> '' then begin DefaultDimension.Reset(); DefaultDimension."Table ID" := TemplTableNo; DefaultDimension."No." := TemplateCode; DefaultDimension."Dimension Code" := DimensionCode; DefaultDimension.Insert(); RecordRef.GetTable(DefaultDimension); ConfigTemplateManagement.UpdateRecord(ConfigTemplateHeader, RecordRef); RecordRef.SetTable(DefaultDimension); DefaultDimension.Modify(); end; end; until ConfigTemplateLine.Next() = 0; end; local procedure GetDimensionCodeFromTemplate(TemplateCode: Code[10]): Code[20] var DefaultDimension: Record "Default Dimension"; ConfigTemplateLine: Record "Config. Template Line"; begin ConfigTemplateLine.SetRange("Data Template Code", TemplateCode); ConfigTemplateLine.SetRange(Type, ConfigTemplateLine.Type::Field); ConfigTemplateLine.SetRange("Field ID", DefaultDimension.FieldNo("Dimension Code")); if not ConfigTemplateLine.FindFirst() then exit(''); exit(CopyStr(ConfigTemplateLine."Default Value", 1, 20)); end; local procedure CreateItemTemplate(TemplateCode: Code[10]): Code[20] var ItemTempl: Record "Item Templ."; ConfigTemplateHeader: Record "Config. Template Header"; ConfigTemplateLine: Record "Config. Template Line"; ItemTemplRecordRef: RecordRef; begin ItemTempl.SetRange(Code, TemplateCode); if not ItemTempl.IsEmpty() then exit(TemplateCode); ConfigTemplateHeader.Get(TemplateCode); ItemTempl.Reset(); ItemTempl.Code := TemplateCode; ItemTempl.Description := ConfigTemplateHeader.Description; ItemTempl.Insert(); ItemTemplRecordRef.GetTable(ItemTempl); ConfigTemplateLine.SetRange("Data Template Code", TemplateCode); ConfigTemplateLine.SetRange("Table ID", Database::Item); ConfigTemplateLine.SetRange(Type, ConfigTemplateLine.Type::Field); CopyConfigTemplateLinesToRecordRef(ConfigTemplateLine, ItemTemplRecordRef); TransferDimensionsFromTemplate(TemplateCode, Database::Item, Database::"Item Templ."); exit(TemplateCode); end; local procedure SetAllowOutgoingRequests() var Shop: Record "Shpfy Shop"; UpgradeTag: Codeunit "Upgrade Tag"; begin if UpgradeTag.HasUpgradeTag(GetAllowOutgoingRequestseUpgradeTag()) then exit; Shop.SetFilter(SystemCreatedAt, '<%1', GetDateBeforeFeature()); if Shop.FindSet() then repeat if not Shop."Allow Outgoing Requests" then begin Shop."Allow Outgoing Requests" := true; Shop.Modify(); end; until Shop.Next() = 0; UpgradeTag.SetUpgradeTag(GetAllowOutgoingRequestseUpgradeTag()); end; local procedure PriceCalculationUpgrade() var Shop: Record "Shpfy Shop"; UpgradeTag: Codeunit "Upgrade Tag"; begin if UpgradeTag.HasUpgradeTag(GetPriceCalculationUpgradeTag()) then exit; Shop.SetFilter("Customer Template Code", '<>%1', ''); Shop.SetRange("Customer Posting Group", ''); if Shop.FindSet(true) then repeat CopyPriceCalculationFieldsFromCustomerTempl(Shop, Shop."Customer Templ. Code"); until Shop.Next() = 0; UpgradeTag.SetUpgradeTag(GetPriceCalculationUpgradeTag()); end; local procedure CopyPriceCalculationFieldsFromCustomerTempl(var Shop: Record "Shpfy Shop"; TemplateCode: Code[20]) var CustomerTempl: Record "Customer Templ."; begin if TemplateCode = '' then exit; if not CustomerTempl.Get(TemplateCode) then exit; Shop."Gen. Bus. Posting Group" := CustomerTempl."Gen. Bus. Posting Group"; Shop."VAT Bus. Posting Group" := CustomerTempl."VAT Bus. Posting Group"; Shop."Tax Area Code" := CustomerTempl."Tax Area Code"; Shop."Tax Liable" := CustomerTempl."Tax Liable"; Shop."VAT Country/Region Code" := CustomerTempl."Country/Region Code"; Shop."Customer Posting Group" := CustomerTempl."Customer Posting Group"; Shop."Prices Including VAT" := CustomerTempl."Prices Including VAT"; Shop."Allow Line Disc." := CustomerTempl."Allow Line Disc."; Shop.Modify(); end; local procedure LoggingModeUpgrade() var Shop: Record "Shpfy Shop"; UpgradeTag: Codeunit "Upgrade Tag"; ShopDataTransfer: DataTransfer; begin if UpgradeTag.HasUpgradeTag(GetLoggingModeUpgradeTag()) then exit; ShopDataTransfer.SetTables(Database::"Shpfy Shop", Database::"Shpfy Shop"); ShopDataTransfer.AddSourceFilter(Shop.FieldNo("Log Enabled"), '=%1', true); ShopDataTransfer.AddConstantValue("Shpfy Logging Mode"::All, Shop.FieldNo("Logging Mode")); ShopDataTransfer.UpdateAuditFields := false; ShopDataTransfer.CopyFields(); UpgradeTag.SetUpgradeTag(GetLoggingModeUpgradeTag()); end; local procedure LocationUpgrade() var ShopLocation: Record "Shpfy Shop Location"; UpgradeTag: Codeunit "Upgrade Tag"; begin if UpgradeTag.HasUpgradeTag(GetLocationUpgradeTag()) then exit; if ShopLocation.FindSet(true) then repeat ShopLocation."Default Product Location" := true; ShopLocation.Modify(); until ShopLocation.Next() = 0; UpgradeTag.SetUpgradeTag(GetLocationUpgradeTag()); end; local procedure SyncPricesWithProductsUpgrade() var Shop: Record "Shpfy Shop"; UpgradeTag: Codeunit "Upgrade Tag"; begin if UpgradeTag.HasUpgradeTag(GetSyncPricesWithProductsUpgradeTag()) then exit; if Shop.FindSet(true) then repeat Shop."Sync Prices" := true; Shop.Modify(); until Shop.Next() = 0; UpgradeTag.SetUpgradeTag(GetSyncPricesWithProductsUpgradeTag()); end; internal procedure SetAutoReleaseSalesOrder() var ShpfyShop: Record "Shpfy Shop"; UpgradeTag: Codeunit "Upgrade Tag"; begin if UpgradeTag.HasUpgradeTag(GetAutoReleaseSalesOrderTag()) then exit; ShpfyShop.ModifyAll("Auto Release Sales Orders", true); UpgradeTag.SetUpgradeTag(GetAutoReleaseSalesOrderTag()); end; local procedure SendShippingConfirmationUpgrade() var Shop: Record "Shpfy Shop"; UpgradeTag: Codeunit "Upgrade Tag"; begin if UpgradeTag.HasUpgradeTag(GetSendShippingConfirmationUpgradeTag()) then exit; if Shop.FindSet(true) then repeat Shop."Send Shipping Confirmation" := true; Shop.Modify(); until Shop.Next() = 0; UpgradeTag.SetUpgradeTag(GetSendShippingConfirmationUpgradeTag()); end; local procedure OrderAttributeValueUpgrade() var OrderAttribute: Record "Shpfy Order Attribute"; UpgradeTag: Codeunit "Upgrade Tag"; OrderAttributeDataTransfer: DataTransfer; begin if UpgradeTag.HasUpgradeTag(GetOrderAttributeValueUpgradeTag()) then exit; if not OrderAttribute.IsEmpty() then begin OrderAttributeDataTransfer.SetTables(Database::"Shpfy Order Attribute", Database::"Shpfy Order Attribute"); OrderAttributeDataTransfer.AddFieldValue(OrderAttribute.FieldNo(Value), OrderAttribute.FieldNo("Attribute Value")); OrderAttributeDataTransfer.UpdateAuditFields := false; OrderAttributeDataTransfer.CopyFields(); end; UpgradeTag.SetUpgradeTag(GetOrderAttributeValueUpgradeTag()); end; local procedure CreditMemoCanBeCreatedUpgrade() var RefundHeader: Record "Shpfy Refund Header"; UpgradeTag: Codeunit "Upgrade Tag"; HeadersInFilter, MaxHeadersInFilter : Integer; RefundIdFilter: Text; begin if UpgradeTag.HasUpgradeTag(GetCreditMemoCanBeCreatedUpgradeTag()) then exit; MaxHeadersInFilter := 100; RefundHeader.SetFilter("Total Refunded Amount", '>%1', 0); if RefundHeader.FindSet() then repeat if RefundIdFilter <> '' then RefundIdFilter += '|'; RefundIdFilter += Format(RefundHeader."Refund Id"); HeadersInFilter += 1; if HeadersInFilter >= MaxHeadersInFilter then begin SetCanCreateCreditMemoInRefundLines(RefundIdFilter); RefundIdFilter := ''; HeadersInFilter := 0; end; until RefundHeader.Next() = 0; if RefundIdFilter <> '' then SetCanCreateCreditMemoInRefundLines(RefundIdFilter); UpgradeTag.SetUpgradeTag(GetCreditMemoCanBeCreatedUpgradeTag()); end; local procedure SetCanCreateCreditMemoInRefundLines(RefundIdFilter: Text) var RefundLine: Record "Shpfy Refund Line"; RefundLineDataTransfer: DataTransfer; begin RefundLineDataTransfer.SetTables(Database::"Shpfy Refund Line", Database::"Shpfy Refund Line"); RefundLineDataTransfer.AddSourceFilter(RefundLine.FieldNo("Refund Id"), RefundIdFilter); RefundLineDataTransfer.AddConstantValue(true, RefundLine.FieldNo("Can Create Credit Memo")); RefundLineDataTransfer.UpdateAuditFields(false); RefundLineDataTransfer.CopyFields(); end; local procedure WebhookSubscriptionUpgrade() var WebhookSubscription: Record "Webhook Subscription"; UpgradeTag: Codeunit "Upgrade Tag"; WebhookTopic: Enum "Shpfy Webhook Topic"; begin if UpgradeTag.HasUpgradeTag(GetWebhookSubscriptionUpgradeTag()) then exit; WebhookTopic := WebhookTopic::BULK_OPERATIONS_FINISH; WebhookSubscription.SetRange(Endpoint, WebhookTopic.Names.Get(WebhookTopic.Ordinals.IndexOf(WebhookTopic.AsInteger()))); if WebhookSubscription.FindSet() then repeat UpdateWebhookSubscriptionTopic(WebhookSubscription, WebhookTopic); until WebhookSubscription.Next() = 0; WebhookTopic := WebhookTopic::ORDERS_CREATE; WebhookSubscription.SetRange(Endpoint, WebhookTopic.Names.Get(WebhookTopic.Ordinals.IndexOf(WebhookTopic.AsInteger()))); if WebhookSubscription.FindSet() then repeat UpdateWebhookSubscriptionTopic(WebhookSubscription, WebhookTopic); until WebhookSubscription.Next() = 0; UpgradeTag.SetUpgradeTag(GetWebhookSubscriptionUpgradeTag()); end; local procedure UpdateWebhookSubscriptionTopic(var WebhookSubscription: Record "Webhook Subscription"; WebhookTopic: Enum "Shpfy Webhook Topic") var NewWebhookSubscription: Record "Webhook Subscription"; begin if NewWebhookSubscription.Get(WebhookSubscription."Subscription ID", Format(WebhookTopic)) then NewWebhookSubscription.Delete(); NewWebhookSubscription := WebhookSubscription; NewWebhookSubscription."Endpoint" := Format(WebhookTopic); NewWebhookSubscription.Insert(); WebhookSubscription.Delete(); end; local procedure ArchiveProcessedOrdersUpgrade() var Shop: Record "Shpfy Shop"; UpgradeTag: Codeunit "Upgrade Tag"; begin if UpgradeTag.HasUpgradeTag(GetArchiveProcessedOrdersUpgradeTag()) then exit; if not Shop.IsEmpty() then Shop.ModifyAll("Archive Processed Orders", true); UpgradeTag.SetUpgradeTag(GetArchiveProcessedOrdersUpgradeTag()); end; local procedure SetShopifyCatalogsType() var Catalog: Record "Shpfy Catalog"; UpgradeTag: Codeunit "Upgrade Tag"; begin if UpgradeTag.HasUpgradeTag(GetShopifyCatalogsTypeUpgradeTag()) then exit; Catalog.SetRange("Catalog Type", Catalog."Catalog Type"::" "); Catalog.ModifyAll("Catalog Type", Catalog."Catalog Type"::"Company", false); UpgradeTag.SetUpgradeTag(GetShopifyCatalogsTypeUpgradeTag()); end; local procedure CreateInvoicesFromOrdersUpgrade() var Shop: Record "Shpfy Shop"; UpgradeTag: Codeunit "Upgrade Tag"; begin if UpgradeTag.HasUpgradeTag(GetCreateInvoicesFromOrdersUpgradeTag()) then exit; if not Shop.IsEmpty() then Shop.ModifyAll("Create Invoices From Orders", true); UpgradeTag.SetUpgradeTag(GetCreateInvoicesFromOrdersUpgradeTag()); end; local procedure OrderTransactionShopCodeUpgrade() var OrderTransaction: Record "Shpfy Order Transaction"; OrderHeader: Record "Shpfy Order Header"; UpgradeTag: Codeunit "Upgrade Tag"; OrderTransactionDataTransfer: DataTransfer; begin if UpgradeTag.HasUpgradeTag(GetOrderTransactionShopCodeUpgradeTag()) then exit; OrderTransactionDataTransfer.SetTables(Database::"Shpfy Order Header", Database::"Shpfy Order Transaction"); OrderTransactionDataTransfer.AddFieldValue(OrderHeader.FieldNo("Shop Code"), OrderTransaction.FieldNo("Shop")); OrderTransactionDataTransfer.AddJoin(OrderHeader.FieldNo("Shopify Order Id"), OrderTransaction.FieldNo("Shopify Order Id")); OrderTransactionDataTransfer.UpdateAuditFields := false; OrderTransactionDataTransfer.CopyFields(); UpgradeTag.SetUpgradeTag(GetOrderTransactionShopCodeUpgradeTag()); end; local procedure HasAdvancedShopifyPlanUpgrade() var Shop: Record "Shpfy Shop"; UpgradeTag: Codeunit "Upgrade Tag"; ShopDataTransfer: DataTransfer; begin if UpgradeTag.HasUpgradeTag(GetHasAdvancedShopifyPlanUpgradeTag()) then exit; ShopDataTransfer.SetTables(Database::"Shpfy Shop", Database::"Shpfy Shop"); ShopDataTransfer.AddSourceFilter(Shop.FieldNo("B2B Enabled"), '=%1', true); ShopDataTransfer.AddConstantValue(true, Shop.FieldNo("Advanced Shopify Plan")); ShopDataTransfer.UpdateAuditFields := false; ShopDataTransfer.CopyFields(); UpgradeTag.SetUpgradeTag(GetHasAdvancedShopifyPlanUpgradeTag()); end; internal procedure ProcessReturnsAsUpgrade() var Shop: Record "Shpfy Shop"; UpgradeTag: Codeunit "Upgrade Tag"; begin if UpgradeTag.HasUpgradeTag(GetProcessReturnsAsUpgradeTag()) then exit; Shop.SetRange("Process Returns As", Shop."Process Returns As"::Quote); Shop.ModifyAll("Process Returns As", Shop."Process Returns As"::"Credit Memo"); UpgradeTag.SetUpgradeTag(GetProcessReturnsAsUpgradeTag()); end; internal procedure GetAllowOutgoingRequestseUpgradeTag(): Code[250] begin exit('MS-445989-AllowOutgoingRequestseUpgradeTag-20220816'); end; internal procedure GetNewAvailabilityCalculationTag(): Code[250] begin exit('MS-454264-NewAvailabilityCalculationTag-20221121'); end; internal procedure GetAutoReleaseSalesOrderTag(): code[250] begin exit('MS-459849-AutoReleaseSalesOrderTag-20230106') end; internal procedure GetPriceCalculationUpgradeTag(): Code[250] begin exit('MS-460298-PriceCalculationUpgradeTag-20221201'); end; local procedure GetLoggingModeUpgradeTag(): Code[250] begin exit('MS-447972-LoggingMode-20230425'); end; internal procedure GetLocationUpgradeTag(): Code[250] begin exit('MS-472953-LocationUpgradeTag-20230525'); end; internal procedure GetSyncPricesWithProductsUpgradeTag(): Code[250] begin exit('MS-480542-SyncPricesWithProductsUpgradeTag-20230814'); end; local procedure GetSendShippingConfirmationUpgradeTag(): Code[250] begin exit('MS-495193-SendShippingConfirmationUpgradeTag-20231221'); end; local procedure GetOrderAttributeValueUpgradeTag(): Code[250] begin exit('MS-497909-OrderAttributeValueUpgradeTag-20240125'); end; local procedure GetCreditMemoCanBeCreatedUpgradeTag(): Code[250] begin exit('MS-471880-CreditMemoCanBeCreatedUpgradeTag-20240201'); end; local procedure GetWebhookSubscriptionUpgradeTag(): Code[250] begin exit('MS-574620-WebHookSubscriptionUpgradeTag-20250419'); end; local procedure GetArchiveProcessedOrdersUpgradeTag(): Code[250] begin exit('MS-593841-ArchiveProcessedOrdersUpgradeTag-20250731'); end; local procedure GetShopifyCatalogsTypeUpgradeTag(): Code[250] begin exit('MS-581129-ShopifyCatalogsTypeUpgradeTag-20250807'); end; local procedure GetCreateInvoicesFromOrdersUpgradeTag(): Code[250] begin exit('MS-604148-CreateInvoicesFromOrdersUpgradeTag-20250922'); end; local procedure GetOrderTransactionShopCodeUpgradeTag(): Code[250] begin exit('MS-610671-OrderTransactionShopCodeUpgrade-20251022'); end; local procedure GetHasAdvancedShopifyPlanUpgradeTag(): Code[250] begin exit('MS-630316-HasAdvancedShopifyPlanUpgrade-20260408'); end; local procedure ItalianSardinianProvinceRenameUpgrade() var UpgradeTag: Codeunit "Upgrade Tag"; begin if UpgradeTag.HasUpgradeTag(GetItalianSardinianProvinceRenameUpgradeTag()) then exit; RenameItalianProvince('IT', 'Olbia-Tempio', 'Gallura Nord-Est Sardegna'); RenameItalianProvince('IT', 'Carbonia-Iglesias', 'Sulcis Iglesiente'); UpgradeTag.SetUpgradeTag(GetItalianSardinianProvinceRenameUpgradeTag()); end; local procedure RenameItalianProvince(CountryRegionCode: Code[20]; OldName: Text[50]; NewName: Text[50]) var OldShpfyTaxArea: Record "Shpfy Tax Area"; NewShpfyTaxArea: Record "Shpfy Tax Area"; begin if not OldShpfyTaxArea.Get(CountryRegionCode, OldName) then exit; // If the new name already exists (e.g. a tenant manually pre-seeded it before this // upgrade ran), leave both rows in place: the new row carries the user's intended // configuration, and the old row is harmless because Shopify no longer sends the // pre-2026-05-14 name -- no lookup will match it. Admins can clean up the stale row // from the Shopify Tax Areas page if desired. Auto-deleting would risk discarding // user-configured Tax Area Code / VAT Bus. Posting Group values on the old row. if NewShpfyTaxArea.Get(CountryRegionCode, NewName) then exit; OldShpfyTaxArea.Rename(CountryRegionCode, NewName); end; local procedure GetItalianSardinianProvinceRenameUpgradeTag(): Code[250] begin exit('MS-638035-ItalianSardinianProvinceRenameUpgrade-20260609'); end; internal procedure GetProcessReturnsAsUpgradeTag(): Code[250] begin exit('MS-658645-ProcessReturnsAsUpgrade-20261110'); end; local procedure GetDateBeforeFeature(): DateTime begin exit(CreateDateTime(DMY2Date(1, 8, 2022), 0T)); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Upgrade Tag", 'OnGetPerCompanyUpgradeTags', '', false, false)] local procedure RegisterPerCompanyTags(var PerCompanyUpgradeTags: List of [Code[250]]) begin PerCompanyUpgradeTags.Add(GetAllowOutgoingRequestseUpgradeTag()); PerCompanyUpgradeTags.Add(GetPriceCalculationUpgradeTag()); PerCompanyUpgradeTags.Add(GetNewAvailabilityCalculationTag()); PerCompanyUpgradeTags.Add(GetAutoReleaseSalesOrderTag()); PerCompanyUpgradeTags.Add(GetLoggingModeUpgradeTag()); PerCompanyUpgradeTags.Add(GetLocationUpgradeTag()); PerCompanyUpgradeTags.Add(GetSyncPricesWithProductsUpgradeTag()); PerCompanyUpgradeTags.Add(GetArchiveProcessedOrdersUpgradeTag()); PerCompanyUpgradeTags.Add(GetShopifyCatalogsTypeUpgradeTag()); PerCompanyUpgradeTags.Add(GetCreateInvoicesFromOrdersUpgradeTag()); PerCompanyUpgradeTags.Add(GetOrderTransactionShopCodeUpgradeTag()); PerCompanyUpgradeTags.Add(GetHasAdvancedShopifyPlanUpgradeTag()); PerCompanyUpgradeTags.Add(GetItalianSardinianProvinceRenameUpgradeTag()); PerCompanyUpgradeTags.Add(GetProcessReturnsAsUpgradeTag()); end;}