Codeunit 5063 ArchiveManagement
src/Layers/W1/BaseApp/Utilities/ArchiveManagement.Codeunit.al988 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.Utilities;using Microsoft.Finance.Deferral;using Microsoft.Inventory.Tracking;using Microsoft.Purchases.Archive;using Microsoft.Purchases.Comment;using Microsoft.Purchases.Document;using Microsoft.Purchases.Setup;using Microsoft.Sales.Archive;using Microsoft.Sales.Comment;using Microsoft.Sales.Document;using Microsoft.Sales.History;using Microsoft.Sales.Setup;using System.Utilities;codeunit 5063 ArchiveManagement{ Permissions = tableData "Purch. Comment Line" = r, tableData "Purchase Header Archive" = ri, tableData "Purchase Line Archive" = ri, tableData "Purch. Comment Line Archive" = ri, tabledata "Sales Comment Line" = r, tabledata "Sales Header Archive" = ri, tabledata "Sales Line Archive" = ri, tabledata "Sales Comment Line Archive" = ri; trigger OnRun() begin end; var DeferralUtilities: Codeunit "Deferral Utilities"; RecordLinkManagement: Codeunit "Record Link Management"; ReleaseSalesDoc: Codeunit "Release Sales Document";#pragma warning disable AA0074#pragma warning disable AA0470 Text001: Label 'Document %1 has been archived.'; Text002: Label 'Do you want to Restore %1 %2 Version %3?'; Text003: Label '%1 %2 has been restored.'; Text004: Label 'Document restored from Version %1.'; Text005: Label '%1 %2 has been partly posted.\Restore not possible.'; Text006: Label 'Entries exist for on or more of the following:\ - %1\ - %2\ - %3.\Restoration of document will delete these entries.\Continue with restore?'; Text007: Label 'Archive %1 no.: %2?';#pragma warning restore AA0470 Text008: Label 'Item Tracking Line';#pragma warning disable AA0470 Text009: Label 'Unposted %1 %2 does not exist anymore.\It is not possible to restore the %1.';#pragma warning restore AA0470#pragma warning restore AA0074 procedure AutoArchiveSalesDocument(var SalesHeader: Record "Sales Header") var SalesReceivablesSetup: Record "Sales & Receivables Setup"; IsHandled: Boolean; begin IsHandled := false; OnBeforeAutoArchiveSalesDocument(SalesHeader, IsHandled); if IsHandled then exit; SalesReceivablesSetup.Get(); case SalesHeader."Document Type" of SalesHeader."Document Type"::Quote: case SalesReceivablesSetup."Archive Quotes" of SalesReceivablesSetup."Archive Quotes"::Always: ArchSalesDocumentNoConfirm(SalesHeader); SalesReceivablesSetup."Archive Quotes"::Question: ArchiveSalesDocument(SalesHeader); end; SalesHeader."Document Type"::Order: if SalesReceivablesSetup."Archive Orders" then begin PrepareDeferralsForSalesOrder(SalesHeader); ArchSalesDocumentNoConfirm(SalesHeader); end; SalesHeader."Document Type"::"Blanket Order": if SalesReceivablesSetup."Archive Blanket Orders" then ArchSalesDocumentNoConfirm(SalesHeader); SalesHeader."Document Type"::"Return Order": if SalesReceivablesSetup."Archive Return Orders" then ArchSalesDocumentNoConfirm(SalesHeader); end; OnAfterAutoArchiveSalesDocument(SalesHeader); end; procedure AutoArchivePurchDocument(var PurchaseHeader: Record "Purchase Header") var PurchasesPayablesSetup: Record "Purchases & Payables Setup"; IsHandled: Boolean; begin IsHandled := false; OnBeforeAutoArchivePurchDocument(PurchaseHeader, IsHandled); if IsHandled then exit; PurchasesPayablesSetup.Get(); case PurchaseHeader."Document Type" of PurchaseHeader."Document Type"::Quote: case PurchasesPayablesSetup."Archive Quotes" of PurchasesPayablesSetup."Archive Quotes"::Always: ArchPurchDocumentNoConfirm(PurchaseHeader); PurchasesPayablesSetup."Archive Quotes"::Question: ArchivePurchDocument(PurchaseHeader); end; PurchaseHeader."Document Type"::Order: if PurchasesPayablesSetup."Archive Orders" then begin PrepareDeferralsPurchaseOrder(PurchaseHeader); ArchPurchDocumentNoConfirm(PurchaseHeader); end; PurchaseHeader."Document Type"::"Blanket Order": if PurchasesPayablesSetup."Archive Blanket Orders" then ArchPurchDocumentNoConfirm(PurchaseHeader); PurchaseHeader."Document Type"::"Return Order": if PurchasesPayablesSetup."Archive Return Orders" then ArchPurchDocumentNoConfirm(PurchaseHeader); end; OnAfterAutoArchivePurchDocument(PurchaseHeader); end; procedure ArchiveSalesDocument(var SalesHeader: Record "Sales Header") var ConfirmManagement: Codeunit "Confirm Management"; IsHandled: Boolean; begin IsHandled := false; OnBeforeArchiveSalesDocument(SalesHeader, IsHandled); if IsHandled then exit; if ConfirmManagement.GetResponseOrDefault( StrSubstNo(Text007, SalesHeader."Document Type", SalesHeader."No."), true) then begin StoreSalesDocument(SalesHeader, false); Message(Text001, SalesHeader."No."); end; end; procedure ArchivePurchDocument(var PurchHeader: Record "Purchase Header") var ConfirmManagement: Codeunit "Confirm Management"; IsHandled: Boolean; begin IsHandled := false; OnBeforeArchivePurchDocument(PurchHeader, IsHandled); if IsHandled then exit; if ConfirmManagement.GetResponseOrDefault( StrSubstNo(Text007, PurchHeader."Document Type", PurchHeader."No."), true) then begin StorePurchDocument(PurchHeader, false); Message(Text001, PurchHeader."No."); end; end; procedure StoreSalesDocument(var SalesHeader: Record "Sales Header"; InteractionExist: Boolean) var SalesLine: Record "Sales Line"; SalesHeaderArchive: Record "Sales Header Archive"; SalesLineArchive: Record "Sales Line Archive"; IsHandled: Boolean; begin IsHandled := false; OnBeforeStoreSalesDocument(SalesHeader, IsHandled); if IsHandled then exit; SalesHeaderArchive.Init(); SalesHeader.CalcFields("Work Description"); SalesHeaderArchive.TransferFields(SalesHeader); SalesHeaderArchive."Archived By" := CopyStr(UserId(), 1, MaxStrLen(SalesHeaderArchive."Archived By")); SalesHeaderArchive."Date Archived" := Today(); SalesHeaderArchive."Time Archived" := Time(); SalesHeaderArchive."Version No." := GetNextVersionNo( DATABASE::"Sales Header", SalesHeader."Document Type".AsInteger(), SalesHeader."No.", SalesHeader."Doc. No. Occurrence"); SalesHeaderArchive."Interaction Exist" := InteractionExist; RecordLinkManagement.CopyLinks(SalesHeader, SalesHeaderArchive); OnBeforeSalesHeaderArchiveInsert(SalesHeaderArchive, SalesHeader); SalesHeaderArchive.Insert(); OnAfterSalesHeaderArchiveInsert(SalesHeaderArchive, SalesHeader); StoreSalesDocumentComments( SalesHeader."Document Type".AsInteger(), SalesHeader."No.", SalesHeader."Doc. No. Occurrence", SalesHeaderArchive."Version No."); SalesLine.SetRange("Document Type", SalesHeader."Document Type"); SalesLine.SetRange("Document No.", SalesHeader."No."); if SalesLine.FindSet() then repeat SalesLineArchive.Init(); SalesLineArchive.TransferFields(SalesLine); SalesLineArchive."Doc. No. Occurrence" := SalesHeader."Doc. No. Occurrence"; SalesLineArchive."Version No." := SalesHeaderArchive."Version No."; RecordLinkManagement.CopyLinks(SalesLine, SalesLineArchive); OnBeforeSalesLineArchiveInsert(SalesLineArchive, SalesLine); SalesLineArchive.Insert(); if SalesLine."Deferral Code" <> '' then StoreDeferrals( Enum::"Deferral Document Type"::Sales.AsInteger(), SalesLine."Document Type".AsInteger(), SalesLine."Document No.", SalesLine."Line No.", SalesHeader."Doc. No. Occurrence", SalesHeaderArchive."Version No."); OnAfterStoreSalesLineArchive(SalesHeader, SalesLine, SalesHeaderArchive, SalesLineArchive); until SalesLine.Next() = 0; OnAfterStoreSalesDocument(SalesHeader, SalesHeaderArchive); end; procedure StorePurchDocument(var PurchHeader: Record "Purchase Header"; InteractionExist: Boolean) var PurchLine: Record "Purchase Line"; PurchHeaderArchive: Record "Purchase Header Archive"; PurchLineArchive: Record "Purchase Line Archive"; IsHandled: Boolean; begin IsHandled := false; OnBeforeStorePurchDocument(PurchHeader, IsHandled); if IsHandled then exit; PurchHeaderArchive.Init(); PurchHeaderArchive.TransferFields(PurchHeader); PurchHeaderArchive."Archived By" := CopyStr(UserId(), 1, MaxStrLen(PurchHeaderArchive."Archived By")); PurchHeaderArchive."Date Archived" := Today(); PurchHeaderArchive."Time Archived" := Time(); PurchHeaderArchive."Version No." := GetNextVersionNo( DATABASE::"Purchase Header", PurchHeader."Document Type".AsInteger(), PurchHeader."No.", PurchHeader."Doc. No. Occurrence"); PurchHeaderArchive."Interaction Exist" := InteractionExist; RecordLinkManagement.CopyLinks(PurchHeader, PurchHeaderArchive); OnBeforePurchHeaderArchiveInsert(PurchHeaderArchive, PurchHeader); PurchHeaderArchive.Insert(); OnAfterPurchHeaderArchiveInsert(PurchHeaderArchive, PurchHeader); StorePurchDocumentComments( PurchHeader."Document Type".AsInteger(), PurchHeader."No.", PurchHeader."Doc. No. Occurrence", PurchHeaderArchive."Version No."); PurchLine.SetRange("Document Type", PurchHeader."Document Type"); PurchLine.SetRange("Document No.", PurchHeader."No."); if PurchLine.FindSet() then repeat PurchLineArchive.Init(); PurchLineArchive.TransferFields(PurchLine); PurchLineArchive."Doc. No. Occurrence" := PurchHeader."Doc. No. Occurrence"; PurchLineArchive."Version No." := PurchHeaderArchive."Version No."; RecordLinkManagement.CopyLinks(PurchLine, PurchLineArchive); OnBeforePurchLineArchiveInsert(PurchLineArchive, PurchLine); PurchLineArchive.Insert(); if PurchLine."Deferral Code" <> '' then StoreDeferrals( Enum::"Deferral Document Type"::Purchase.AsInteger(), PurchLine."Document Type".AsInteger(), PurchLine."Document No.", PurchLine."Line No.", PurchHeader."Doc. No. Occurrence", PurchHeaderArchive."Version No."); OnAfterStorePurchLineArchive(PurchHeader, PurchLine, PurchHeaderArchive, PurchLineArchive); until PurchLine.Next() = 0; OnAfterStorePurchDocument(PurchHeader, PurchHeaderArchive); end; procedure RestoreSalesDocument(var SalesHeaderArchive: Record "Sales Header Archive") var SalesHeader: Record "Sales Header"; SalesShptHeader: Record "Sales Shipment Header"; SalesInvHeader: Record "Sales Invoice Header"; ReservEntry: Record "Reservation Entry"; ItemChargeAssgntSales: Record "Item Charge Assignment (Sales)"; ConfirmManagement: Codeunit "Confirm Management"; ConfirmRequired: Boolean; RestoreDocument: Boolean; OldOpportunityNo: Code[20]; IsHandled: Boolean; DoCheck, SkipDeletingLinks : Boolean; begin OnBeforeRestoreSalesDocument(SalesHeaderArchive, IsHandled); if IsHandled then exit; if not SalesHeader.Get(SalesHeaderArchive."Document Type", SalesHeaderArchive."No.") then Error(Text009, SalesHeaderArchive."Document Type", SalesHeaderArchive."No."); SalesHeader.TestField(Status, SalesHeader.Status::Open); DoCheck := true; OnBeforeCheckIfDocumentIsPartiallyPosted(SalesHeaderArchive, DoCheck); if (SalesHeader."Document Type" = SalesHeader."Document Type"::Order) and DoCheck then begin SalesShptHeader.Reset(); SalesShptHeader.SetCurrentKey("Order No."); SalesShptHeader.SetRange("Order No.", SalesHeader."No."); if not SalesShptHeader.IsEmpty() then Error(Text005, SalesHeader."Document Type", SalesHeader."No."); SalesInvHeader.Reset(); SalesInvHeader.SetCurrentKey("Order No."); SalesInvHeader.SetRange("Order No.", SalesHeader."No."); if not SalesInvHeader.IsEmpty() then Error(Text005, SalesHeader."Document Type", SalesHeader."No."); end; ConfirmRequired := false; ReservEntry.Reset(); ReservEntry.SetCurrentKey("Source ID", "Source Ref. No.", "Source Type", "Source Subtype"); ReservEntry.SetRange("Source ID", SalesHeader."No."); ReservEntry.SetRange("Source Type", DATABASE::"Sales Line"); ReservEntry.SetRange("Source Subtype", SalesHeader."Document Type"); if ReservEntry.FindFirst() then ConfirmRequired := true; ItemChargeAssgntSales.Reset(); ItemChargeAssgntSales.SetRange("Document Type", SalesHeader."Document Type"); ItemChargeAssgntSales.SetRange("Document No.", SalesHeader."No."); if ItemChargeAssgntSales.FindFirst() then ConfirmRequired := true; RestoreDocument := false; if ConfirmRequired then begin if ConfirmManagement.GetResponseOrDefault( StrSubstNo( Text006, ReservEntry.TableCaption(), ItemChargeAssgntSales.TableCaption(), Text008), true) then RestoreDocument := true; end else if ConfirmManagement.GetResponseOrDefault( StrSubstNo( Text002, SalesHeaderArchive."Document Type", SalesHeaderArchive."No.", SalesHeaderArchive."Version No."), true) then RestoreDocument := true; if RestoreDocument then begin SalesHeader.TestField("Doc. No. Occurrence", SalesHeaderArchive."Doc. No. Occurrence"); SalesHeaderArchive.CalcFields("Work Description"); if SalesHeader."Opportunity No." <> '' then begin OldOpportunityNo := SalesHeader."Opportunity No."; SalesHeader."Opportunity No." := ''; end; SkipDeletingLinks := false; OnRestoreDocumentOnBeforeDeleteSalesHeader(SalesHeader, SkipDeletingLinks); if not SkipDeletingLinks then SalesHeader.DeleteLinks(); SalesHeader.Delete(true); OnRestoreDocumentOnAfterDeleteSalesHeader(SalesHeader); SalesHeader.Init(); SalesHeader.SetHideValidationDialog(true); SalesHeader."Document Type" := SalesHeaderArchive."Document Type"; SalesHeader."No." := SalesHeaderArchive."No."; OnBeforeSalesHeaderInsert(SalesHeader, SalesHeaderArchive); SalesHeader.Insert(true); OnRestoreSalesDocumentOnAfterSalesHeaderInsert(SalesHeader, SalesHeaderArchive); SalesHeader.TransferFields(SalesHeaderArchive); SalesHeader.Status := SalesHeader.Status::Open; OnRestoreSalesDocumentOnBeforeSalesHeaderValidateFields(SalesHeader, SalesHeaderArchive); if SalesHeaderArchive."Sell-to Contact No." <> '' then SalesHeader.Validate("Sell-to Contact No.", SalesHeaderArchive."Sell-to Contact No.") else SalesHeader.Validate("Sell-to Customer No.", SalesHeaderArchive."Sell-to Customer No."); if SalesHeaderArchive."Bill-to Contact No." <> '' then SalesHeader.Validate("Bill-to Contact No.", SalesHeaderArchive."Bill-to Contact No.") else SalesHeader.Validate("Bill-to Customer No.", SalesHeaderArchive."Bill-to Customer No."); SalesHeader.Validate("Salesperson Code", SalesHeaderArchive."Salesperson Code"); SalesHeader.Validate("Payment Terms Code", SalesHeaderArchive."Payment Terms Code"); SalesHeader.Validate("Payment Discount %", SalesHeaderArchive."Payment Discount %"); SalesHeader."Shortcut Dimension 1 Code" := SalesHeaderArchive."Shortcut Dimension 1 Code"; SalesHeader."Shortcut Dimension 2 Code" := SalesHeaderArchive."Shortcut Dimension 2 Code"; SalesHeader."Dimension Set ID" := SalesHeaderArchive."Dimension Set ID"; RecordLinkManagement.CopyLinks(SalesHeaderArchive, SalesHeader); SalesHeader.LinkSalesDocWithOpportunity(OldOpportunityNo); OnAfterTransferFromArchToSalesHeader(SalesHeader, SalesHeaderArchive); SalesHeader.Modify(true); RestoreSalesLines(SalesHeaderArchive, SalesHeader); SalesHeader.Status := SalesHeader.Status::Released; ReleaseSalesDoc.Reopen(SalesHeader); OnAfterRestoreSalesDocument(SalesHeader, SalesHeaderArchive); Message(Text003, SalesHeader."Document Type", SalesHeader."No."); end; end; local procedure RestoreSalesLines(var SalesHeaderArchive: Record "Sales Header Archive"; SalesHeader: Record "Sales Header") var SalesLine: Record "Sales Line"; SalesLineArchive: Record "Sales Line Archive"; ShouldValidateQuantity: Boolean; begin RestoreSalesLineComments(SalesHeaderArchive, SalesHeader); SalesLineArchive.SetRange("Document Type", SalesHeaderArchive."Document Type"); SalesLineArchive.SetRange("Document No.", SalesHeaderArchive."No."); SalesLineArchive.SetRange("Doc. No. Occurrence", SalesHeaderArchive."Doc. No. Occurrence"); SalesLineArchive.SetRange("Version No.", SalesHeaderArchive."Version No."); OnRestoreSalesLinesOnAfterSalesLineArchiveSetFilters(SalesLineArchive, SalesHeaderArchive, SalesHeader); if SalesLineArchive.FindSet() then repeat SalesLine.Init(); SalesLine.TransferFields(SalesLineArchive); OnRestoreSalesLinesOnBeforeSalesLineInsert(SalesLine, SalesLineArchive); SalesLine.Insert(true); OnRestoreSalesLinesOnAfterSalesLineInsert(SalesLine, SalesLineArchive); if SalesLine.Type <> SalesLine.Type::" " then begin SalesLine.Validate("No."); if SalesLineArchive."Variant Code" <> '' then SalesLine.Validate("Variant Code", SalesLineArchive."Variant Code"); if SalesLineArchive."Unit of Measure Code" <> '' then SalesLine.Validate("Unit of Measure Code", SalesLineArchive."Unit of Measure Code"); SalesLine.Validate("Location Code", SalesLineArchive."Location Code"); ShouldValidateQuantity := SalesLine.Quantity <> 0; OnRestoreSalesLinesOnAfterCalcShouldValidateQuantity(SalesLine, SalesLineArchive, ShouldValidateQuantity); if ShouldValidateQuantity then SalesLine.Validate(Quantity, SalesLineArchive.Quantity); OnRestoreSalesLinesOnAfterValidateQuantity(SalesLine, SalesLineArchive); SalesLine.Validate("Unit Price", SalesLineArchive."Unit Price"); SalesLine.Validate("Unit Cost (LCY)", SalesLineArchive."Unit Cost (LCY)"); SalesLine.Validate("Line Discount %", SalesLineArchive."Line Discount %"); if SalesLineArchive."Inv. Discount Amount" <> 0 then SalesLine.Validate("Inv. Discount Amount", SalesLineArchive."Inv. Discount Amount"); if SalesLine.Amount <> SalesLineArchive.Amount then SalesLine.Validate(Amount, SalesLineArchive.Amount); SalesLine.Validate(Description, SalesLineArchive.Description); end; SalesLine."Shortcut Dimension 1 Code" := SalesLineArchive."Shortcut Dimension 1 Code"; SalesLine."Shortcut Dimension 2 Code" := SalesLineArchive."Shortcut Dimension 2 Code"; SalesLine."Dimension Set ID" := SalesLineArchive."Dimension Set ID"; SalesLine."Deferral Code" := SalesLineArchive."Deferral Code"; RestoreDeferrals( Enum::"Deferral Document Type"::Sales.AsInteger(), SalesLineArchive."Document Type".AsInteger(), SalesLineArchive."Document No.", SalesLineArchive."Line No.", SalesHeaderArchive."Doc. No. Occurrence", SalesHeaderArchive."Version No."); RecordLinkManagement.CopyLinks(SalesLineArchive, SalesLine); OnAfterTransferFromArchToSalesLine(SalesLine, SalesLineArchive); SalesLine.Modify(true); OnAfterRestoreSalesLine(SalesHeader, SalesLine, SalesHeaderArchive, SalesLineArchive); until SalesLineArchive.Next() = 0; OnAfterRestoreSalesLines(SalesHeader, SalesLine, SalesHeaderArchive, SalesLineArchive); end; procedure GetNextOccurrenceNo(TableId: Integer; DocType: Option Quote,"Order",Invoice,"Credit Memo","Blanket Order","Return Order"; DocNo: Code[20]) OccurenceNo: Integer var SalesHeaderArchive: Record "Sales Header Archive"; PurchHeaderArchive: Record "Purchase Header Archive"; begin case TableId of DATABASE::"Sales Header": begin SalesHeaderArchive.LockTable(); SalesHeaderArchive.SetRange("Document Type", DocType); SalesHeaderArchive.SetRange("No.", DocNo); if SalesHeaderArchive.FindLast() then exit(SalesHeaderArchive."Doc. No. Occurrence" + 1); exit(1); end; DATABASE::"Purchase Header": begin PurchHeaderArchive.LockTable(); PurchHeaderArchive.SetRange("Document Type", DocType); PurchHeaderArchive.SetRange("No.", DocNo); if PurchHeaderArchive.FindLast() then exit(PurchHeaderArchive."Doc. No. Occurrence" + 1); exit(1); end; else begin OnGetNextOccurrenceNo(TableId, DocType, DocNo, OccurenceNo); exit(OccurenceNo) end; end; end; procedure GetNextVersionNo(TableId: Integer; DocType: Option Quote,"Order",Invoice,"Credit Memo","Blanket Order","Return Order"; DocNo: Code[20]; DocNoOccurrence: Integer) VersionNo: Integer var SalesHeaderArchive: Record "Sales Header Archive"; PurchHeaderArchive: Record "Purchase Header Archive"; IsHandled: Boolean; begin IsHandled := false; OnBeforeGetNextVersionNo(TableId, DocType, DocNo, DocNoOccurrence, VersionNo, IsHandled); if IsHandled then exit(VersionNo); case TableId of DATABASE::"Sales Header": begin SalesHeaderArchive.LockTable(); SalesHeaderArchive.SetRange("Document Type", DocType); SalesHeaderArchive.SetRange("No.", DocNo); SalesHeaderArchive.SetRange("Doc. No. Occurrence", DocNoOccurrence); if SalesHeaderArchive.FindLast() then exit(SalesHeaderArchive."Version No." + 1); exit(1); end; DATABASE::"Purchase Header": begin PurchHeaderArchive.LockTable(); PurchHeaderArchive.SetRange("Document Type", DocType); PurchHeaderArchive.SetRange("No.", DocNo); PurchHeaderArchive.SetRange("Doc. No. Occurrence", DocNoOccurrence); if PurchHeaderArchive.FindLast() then exit(PurchHeaderArchive."Version No." + 1); exit(1); end; else begin OnGetNextVersionNo(TableId, DocType, DocNo, DocNoOccurrence, VersionNo); exit(VersionNo) end; end; end; procedure SalesDocArchiveGranule(): Boolean var SalesHeaderArchive: Record "Sales Header Archive"; begin exit(SalesHeaderArchive.WritePermission); end; procedure PurchaseDocArchiveGranule(): Boolean var PurchaseHeaderArchive: Record "Purchase Header Archive"; begin exit(PurchaseHeaderArchive.WritePermission); end; local procedure StoreSalesDocumentComments(DocType: Option; DocNo: Code[20]; DocNoOccurrence: Integer; VersionNo: Integer) var SalesCommentLine: Record "Sales Comment Line"; SalesCommentLineArch: Record "Sales Comment Line Archive"; begin SalesCommentLine.SetRange("Document Type", DocType); SalesCommentLine.SetRange("No.", DocNo); if SalesCommentLine.FindSet() then repeat SalesCommentLineArch.Init(); SalesCommentLineArch.TransferFields(SalesCommentLine); SalesCommentLineArch."Doc. No. Occurrence" := DocNoOccurrence; SalesCommentLineArch."Version No." := VersionNo; OnStoreSalesDocumentCommentsOnBeforeSalesCommentLineArchInsert(SalesCommentLineArch, SalesCommentLine); SalesCommentLineArch.Insert(); until SalesCommentLine.Next() = 0; end; procedure StorePurchDocumentComments(DocType: Option; DocNo: Code[20]; DocNoOccurrence: Integer; VersionNo: Integer) var PurchCommentLine: Record "Purch. Comment Line"; PurchCommentLineArch: Record "Purch. Comment Line Archive"; begin PurchCommentLine.SetRange("Document Type", DocType); PurchCommentLine.SetRange("No.", DocNo); if PurchCommentLine.FindSet() then repeat PurchCommentLineArch.Init(); PurchCommentLineArch.TransferFields(PurchCommentLine); PurchCommentLineArch."Doc. No. Occurrence" := DocNoOccurrence; PurchCommentLineArch."Version No." := VersionNo; OnStorePurchDocumentCommentsOnBeforePurchCommentLineArchInsert(PurchCommentLineArch, PurchCommentLine); PurchCommentLineArch.Insert(); until PurchCommentLine.Next() = 0; end; procedure ArchSalesDocumentNoConfirm(var SalesHeader: Record "Sales Header") var IsHandled: Boolean; begin IsHandled := false; OnBeforeArchSalesDocumentNoConfirm(SalesHeader, IsHandled); if IsHandled then exit; StoreSalesDocument(SalesHeader, false); end; procedure ArchPurchDocumentNoConfirm(var PurchHeader: Record "Purchase Header") var IsHandled: Boolean; begin IsHandled := false; OnBeforeArchPurchDocumentNoConfirm(PurchHeader, IsHandled); if IsHandled then exit; StorePurchDocument(PurchHeader, false); end; local procedure StoreDeferrals(DeferralDocType: Integer; DocType: Integer; DocNo: Code[20]; LineNo: Integer; DocNoOccurrence: Integer; VersionNo: Integer) var DeferralHeaderArchive: Record "Deferral Header Archive"; DeferralLineArchive: Record "Deferral Line Archive"; DeferralHeader: Record "Deferral Header"; DeferralLine: Record "Deferral Line"; begin if DeferralHeader.Get(DeferralDocType, '', '', DocType, DocNo, LineNo) then begin DeferralHeaderArchive.Init(); DeferralHeaderArchive.TransferFields(DeferralHeader); DeferralHeaderArchive."Doc. No. Occurrence" := DocNoOccurrence; DeferralHeaderArchive."Version No." := VersionNo; DeferralHeaderArchive.Insert(); DeferralLine.SetRange("Deferral Doc. Type", DeferralDocType); DeferralLine.SetRange("Gen. Jnl. Template Name", ''); DeferralLine.SetRange("Gen. Jnl. Batch Name", ''); DeferralLine.SetRange("Document Type", DocType); DeferralLine.SetRange("Document No.", DocNo); DeferralLine.SetRange("Line No.", LineNo); if DeferralLine.FindSet() then repeat DeferralLineArchive.Init(); DeferralLineArchive.TransferFields(DeferralLine); DeferralLineArchive."Doc. No. Occurrence" := DocNoOccurrence; DeferralLineArchive."Version No." := VersionNo; DeferralLineArchive.Insert(); until DeferralLine.Next() = 0; end; end; local procedure RestoreDeferrals(DeferralDocType: Integer; DocType: Integer; DocNo: Code[20]; LineNo: Integer; DocNoOccurrence: Integer; VersionNo: Integer) var DeferralHeaderArchive: Record "Deferral Header Archive"; DeferralLineArchive: Record "Deferral Line Archive"; DeferralHeader: Record "Deferral Header"; DeferralLine: Record "Deferral Line"; begin if DeferralHeaderArchive.Get(DeferralDocType, DocType, DocNo, DocNoOccurrence, VersionNo, LineNo) then begin OnRestoreDeferralsOnAfterGetDeferralHeaderArchive(DeferralHeaderArchive, DeferralHeader); // Updates the header if is exists already and removes all the lines DeferralUtilities.SetDeferralRecords(DeferralHeader, DeferralDocType, '', '', DocType, DocNo, LineNo, DeferralHeaderArchive."Calc. Method", DeferralHeaderArchive."No. of Periods", DeferralHeaderArchive."Amount to Defer", DeferralHeaderArchive."Start Date", DeferralHeaderArchive."Deferral Code", DeferralHeaderArchive."Schedule Description", DeferralHeaderArchive."Initial Amount to Defer", true, DeferralHeaderArchive."Currency Code"); // Add lines as exist in the archives DeferralLineArchive.SetRange("Deferral Doc. Type", DeferralDocType); DeferralLineArchive.SetRange("Document Type", DocType); DeferralLineArchive.SetRange("Document No.", DocNo); DeferralLineArchive.SetRange("Doc. No. Occurrence", DocNoOccurrence); DeferralLineArchive.SetRange("Version No.", VersionNo); DeferralLineArchive.SetRange("Line No.", LineNo); if DeferralLineArchive.FindSet() then repeat DeferralLine.Init(); DeferralLine.TransferFields(DeferralLineArchive); DeferralLine.Insert(); until DeferralLineArchive.Next() = 0; end else // Removes any lines that may have been defaulted DeferralUtilities.RemoveOrSetDeferralSchedule('', DeferralDocType, '', '', DocType, DocNo, LineNo, 0, 0D, '', '', true); end; local procedure RestoreSalesLineComments(SalesHeaderArchive: Record "Sales Header Archive"; SalesHeader: Record "Sales Header") var SalesCommentLineArchive: Record "Sales Comment Line Archive"; SalesCommentLine: Record "Sales Comment Line"; NextLine: Integer; begin SalesCommentLineArchive.SetRange("Document Type", SalesHeaderArchive."Document Type"); SalesCommentLineArchive.SetRange("No.", SalesHeaderArchive."No."); SalesCommentLineArchive.SetRange("Doc. No. Occurrence", SalesHeaderArchive."Doc. No. Occurrence"); SalesCommentLineArchive.SetRange("Version No.", SalesHeaderArchive."Version No."); if SalesCommentLineArchive.FindSet() then repeat SalesCommentLine.Init(); SalesCommentLine.TransferFields(SalesCommentLineArchive); SalesCommentLine.Insert(); until SalesCommentLineArchive.Next() = 0; SalesCommentLine.SetRange("Document Type", SalesHeader."Document Type"); SalesCommentLine.SetRange("No.", SalesHeader."No."); SalesCommentLine.SetRange("Document Line No.", 0); if SalesCommentLine.FindLast() then NextLine := SalesCommentLine."Line No."; NextLine += 10000; SalesCommentLine.Init(); SalesCommentLine."Document Type" := SalesHeader."Document Type"; SalesCommentLine."No." := SalesHeader."No."; SalesCommentLine."Document Line No." := 0; SalesCommentLine."Line No." := NextLine; SalesCommentLine.Date := WorkDate(); SalesCommentLine.Comment := StrSubstNo(Text004, Format(SalesHeaderArchive."Version No.")); OnRestoreSalesLineCommentsOnBeforeInsertSalesCommentLine(SalesCommentLine); SalesCommentLine.Insert(); end; procedure RoundSalesDeferralsForArchive(SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line") var DeferralHeader: Record "Deferral Header"; AmtToDefer: Decimal; AmtToDeferACY: Decimal; begin SalesLine.SetFilter("Deferral Code", '<>%1', ''); if SalesLine.FindSet() then repeat if DeferralHeader.Get(Enum::"Deferral Document Type"::Sales, '', '', SalesLine."Document Type", SalesLine."Document No.", SalesLine."Line No.") then DeferralUtilities.RoundDeferralAmount( DeferralHeader, SalesHeader."Currency Code", SalesHeader."Currency Factor", SalesHeader."Posting Date", AmtToDeferACY, AmtToDefer); until SalesLine.Next() = 0; end; procedure RoundPurchaseDeferralsForArchive(PurchaseHeader: Record "Purchase Header"; var PurchaseLine: Record "Purchase Line") var DeferralHeader: Record "Deferral Header"; AmtToDefer: Decimal; AmtToDeferACY: Decimal; begin PurchaseLine.SetFilter("Deferral Code", '<>%1', ''); if PurchaseLine.FindSet() then repeat if DeferralHeader.Get(Enum::"Deferral Document Type"::Purchase, '', '', PurchaseLine."Document Type", PurchaseLine."Document No.", PurchaseLine."Line No.") then DeferralUtilities.RoundDeferralAmount( DeferralHeader, PurchaseHeader."Currency Code", PurchaseHeader."Currency Factor", PurchaseHeader."Posting Date", AmtToDeferACY, AmtToDefer); until PurchaseLine.Next() = 0; end; local procedure PrepareDeferralsForSalesOrder(SalesHeader: Record "Sales Header") var SalesLine: Record "Sales Line"; begin if SalesHeader."Document Type" = SalesHeader."Document Type"::Order then begin SalesLine.Reset(); SalesLine.SetRange("Document Type", SalesHeader."Document Type"); SalesLine.SetRange("Document No.", SalesHeader."No."); SalesLine.SetFilter("Qty. Invoiced (Base)", '<>%1', 0); if SalesLine.IsEmpty() then exit; RoundSalesDeferralsForArchive(SalesHeader, SalesLine); end; end; local procedure PrepareDeferralsPurchaseOrder(PurchaseHeader: Record "Purchase Header") var PurchaseLine: Record "Purchase Line"; begin if PurchaseHeader."Document Type" = PurchaseHeader."Document Type"::Order then begin PurchaseLine.Reset(); PurchaseLine.SetRange("Document Type", PurchaseHeader."Document Type"); PurchaseLine.SetRange("Document No.", PurchaseHeader."No."); PurchaseLine.SetFilter("Qty. Invoiced (Base)", '<>%1', 0); if PurchaseLine.IsEmpty() then exit; RoundPurchaseDeferralsForArchive(PurchaseHeader, PurchaseLine); end; end; [IntegrationEvent(false, false)] local procedure OnAfterAutoArchivePurchDocument(var PurchaseHeader: Record "Purchase Header") begin end; [IntegrationEvent(false, false)] local procedure OnAfterAutoArchiveSalesDocument(var SalesHeader: Record "Sales Header") begin end; [IntegrationEvent(false, false)] local procedure OnAfterStoreSalesDocument(var SalesHeader: Record "Sales Header"; var SalesHeaderArchive: Record "Sales Header Archive") begin end; [IntegrationEvent(false, false)] local procedure OnAfterStoreSalesLineArchive(var SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line"; var SalesHeaderArchive: Record "Sales Header Archive"; var SalesLineArchive: Record "Sales Line Archive") begin end; [IntegrationEvent(false, false)] local procedure OnAfterStorePurchDocument(var PurchaseHeader: Record "Purchase Header"; var PurchaseHeaderArchive: Record "Purchase Header Archive") begin end; [IntegrationEvent(false, false)] local procedure OnAfterStorePurchLineArchive(var PurchHeader: Record "Purchase Header"; var PurchLine: Record "Purchase Line"; var PurchHeaderArchive: Record "Purchase Header Archive"; var PurchLineArchive: Record "Purchase Line Archive") begin end; [IntegrationEvent(false, false)] local procedure OnAfterRestoreSalesDocument(var SalesHeader: Record "Sales Header"; var SalesHeaderArchive: Record "Sales Header Archive") begin end; [IntegrationEvent(false, false)] local procedure OnAfterRestoreSalesLine(var SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line"; var SalesHeaderArchive: Record "Sales Header Archive"; var SalesLineArchive: Record "Sales Line Archive") begin end; [IntegrationEvent(false, false)] local procedure OnAfterRestoreSalesLines(var SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line"; var SalesHeaderArchive: Record "Sales Header Archive"; var SalesLineArchive: Record "Sales Line Archive") begin end; [IntegrationEvent(false, false)] local procedure OnAfterSalesHeaderArchiveInsert(var SalesHeaderArchive: Record "Sales Header Archive"; SalesHeader: Record "Sales Header") begin end; [IntegrationEvent(false, false)] local procedure OnAfterPurchHeaderArchiveInsert(var PurchaseHeaderArchive: Record "Purchase Header Archive"; PurchaseHeader: Record "Purchase Header") begin end; [IntegrationEvent(false, false)] local procedure OnAfterTransferFromArchToSalesHeader(var SalesHeader: Record "Sales Header"; var SalesHeaderArchive: Record "Sales Header Archive") begin end; [IntegrationEvent(false, false)] local procedure OnAfterTransferFromArchToSalesLine(var SalesLine: Record "Sales Line"; var SalesLineArchive: Record "Sales Line Archive") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeAutoArchiveSalesDocument(var SalesHeader: Record "Sales Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeAutoArchivePurchDocument(var PurchaseHeader: Record "Purchase Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeArchivePurchDocument(var PurchaseHeader: Record "Purchase Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSalesHeaderInsert(var SalesHeader: Record "Sales Header"; SalesHeaderArchive: Record "Sales Header Archive"); begin end; [IntegrationEvent(false, false)] local procedure OnBeforeRestoreSalesDocument(var SalesHeaderArchive: Record "Sales Header Archive"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCheckIfDocumentIsPartiallyPosted(var SalesHeaderArchive: Record "Sales Header Archive"; var DoCheck: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeGetNextVersionNo(TableId: Integer; DocType: Option Quote,"Order",Invoice,"Credit Memo","Blanket Order","Return Order"; DocNo: Code[20]; DocNoOccurrence: Integer; var VersionNo: Integer; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSalesHeaderArchiveInsert(var SalesHeaderArchive: Record "Sales Header Archive"; SalesHeader: Record "Sales Header") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSalesLineArchiveInsert(var SalesLineArchive: Record "Sales Line Archive"; SalesLine: Record "Sales Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforePurchHeaderArchiveInsert(var PurchaseHeaderArchive: Record "Purchase Header Archive"; PurchaseHeader: Record "Purchase Header") begin end; [IntegrationEvent(false, false)] local procedure OnBeforePurchLineArchiveInsert(var PurchaseLineArchive: Record "Purchase Line Archive"; PurchaseLine: Record "Purchase Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeStoreSalesDocument(var SalesHeader: Record "Sales Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnGetNextOccurrenceNo(TableId: Integer; DocType: Option; DocNo: Code[20]; var OccurenceNo: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnGetNextVersionNo(TableId: Integer; DocType: Option; DocNo: Code[20]; DocNoOccurrence: Integer; var VersionNo: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnRestoreDocumentOnAfterDeleteSalesHeader(var SalesHeader: Record "Sales Header") begin end; [IntegrationEvent(false, false)] local procedure OnRestoreDocumentOnBeforeDeleteSalesHeader(var SalesHeader: Record "Sales Header"; var SkipDeletingLinks: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnRestoreSalesLinesOnAfterCalcShouldValidateQuantity(var SalesLine: Record "Sales Line"; var SalesLineArchive: Record "Sales Line Archive"; var ShouldValidateQuantity: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnRestoreSalesDocumentOnAfterSalesHeaderInsert(var SalesHeader: Record "Sales Header"; var SalesHeaderArchive: Record "Sales Header Archive"); begin end; [IntegrationEvent(false, false)] local procedure OnRestoreSalesLinesOnAfterSalesLineInsert(var SalesLine: Record "Sales Line"; var SalesLineArchive: Record "Sales Line Archive") begin end; [IntegrationEvent(false, false)] local procedure OnRestoreSalesLinesOnAfterSalesLineArchiveSetFilters(var SalesLineArchive: Record "Sales Line Archive"; var SalesHeaderArchive: Record "Sales Header Archive"; SalesHeader: Record "Sales Header") begin end; [IntegrationEvent(false, false)] local procedure OnRestoreSalesLinesOnBeforeSalesLineInsert(var SalesLine: Record "Sales Line"; var SalesLineArchive: Record "Sales Line Archive") begin end; [IntegrationEvent(false, false)] local procedure OnRestoreSalesLinesOnAfterValidateQuantity(var SalesLine: Record "Sales Line"; var SalesLineArchive: Record "Sales Line Archive") begin end; [IntegrationEvent(false, false)] local procedure OnStorePurchDocumentCommentsOnBeforePurchCommentLineArchInsert(var PurchCommentLineArchive: Record "Purch. Comment Line Archive"; PurchCommentLine: Record "Purch. Comment Line") begin end; [IntegrationEvent(false, false)] local procedure OnStoreSalesDocumentCommentsOnBeforeSalesCommentLineArchInsert(var SalesCommentLineArchive: Record "Sales Comment Line Archive"; SalesCommentLine: Record "Sales Comment Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeStorePurchDocument(var PurchHeader: Record "Purchase Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeArchiveSalesDocument(var SalesHeader: Record "Sales Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnRestoreDeferralsOnAfterGetDeferralHeaderArchive(DeferralHeaderArchive: Record "Deferral Header Archive"; var DeferralHeader: Record "Deferral Header") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeArchPurchDocumentNoConfirm(var PurchaseHeader: Record "Purchase Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeArchSalesDocumentNoConfirm(var SalesHeader: Record "Sales Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnRestoreSalesLineCommentsOnBeforeInsertSalesCommentLine(var SalesCommentLine: Record "Sales Comment Line") begin end; [IntegrationEvent(false, false)] local procedure OnRestoreSalesDocumentOnBeforeSalesHeaderValidateFields(var SalesHeader: Record "Sales Header"; SalesHeaderArchive: Record "Sales Header Archive"); begin end;}