Codeunit 1173 Document Attachment Mgmt
src/Layers/W1/BaseApp/Foundation/Attachment/DocumentAttachmentMgmt.Codeunit.al1,908 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.Foundation.Attachment;using Microsoft.CRM.Opportunity;using Microsoft.Finance.VAT.Reporting;using Microsoft.FixedAssets.FixedAsset;using Microsoft.HumanResources.Employee;using Microsoft.Inventory.Item;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Resources.Resource;using Microsoft.Purchases.Document;using Microsoft.Purchases.History;using Microsoft.Purchases.Posting;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Sales.History;using Microsoft.Sales.Posting;using Microsoft.Utilities;using System.Environment.Configuration;using System.Utilities;codeunit 1173 "Document Attachment Mgmt"{ // // Code unit to manage document attachment to records. trigger OnRun() begin end; var ConfirmManagement: Codeunit "Confirm Management"; PrintedToAttachmentTxt: Label 'The document has been printed to attachments.'; NoSaveToPDFReportTxt: Label 'There are no reports which could be saved to PDF for this document.'; ShowAttachmentsTxt: Label 'Show Attachments'; DeleteAttachmentsConfirmQst: Label 'Do you want to delete the attachments for this document?'; RelatedAttachmentsFilterTxt: Label '%1|%2', Comment = '%1 = Source Table ID, %2 = Related Table ID', Locked = true; procedure DeleteAttachedDocuments(RecRef: RecordRef) var DocumentAttachment: Record "Document Attachment"; begin if RecRef.IsTemporary() then exit; if DocumentAttachment.IsEmpty() then exit; SetDocumentAttachmentFiltersForRecRef(DocumentAttachment, RecRef); if AttachedDocumentsExist(RecRef) then DocumentAttachment.DeleteAll(true); end; procedure DeleteAttachedDocumentsWithConfirm(RecRef: RecordRef) var IsHandled: Boolean; begin IsHandled := false; OnBeforeDeleteAttachedDocumentsWithConfirm(RecRef, IsHandled); if IsHandled then exit; if AttachedDocumentsExist(RecRef) then if ConfirmManagement.GetResponseOrDefault(DeleteAttachmentsConfirmQst, true) then DeleteAttachedDocuments(RecRef); end; procedure AttachedDocumentsExist(RecRef: RecordRef): Boolean var DocumentAttachment: Record "Document Attachment"; begin if RecRef.IsTemporary() then exit(false); if DocumentAttachment.IsEmpty() then exit(false); SetDocumentAttachmentFiltersForRecRef(DocumentAttachment, RecRef); exit(not DocumentAttachment.IsEmpty()) end; internal procedure UpdateNumOfRecForFactbox(var Rec: Record "Document Attachment"; var NumberOfRecords: Integer) var CurrentFilterGroup: Integer; begin CurrentFilterGroup := Rec.FilterGroup; Rec.FilterGroup := 4; NumberOfRecords := 0; if Rec.GetFilters() <> '' then begin if Evaluate(Rec."VAT Report Config. Code", Rec.GetFilter("VAT Report Config. Code")) then; NumberOfRecords := Rec.Count(); end; Rec.FilterGroup := CurrentFilterGroup; end; procedure GetRefTable(var RecRef: RecordRef; DocumentAttachment: Record "Document Attachment"): Boolean var Customer: Record Customer; Vendor: Record Vendor; Item: Record Item; Employee: Record Employee; FixedAsset: Record "Fixed Asset"; Resource: Record Resource; SalesHeader: Record "Sales Header"; PurchaseHeader: Record "Purchase Header"; Job: Record Job; SalesCrMemoHeader: Record "Sales Cr.Memo Header"; SalesInvoiceHeader: Record "Sales Invoice Header"; SalesShipmentHeader: Record "Sales Shipment Header"; ReturnReceiptHeader: Record "Return Receipt Header"; PurchInvHeader: Record "Purch. Inv. Header"; PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr."; VATReportHeader: Record "VAT Report Header"; Opportunity: Record Opportunity; begin case DocumentAttachment."Table ID" of 0: exit(false); Database::Customer: if Customer.Get(DocumentAttachment."No.") then RecRef.GetTable(Customer); Database::Vendor: if Vendor.Get(DocumentAttachment."No.") then RecRef.GetTable(Vendor); Database::Item: if Item.Get(DocumentAttachment."No.") then RecRef.GetTable(Item); Database::Employee: if Employee.Get(DocumentAttachment."No.") then RecRef.GetTable(Employee); Database::"Fixed Asset": if FixedAsset.Get(DocumentAttachment."No.") then RecRef.GetTable(FixedAsset); Database::Resource: if Resource.Get(DocumentAttachment."No.") then RecRef.GetTable(Resource); Database::Job: if Job.Get(DocumentAttachment."No.") then RecRef.GetTable(Job); Database::"Sales Header": if SalesHeader.Get(DocumentAttachment."Document Type", DocumentAttachment."No.") then RecRef.GetTable(SalesHeader); Database::"Sales Invoice Header": if SalesInvoiceHeader.Get(DocumentAttachment."No.") then RecRef.GetTable(SalesInvoiceHeader); Database::"Sales Cr.Memo Header": if SalesCrMemoHeader.Get(DocumentAttachment."No.") then RecRef.GetTable(SalesCrMemoHeader); Database::"Sales Shipment Header": if SalesShipmentHeader.Get(DocumentAttachment."No.") then RecRef.GetTable(SalesShipmentHeader); Database::"Return Receipt Header": if ReturnReceiptHeader.Get(DocumentAttachment."No.") then RecRef.GetTable(ReturnReceiptHeader); Database::"Purchase Header": if PurchaseHeader.Get(DocumentAttachment."Document Type", DocumentAttachment."No.") then RecRef.GetTable(PurchaseHeader); Database::"Purch. Inv. Header": if PurchInvHeader.Get(DocumentAttachment."No.") then RecRef.GetTable(PurchInvHeader); Database::"Purch. Cr. Memo Hdr.": if PurchCrMemoHdr.Get(DocumentAttachment."No.") then RecRef.GetTable(PurchCrMemoHdr); Database::"VAT Report Header": if VATReportHeader.Get(DocumentAttachment."VAT Report Config. Code", DocumentAttachment."No.") then RecRef.GetTable(VATReportHeader); Database::Opportunity: if Opportunity.Get(DocumentAttachment."No.") then RecRef.GetTable(Opportunity); end; OnAfterGetRefTable(RecRef, DocumentAttachment); exit(RecRef.Number > 0); end; procedure SetDocumentAttachmentRelatedFiltersForRecRef(var DocumentAttachment: Record "Document Attachment"; RecRef: RecordRef) begin SetDocumentAttachmentFiltersForRecRefInternal(DocumentAttachment, RecRef, true); OnAfterSetDocumentAttachmentFiltersForRecRef(DocumentAttachment, RecRef); end; procedure SetDocumentAttachmentFiltersForRecRef(var DocumentAttachment: Record "Document Attachment"; RecRef: RecordRef) begin SetDocumentAttachmentFiltersForRecRefInternal(DocumentAttachment, RecRef, false); OnAfterSetDocumentAttachmentFiltersForRecRef(DocumentAttachment, RecRef); end; internal procedure SetDocumentAttachmentFiltersForRecRefInternal(var DocumentAttachment: Record "Document Attachment"; RecRef: RecordRef; GetRelatedAttachments: Boolean) var FieldRef: FieldRef; RecNo: Code[20]; AttachmentDocumentType: Enum "Attachment Document Type"; LineNo: Integer; FieldNo: Integer; VATRepConfigType: Enum "VAT Report Configuration"; begin if GetRelatedAttachments then SetRelatedAttachmentsFilter(RecRef.Number(), DocumentAttachment) else DocumentAttachment.SetRange("Table ID", RecRef.Number()); if TableHasNumberFieldPrimayKey(RecRef.Number(), FieldNo) then begin FieldRef := RecRef.Field(FieldNo); RecNo := FieldRef.Value(); DocumentAttachment.SetRange("No.", RecNo); end; if TableHasDocTypePrimaryKey(RecRef.Number(), FieldNo) then begin FieldRef := RecRef.Field(FieldNo); AttachmentDocumentType := FieldRef.Value(); TransformAttachmentDocumentTypeValue(RecRef.Number(), AttachmentDocumentType); DocumentAttachment.SetRange("Document Type", AttachmentDocumentType); end; if TableHasLineNumberPrimaryKey(RecRef.Number(), FieldNo) then begin FieldRef := RecRef.Field(FieldNo); LineNo := FieldRef.Value(); DocumentAttachment.SetRange("Line No.", LineNo); end; if TableHasVATReportConfigCodePrimaryKey(RecRef.Number(), FieldNo) then begin FieldRef := RecRef.Field(FieldNo); VATRepConfigType := FieldRef.Value(); DocumentAttachment.SetRange("VAT Report Config. Code", VATRepConfigType); end; OnAfterSetDocumentAttachmentFiltersForRecRefInternal(DocumentAttachment, RecRef, GetRelatedAttachments); end; local procedure SetRelatedAttachmentsFilter(TableNo: Integer; var DocumentAttachment: Record "Document Attachment") RelatedTable: Integer; begin case TableNo of Database::"Sales Header": RelatedTable := Database::"Sales Line"; Database::"Sales Invoice Header": RelatedTable := Database::"Sales Invoice Line"; Database::"Sales Cr.Memo Header": RelatedTable := Database::"Sales Cr.Memo Line"; Database::"Purchase Header": RelatedTable := Database::"Purchase Line"; Database::"Purch. Inv. Header": RelatedTable := Database::"Purch. Inv. Line"; Database::"Purch. Cr. Memo Hdr.": RelatedTable := Database::"Purch. Cr. Memo Line"; end; OnSetRelatedAttachmentsFilterOnBeforeSetTableIdFilter(TableNo, RelatedTable); if RelatedTable = 0 then begin DocumentAttachment.SetFilter("Table ID", '%1', TableNo); exit; end; DocumentAttachment.SetFilter("Table ID", RelatedAttachmentsFilterTxt, TableNo, RelatedTable); end; internal procedure IsSalesDocumentFlow(TableNo: Integer): Boolean begin exit(TableNo in [Database::Customer, Database::"Sales Header", Database::"Sales Line", Database::"Sales Invoice Header", Database::"Sales Invoice Line", Database::"Sales Cr.Memo Header", Database::"Sales Cr.Memo Line", Database::Item]); end; internal procedure IsPurchaseDocumentFlow(TableNo: Integer): Boolean begin exit(TableNo in [Database::Vendor, Database::"Purchase Header", Database::"Purchase Line", Database::"Purch. Inv. Header", Database::"Purch. Inv. Line", Database::"Purch. Cr. Memo Hdr.", Database::"Purch. Cr. Memo Line", Database::Item]); end; internal procedure IsServiceDocumentFlow(TableNo: Integer) IsDocumentFlow: Boolean begin OnAfterIsServiceDocumentFlow(TableNo, IsDocumentFlow); end; internal procedure IsProductionDocumentFlow(TableNo: Integer) IsDocumentFlow: Boolean begin OnAfterIsProductionDocumentFlow(TableNo, IsDocumentFlow); end; internal procedure IsFlowFieldsEditable(TableNo: Integer) Editable: Boolean begin Editable := not TableIsDocument(TableNo); OnAfterIsFlowFieldsEditable(TableNo, Editable); end; local procedure TableIsDocument(TableID: Integer) IsDocument: Boolean begin IsDocument := TableID in [Database::"Sales Header", Database::"Sales Line", Database::"Purchase Header", Database::"Purchase Line", Database::"Sales Invoice Header", Database::"Sales Cr.Memo Header", Database::"Purch. Inv. Header", Database::"Purch. Cr. Memo Hdr.", Database::"Sales Invoice Line", Database::"Sales Cr.Memo Line", Database::"Purch. Inv. Line", Database::"Purch. Cr. Memo Line"]; OnAfterTableIsDocument(TableID, IsDocument); end; internal procedure TableHasNumberFieldPrimayKey(TableNo: Integer; var FieldNo: Integer): Boolean var Result: Boolean; begin case TableNo of Database::Customer, Database::Vendor, Database::Item, Database::Employee, Database::"Fixed Asset", Database::Job, Database::Resource, Database::"VAT Report Header", Database::Opportunity: begin FieldNo := 1; exit(true); end; Database::"Sales Header", Database::"Sales Line", Database::"Purchase Header", Database::"Purchase Line", Database::"Sales Shipment Header", Database::"Sales Invoice Header", Database::"Sales Cr.Memo Header", Database::"Purch. Inv. Header", Database::"Purch. Cr. Memo Hdr.", Database::"Return Receipt Header", Database::"Sales Invoice Line", Database::"Sales Cr.Memo Line", Database::"Purch. Inv. Line", Database::"Purch. Cr. Memo Line": begin FieldNo := 3; exit(true); end; end; Result := false; OnAfterTableHasNumberFieldPrimaryKey(TableNo, Result, FieldNo); exit(Result); end; internal procedure TableHasDocTypePrimaryKey(TableNo: Integer; var FieldNo: Integer): Boolean var Result: Boolean; begin case TableNo of Database::"Sales Header", Database::"Sales Line", Database::"Purchase Header", Database::"Purchase Line": begin FieldNo := 1; exit(true); end; end; Result := false; OnAfterTableHasDocTypePrimaryKey(TableNo, Result, FieldNo); exit(Result); end; internal procedure TableHasLineNumberPrimaryKey(TableNo: Integer; var FieldNo: Integer): Boolean var Result: Boolean; begin case TableNo of Database::"Sales Line", Database::"Purchase Line", Database::"Sales Invoice Line", Database::"Sales Cr.Memo Line", Database::"Purch. Inv. Line", Database::"Purch. Cr. Memo Line": begin FieldNo := 4; exit(true); end; end; Result := false; OnAfterTableHasLineNumberPrimaryKey(TableNo, Result, FieldNo); exit(Result); end; internal procedure TableHasVATReportConfigCodePrimaryKey(TableNo: Integer; var FieldNo: Integer): Boolean begin if TableNo in [Database::"VAT Report Header"] then begin FieldNo := 2; exit(true); end; exit(false); end; internal procedure TransformAttachmentDocumentTypeValue(TableNo: Integer; var AttachmentDocumentType: Enum "Attachment Document Type") begin OnAfterTransformAttachmentDocumentTypeValue(TableNo, AttachmentDocumentType); end; internal procedure IsSupportedByFileViewerExtension(FileExtension: Text; IncludeImages: Boolean): Boolean begin if FileExtension = '' then exit(false); case LowerCase(FileExtension) of 'pdf': exit(true); 'jpg', 'jpeg', 'bmp', 'png', 'tiff', 'tif', 'gif', 'svg', 'webp', 'avif', 'ico': exit(IncludeImages); else exit(false); end; end; internal procedure IsSupportedByFileViewerFileName(FileName: Text; IncludeImages: Boolean): Boolean var LowerFileName: Text; begin if FileName = '' then exit(false); LowerFileName := LowerCase(FileName); if LowerFileName.EndsWith('.pdf') then exit(true); if not IncludeImages then exit(false); exit( LowerFileName.EndsWith('.jpg') or LowerFileName.EndsWith('.jpeg') or LowerFileName.EndsWith('.bmp') or LowerFileName.EndsWith('.png') or LowerFileName.EndsWith('.tiff') or LowerFileName.EndsWith('.tif') or LowerFileName.EndsWith('.gif') or LowerFileName.EndsWith('.svg') or LowerFileName.EndsWith('.webp') or LowerFileName.EndsWith('.avif') or LowerFileName.EndsWith('.ico')); end; [EventSubscriber(ObjectType::Table, Database::"Customer", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeleteCustomer(var Rec: Record Customer; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Sales Header", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeleteSalesHeader(var Rec: Record "Sales Header"; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeleteSalesLine(var Rec: Record "Sales Line"; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Sales Cr.Memo Header", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeleteSalesCreditMemoHeader(var Rec: Record "Sales Cr.Memo Header"; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Sales Cr.Memo Line", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeleteSalesCreditMemoLine(var Rec: Record "Sales Cr.Memo Line"; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Sales Invoice Header", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeleteSalesInvoiceHeader(var Rec: Record "Sales Invoice Header"; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Sales Invoice Line", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeleteSalesInvoiceLine(var Rec: Record "Sales Invoice Line"; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Purch. Inv. Header", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeletePurchInvHeader(var Rec: Record "Purch. Inv. Header"; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Purch. Inv. Line", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeletePurchInvLine(var Rec: Record "Purch. Inv. Line"; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Purch. Cr. Memo Hdr.", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeletePurchCreditMemoHeader(var Rec: Record "Purch. Cr. Memo Hdr."; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Purch. Cr. Memo Line", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeletePurchCreditMemoLine(var Rec: Record "Purch. Cr. Memo Line"; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Quote to Order", 'OnBeforeDeleteSalesQuote', '', false, false)] local procedure DocAttachFlowFromSalesQuoteToSalesOrder(var QuoteSalesHeader: Record "Sales Header"; var OrderSalesHeader: Record "Sales Header") var FromRecRef: RecordRef; ToRecRef: RecordRef; begin if QuoteSalesHeader."No." = '' then exit; if QuoteSalesHeader.IsTemporary() then exit; if OrderSalesHeader."No." = '' then exit; if OrderSalesHeader.IsTemporary() then exit; FromRecRef.GetTable(QuoteSalesHeader); ToRecRef.GetTable(OrderSalesHeader); CopyAttachments(FromRecRef, ToRecRef); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Blanket Sales Order to Order", 'OnBeforeInsertSalesOrderHeader', '', false, false)] local procedure DocAttachFlowForSalesHeaderFromBlanketOrderToSalesOrder(var SalesOrderHeader: Record "Sales Header"; BlanketOrderSalesHeader: Record "Sales Header") var FromRecRef: RecordRef; ToRecRef: RecordRef; RecRef: RecordRef; begin // Invoked when a sales order is created from blanket sales order // Need to delete docs that came from customer to sales header and copy docs from blanket sales header if SalesOrderHeader."No." = '' then exit; if SalesOrderHeader.IsTemporary() then exit; if BlanketOrderSalesHeader."No." = '' then exit; if BlanketOrderSalesHeader.IsTemporary() then exit; RecRef.GetTable(SalesOrderHeader); DeleteAttachedDocuments(RecRef); // Copy docs for sales header from blanket order to sales order FromRecRef.GetTable(BlanketOrderSalesHeader); ToRecRef.GetTable(SalesOrderHeader); CopyAttachments(FromRecRef, ToRecRef); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Blanket Sales Order to Order", 'OnAfterInsertSalesOrderLine', '', false, false)] local procedure DocAttachFlowForSalesLinesFromBlanketOrderToSalesOrder(var SalesOrderLine: Record "Sales Line"; SalesOrderHeader: Record "Sales Header"; BlanketOrderSalesLine: Record "Sales Line"; BlanketOrderSalesHeader: Record "Sales Header") var FromRecRef: RecordRef; ToRecRef: RecordRef; RecRef: RecordRef; begin // Invoked when a sales order line is created from blanket sales order line // Need to delete docs that came from item to sale item for sales order line and copy docs from blanket sales order line if SalesOrderLine."No." = '' then exit; if SalesOrderLine.IsTemporary() then exit; if BlanketOrderSalesLine."No." = '' then exit; if BlanketOrderSalesLine.IsTemporary() then exit; RecRef.GetTable(SalesOrderLine); DeleteAttachedDocuments(RecRef); FromRecRef.GetTable(BlanketOrderSalesLine); ToRecRef.GetTable(SalesOrderLine); CopyAttachments(FromRecRef, ToRecRef); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Quote to Invoice", 'OnBeforeDeletionOfQuote', '', false, false)] local procedure DocAttachFlowForSalesHeaderFromSalesQuoteToSalesInvoice(var SalesHeader: Record "Sales Header"; var SalesInvoiceHeader: Record "Sales Header") var FromRecRef: RecordRef; ToRecRef: RecordRef; begin if SalesHeader."No." = '' then exit; if SalesHeader.IsTemporary() then exit; if SalesInvoiceHeader."No." = '' then exit; if SalesInvoiceHeader.IsTemporary() then exit; FromRecRef.GetTable(SalesHeader); ToRecRef.GetTable(SalesInvoiceHeader); CopyAttachments(FromRecRef, ToRecRef); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Quote to Invoice", 'OnBeforeInsertSalesInvoiceLine', '', false, false)] local procedure DocAttachFlowForSalesLinesFromSalesQuoteToSalesInvoice(SalesQuoteLine: Record "Sales Line"; SalesQuoteHeader: Record "Sales Header"; var SalesInvoiceLine: Record "Sales Line"; SalesInvoiceHeader: Record "Sales Header") var FromRecRef: RecordRef; ToRecRef: RecordRef; begin // Copying sales line items from sales quote to a sales invoice if SalesInvoiceLine."No." = '' then exit; if SalesInvoiceLine.IsTemporary() then exit; FromRecRef.GetTable(SalesQuoteLine); ToRecRef.GetTable(SalesInvoiceLine); CopyAttachments(FromRecRef, ToRecRef); end; [EventSubscriber(ObjectType::Table, Database::"Sales Header", 'OnAfterInsertEvent', '', false, false)] local procedure DocAttachFlowForSalesHeaderInsert(var Rec: Record "Sales Header"; RunTrigger: Boolean) var Customer: Record Customer; FromRecRef: RecordRef; ToRecRef: RecordRef; begin // If quote no. is NOT empty that means this sales header came from an existing quote // In this case we need to exit out if Rec."Quote No." <> '' then exit; if Rec."No." = '' then exit; if Rec.IsTemporary() then exit; if not Customer.Get(Rec."Sell-to Customer No.") then exit; FromRecRef.GetTable(Customer); ToRecRef.GetTable(Rec); CopyAttachments(FromRecRef, ToRecRef); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Quote to Order", 'OnAfterInsertSalesOrderLine', '', false, false)] local procedure DocAttachFlowForSalesQuoteToSalesOrderSalesLines(var SalesOrderLine: Record "Sales Line"; SalesOrderHeader: Record "Sales Header"; SalesQuoteLine: Record "Sales Line"; SalesQuoteHeader: Record "Sales Header") var FromRecRef: RecordRef; ToRecRef: RecordRef; begin // Copying sales line items from quote to an order if SalesOrderLine."No." = '' then exit; if SalesOrderLine.IsTemporary() then exit; FromRecRef.GetTable(SalesQuoteLine); ToRecRef.GetTable(SalesOrderLine); CopyAttachments(FromRecRef, ToRecRef); end; [EventSubscriber(ObjectType::Table, Database::"Sales Header", 'OnAfterValidateEvent', 'Sell-to Customer No.', false, false)] local procedure DocAttachFlowForSalesHeaderCustomerChg(var Rec: Record "Sales Header"; var xRec: Record "Sales Header"; CurrFieldNo: Integer) var RecRef: RecordRef; begin if Rec."No." = '' then exit; if Rec.IsTemporary() then exit; RecRef.GetTable(Rec); if (Rec."Sell-to Customer No." <> xRec."Sell-to Customer No.") and (xRec."Sell-to Customer No." <> '') then DeleteAttachedDocumentsWithConfirm(RecRef); DocAttachFlowForSalesHeaderInsert(Rec, true); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Copy Document Mgt.", 'OnAfterCopySalesHeader', '', false, false)] local procedure DocAttachFlowForCopyDocumentSalesHeader(ToSalesHeader: Record "Sales Header"; OldSalesHeader: Record "Sales Header") begin DocAttachFlowForSalesHeaderCustomerChg(ToSalesHeader, OldSalesHeader, 0); end; [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnAfterInsertEvent', '', false, false)] local procedure DocAttachFlowForSalesLineInsert(var Rec: Record "Sales Line"; RunTrigger: Boolean) var Item: Record Item; SalesHeader: Record "Sales Header"; FromRecRef: RecordRef; ToRecRef: RecordRef; begin if Rec."Line No." = 0 then exit; if Rec.IsTemporary() then exit; if Rec.Type <> Rec.Type::Item then exit; // Skipping if the parent sales header came from a quote if SalesHeader.Get(Rec."Document Type", Rec."Document No.") then if SalesHeader."Quote No." <> '' then exit; if not Item.Get(Rec."No.") then exit; FromRecRef.GetTable(Item); ToRecRef.GetTable(Rec); CopyAttachments(FromRecRef, ToRecRef); end; [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnAfterValidateEvent', 'No.', false, false)] local procedure DocAttachFlowForSalesLineItemChg(var Rec: Record "Sales Line"; var xRec: Record "Sales Line"; CurrFieldNo: Integer) var xRecRef: RecordRef; begin if Rec."Line No." = 0 then exit; if Rec.IsTemporary() then exit; xRecRef.GetTable(xRec); if (Rec."No." <> xRec."No.") and (xRec."No." <> '') then DeleteAttachedDocuments(xRecRef); DocAttachFlowForSalesLineInsert(Rec, true); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Post", 'OnBeforeDeleteAfterPosting', '', false, false)] local procedure DocAttachForPostedSalesDocs(var SalesHeader: Record "Sales Header"; var SalesInvoiceHeader: Record "Sales Invoice Header"; var SalesCrMemoHeader: Record "Sales Cr.Memo Header") var FromRecRef: RecordRef; ToRecRef: RecordRef; IsHandled: Boolean; begin IsHandled := false; OnBeforeDocAttachForPostedSalesDocs(SalesHeader, SalesInvoiceHeader, SalesCrMemoHeader, IsHandled); if IsHandled then exit; // Triggered when a posted sales cr. memo / posted sales invoice is created if SalesHeader.IsTemporary() then exit; if SalesInvoiceHeader.IsTemporary() then exit; if SalesCrMemoHeader.IsTemporary() then exit; FromRecRef.GetTable(SalesHeader); if SalesInvoiceHeader."No." <> '' then ToRecRef.GetTable(SalesInvoiceHeader); if SalesCrMemoHeader."No." <> '' then ToRecRef.GetTable(SalesCrMemoHeader); CopyAttachmentsForPostedDocs(FromRecRef, ToRecRef); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Purch.-Post", 'OnBeforeDeleteAfterPosting', '', false, false)] local procedure DocAttachForPostedPurchaseDocs(var PurchaseHeader: Record "Purchase Header"; var PurchInvHeader: Record "Purch. Inv. Header"; var PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr."; var PurchRcptHeader: Record "Purch. Rcpt. Header") var FromRecRef: RecordRef; ToRecRef: RecordRef; IsHandled: Boolean; begin IsHandled := false; OnBeforeDocAttachForPostedPurchaseDocs(PurchaseHeader, PurchInvHeader, PurchCrMemoHdr, PurchRcptHeader, IsHandled); if IsHandled then exit; // Triggered when a posted purchase cr. memo / posted purchase invoice is created if PurchaseHeader.IsTemporary() then exit; if PurchInvHeader.IsTemporary() then exit; if PurchCrMemoHdr.IsTemporary() then exit; if PurchRcptHeader.IsTemporary() then exit; FromRecRef.GetTable(PurchaseHeader); if PurchInvHeader."No." <> '' then begin ToRecRef.GetTable(PurchInvHeader); CopyAttachmentsForPostedDocs(FromRecRef, ToRecRef); end; if PurchCrMemoHdr."No." <> '' then begin ToRecRef.GetTable(PurchCrMemoHdr); CopyAttachmentsForPostedDocs(FromRecRef, ToRecRef); end; if PurchRcptHeader."No." <> '' then begin ToRecRef.GetTable(PurchRcptHeader); CopyAttachmentsForPostedDocs(FromRecRef, ToRecRef); end; end; [EventSubscriber(ObjectType::Table, Database::"Vendor", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeleteVendor(var Rec: Record Vendor; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Purchase Header", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeletePurchaseHeader(var Rec: Record "Purchase Header"; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Purchase Line", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeletePurchaseLine(var Rec: Record "Purchase Line"; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Purchase Header", 'OnAfterInsertEvent', '', false, false)] local procedure DocAttachFlowForPurchaseHeaderInsert(var Rec: Record "Purchase Header"; RunTrigger: Boolean) var Vendor: Record Vendor; FromRecRef: RecordRef; ToRecRef: RecordRef; begin // If quote no. is NOT empty that means this purchase header came from an existing quote // In this case we need to exit out if Rec."Quote No." <> '' then exit; if Rec."No." = '' then exit; if Rec.IsTemporary() then exit; if not Vendor.Get(Rec."Buy-from Vendor No.") then exit; FromRecRef.GetTable(Vendor); ToRecRef.GetTable(Rec); CopyAttachments(FromRecRef, ToRecRef); end; [EventSubscriber(ObjectType::Table, Database::"Purchase Header", 'OnAfterValidateEvent', 'Buy-from Vendor No.', false, false)] local procedure DocAttachFlowForPurchaseHeaderVendorChange(var Rec: Record "Purchase Header"; var xRec: Record "Purchase Header"; CurrFieldNo: Integer) var RecRef: RecordRef; begin if Rec."No." = '' then exit; if Rec.IsTemporary() then exit; RecRef.GetTable(Rec); if (Rec."Buy-from Vendor No." <> xRec."Buy-from Vendor No.") and (xRec."Buy-from Vendor No." <> '') then DeleteAttachedDocumentsWithConfirm(RecRef); DocAttachFlowForPurchaseHeaderInsert(Rec, true); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Copy Document Mgt.", 'OnAfterCopyPurchaseHeader', '', false, false)] local procedure DocAttachFlowForCopyDocumentPurchHeader(ToPurchaseHeader: Record "Purchase Header"; OldPurchaseHeader: Record "Purchase Header") begin DocAttachFlowForPurchaseHeaderVendorChange(ToPurchaseHeader, OldPurchaseHeader, 0); end; [EventSubscriber(ObjectType::Table, Database::"Purchase Line", 'OnAfterInsertEvent', '', false, false)] local procedure DocAttachFlowForPurchaseLineInsert(var Rec: Record "Purchase Line"; RunTrigger: Boolean) var Item: Record Item; FromRecRef: RecordRef; ToRecRef: RecordRef; begin if Rec."Line No." = 0 then exit; if Rec.IsTemporary() then exit; if Rec.Type <> Rec.Type::Item then exit; if not Item.Get(Rec."No.") then exit; FromRecRef.GetTable(Item); ToRecRef.GetTable(Rec); CopyAttachments(FromRecRef, ToRecRef); end; [EventSubscriber(ObjectType::Table, Database::"Purchase Line", 'OnAfterValidateEvent', 'No.', false, false)] local procedure DocAttachFlowForPurchaseLineItemChg(var Rec: Record "Purchase Line"; var xRec: Record "Purchase Line"; CurrFieldNo: Integer) var xRecRef: RecordRef; begin if Rec."Line No." = 0 then exit; if Rec.IsTemporary() then exit; xRecRef.GetTable(xRec); if (Rec."No." <> xRec."No.") and (xRec."No." <> '') then DeleteAttachedDocuments(xRecRef); DocAttachFlowForPurchaseLineInsert(Rec, true); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Purch.-Quote to Order", 'OnBeforeDeletePurchQuote', '', false, false)] local procedure DocAttachFlowForPurchQuoteToPurchOrder(var QuotePurchHeader: Record "Purchase Header"; var OrderPurchHeader: Record "Purchase Header") var FromRecRef: RecordRef; ToRecRef: RecordRef; begin if QuotePurchHeader."No." = '' then exit; if QuotePurchHeader.IsTemporary() then exit; if OrderPurchHeader."No." = '' then exit; if OrderPurchHeader.IsTemporary() then exit; FromRecRef.GetTable(QuotePurchHeader); ToRecRef.GetTable(OrderPurchHeader); CopyAttachments(FromRecRef, ToRecRef); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Purch.-Quote to Order", 'OnAfterInsertPurchOrderLine', '', false, false)] local procedure DocAttachFlowForPurchQuoteToPurchOrderLines(var PurchaseQuoteLine: Record "Purchase Line"; var PurchaseOrderLine: Record "Purchase Line") var FromRecRef: RecordRef; ToRecRef: RecordRef; begin // Copying purchase line items from quote to an order if PurchaseOrderLine."No." = '' then exit; if PurchaseOrderLine.IsTemporary() then exit; FromRecRef.GetTable(PurchaseQuoteLine); ToRecRef.GetTable(PurchaseOrderLine); CopyAttachments(FromRecRef, ToRecRef); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Blanket Purch. Order to Order", 'OnBeforePurchOrderHeaderModify', '', false, false)] local procedure DocAttachFlowForBlanketPurchaseHeader(var PurchOrderHeader: Record "Purchase Header"; BlanketOrderPurchHeader: Record "Purchase Header") var FromRecRef: RecordRef; ToRecRef: RecordRef; RecRef: RecordRef; begin // Invoked when a purchase order is created from blanket purchase order // Need to delete docs that came from vendor to purchase header and copy docs from blanket purchase header if PurchOrderHeader."No." = '' then exit; if PurchOrderHeader.IsTemporary() then exit; if BlanketOrderPurchHeader."No." = '' then exit; if BlanketOrderPurchHeader.IsTemporary() then exit; RecRef.GetTable(PurchOrderHeader); DeleteAttachedDocuments(RecRef); // Copy docs for purchase header from blanket order to purchase order FromRecRef.GetTable(BlanketOrderPurchHeader); ToRecRef.GetTable(PurchOrderHeader); CopyAttachments(FromRecRef, ToRecRef); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Blanket Purch. Order to Order", 'OnBeforeInsertPurchOrderLine', '', false, false)] local procedure DocAttachFlowForBlanketPurchaseLine(var PurchOrderLine: Record "Purchase Line"; PurchOrderHeader: Record "Purchase Header"; BlanketOrderPurchLine: Record "Purchase Line"; BlanketOrderPurchHeader: Record "Purchase Header") var FromRecRef: RecordRef; ToRecRef: RecordRef; RecRef: RecordRef; begin // Invoked when a purch order line is created from blanket purch order line // Need to delete docs that came from item to purch item for purch order line and copy docs from blanket purch order line if PurchOrderLine."No." = '' then exit; if PurchOrderLine.IsTemporary() then exit; if BlanketOrderPurchLine."No." = '' then exit; if BlanketOrderPurchLine.IsTemporary() then exit; RecRef.GetTable(PurchOrderLine); DeleteAttachedDocuments(RecRef); FromRecRef.GetTable(BlanketOrderPurchLine); ToRecRef.GetTable(PurchOrderLine); CopyAttachments(FromRecRef, ToRecRef); end; [EventSubscriber(ObjectType::Table, Database::"Item", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeleteItem(var Rec: Record Item; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Resource", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeleteResource(var Rec: Record Resource; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Job", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeleteJob(var Rec: Record Job; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Employee", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeleteEmployee(var Rec: Record Employee; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Fixed Asset", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeleteFixedAsset(var Rec: Record "Fixed Asset"; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::Opportunity, OnAfterDeleteEvent, '', false, false)] local procedure DeleteAttachedDocumentsOnAfterDeleteOpportunity(var Rec: Record Opportunity; RunTrigger: Boolean) var RecRef: RecordRef; begin RecRef.GetTable(Rec); DeleteAttachedDocuments(RecRef); end; [EventSubscriber(ObjectType::Table, Database::"Customer", 'OnAfterRenameEvent', '', false, false)] local procedure MoveAttachedDocumentsOnAfterRenameCustomer(var Rec: Record Customer; var xRec: Record Customer; RunTrigger: Boolean) var MoveFromRecRef: RecordRef; MoveToRecRef: RecordRef; begin // Moves attached docs when an Customer record is renamed [When No. is changed] from old to new rec MoveFromRecRef.GetTable(xRec); MoveToRecRef.GetTable(Rec); MoveAttachmentsWithinSameRecordType(MoveFromRecRef, MoveToRecRef); end; [EventSubscriber(ObjectType::Table, Database::"Vendor", 'OnAfterRenameEvent', '', false, false)] local procedure MoveAttachedDocumentsOnAfterRenameVendor(var Rec: Record Vendor; var xRec: Record Vendor; RunTrigger: Boolean) var MoveFromRecRef: RecordRef; MoveToRecRef: RecordRef; begin // Moves attached docs when an Vendor record is renamed [When No. is changed] from old to new rec MoveFromRecRef.GetTable(xRec); MoveToRecRef.GetTable(Rec); MoveAttachmentsWithinSameRecordType(MoveFromRecRef, MoveToRecRef); end; [EventSubscriber(ObjectType::Table, Database::"Item", 'OnAfterRenameEvent', '', false, false)] local procedure MoveAttachedDocumentsOnAfterRenameItem(var Rec: Record Item; var xRec: Record Item; RunTrigger: Boolean) var MoveFromRecRef: RecordRef; MoveToRecRef: RecordRef; begin // Moves attached docs when an Item record is renamed [When item no. is changed] from old to new rec MoveFromRecRef.GetTable(xRec); MoveToRecRef.GetTable(Rec); MoveAttachmentsWithinSameRecordType(MoveFromRecRef, MoveToRecRef); end; [EventSubscriber(ObjectType::Table, Database::"Employee", 'OnAfterRenameEvent', '', false, false)] local procedure MoveAttachedDocumentsOnAfterRenameEmployee(var Rec: Record Employee; var xRec: Record Employee; RunTrigger: Boolean) var MoveFromRecRef: RecordRef; MoveToRecRef: RecordRef; begin // Moves attached docs when an Employee record is renamed [When No. is changed] from old to new rec MoveFromRecRef.GetTable(xRec); MoveToRecRef.GetTable(Rec); MoveAttachmentsWithinSameRecordType(MoveFromRecRef, MoveToRecRef); end; [EventSubscriber(ObjectType::Table, Database::"Fixed Asset", 'OnAfterRenameEvent', '', false, false)] local procedure MoveAttachedDocumentsOnAfterRenameFixedAsset(var Rec: Record "Fixed Asset"; var xRec: Record "Fixed Asset"; RunTrigger: Boolean) var MoveFromRecRef: RecordRef; MoveToRecRef: RecordRef; begin // Moves attached docs when an Fixed Asset record is renamed [When No. is changed] from old to new rec MoveFromRecRef.GetTable(xRec); MoveToRecRef.GetTable(Rec); MoveAttachmentsWithinSameRecordType(MoveFromRecRef, MoveToRecRef); end; [EventSubscriber(ObjectType::Table, Database::"Resource", 'OnAfterRenameEvent', '', false, false)] local procedure MoveAttachedDocumentsOnAfterRenameResource(var Rec: Record Resource; var xRec: Record Resource; RunTrigger: Boolean) var MoveFromRecRef: RecordRef; MoveToRecRef: RecordRef; begin // Moves attached docs when an Resource record is renamed [When No. is changed] from old to new rec MoveFromRecRef.GetTable(xRec); MoveToRecRef.GetTable(Rec); MoveAttachmentsWithinSameRecordType(MoveFromRecRef, MoveToRecRef); end; [EventSubscriber(ObjectType::Table, Database::"Job", 'OnAfterRenameEvent', '', false, false)] local procedure MoveAttachedDocumentsOnAfterRenameJob(var Rec: Record Job; var xRec: Record Job; RunTrigger: Boolean) var MoveFromRecRef: RecordRef; MoveToRecRef: RecordRef; begin // Moves attached docs when an Job record is renamed [When No. is changed] from old to new rec MoveFromRecRef.GetTable(xRec); MoveToRecRef.GetTable(Rec); MoveAttachmentsWithinSameRecordType(MoveFromRecRef, MoveToRecRef); end; [EventSubscriber(ObjectType::Table, Database::Opportunity, OnAfterRenameEvent, '', false, false)] local procedure MoveAttachedDocumentsOnAfterRenameOpportunity(var Rec: Record Opportunity; var xRec: Record Opportunity; RunTrigger: Boolean) var MoveFromRecRef: RecordRef; MoveToRecRef: RecordRef; begin // Moves attached docs when an Opportunity record is renamed [When No. is changed] from old to new rec MoveFromRecRef.GetTable(xRec); MoveToRecRef.GetTable(Rec); MoveAttachmentsWithinSameRecordType(MoveFromRecRef, MoveToRecRef); end; procedure IsDuplicateFile(TableID: Integer; DocumentNo: Code[20]; AttachmentDocumentType: Enum "Attachment Document Type"; RecLineNo: Integer; FileName: Text; FileExtension: Text): Boolean var DocumentAttachment: Record "Document Attachment"; begin DocumentAttachment.SetRange("Table ID", TableID); DocumentAttachment.SetRange("No.", DocumentNo); DocumentAttachment.SetRange("Document Type", AttachmentDocumentType); DocumentAttachment.SetRange("Line No.", RecLineNo); DocumentAttachment.SetRange("File Name", FileName); DocumentAttachment.SetRange("File Extension", FileExtension); OnIsDuplicateFileOnAfterSetFilters(DocumentAttachment); if not DocumentAttachment.IsEmpty() then exit(true); exit(false); end; procedure CopyAttachments(FromRec: Variant; ToRec: Variant) var FromRecRef: RecordRef; ToRecRef: RecordRef; begin FromRecRef.GetTable(FromRec); ToRecRef.GetTable(ToRec); CopyAttachments(FromRecRef, ToRecRef); end; procedure CopyAttachments(var FromRecRef: RecordRef; var ToRecRef: RecordRef) var FromDocumentAttachment: Record "Document Attachment"; ToDocumentAttachment: Record "Document Attachment"; ToDocumentAttachment2: Record "Document Attachment"; FromFieldRef: FieldRef; ToFieldRef: FieldRef; FromAttachmentDocumentType: Enum "Attachment Document Type"; FromLineNo: Integer; FromNo: Code[20]; ToNo: Code[20]; ToAttachmentDocumentType: Enum "Attachment Document Type"; ToLineNo: Integer; IsHandled: Boolean; begin IsHandled := false; OnBeforeCopyAttachments(FromRecRef, ToRecRef, IsHandled); if IsHandled then exit; FromDocumentAttachment.SetRange("Table ID", FromRecRef.Number); if FromDocumentAttachment.IsEmpty() then exit; case FromRecRef.Number() of Database::Customer, Database::Vendor, Database::Item: begin FromFieldRef := FromRecRef.Field(1); FromNo := FromFieldRef.Value(); FromDocumentAttachment.SetRange("No.", FromNo); end; Database::"Sales Header", Database::"Purchase Header": begin FromFieldRef := FromRecRef.Field(1); FromAttachmentDocumentType := FromFieldRef.Value(); FromDocumentAttachment.SetRange("Document Type", FromAttachmentDocumentType); FromFieldRef := FromRecRef.Field(3); FromNo := FromFieldRef.Value(); FromDocumentAttachment.SetRange("No.", FromNo); end; Database::"Sales Line", Database::"Purchase Line": begin FromFieldRef := FromRecRef.Field(1); FromAttachmentDocumentType := FromFieldRef.Value(); FromDocumentAttachment.SetRange("Document Type", FromAttachmentDocumentType); FromFieldRef := FromRecRef.Field(3); FromNo := FromFieldRef.Value(); FromDocumentAttachment.SetRange("No.", FromNo); FromFieldRef := FromRecRef.Field(4); FromLineNo := FromFieldRef.Value(); FromDocumentAttachment.SetRange("Line No.", FromLineNo); end; end; OnCopyAttachmentsOnAfterSetFromParameters(FromRecRef, FromDocumentAttachment, FromAttachmentDocumentType); case ToRecRef.Number() of Database::"Sales Line": if FromRecRef.Number() <> Database::"Sales Line" then FromDocumentAttachment.SetRange("Document Flow Sales", true); Database::"Sales Header": if FromRecRef.Number() <> Database::"Sales Header" then FromDocumentAttachment.SetRange("Document Flow Sales", true); Database::"Purchase Line": if FromRecRef.Number() <> Database::"Purchase Line" then FromDocumentAttachment.SetRange("Document Flow Purchase", true); Database::"Purchase Header": if FromRecRef.Number() <> Database::"Purchase Header" then FromDocumentAttachment.SetRange("Document Flow Purchase", true); end; OnCopyAttachmentsOnAfterSetDocumentFlowFilter(FromDocumentAttachment, FromRecRef, ToRecRef); if FromDocumentAttachment.FindSet() then begin case ToRecRef.Number() of Database::"Sales Header", Database::"Purchase Header": begin ToFieldRef := ToRecRef.Field(1); ToAttachmentDocumentType := ToFieldRef.Value(); ToFieldRef := ToRecRef.Field(3); ToNo := ToFieldRef.Value(); end; Database::"Sales Line", Database::"Purchase Line": begin ToFieldRef := ToRecRef.Field(1); ToAttachmentDocumentType := ToFieldRef.Value(); ToFieldRef := ToRecRef.Field(3); ToNo := ToFieldRef.Value(); ToFieldRef := ToRecRef.Field(4); ToLineNo := ToFieldRef.Value(); end; end; OnCopyAttachmentsOnAfterSetToParameters(ToDocumentAttachment, ToRecRef, ToFieldRef, ToNo, ToLineNo, ToAttachmentDocumentType); repeat if not SkipDuplicateToDocumentAttachmentIDOnCopyFromOrderToInvoice(ToRecRef, FromDocumentAttachment, FromAttachmentDocumentType, ToAttachmentDocumentType, ToNo, ToLineNo) then begin Clear(ToDocumentAttachment); ToDocumentAttachment.Init(); ToDocumentAttachment.TransferFields(FromDocumentAttachment); ToDocumentAttachment.Validate("Table ID", ToRecRef.Number); ToDocumentAttachment.Validate("No.", ToNo); case ToRecRef.Number() of Database::"Sales Header", Database::"Purchase Header": ToDocumentAttachment.Validate("Document Type", ToAttachmentDocumentType); Database::"Sales Line", Database::"Purchase Line": begin ToDocumentAttachment.Validate("Document Type", ToAttachmentDocumentType); ToDocumentAttachment.Validate("Line No.", ToLineNo); end; end; OnCopyAttachmentsOnAfterSetToDocumentFilters(ToDocumentAttachment, ToRecRef, ToAttachmentDocumentType, ToNo, ToLineNo); if not ToDocumentAttachment.Insert(true) then begin ToDocumentAttachment2 := ToDocumentAttachment; ToDocumentAttachment.Find('='); ToDocumentAttachment.TransferFields(ToDocumentAttachment2, false); end; ToDocumentAttachment."Attached Date" := FromDocumentAttachment."Attached Date"; ToDocumentAttachment.Modify(); end; until FromDocumentAttachment.Next() = 0; end; // Copies attachments for header and then calls CopyAttachmentsForPostedDocsLines to copy attachments for lines. end; local procedure SkipDuplicateToDocumentAttachmentIDOnCopyFromOrderToInvoice(var ToRecordRef: RecordRef; FromDocumentAttachment: Record "Document Attachment"; FromAttachmentDocumentType: Enum "Attachment Document Type"; ToAttachmentDocumentType: Enum "Attachment Document Type"; ToNo: Code[20]; ToLineNo: Integer): Boolean; var ToDocumentAttachment: Record "Document Attachment"; begin if (FromAttachmentDocumentType <> FromAttachmentDocumentType::Order) or (ToAttachmentDocumentType <> ToAttachmentDocumentType::Invoice) then exit(false); case true of TableIsDocumentHeader(ToRecordRef.Number()): begin ToDocumentAttachment.SetRange("Table ID", ToRecordRef.Number()); ToDocumentAttachment.SetRange("Document Type", ToAttachmentDocumentType); ToDocumentAttachment.SetRange("No.", ToNo); ToDocumentAttachment.SetRange(ID, FromDocumentAttachment.ID); if not ToDocumentAttachment.IsEmpty() then exit(true); end; TableIsDocumentLine(ToRecordRef.Number()): begin ToDocumentAttachment.SetRange("Table ID", ToRecordRef.Number()); ToDocumentAttachment.SetRange("Document Type", ToAttachmentDocumentType); ToDocumentAttachment.SetRange("No.", ToNo); ToDocumentAttachment.SetRange("Line No.", ToLineNo); ToDocumentAttachment.SetRange(ID, FromDocumentAttachment.ID); if not ToDocumentAttachment.IsEmpty() then exit(true); end; else exit(false); end; exit(false); end; local procedure TableIsDocumentHeader(TableNo: Integer) IsHeader: Boolean begin IsHeader := TableNo in [Database::"Sales Header", Database::"Purchase Header"]; OnAfterTableIsDocumentHeader(TableNo, IsHeader); end; local procedure TableIsDocumentLine(TableNo: Integer) IsHeader: Boolean begin IsHeader := TableNo in [Database::"Sales Line", Database::"Purchase Line"]; OnAfterTableIsDocumentLine(TableNo, IsHeader); end; procedure CopyAttachmentsForPostedDocs(var FromRecRef: RecordRef; var ToRecRef: RecordRef) var FromDocumentAttachment: Record "Document Attachment"; ToDocumentAttachment: Record "Document Attachment"; FromFieldRef: FieldRef; ToFieldRef: FieldRef; FromAttachmentDocumentType: Enum "Attachment Document Type"; FromNo: Code[20]; ToNo: Code[20]; IsHandled: Boolean; begin IsHandled := false; OnBeforeCopyAttachmentsForPostedDocsLines(FromRecRef, ToRecRef, IsHandled); if IsHandled then exit; FromDocumentAttachment.SetRange("Table ID", FromRecRef.Number); FromFieldRef := FromRecRef.Field(1); FromAttachmentDocumentType := FromFieldRef.Value(); TransformAttachmentDocumentTypeValue(FromRecRef.Number(), FromAttachmentDocumentType); FromDocumentAttachment.SetRange("Document Type", FromAttachmentDocumentType); FromFieldRef := FromRecRef.Field(3); FromNo := FromFieldRef.Value(); FromDocumentAttachment.SetRange("No.", FromNo); // Find any attached docs for headers (sales / purchase / service) if FromDocumentAttachment.FindSet() then repeat Clear(ToDocumentAttachment); ToDocumentAttachment.Init(); ToDocumentAttachment.TransferFields(FromDocumentAttachment); ToDocumentAttachment.Validate("Table ID", ToRecRef.Number); ToFieldRef := ToRecRef.Field(3); ToNo := ToFieldRef.Value(); ToDocumentAttachment.Validate("No.", ToNo); SetDocumentTypeForPostedDocument(ToDocumentAttachment, ToRecRef.Number); OnCopyAttachmentsForPostedDocsOnBeforeToDocumentAttachmentInsert(FromDocumentAttachment, ToDocumentAttachment); ToDocumentAttachment.Insert(true); OnCopyAttachmentsForPostedDocsOnAfterToDocumentAttachmentInsert(FromDocumentAttachment, ToDocumentAttachment); until FromDocumentAttachment.Next() = 0; CopyAttachmentsForPostedDocsLines(FromRecRef, ToRecRef); end; procedure CopyAttachmentsForPostedDocsLines(var FromRecRef: RecordRef; var ToRecRef: RecordRef) var FromDocumentAttachmentLine: Record "Document Attachment"; ToDocumentAttachmentLine: Record "Document Attachment"; FromFieldRef: FieldRef; ToFieldRef: FieldRef; FromAttachmentDocumentType: Enum "Attachment Document Type"; FromNo: Code[20]; ToNo: Code[20]; begin FromFieldRef := FromRecRef.Field(3); FromNo := FromFieldRef.Value(); FromDocumentAttachmentLine.Reset(); FromFieldRef := FromRecRef.Field(1); FromAttachmentDocumentType := FromFieldRef.Value(); TransformAttachmentDocumentTypeValue(FromRecRef.Number(), FromAttachmentDocumentType); FromDocumentAttachmentLine.SetRange("Document Type", FromAttachmentDocumentType); ToFieldRef := ToRecRef.Field(3); ToNo := ToFieldRef.Value(); case FromRecRef.Number() of Database::"Sales Header": FromDocumentAttachmentLine.SetRange("Table ID", Database::"Sales Line"); Database::"Purchase Header": FromDocumentAttachmentLine.SetRange("Table ID", Database::"Purchase Line"); end; FromDocumentAttachmentLine.SetRange("No.", FromNo); FromDocumentAttachmentLine.SetRange("Document Type", FromAttachmentDocumentType); OnCopyAttachmentsForPostedDocsLinesOnAfterSetFromFilters(FromRecRef, FromDocumentAttachmentLine); if FromDocumentAttachmentLine.FindSet() then repeat ToDocumentAttachmentLine.TransferFields(FromDocumentAttachmentLine); case ToRecRef.Number of Database::"Sales Invoice Header": ToDocumentAttachmentLine.Validate("Table ID", Database::"Sales Invoice Line"); Database::"Sales Cr.Memo Header": ToDocumentAttachmentLine.Validate("Table ID", Database::"Sales Cr.Memo Line"); Database::"Purch. Inv. Header": ToDocumentAttachmentLine.Validate("Table ID", Database::"Purch. Inv. Line"); Database::"Purch. Cr. Memo Hdr.": ToDocumentAttachmentLine.Validate("Table ID", Database::"Purch. Cr. Memo Line"); end; OnCopyAttachmentsForPostedDocsLinesOnAfterSetToTableID(ToRecRef, ToDocumentAttachmentLine); SetDocumentTypeForPostedDocument(ToDocumentAttachmentLine, ToRecRef.Number); ToDocumentAttachmentLine.Validate("No.", ToNo); if ToDocumentAttachmentLine.Insert(true) then; until FromDocumentAttachmentLine.Next() = 0; end; local procedure SetDocumentTypeForPostedDocument(var DocumentAttachment: Record "Document Attachment"; PostedDocumentTableID: Integer) var IsHandled: Boolean; begin OnBeforeSetDocumentTypeForPostedDocument(DocumentAttachment, PostedDocumentTableID, IsHandled); if IsHandled then exit; case PostedDocumentTableID of Database::"Sales Invoice Header", Database::"Purch. Inv. Header": DocumentAttachment.Validate("Document Type", DocumentAttachment."Document Type"::Invoice); Database::"Sales Cr.Memo Header", Database::"Purch. Cr. Memo Hdr.": DocumentAttachment.Validate("Document Type", DocumentAttachment."Document Type"::"Credit Memo"); else Clear(DocumentAttachment."Document Type"); end; end; procedure MoveAttachmentsWithinSameRecordType(var MoveFromRecRef: RecordRef; var MoveToRecRef: RecordRef) var DocumentAttachmentFound: Record "Document Attachment"; DocumentAttachmentToCreate: Record "Document Attachment"; MoveFromFieldRef: FieldRef; MoveToFieldRef: FieldRef; MoveFromRecNo: Code[20]; MoveToRecNo: Code[20]; begin // Moves attachments from one record to another for same type if MoveFromRecRef.Number() <> MoveToRecRef.Number() then exit; if MoveFromRecRef.IsTemporary() or MoveToRecRef.IsTemporary() then exit; DocumentAttachmentFound.SetRange("Table ID", MoveFromRecRef.Number); if TableIsEntity(MoveFromRecRef.Number) then begin MoveFromFieldRef := MoveFromRecRef.Field(1); MoveFromRecNo := MoveFromFieldRef.Value(); MoveToFieldRef := MoveToRecRef.Field(1); MoveToRecNo := MoveToFieldRef.Value(); DocumentAttachmentFound.SetRange("No.", MoveFromRecNo); end; // Find any attached docs to be moved if DocumentAttachmentFound.IsEmpty() then exit; // Create a copy of all found attachments with new number [MoveToRecNo] // Need to do this because MODIFY does not support renaming keys for a record. if DocumentAttachmentFound.FindSet() then repeat Clear(DocumentAttachmentToCreate); DocumentAttachmentToCreate.Init(); DocumentAttachmentToCreate.TransferFields(DocumentAttachmentFound); DocumentAttachmentToCreate.Validate("No.", MoveToRecNo); OnMoveAttachmentsWithinSameRecordTypeOnBeforeInsert(DocumentAttachmentToCreate, MoveToRecRef, MoveToRecNo); DocumentAttachmentToCreate.Insert(true); until DocumentAttachmentFound.Next() = 0; // Delete orphan attachments DocumentAttachmentFound.DeleteAll(true); end; local procedure TableIsEntity(TableNo: Integer) IsEntity: Boolean begin IsEntity := TableNo in [ Database::Customer, Database::Vendor, Database::Job, Database::Employee, Database::"Fixed Asset", Database::Resource, Database::Item, Database::Opportunity]; OnAfterTableIsEntity(TableNo, IsEntity); end; procedure ShowNotification(Variant: Variant; NumberOfReportsAttached: Integer; ShowAction: Boolean) begin if NumberOfReportsAttached > 0 then ShowDocPrintedToAttachmentNotification(Variant, ShowAction) else ShowNotFoundPrintableReportsNotification(Variant); end; procedure ShowDocPrintedToAttachmentNotification(Variant: Variant; ShowAction: Boolean) var DocumentAttachment: Record "Document Attachment"; NotificationLifecycleMgt: Codeunit "Notification Lifecycle Mgt."; Notification: Notification; RecRef: RecordRef; begin RecRef.GetTable(Variant); DocumentAttachment.InitFieldsFromRecRef(RecRef); Notification.Id := GetNotificationId(); Notification.Message := PrintedToAttachmentTxt; if ShowAction then Notification.AddAction(ShowAttachmentsTxt, Codeunit::"Document Attachment Mgmt", 'ShowDocumentAttachments'); Notification.SetData(DocumentAttachment.FieldName("Table ID"), Format(DocumentAttachment."Table ID")); Notification.SetData(DocumentAttachment.FieldName("Document Type"), Format(DocumentAttachment."Document Type")); Notification.SetData(DocumentAttachment.FieldName("No."), Format(DocumentAttachment."No.")); NotificationLifecycleMgt.SendNotificationWithAdditionalContext( Notification, RecRef.RecordId(), GetNotificationId()); end; procedure ShowNotFoundPrintableReportsNotification(Variant: Variant) var DocumentAttachment: Record "Document Attachment"; NotificationLifecycleMgt: Codeunit "Notification Lifecycle Mgt."; Notification: Notification; RecRef: RecordRef; begin RecRef.GetTable(Variant); DocumentAttachment.InitFieldsFromRecRef(RecRef); Notification.Id := GetNoPritableReportsNotificationId(); Notification.Message := NoSaveToPDFReportTxt; NotificationLifecycleMgt.SendNotification(Notification, RecRef.RecordId()); end; local procedure GetNotificationId(): Guid; begin exit('7D722415-F630-4ED5-B876-0372C1360C9F'); end; local procedure GetNoPritableReportsNotificationId(): Guid; begin exit('2E0AD887-8F86-4AD4-ADE9-846002434BFA'); end; procedure ShowDocumentAttachments(Notification: Notification); var DocumentAttachment: Record "Document Attachment"; TableId: Integer; DocumentNo: Code[20]; begin Evaluate(TableId, Notification.GetData(DocumentAttachment.FieldName("Table ID"))); Evaluate(DocumentAttachment."Document Type", Notification.GetData(DocumentAttachment.FieldName("Document Type"))); Evaluate(DocumentNo, Notification.GetData(DocumentAttachment.FieldName("No."))); DocumentAttachment.SetRange("Table ID", TableId); DocumentAttachment.SetRange("Document Type", DocumentAttachment."Document Type"); DocumentAttachment.SetRange("No.", DocumentNo); Page.RunModal(Page::"Document Attachment Details", DocumentAttachment); end; procedure DeleteAttachedDocuments(ForVariantRec: Variant; WithConfirm: Boolean) var ForRecordRef: RecordRef; begin ForRecordRef.GetTable(ForVariantRec); if WithConfirm then DeleteAttachedDocumentsWithConfirm(ForRecordRef) else DeleteAttachedDocuments(ForRecordRef); end; [IntegrationEvent(false, false)] local procedure OnAfterSetDocumentAttachmentFiltersForRecRef(var DocumentAttachment: Record "Document Attachment"; RecRef: RecordRef) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCopyAttachmentsForPostedDocsLines(var FromRecRef: RecordRef; var ToRecRef: RecordRef; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSetDocumentTypeForPostedDocument(var DocumentAttachment: Record "Document Attachment"; PostedDocumentTableID: Integer; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeDeleteAttachedDocumentsWithConfirm(RecRef: RecordRef; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeDocAttachForPostedPurchaseDocs(var PurchaseHeader: Record "Purchase Header"; var PurchInvHeader: Record "Purch. Inv. Header"; var PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr."; var PurchRcptHeader: Record "Purch. Rcpt. Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeDocAttachForPostedSalesDocs(var SalesHeader: Record "Sales Header"; var SalesInvoiceHeader: Record "Sales Invoice Header"; var SalesCrMemoHeader: Record "Sales Cr.Memo Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCopyAttachmentsForPostedDocsOnBeforeToDocumentAttachmentInsert(var FromDocumentAttachment: Record "Document Attachment"; var ToDocumentAttachment: Record "Document Attachment") begin end; [IntegrationEvent(false, false)] local procedure OnCopyAttachmentsForPostedDocsOnAfterToDocumentAttachmentInsert(var FromDocumentAttachment: Record "Document Attachment"; var ToDocumentAttachment: Record "Document Attachment") begin end; [IntegrationEvent(false, false)] local procedure OnIsDuplicateFileOnAfterSetFilters(var DocumentAttachment: Record "Document Attachment") begin end; [IntegrationEvent(false, false)] local procedure OnAfterTableHasNumberFieldPrimaryKey(TableNo: Integer; var Result: Boolean; var FieldNo: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnAfterTableHasDocTypePrimaryKey(TableNo: Integer; var Result: Boolean; var FieldNo: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnAfterTableHasLineNumberPrimaryKey(TableNo: Integer; var Result: Boolean; var FieldNo: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnAfterSetDocumentAttachmentFiltersForRecRefInternal(var DocumentAttachment: Record "Document Attachment"; RecordRef: RecordRef; GetRelatedAttachments: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnSetRelatedAttachmentsFilterOnBeforeSetTableIdFilter(TableNo: Integer; var RelatedTable: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCopyAttachments(var FromRecRef: RecordRef; var ToRecRef: RecordRef; var Handled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterGetRefTable(var RecRef: RecordRef; DocumentAttachment: Record "Document Attachment") begin end; [IntegrationEvent(false, false)] local procedure OnAfterIsFlowFieldsEditable(TableNo: Integer; var Editable: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterTableIsDocument(TableNo: Integer; var IsDocument: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnCopyAttachmentsOnAfterSetFromParameters(FromRecRef: RecordRef; var FromDocumentAttachment: Record "Document Attachment"; var FromAttachmentDocumentType: Enum "Attachment Document Type") begin end; [IntegrationEvent(false, false)] local procedure OnCopyAttachmentsOnAfterSetDocumentFlowFilter(var FromDocumentAttachment: Record "Document Attachment"; FromRecRef: RecordRef; ToRecRef: RecordRef) begin end; [IntegrationEvent(false, false)] local procedure OnCopyAttachmentsOnAfterSetToParameters(var ToDocumentAttachment: Record "Document Attachment"; ToRecRef: RecordRef; var ToFieldRef: FieldRef; var ToNo: Code[20]; var ToLineNo: Integer; var ToAttachmentDocumentType: Enum "Attachment Document Type"); begin end; [IntegrationEvent(false, false)] local procedure OnCopyAttachmentsOnAfterSetToDocumentFilters(var ToDocumentAttachment: Record "Document Attachment"; ToRecRef: RecordRef; ToAttachmentDocumentType: Enum "Attachment Document Type"; ToNo: Code[20]; ToLineNo: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnAfterTableIsDocumentHeader(TableNo: Integer; var IsHeader: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnAfterTableIsDocumentLine(TableNo: Integer; var IsLine: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnAfterTableIsEntity(TableNo: Integer; var IsEntity: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnCopyAttachmentsForPostedDocsLinesOnAfterSetFromFilters(FromRecRef: RecordRef; var FromDocumentAttachmentLine: Record "Document Attachment") begin end; [IntegrationEvent(false, false)] local procedure OnCopyAttachmentsForPostedDocsLinesOnAfterSetToTableID(ToRecRef: RecordRef; var ToDocumentAttachmentLine: Record "Document Attachment") begin end; [IntegrationEvent(false, false)] local procedure OnAfterTransformAttachmentDocumentTypeValue(TableNo: Integer; var AttachmentDocumentType: Enum "Attachment Document Type") begin end; [IntegrationEvent(false, false)] local procedure OnAfterIsServiceDocumentFlow(TableNo: Integer; var IsDocumentFlow: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterIsProductionDocumentFlow(TableNo: Integer; var IsDocumentFlow: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnMoveAttachmentsWithinSameRecordTypeOnBeforeInsert(var DocumentAttachmentToCreate: Record "Document Attachment"; MoveToRecRef: RecordRef; MoveToRecNo: Code[20]) begin end;}