Codeunit 104051 Update VAT Date Field
src/Layers/W1/BaseApp/OtherCapabilities/Upgrade/UpdateVATDateField.Codeunit.al349 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.Upgrade;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.VAT.Ledger;using Microsoft.Purchases.History;using Microsoft.Sales.FinanceCharge;using Microsoft.Sales.History;using Microsoft.Sales.Reminder;using System.Upgrade;codeunit 104051 "Update VAT Date Field"{ Subtype = Upgrade; trigger OnRun() begin end; trigger OnUpgradePerCompany() begin UpdateVATEntries(); UpdateGLEntries(); UpdatePurchSalesEntries(); UpdateIssuedDocsEntries(); if not UpgradeTag.HasUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldVATEntriesBlankUpgrade()) then begin UpdateBlankVATEntries(); UpgradeTag.SetUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldVATEntriesBlankUpgrade()); end; if not UpgradeTag.HasUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldGLEntriesBlankUpgrade()) then begin UpdateBlankGLEntries(); UpgradeTag.SetUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldGLEntriesBlankUpgrade()); end; if not UpgradeTag.HasUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldSalesPurchBlankUpgrade()) then begin UpdatePurchSalesBlankEntries(); UpgradeTag.SetUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldSalesPurchBlankUpgrade()); end; if not UpgradeTag.HasUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldIssuedDocsBlankUpgrade()) then begin UpdateIssuedDocsBlankEntries(); UpgradeTag.SetUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldIssuedDocsBlankUpgrade()); end; end; var UpgradeTag: Codeunit "Upgrade Tag"; UpgradeTagDefinitions: Codeunit "Upgrade Tag Definitions"; BlankDate: Date; local procedure UpdateBlankVATEntries() var VATEntry: Record "VAT Entry"; GLSetup: Record "General Ledger Setup"; VATDateDataTransfer: DataTransfer; begin if not GLSetup.Get() then exit; VATEntry.SetRange("VAT Reporting Date", 0D); if VATEntry.IsEmpty() then exit; // Only update entries that has blank VAT Reporting Date VATDateDataTransfer.SetTables(Database::"VAT Entry", Database::"VAT Entry"); VATDateDataTransfer.AddSourceFilter(VATEntry.FieldNo("VAT Reporting Date"), '=%1', 0D); if GLSetup."VAT Reporting Date" = GLSetup."VAT Reporting Date"::"Posting Date" then VATDateDataTransfer.AddFieldValue(VATEntry.FieldNo("Posting Date"), VATEntry.FieldNo("VAT Reporting Date")) else VATDateDataTransfer.AddFieldValue(VATEntry.FieldNo("Document Date"), VATEntry.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields := false; VATDateDataTransfer.CopyFields(); end; local procedure UpdateBlankGLEntries() var GLEntry: Record "G/L Entry"; GLSetup: Record "General Ledger Setup"; VATDateDataTransfer: DataTransfer; begin if not GLSetup.Get() then exit; GLEntry.SetRange("VAT Reporting Date", 0D); if GLEntry.IsEmpty() then exit; // Only update entries that has blank VAT Reporting Date VATDateDataTransfer.SetTables(Database::"G/L Entry", Database::"G/L Entry"); VATDateDataTransfer.AddSourceFilter(GLEntry.FieldNo("VAT Reporting Date"), '=%1', 0D); if GLSetup."VAT Reporting Date" = GLSetup."VAT Reporting Date"::"Posting Date" then VATDateDataTransfer.AddFieldValue(GLEntry.FieldNo("Posting Date"), GLEntry.FieldNo("VAT Reporting Date")) else VATDateDataTransfer.AddFieldValue(GLEntry.FieldNo("Document Date"), GLEntry.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields := false; VATDateDataTransfer.CopyFields(); end; local procedure UpdateVATEntries() var VATEntry: Record "VAT Entry"; VATDateDataTransfer: DataTransfer; begin if UpgradeTag.HasUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldVATEntriesUpgrade()) then exit; VATEntry.SetFilter("VAT Reporting Date", '<>%1', BlankDate); if not VATEntry.IsEmpty then exit; VATDateDataTransfer.SetTables(Database::"VAT Entry", Database::"VAT Entry"); VATDateDataTransfer.AddFieldValue(VATEntry.FieldNo("Posting Date"), VATEntry.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields(false); VATDateDataTransfer.CopyFields(); Clear(VATDateDataTransfer); UpgradeTag.SetUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldVATEntriesUpgrade()); end; local procedure UpdateGLEntries() var GLEntry: Record "G/L Entry"; TotalRows: Integer; FromNo, ToNo : Integer; begin if UpgradeTag.HasUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldGLEntriesUpgrade()) then exit; GLEntry.SetFilter("VAT Reporting Date", '<>%1', BlankDate); if not GLEntry.IsEmpty() then exit; GLEntry.Reset(); TotalRows := GLEntry.Count(); ToNo := 0; while ToNo < TotalRows do begin // Batch size 5 million FromNo := ToNo + 1; ToNo := FromNo + 5000000; if ToNo > TotalRows then ToNo := TotalRows; DataTransferGLEntries(FromNo, ToNo); end; UpgradeTag.SetUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldGLEntriesUpgrade()); end; local procedure DataTransferGLEntries(FromEntryNo: Integer; ToEntryNo: Integer) var GLEntry: Record "G/L Entry"; VATDateDataTransfer: DataTransfer; begin VATDateDataTransfer.SetTables(Database::"G/L Entry", Database::"G/L Entry"); VATDateDataTransfer.AddSourceFilter(GLEntry.FieldNo("Entry No."), '%1..%2', FromEntryNo, ToEntryNo); VATDateDataTransfer.AddFieldValue(GLEntry.FieldNo("Posting Date"), GLEntry.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields(false); VATDateDataTransfer.CopyFields(); Clear(VATDateDataTransfer); end; local procedure UpdatePurchSalesEntries() var SalesInvHeader: Record "Sales Invoice Header"; SalesCrMemoHeader: Record "Sales Cr.Memo Header"; PurchInvHeader: Record "Purch. Inv. Header"; PurchCrMemoHeader: Record "Purch. Cr. Memo Hdr."; VATDateDataTransfer: DataTransfer; begin if UpgradeTag.HasUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldSalesPurchUpgrade()) then exit; SalesInvHeader.SetFilter("VAT Reporting Date", '<>%1', BlankDate); if not SalesInvHeader.IsEmpty then exit; SalesCrMemoHeader.SetFilter("VAT Reporting Date", '<>%1', BlankDate); if not SalesCrMemoHeader.IsEmpty then exit; PurchInvHeader.SetFilter("VAT Reporting Date", '<>%1', BlankDate); if not PurchInvHeader.IsEmpty then exit; PurchCrMemoHeader.SetFilter("VAT Reporting Date", '<>%1', BlankDate); if not PurchCrMemoHeader.IsEmpty then exit; VATDateDataTransfer.SetTables(Database::"Sales Invoice Header", Database::"Sales Invoice Header"); VATDateDataTransfer.AddFieldValue(SalesInvHeader.FieldNo("Posting Date"), SalesInvHeader.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields(false); VATDateDataTransfer.CopyFields(); Clear(VATDateDataTransfer); VATDateDataTransfer.SetTables(Database::"Sales Cr.Memo Header", Database::"Sales Cr.Memo Header"); VATDateDataTransfer.AddFieldValue(SalesCrMemoHeader.FieldNo("Posting Date"), SalesCrMemoHeader.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields(false); VATDateDataTransfer.CopyFields(); Clear(VATDateDataTransfer); VATDateDataTransfer.SetTables(Database::"Purch. Inv. Header", Database::"Purch. Inv. Header"); VATDateDataTransfer.AddFieldValue(PurchInvHeader.FieldNo("Posting Date"), PurchInvHeader.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields(false); VATDateDataTransfer.CopyFields(); Clear(VATDateDataTransfer); VATDateDataTransfer.SetTables(Database::"Purch. Cr. Memo Hdr.", Database::"Purch. Cr. Memo Hdr."); VATDateDataTransfer.AddFieldValue(PurchCrMemoHeader.FieldNo("Posting Date"), PurchCrMemoHeader.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields(false); VATDateDataTransfer.CopyFields(); Clear(VATDateDataTransfer); UpgradeTag.SetUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldSalesPurchUpgrade()); end; local procedure UpdatePurchSalesBlankEntries() var GLSetup: Record "General Ledger Setup"; SalesInvHeader: Record "Sales Invoice Header"; SalesCrMemoHeader: Record "Sales Cr.Memo Header"; PurchInvHeader: Record "Purch. Inv. Header"; PurchCrMemoHeader: Record "Purch. Cr. Memo Hdr."; VATDateDataTransfer: DataTransfer; begin if not GLSetup.Get() then exit; // Only update entries that has blank VAT Reporting Date VATDateDataTransfer.SetTables(Database::"Sales Invoice Header", Database::"Sales Invoice Header"); VATDateDataTransfer.AddSourceFilter(SalesInvHeader.FieldNo("VAT Reporting Date"), '=%1', 0D); if GLSetup."VAT Reporting Date" = GLSetup."VAT Reporting Date"::"Posting Date" then VATDateDataTransfer.AddFieldValue(SalesInvHeader.FieldNo("Posting Date"), SalesInvHeader.FieldNo("VAT Reporting Date")) else VATDateDataTransfer.AddFieldValue(SalesInvHeader.FieldNo("Document Date"), SalesInvHeader.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields := false; VATDateDataTransfer.CopyFields(); Clear(VATDateDataTransfer); // Only update entries that has blank VAT Reporting Date VATDateDataTransfer.SetTables(Database::"Sales Cr.Memo Header", Database::"Sales Cr.Memo Header"); VATDateDataTransfer.AddSourceFilter(SalesCrMemoHeader.FieldNo("VAT Reporting Date"), '=%1', 0D); if GLSetup."VAT Reporting Date" = GLSetup."VAT Reporting Date"::"Posting Date" then VATDateDataTransfer.AddFieldValue(SalesCrMemoHeader.FieldNo("Posting Date"), SalesCrMemoHeader.FieldNo("VAT Reporting Date")) else VATDateDataTransfer.AddFieldValue(SalesCrMemoHeader.FieldNo("Document Date"), SalesCrMemoHeader.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields := false; VATDateDataTransfer.CopyFields(); Clear(VATDateDataTransfer); // Only update entries that has blank VAT Reporting Date VATDateDataTransfer.SetTables(Database::"Purch. Inv. Header", Database::"Purch. Inv. Header"); VATDateDataTransfer.AddSourceFilter(PurchInvHeader.FieldNo("VAT Reporting Date"), '=%1', 0D); if GLSetup."VAT Reporting Date" = GLSetup."VAT Reporting Date"::"Posting Date" then VATDateDataTransfer.AddFieldValue(PurchInvHeader.FieldNo("Posting Date"), PurchInvHeader.FieldNo("VAT Reporting Date")) else VATDateDataTransfer.AddFieldValue(PurchInvHeader.FieldNo("Document Date"), PurchInvHeader.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields := false; VATDateDataTransfer.CopyFields(); Clear(VATDateDataTransfer); // Only update entries that has blank VAT Reporting Date VATDateDataTransfer.SetTables(Database::"Purch. Cr. Memo Hdr.", Database::"Purch. Cr. Memo Hdr."); VATDateDataTransfer.AddSourceFilter(PurchCrMemoHeader.FieldNo("VAT Reporting Date"), '=%1', 0D); if GLSetup."VAT Reporting Date" = GLSetup."VAT Reporting Date"::"Posting Date" then VATDateDataTransfer.AddFieldValue(PurchCrMemoHeader.FieldNo("Posting Date"), PurchCrMemoHeader.FieldNo("VAT Reporting Date")) else VATDateDataTransfer.AddFieldValue(PurchCrMemoHeader.FieldNo("Document Date"), PurchCrMemoHeader.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields := false; VATDateDataTransfer.CopyFields(); Clear(VATDateDataTransfer); end; local procedure UpdateIssuedDocsEntries() var IssuedReminderHeader: Record "Issued Reminder Header"; IssuedFinChargeMemoHeader: Record "Issued Fin. Charge Memo Header"; VATDateDataTransfer: DataTransfer; begin if UpgradeTag.HasUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldIssuedDocsUpgrade()) then exit; IssuedReminderHeader.SetFilter("VAT Reporting Date", '<>%1', BlankDate); if not IssuedReminderHeader.IsEmpty then exit; IssuedFinChargeMemoHeader.SetFilter("VAT Reporting Date", '<>%1', BlankDate); if not IssuedFinChargeMemoHeader.IsEmpty then exit; VATDateDataTransfer.SetTables(Database::"Issued Reminder Header", Database::"Issued Reminder Header"); VATDateDataTransfer.AddFieldValue(IssuedReminderHeader.FieldNo("Posting Date"), IssuedReminderHeader.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields(false); VATDateDataTransfer.CopyFields(); Clear(VATDateDataTransfer); VATDateDataTransfer.SetTables(Database::"Issued Fin. Charge Memo Header", Database::"Issued Fin. Charge Memo Header"); VATDateDataTransfer.AddFieldValue(IssuedFinChargeMemoHeader.FieldNo("Posting Date"), IssuedFinChargeMemoHeader.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields(false); VATDateDataTransfer.CopyFields(); Clear(VATDateDataTransfer); UpgradeTag.SetUpgradeTag(UpgradeTagDefinitions.GetVATDateFieldIssuedDocsUpgrade()); end; local procedure UpdateIssuedDocsBlankEntries() var GLSetup: Record "General Ledger Setup"; IssuedReminderHeader: Record "Issued Reminder Header"; IssuedFinChargeMemoHeader: Record "Issued Fin. Charge Memo Header"; VATDateDataTransfer: DataTransfer; begin if not GLSetup.Get() then exit; // Only update entries that has blank VAT Reporting Date VATDateDataTransfer.SetTables(Database::"Issued Reminder Header", Database::"Issued Reminder Header"); VATDateDataTransfer.AddSourceFilter(IssuedReminderHeader.FieldNo("VAT Reporting Date"), '=%1', 0D); if GLSetup."VAT Reporting Date" = GLSetup."VAT Reporting Date"::"Posting Date" then VATDateDataTransfer.AddFieldValue(IssuedReminderHeader.FieldNo("Posting Date"), IssuedReminderHeader.FieldNo("VAT Reporting Date")) else VATDateDataTransfer.AddFieldValue(IssuedReminderHeader.FieldNo("Document Date"), IssuedReminderHeader.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields := false; VATDateDataTransfer.CopyFields(); Clear(VATDateDataTransfer); // Only update entries that has blank VAT Reporting Date VATDateDataTransfer.SetTables(Database::"Issued Fin. Charge Memo Header", Database::"Issued Fin. Charge Memo Header"); VATDateDataTransfer.AddSourceFilter(IssuedFinChargeMemoHeader.FieldNo("VAT Reporting Date"), '=%1', 0D); if GLSetup."VAT Reporting Date" = GLSetup."VAT Reporting Date"::"Posting Date" then VATDateDataTransfer.AddFieldValue(IssuedFinChargeMemoHeader.FieldNo("Posting Date"), IssuedFinChargeMemoHeader.FieldNo("VAT Reporting Date")) else VATDateDataTransfer.AddFieldValue(IssuedFinChargeMemoHeader.FieldNo("Document Date"), IssuedFinChargeMemoHeader.FieldNo("VAT Reporting Date")); VATDateDataTransfer.UpdateAuditFields := false; VATDateDataTransfer.CopyFields(); Clear(VATDateDataTransfer); end;}