Codeunit 5503 Graph Mgt - Attachment Buffer, source in 29
Source29
src/Layers/W1/BaseApp/Integration/Graph/GraphMgtAttachmentBuffer.Codeunit.al2629 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------
namespace Microsoft.Integration.Graph;
using Microsoft.Assembly.Document;
using Microsoft.Assembly.History;
using Microsoft.EServices.EDocument;
using Microsoft.Finance.GeneralLedger.Journal;
using Microsoft.Finance.GeneralLedger.Ledger;
using Microsoft.Foundation.Attachment;
using Microsoft.HumanResources.Employee;
using Microsoft.Integration.Entity;
using Microsoft.Inventory.Counting.Document;
using Microsoft.Inventory.Counting.History;
using Microsoft.Inventory.Counting.Recording;
using Microsoft.Inventory.Document;
using Microsoft.Inventory.History;
using Microsoft.Inventory.Item;
using Microsoft.Inventory.Transfer;
using Microsoft.Projects.Project.Job;
using Microsoft.Purchases.Archive;
using Microsoft.Purchases.Document;
using Microsoft.Purchases.History;
using Microsoft.Purchases.Vendor;
using Microsoft.Sales.Archive;
using Microsoft.Sales.Customer;
using Microsoft.Sales.Document;
using Microsoft.Sales.History;
using System;
using System.Environment;
using System.IO;
using System.Reflection;
using System.Utilities;
codeunit 5503 "Graph Mgt - Attachment Buffer"
{
Permissions = TableData "Incoming Document Attachment" = rimd, tabledata "Tenant Media" = r;
trigger OnRun()
begin
end;
var
DocumentIDNotSpecifiedForAttachmentsErr: Label 'You must specify a document id to get the attachments.';
DocumentIDorTypeNotSpecifiedForAttachmentsErr: Label 'You must specify a document id and a document type to get the attachments.';
DocumentDoesNotExistErr: Label 'No document with the specified ID exists.';
MultipleDocumentsFoundForIdErr: Label 'Multiple documents have been found for the specified criteria.';
CannotInsertAnAttachmentThatAlreadyExistsErr: Label 'You cannot insert an attachment because an attachment already exists.';
CannotModifyAnAttachmentThatDoesntExistErr: Label 'You cannot modify an attachment that does not exist.';
CannotDeleteAnAttachmentThatDoesntExistErr: Label 'You cannot delete an attachment that does not exist.';
EmptyGuid: Guid;
AttachmentLinkedToAnotherDocumentErr: Label 'The attachment is linked to another document than you specified.';
DocumentTypeInvalidErr: Label 'Document type is not valid.';
UnsopportedDocumentTypeErr: Label 'The selected Document type %1 is not supported.', Comment = '%1 name of document type, e.g. Journal, Cusotmer, Item, Sales Invoice...';
CannotFindParentKeyErr: Label 'Cannot find the No. field on the parent record. Double check if the proper type is provided.';
AttachmentLoadLimitExceededErr: Label 'Loading more than %1 attachments is not supported. Set a filter to reduce the response size.', Comment = '%1 - an integer';
[Scope('Cloud')]
procedure LoadDocumentAttachments(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; DocumentFilter: Text)
var
DocumentAttachment: Record "Document Attachment";
LoadContent: Boolean;
begin
DocumentAttachment.SetView(DocumentFilter);
LoadContent := DocumentAttachment.Count() = 1;
if DocumentAttachment.FindSet() then
repeat
TransferDocAttachmentToBuffer(DocumentAttachment, TempAttachmentEntityBuffer, LoadContent)
until DocumentAttachment.Next() = 0;
end;
local procedure TransferDocAttachmentToBuffer(var DocumentAttachment: Record "Document Attachment"; var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; LoadContent: Boolean)
var
FileManagement: Codeunit "File Management";
TempBlob: Codeunit "Temp Blob";
ContentOutStream: OutStream;
begin
Clear(TempAttachmentEntityBuffer."Byte Size");
TempAttachmentEntityBuffer."Created Date-Time" := DocumentAttachment."Attached Date";
TempAttachmentEntityBuffer."File Name" := CopyStr(FileManagement.CreateFileNameWithExtension(DocumentAttachment."File Name", DocumentAttachment."File Extension"), 1, MaxStrLen(TempAttachmentEntityBuffer."File Name"));
TempAttachmentEntityBuffer.Type := DocumentAttachment."File Type";
TempAttachmentEntityBuffer."Attachment Type" := TempAttachmentEntityBuffer."Attachment Type"::"Document Attachment";
TempAttachmentEntityBuffer.Id := DocumentAttachment.SystemId;
ConvertDocumentTypeFromDocumentAttachment(DocumentAttachment, TempAttachmentEntityBuffer);
TempAttachmentEntityBuffer."Document Flow Sales" := DocumentAttachment."Document Flow Sales";
TempAttachmentEntityBuffer."Line No." := DocumentAttachment."Line No.";
TempAttachmentEntityBuffer."Document Id" := GetDocumentAttachmentDocumentId(DocumentAttachment);
if TempAttachmentEntityBuffer.Insert() then;
if LoadContent then begin
TempAttachmentEntityBuffer.Content.CreateOutStream(ContentOutStream);
DocumentAttachment.ExportToStream(ContentOutStream);
TempAttachmentEntityBuffer.Modify();
end;
if not LoadContent and DocumentAttachment.HasContent() then begin
DocumentAttachment.GetAsTempBlob(TempBlob);
TempAttachmentEntityBuffer."Byte Size" := TempBlob.Length();
TempAttachmentEntityBuffer.Modify();
end;
end;
local procedure GetDocumentAttachmentDocumentId(var DocumentAttachment: Record "Document Attachment"): Guid
var
DummySalesHeader: Record "Sales Header";
SalesInvoiceEntityAggregate: Record "Sales Invoice Entity Aggregate";
PurchInvEntityAggregate: Record "Purch. Inv. Entity Aggregate";
SalesCrMemoEntityBuffer: Record "Sales Cr. Memo Entity Buffer";
PurchCrMemoEntityBuffer: Record "Purch. Cr. Memo Entity Buffer";
SalesQuoteEntityBuffer: Record "Sales Quote Entity Buffer";
SalesOrderEntityBuffer: Record "Sales Order Entity Buffer";
PurchaseOrderEntityBuffer: Record "Purchase Order Entity Buffer";
DataTypeManagement: Codeunit "Data Type Management";
MainRecordRef: RecordRef;
FieldRefVar: FieldRef;
ParentId: Guid;
begin
if DocumentAttachment."No." = '' then
exit(ParentId);
MainRecordRef.Open(DocumentAttachment."Table ID");
if not DataTypeManagement.FindFieldByName(MainRecordRef, FieldRefVar, DummySalesHeader.FieldName("No.")) then
exit(ParentId);
case MainRecordRef.Number of
Database::"Sales Header":
begin
if DocumentAttachment."Document Type" = DocumentAttachment."Document Type"::Invoice then begin
SalesInvoiceEntityAggregate.Get(DocumentAttachment."No.", false);
exit(SalesInvoiceEntityAggregate.Id);
end;
if DocumentAttachment."Document Type" = DocumentAttachment."Document Type"::Quote then begin
SalesQuoteEntityBuffer.Get(DocumentAttachment."No.");
exit(SalesQuoteEntityBuffer.Id);
end;
if DocumentAttachment."Document Type" = DocumentAttachment."Document Type"::Order then begin
SalesOrderEntityBuffer.Get(DocumentAttachment."No.");
exit(SalesOrderEntityBuffer.Id);
end;
if DocumentAttachment."Document Type" = DocumentAttachment."Document Type"::"Credit Memo" then begin
SalesCrMemoEntityBuffer.Get(DocumentAttachment."No.", false);
exit(SalesCrMemoEntityBuffer.Id);
end;
end;
Database::"Purchase Header":
begin
if DocumentAttachment."Document Type" = DocumentAttachment."Document Type"::Invoice then begin
PurchInvEntityAggregate.Get(DocumentAttachment."No.", false);
exit(PurchInvEntityAggregate.Id);
end;
if DocumentAttachment."Document Type" = DocumentAttachment."Document Type"::Order then begin
PurchaseOrderEntityBuffer.Get(DocumentAttachment."No.");
exit(PurchaseOrderEntityBuffer.Id);
end;
if DocumentAttachment."Document Type" = DocumentAttachment."Document Type"::"Credit Memo" then begin
PurchCrMemoEntityBuffer.Get(DocumentAttachment."No.", false);
exit(PurchCrMemoEntityBuffer.Id);
end;
end;
Database::"Sales Invoice Header":
begin
SalesInvoiceEntityAggregate.Get(DocumentAttachment."No.", true);
exit(SalesInvoiceEntityAggregate.Id)
end;
Database::"Sales Cr.Memo Header":
begin
SalesCrMemoEntityBuffer.Get(DocumentAttachment."No.", true);
exit(SalesCrMemoEntityBuffer.Id);
end;
Database::"Purch. Inv. Header":
begin
PurchInvEntityAggregate.Get(DocumentAttachment."No.", true);
exit(PurchInvEntityAggregate.Id)
end;
Database::"Purch. Cr. Memo Hdr.":
begin
PurchCrMemoEntityBuffer.Get(DocumentAttachment."No.", true);
exit(PurchCrMemoEntityBuffer.Id);
end;
end;
FieldRefVar.SetRange(DocumentAttachment."No.");
MainRecordRef.FindFirst();
exit(MainRecordRef.Field(MainRecordRef.SystemIdNo).Value);
end;
local procedure ConvertDocumentTypeFromDocumentAttachment(var DocumentAttachment: Record "Document Attachment"; var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary)
var
SalesHeader: Record "Sales Header";
PurchaseHeader: Record "Purchase Header";
begin
case DocumentAttachment."Table ID" of
Database::"Sales Header":
begin
SalesHeader.Get(DocumentAttachment."Document Type", DocumentAttachment."No.");
case SalesHeader."Document Type" of
SalesHeader."Document Type"::"Quote":
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Sales Quote";
exit;
end;
SalesHeader."Document Type"::"Order":
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Sales Order";
exit;
end;
SalesHeader."Document Type"::"Invoice":
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Sales Invoice";
exit;
end;
SalesHeader."Document Type"::"Credit Memo":
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Sales Credit Memo";
exit;
end;
end;
end;
Database::"Purchase Header":
begin
PurchaseHeader.Get(DocumentAttachment."Document Type", DocumentAttachment."No.");
case PurchaseHeader."Document Type" of
PurchaseHeader."Document Type"::"Invoice":
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Purchase Invoice";
exit;
end;
PurchaseHeader."Document Type"::"Order":
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Purchase Order";
exit;
end;
PurchaseHeader."Document Type"::"Credit Memo":
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Purchase Credit Memo";
exit;
end;
end;
end;
Database::"Purch. Inv. Header":
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Purchase Invoice";
exit;
end;
Database::"Sales Invoice Header":
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Sales Invoice";
exit;
end;
Database::"Sales Cr.Memo Header":
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Sales Credit Memo";
exit;
end;
Database::"Purch. Cr. Memo Hdr.":
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Purchase Credit Memo";
exit;
end;
Database::Employee:
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Employee";
exit;
end;
Database::Item:
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Item";
exit;
end;
Database::Job:
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Job";
exit;
end;
Database::Customer:
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Customer";
exit;
end;
Database::Vendor:
begin
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Vendor";
exit;
end;
else
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::" ";
end;
end;
procedure ConvertDocumentTypeToDocumentAttachment(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var DocumentAttachment: Record "Document Attachment")
var
SalesInvoiceEntityAggregate: Record "Sales Invoice Entity Aggregate";
SalesCrMemoEntityBuffer: Record "Sales Cr. Memo Entity Buffer";
PurchInvEntityAggregate: Record "Purch. Inv. Entity Aggregate";
PurchCrMemoEntityBuffer: Record "Purch. Cr. Memo Entity Buffer";
begin
case TempAttachmentEntityBuffer."Document Type" of
TempAttachmentEntityBuffer."Document Type"::"Sales Quote":
begin
DocumentAttachment."Table ID" := Database::"Sales Header";
DocumentAttachment."Document Type" := DocumentAttachment."Document Type"::Quote;
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Sales Order":
begin
DocumentAttachment."Table ID" := Database::"Sales Header";
DocumentAttachment."Document Type" := DocumentAttachment."Document Type"::Order;
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Sales Invoice":
begin
SalesInvoiceEntityAggregate.SetRange(Id, TempAttachmentEntityBuffer."Document Id");
SalesInvoiceEntityAggregate.FindFirst();
DocumentAttachment."Document Type" := DocumentAttachment."Document Type"::Invoice;
if SalesInvoiceEntityAggregate.Posted then begin
DocumentAttachment."Table ID" := Database::"Sales Invoice Header";
DocumentAttachment."No." := SalesInvoiceEntityAggregate."No.";
exit;
end else begin
DocumentAttachment."Table ID" := Database::"Sales Header";
DocumentAttachment."No." := SalesInvoiceEntityAggregate."No.";
exit;
end;
end;
TempAttachmentEntityBuffer."Document Type"::"Sales Credit Memo":
begin
SalesCrMemoEntityBuffer.SetRange(Id, TempAttachmentEntityBuffer."Document Id");
SalesCrMemoEntityBuffer.FindFirst();
DocumentAttachment."Document Type" := DocumentAttachment."Document Type"::"Credit Memo";
if SalesCrMemoEntityBuffer.Posted then begin
DocumentAttachment."Table ID" := Database::"Sales Cr.Memo Header";
DocumentAttachment."No." := SalesCrMemoEntityBuffer."No.";
exit;
end else begin
DocumentAttachment."Table ID" := Database::"Sales Header";
DocumentAttachment."No." := SalesCrMemoEntityBuffer."No.";
exit;
end;
end;
TempAttachmentEntityBuffer."Document Type"::"Purchase Invoice":
begin
PurchInvEntityAggregate.SetRange(Id, TempAttachmentEntityBuffer."Document Id");
PurchInvEntityAggregate.FindFirst();
DocumentAttachment."Document Type" := DocumentAttachment."Document Type"::Invoice;
if PurchInvEntityAggregate.Posted then begin
DocumentAttachment."Table ID" := Database::"Purch. Inv. Header";
DocumentAttachment."No." := PurchInvEntityAggregate."No.";
exit;
end else begin
DocumentAttachment."Table ID" := Database::"Purchase Header";
DocumentAttachment."No." := PurchInvEntityAggregate."No.";
exit;
end;
end;
TempAttachmentEntityBuffer."Document Type"::"Purchase Order":
begin
DocumentAttachment."Document Type" := DocumentAttachment."Document Type"::Order;
DocumentAttachment."Table ID" := Database::"Purchase Header";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Purchase Credit Memo":
begin
PurchCrMemoEntityBuffer.SetRange(Id, TempAttachmentEntityBuffer."Document Id");
PurchCrMemoEntityBuffer.FindFirst();
DocumentAttachment."Document Type" := DocumentAttachment."Document Type"::"Credit Memo";
if PurchCrMemoEntityBuffer.Posted then begin
DocumentAttachment."Table ID" := Database::"Purch. Cr. Memo Hdr.";
DocumentAttachment."No." := PurchCrMemoEntityBuffer."No.";
exit;
end else begin
DocumentAttachment."Table ID" := Database::"Purchase Header";
DocumentAttachment."No." := PurchCrMemoEntityBuffer."No.";
exit;
end;
end;
TempAttachmentEntityBuffer."Document Type"::"Employee":
begin
DocumentAttachment."Table ID" := Database::Employee;
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Item":
begin
DocumentAttachment."Table ID" := Database::Item;
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Job":
begin
DocumentAttachment."Table ID" := Database::Job;
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Customer":
begin
DocumentAttachment."Table ID" := Database::Customer;
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Vendor":
begin
DocumentAttachment."Table ID" := Database::Vendor;
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Purchase Quote":
begin
DocumentAttachment."Table ID" := Database::"Purchase Header";
DocumentAttachment."Document Type" := DocumentAttachment."Document Type"::Quote;
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Blanket Sales Order":
begin
DocumentAttachment."Table ID" := Database::"Sales Header";
DocumentAttachment."Document Type" := DocumentAttachment."Document Type"::"Blanket Order";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Sales Return Order":
begin
DocumentAttachment."Table ID" := Database::"Sales Header";
DocumentAttachment."Document Type" := DocumentAttachment."Document Type"::"Return Order";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Blanket Purchase Order":
begin
DocumentAttachment."Table ID" := Database::"Purchase Header";
DocumentAttachment."Document Type" := DocumentAttachment."Document Type"::"Blanket Order";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Purchase Return Order":
begin
DocumentAttachment."Table ID" := Database::"Purchase Header";
DocumentAttachment."Document Type" := DocumentAttachment."Document Type"::"Return Order";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Sales Shipment":
begin
DocumentAttachment."Table ID" := Database::"Sales Shipment Header";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Return Receipt":
begin
DocumentAttachment."Table ID" := Database::"Return Receipt Header";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Purchase Receipt":
begin
DocumentAttachment."Table ID" := Database::"Purch. Rcpt. Header";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Purch. Return Shipment":
begin
DocumentAttachment."Table ID" := Database::"Return Shipment Header";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Transfer Order":
begin
DocumentAttachment."Table ID" := Database::"Transfer Header";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Transfer Shipment":
begin
DocumentAttachment."Table ID" := Database::"Transfer Shipment Header";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Transfer Receipt":
begin
DocumentAttachment."Table ID" := Database::"Transfer Receipt Header";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Posted Direct Transfer":
begin
DocumentAttachment."Table ID" := Database::"Direct Trans. Header";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Sales Archive Quote",
TempAttachmentEntityBuffer."Document Type"::"Sales Archive Order",
TempAttachmentEntityBuffer."Document Type"::"Sales Archive Return",
TempAttachmentEntityBuffer."Document Type"::"Sales Archive Blanket Order":
begin
DocumentAttachment."Table ID" := Database::"Sales Header Archive";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Purchase Archive Quote",
TempAttachmentEntityBuffer."Document Type"::"Purchase Archive Order",
TempAttachmentEntityBuffer."Document Type"::"Purchase Archive Return",
TempAttachmentEntityBuffer."Document Type"::"Purchase Archive Blanket Order":
begin
DocumentAttachment."Table ID" := Database::"Purchase Header Archive";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Assembly Order":
begin
DocumentAttachment."Table ID" := Database::"Assembly Header";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Posted Assembly Order":
begin
DocumentAttachment."Table ID" := Database::"Posted Assembly Header";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Phys. Inventory Order":
begin
DocumentAttachment."Table ID" := Database::"Phys. Invt. Order Header";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Posted Phys. Inventory Order":
begin
DocumentAttachment."Table ID" := Database::"Pstd. Phys. Invt. Order Hdr";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Phys. Inventory Recording":
begin
DocumentAttachment."Table ID" := Database::"Phys. Invt. Record Header";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Posted Phys. Inventory Recording":
begin
DocumentAttachment."Table ID" := Database::"Pstd. Phys. Invt. Record Hdr";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Inventory Shipment",
TempAttachmentEntityBuffer."Document Type"::"Inventory Receipt":
begin
DocumentAttachment."Table ID" := Database::"Invt. Document Header";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Posted Inventory Shipment":
begin
DocumentAttachment."Table ID" := Database::"Invt. Shipment Header";
exit;
end;
TempAttachmentEntityBuffer."Document Type"::"Posted Inventory Receipt":
begin
DocumentAttachment."Table ID" := Database::"Invt. Receipt Header";
exit;
end;
else
Error(UnsopportedDocumentTypeErr, TempAttachmentEntityBuffer."Document Type");
end;
end;
[Scope('Cloud')]
procedure LoadAttachments(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; DocumentIdFilter: Text; AttachmentIdFilter: Text)
var
IncomingDocument: Record "Incoming Document";
DocumentRecordRef: RecordRef;
DocumentId: Guid;
GLEntryNo: Integer;
begin
TempAttachmentEntityBuffer.Reset();
TempAttachmentEntityBuffer.DeleteAll();
if not IsLinkedAttachment(DocumentIdFilter) then begin
LoadUnlinkedAttachmentsToBuffer(TempAttachmentEntityBuffer, AttachmentIdFilter);
exit;
end;
FindParentDocument(DocumentIdFilter, DocumentRecordRef);
if not FindIncomingDocument(DocumentRecordRef, IncomingDocument) then
exit;
if IsGLEntry(DocumentRecordRef) then
GLEntryNo := GetGLEntryNo(DocumentRecordRef)
else
DocumentId := GetDocumentId(DocumentRecordRef);
LoadLinkedAttachmentsToBuffer(TempAttachmentEntityBuffer, IncomingDocument, AttachmentIdFilter);
if TempAttachmentEntityBuffer.FindSet() then
repeat
if GLEntryNo <> 0 then
TempAttachmentEntityBuffer."G/L Entry No." := GLEntryNo
else
TempAttachmentEntityBuffer."Document Id" := DocumentId;
TempAttachmentEntityBuffer.Modify(true);
until TempAttachmentEntityBuffer.Next() = 0;
end;
[Scope('Cloud')]
procedure LoadAttachmentsWithDocumentType(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; DocumentIdFilter: Text; AttachmentIdFilter: Text; DocumentTypeFilter: Text)
var
IncomingDocument: Record "Incoming Document";
DocumentRecordRef: RecordRef;
DocumentId: Guid;
ErrorMsg: Text;
begin
TempAttachmentEntityBuffer.Reset();
TempAttachmentEntityBuffer.DeleteAll();
if not IsLinkedAttachment(DocumentIdFilter) then begin
LoadUnlinkedAttachmentsToBuffer(TempAttachmentEntityBuffer, AttachmentIdFilter);
exit;
end;
FindParentDocumentWithDocumentTypeSafe(DocumentIdFilter, DocumentTypeFilter, DocumentRecordRef, ErrorMsg);
if ErrorMsg <> '' then
Error(ErrorMsg);
if not FindIncomingDocument(DocumentRecordRef, IncomingDocument) then
exit;
DocumentId := GetDocumentId(DocumentRecordRef);
LoadLinkedAttachmentsToBuffer(TempAttachmentEntityBuffer, IncomingDocument, AttachmentIdFilter);
if TempAttachmentEntityBuffer.FindSet() then
repeat
TempAttachmentEntityBuffer."Document Id" := DocumentId;
if IsGLEntry(DocumentRecordRef) then
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::Journal;
TempAttachmentEntityBuffer.Modify(true);
until TempAttachmentEntityBuffer.Next() = 0;
end;
[Scope('Cloud')]
procedure LoadAttachmentsWithoutDocumentType(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; AttachmentIdFilter: Text)
var
DocumentRecordRef: RecordRef;
DocumentId: Guid;
begin
TempAttachmentEntityBuffer.Reset();
TempAttachmentEntityBuffer.DeleteAll();
LoadAttachmentsToBuffer(TempAttachmentEntityBuffer, AttachmentIdFilter);
if TempAttachmentEntityBuffer.FindSet() then
repeat
TempAttachmentEntityBuffer."Document Id" := DocumentId;
if IsGLEntry(DocumentRecordRef) then
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::Journal;
TempAttachmentEntityBuffer.Modify(true);
until TempAttachmentEntityBuffer.Next() = 0;
end;
[Scope('Cloud')]
procedure PropagateInsertAttachment(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempFieldBuffer: Record "Field Buffer" temporary)
var
ErrorMsg: Text;
begin
if PropagateInsertLinkedAttachment(TempAttachmentEntityBuffer, TempFieldBuffer, ErrorMsg) then
exit;
ThrowErrorIfAny(ErrorMsg);
PropagateInsertUnlinkedAttachment(TempAttachmentEntityBuffer, TempFieldBuffer);
end;
[Scope('Cloud')]
procedure PropagateInsertAttachmentSafe(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempFieldBuffer: Record "Field Buffer" temporary)
var
ErrorMsg: Text;
begin
if PropagateInsertLinkedAttachment(TempAttachmentEntityBuffer, TempFieldBuffer, ErrorMsg) then
exit;
// Ignore an error from above if any, because we don't want to ask the user
// to upload the same attachment twice because of a small error like wrong documentId, etc.
// The client can then handle this and link the attachment and the document afterwards.
PropagateInsertUnlinkedAttachment(TempAttachmentEntityBuffer, TempFieldBuffer);
end;
[Scope('Cloud')]
procedure PropagateInsertAttachmentSafeWithDocumentType(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempFieldBuffer: Record "Field Buffer" temporary)
var
ErrorMsg: Text;
begin
if PropagateInsertLinkedAttachmentWithDocumentType(TempAttachmentEntityBuffer, TempFieldBuffer, ErrorMsg) then
exit;
PropagateInsertUnlinkedAttachment(TempAttachmentEntityBuffer, TempFieldBuffer);
end;
[Scope('Cloud')]
procedure PropagateInsertAttachmentSafeWithoutDocumentType(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempFieldBuffer: Record "Field Buffer" temporary)
var
ErrorMsg: Text;
begin
if PropagateInsertAttachmentWithoutDocumentType(TempAttachmentEntityBuffer, TempFieldBuffer, ErrorMsg) then
exit;
end;
local procedure PropagateInsertLinkedAttachmentWithDocumentType(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempFieldBuffer: Record "Field Buffer" temporary; var ErrorMsg: Text): Boolean
var
IncomingDocument: Record "Incoming Document";
IncomingDocumentAttachment: Record "Incoming Document Attachment";
LastUsedIncomingDocumentAttachment: Record "Incoming Document Attachment";
UnlinkedAttachment: Record "Unlinked Attachment";
DocumentRecordRef: RecordRef;
AttachmentRecordRef: RecordRef;
LineNo: Integer;
Name: Text[250];
Extension: Text[30];
DocumentIdFilter: Text;
DocumentTypeFilter: Text;
DocumentId: Guid;
AttachmentId: Guid;
begin
DocumentIdFilter := GetDocumentIdFilter(TempAttachmentEntityBuffer);
DocumentTypeFilter := GetDocumentTypeFilter(TempAttachmentEntityBuffer);
if not (IsLinkedAttachment(DocumentIdFilter)) then
exit(false);
FindParentDocumentWithDocumentTypeSafe(DocumentIdFilter, DocumentTypeFilter, DocumentRecordRef, ErrorMsg);
if ErrorMsg <> '' then
exit(false);
VerifyCRUDIsPossibleSafe(DocumentRecordRef, ErrorMsg);
if ErrorMsg <> '' then
exit(false);
FindOrCreateIncomingDocument(DocumentRecordRef, IncomingDocument);
LastUsedIncomingDocumentAttachment.SetRange("Incoming Document Entry No.", IncomingDocument."Entry No.");
if not LastUsedIncomingDocumentAttachment.FindLast() then
LineNo := GetIncrement()
else
LineNo := LastUsedIncomingDocumentAttachment."Line No." + GetIncrement();
if not IsNullGuid(TempAttachmentEntityBuffer.Id) then begin
IncomingDocumentAttachment.SetRange(SystemId, TempAttachmentEntityBuffer.Id);
if IncomingDocumentAttachment.FindFirst() then begin
ErrorMsg := CannotInsertAnAttachmentThatAlreadyExistsErr;
exit(false);
end;
end;
DocumentId := GetDocumentId(DocumentRecordRef);
TransferToIncomingDocumentAttachment(TempAttachmentEntityBuffer, IncomingDocumentAttachment, TempFieldBuffer, true);
FileNameToNameAndExtension(TempAttachmentEntityBuffer."File Name", Name, Extension);
IncomingDocumentAttachment."Incoming Document Entry No." := IncomingDocument."Entry No.";
IncomingDocumentAttachment."Line No." := LineNo;
IncomingDocumentAttachment.Name := Name;
IncomingDocumentAttachment."File Extension" := Extension;
if IncomingDocument.Posted then begin
IncomingDocumentAttachment."Document No." := IncomingDocument."Document No.";
IncomingDocumentAttachment."Posting Date" := IncomingDocument."Posting Date";
end;
if IsNullGuid(TempAttachmentEntityBuffer.Id) then
IncomingDocumentAttachment.Insert(true)
else begin
IncomingDocumentAttachment.SystemId := TempAttachmentEntityBuffer.Id;
IncomingDocumentAttachment.Insert(true, true);
end;
if FindUnlinkedAttachment(TempAttachmentEntityBuffer.Id, UnlinkedAttachment) then begin
AttachmentId := UnlinkedAttachment.SystemId;
UnlinkedAttachment.Delete(true);
AttachmentRecordRef.GetTable(IncomingDocumentAttachment);
end;
TempAttachmentEntityBuffer.Id := IncomingDocumentAttachment.SystemId;
exit(true);
end;
local procedure GetIncrement(): Integer
begin
exit(10000);
end;
local procedure PropagateInsertAttachmentWithoutDocumentType(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempFieldBuffer: Record "Field Buffer" temporary; var ErrorMsg: Text): Boolean
var
IncomingDocument: Record "Incoming Document";
IncomingDocumentAttachment: Record "Incoming Document Attachment";
LastUsedIncomingDocumentAttachment: Record "Incoming Document Attachment";
LineNo: Integer;
Name: Text[250];
Extension: Text[30];
begin
FileNameToNameAndExtension(TempAttachmentEntityBuffer."File Name", Name, Extension);
IncomingDocument.Description := CopyStr(Name, 1, MaxStrLen(IncomingDocument.Description));
IncomingDocument.Insert(true);
LastUsedIncomingDocumentAttachment.SetRange("Incoming Document Entry No.", IncomingDocument."Entry No.");
if not LastUsedIncomingDocumentAttachment.FindLast() then
LineNo := GetIncrement()
else
LineNo := LastUsedIncomingDocumentAttachment."Line No." + GetIncrement();
if not IsNullGuid(TempAttachmentEntityBuffer.Id) then begin
IncomingDocumentAttachment.SetRange(SystemId, TempAttachmentEntityBuffer.Id);
if IncomingDocumentAttachment.FindFirst() then begin
ErrorMsg := CannotInsertAnAttachmentThatAlreadyExistsErr;
exit(false);
end;
end;
TransferToIncomingDocumentAttachment(TempAttachmentEntityBuffer, IncomingDocumentAttachment, TempFieldBuffer, true);
IncomingDocumentAttachment."Incoming Document Entry No." := IncomingDocument."Entry No.";
IncomingDocumentAttachment."Line No." := LineNo;
IncomingDocumentAttachment.Name := Name;
IncomingDocumentAttachment."File Extension" := Extension;
if IncomingDocument.Posted then begin
IncomingDocumentAttachment."Document No." := IncomingDocument."Document No.";
IncomingDocumentAttachment."Posting Date" := IncomingDocument."Posting Date";
end;
if IsNullGuid(TempAttachmentEntityBuffer.Id) then
IncomingDocumentAttachment.Insert(true)
else begin
IncomingDocumentAttachment.SystemId := TempAttachmentEntityBuffer.Id;
IncomingDocumentAttachment.Insert(true, true);
end;
TempAttachmentEntityBuffer.Id := IncomingDocumentAttachment.SystemId;
exit(true);
end;
local procedure PropagateInsertUnlinkedAttachment(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempFieldBuffer: Record "Field Buffer" temporary): Boolean
var
UnlinkedAttachment: Record "Unlinked Attachment";
IncomingDocumentAttachment: Record "Incoming Document Attachment";
IncomingDocument: Record "Incoming Document";
AttachmentRecordRef: RecordRef;
AttachmentId: Guid;
begin
if not IsNullGuid(TempAttachmentEntityBuffer.Id) then
if FindUnlinkedAttachment(TempAttachmentEntityBuffer.Id, UnlinkedAttachment) then
Error(CannotInsertAnAttachmentThatAlreadyExistsErr);
Clear(UnlinkedAttachment);
TransferToUnlinkedAttachment(TempAttachmentEntityBuffer, UnlinkedAttachment, TempFieldBuffer, true);
if IsNullGuid(TempAttachmentEntityBuffer.Id) then
UnlinkedAttachment.Insert(true)
else begin
UnlinkedAttachment.SystemId := TempAttachmentEntityBuffer.Id;
UnlinkedAttachment.Insert(true, true);
end;
UnlinkedAttachment.Find();
if FindLinkedAttachment(TempAttachmentEntityBuffer.Id, IncomingDocumentAttachment) then begin
AttachmentId := IncomingDocumentAttachment.SystemId;
IncomingDocument.Get(IncomingDocumentAttachment."Incoming Document Entry No.");
DeleteLinkedAttachment(IncomingDocumentAttachment, IncomingDocument);
AttachmentRecordRef.GetTable(UnlinkedAttachment);
end;
Clear(TempAttachmentEntityBuffer."Document Id");
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::" ";
TempAttachmentEntityBuffer.Id := UnlinkedAttachment.SystemId;
exit(true);
end;
local procedure PropagateInsertLinkedAttachment(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempFieldBuffer: Record "Field Buffer" temporary; var ErrorMsg: Text): Boolean
var
IncomingDocument: Record "Incoming Document";
IncomingDocumentAttachment: Record "Incoming Document Attachment";
LastUsedIncomingDocumentAttachment: Record "Incoming Document Attachment";
UnlinkedAttachment: Record "Unlinked Attachment";
DocumentRecordRef: RecordRef;
AttachmentRecordRef: RecordRef;
LineNo: Integer;
Name: Text[250];
Extension: Text[30];
DocumentIdFilter: Text;
GLEntryNoFilter: Text;
DocumentId: Guid;
AttachmentId: Guid;
begin
DocumentIdFilter := GetDocumentIdFilter(TempAttachmentEntityBuffer);
GLEntryNoFilter := GetGLEntryNoFilter(TempAttachmentEntityBuffer);
if not (IsLinkedAttachment(DocumentIdFilter) or IsLinkedAttachment(GLEntryNoFilter)) then
exit(false);
if GLEntryNoFilter <> '' then
FindParentDocumentSafe(GLEntryNoFilter, DocumentRecordRef, ErrorMsg)
else
FindParentDocumentSafe(DocumentIdFilter, DocumentRecordRef, ErrorMsg);
if ErrorMsg <> '' then
exit(false);
VerifyCRUDIsPossibleSafe(DocumentRecordRef, ErrorMsg);
if ErrorMsg <> '' then
exit(false);
FindOrCreateIncomingDocument(DocumentRecordRef, IncomingDocument);
LastUsedIncomingDocumentAttachment.SetRange("Incoming Document Entry No.", IncomingDocument."Entry No.");
if not LastUsedIncomingDocumentAttachment.FindLast() then
LineNo := GetIncrement()
else
LineNo := LastUsedIncomingDocumentAttachment."Line No." + GetIncrement();
if not IsNullGuid(TempAttachmentEntityBuffer.Id) then
if IncomingDocumentAttachment.GetBySystemId(TempAttachmentEntityBuffer.Id) then begin
ErrorMsg := CannotInsertAnAttachmentThatAlreadyExistsErr;
exit(false);
end;
DocumentId := GetDocumentId(DocumentRecordRef);
TransferToIncomingDocumentAttachment(TempAttachmentEntityBuffer, IncomingDocumentAttachment, TempFieldBuffer, true);
FileNameToNameAndExtension(TempAttachmentEntityBuffer."File Name", Name, Extension);
IncomingDocumentAttachment."Incoming Document Entry No." := IncomingDocument."Entry No.";
IncomingDocumentAttachment."Line No." := LineNo;
IncomingDocumentAttachment.Name := Name;
IncomingDocumentAttachment."File Extension" := Extension;
if IncomingDocument.Posted then begin
IncomingDocumentAttachment."Document No." := IncomingDocument."Document No.";
IncomingDocumentAttachment."Posting Date" := IncomingDocument."Posting Date";
end;
if IsNullGuid(TempAttachmentEntityBuffer.Id) then
IncomingDocumentAttachment.Insert(true)
else begin
IncomingDocumentAttachment.SystemId := TempAttachmentEntityBuffer.Id;
IncomingDocumentAttachment.Insert(true, true);
end;
if FindUnlinkedAttachment(TempAttachmentEntityBuffer.Id, UnlinkedAttachment) then begin
AttachmentId := UnlinkedAttachment.SystemId;
UnlinkedAttachment.Delete(true);
AttachmentRecordRef.GetTable(IncomingDocumentAttachment);
end;
TempAttachmentEntityBuffer.Id := IncomingDocumentAttachment.SystemId;
exit(true);
end;
[Scope('Cloud')]
procedure PropagateModifyAttachment(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempFieldBuffer: Record "Field Buffer" temporary)
var
IncomingDocument: Record "Incoming Document";
IncomingDocumentAttachment: Record "Incoming Document Attachment";
UnlinkedAttachment: Record "Unlinked Attachment";
DocumentRecordRef: RecordRef;
DocumentRecord: Variant;
DocumentIdFilter: Text;
GLEntryNoFilter: Text;
IsUnlinked: Boolean;
IsLinked: Boolean;
ShouldBeLinked: Boolean;
ShouldBeUnlinked: Boolean;
begin
IsUnlinked := FindUnlinkedAttachment(TempAttachmentEntityBuffer.Id, UnlinkedAttachment);
if IsUnlinked then begin
TransferToUnlinkedAttachment(TempAttachmentEntityBuffer, UnlinkedAttachment, TempFieldBuffer, false);
UnlinkedAttachment.Modify(true);
ShouldBeLinked := not IsNullGuid(TempAttachmentEntityBuffer."Document Id");
if ShouldBeLinked then
LinkAttachmentToDocument(
TempAttachmentEntityBuffer.Id, TempAttachmentEntityBuffer."Document Id", TempAttachmentEntityBuffer."File Name");
exit;
end;
IncomingDocumentAttachment.SetAutoCalcFields(Content);
IsLinked := IncomingDocumentAttachment.GetBySystemId(TempAttachmentEntityBuffer.Id);
if IsLinked then begin
ShouldBeUnlinked := IsNullGuid(TempAttachmentEntityBuffer."Document Id") and (TempAttachmentEntityBuffer."G/L Entry No." = 0);
if ShouldBeUnlinked then begin
IncomingDocument.Get(IncomingDocumentAttachment."Incoming Document Entry No.");
IncomingDocument.GetRecord(DocumentRecord);
DocumentRecordRef := DocumentRecord;
VerifyCRUDIsPossible(DocumentRecordRef);
TransferToIncomingDocumentAttachment(TempAttachmentEntityBuffer, IncomingDocumentAttachment, TempFieldBuffer, false);
UnlinkAttachmentFromDocument(IncomingDocumentAttachment);
exit;
end;
DocumentIdFilter := GetDocumentIdFilter(TempAttachmentEntityBuffer);
GLEntryNoFilter := GetGLEntryNoFilter(TempAttachmentEntityBuffer);
if GLEntryNoFilter <> '' then
FindParentDocument(GLEntryNoFilter, DocumentRecordRef)
else
FindParentDocument(DocumentIdFilter, DocumentRecordRef);
if not FindIncomingDocument(DocumentRecordRef, IncomingDocument) then
Error(AttachmentLinkedToAnotherDocumentErr);
VerifyCRUDIsPossible(DocumentRecordRef);
TransferToIncomingDocumentAttachment(TempAttachmentEntityBuffer, IncomingDocumentAttachment, TempFieldBuffer, false);
IncomingDocumentAttachment.Modify(true);
exit;
end;
Error(CannotModifyAnAttachmentThatDoesntExistErr);
end;
[Scope('Cloud')]
procedure PropagateModifyAttachmentWithDocumentType(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempFieldBuffer: Record "Field Buffer" temporary)
var
IncomingDocument: Record "Incoming Document";
IncomingDocumentAttachment: Record "Incoming Document Attachment";
UnlinkedAttachment: Record "Unlinked Attachment";
DocumentRecordRef: RecordRef;
DocumentRecord: Variant;
DocumentIdFilter: Text;
DocumentTypeFilter: Text;
ErrorMsg: Text;
IsUnlinked: Boolean;
IsLinked: Boolean;
ShouldBeLinked: Boolean;
ShouldBeUnlinked: Boolean;
begin
IsUnlinked := FindUnlinkedAttachment(TempAttachmentEntityBuffer.Id, UnlinkedAttachment);
if IsUnlinked then begin
TransferToUnlinkedAttachment(TempAttachmentEntityBuffer, UnlinkedAttachment, TempFieldBuffer, false);
UnlinkedAttachment.Modify(true);
ShouldBeLinked := not IsNullGuid(TempAttachmentEntityBuffer."Document Id");
if ShouldBeLinked then
LinkAttachmentToDocumentWithDocumentType(
TempAttachmentEntityBuffer.Id, TempAttachmentEntityBuffer."Document Id", TempAttachmentEntityBuffer."Document Type", TempAttachmentEntityBuffer."File Name");
exit;
end;
IncomingDocumentAttachment.SetAutoCalcFields(Content);
IncomingDocumentAttachment.SetRange(SystemId, TempAttachmentEntityBuffer.Id);
IsLinked := IncomingDocumentAttachment.FindFirst();
if IsLinked then begin
ShouldBeUnlinked := IsNullGuid(TempAttachmentEntityBuffer."Document Id");
if ShouldBeUnlinked then begin
IncomingDocument.Get(IncomingDocumentAttachment."Incoming Document Entry No.");
IncomingDocument.GetRecord(DocumentRecord);
DocumentRecordRef := DocumentRecord;
VerifyCRUDIsPossible(DocumentRecordRef);
TransferToIncomingDocumentAttachment(TempAttachmentEntityBuffer, IncomingDocumentAttachment, TempFieldBuffer, false);
UnlinkAttachmentFromDocument(IncomingDocumentAttachment);
exit;
end;
DocumentIdFilter := GetDocumentIdFilter(TempAttachmentEntityBuffer);
DocumentTypeFilter := GetDocumentTypeFilter(TempAttachmentEntityBuffer);
FindParentDocumentWithDocumentTypeSafe(DocumentIdFilter, DocumentTypeFilter, DocumentRecordRef, ErrorMsg);
if ErrorMsg <> '' then
Error(ErrorMsg);
if not FindIncomingDocument(DocumentRecordRef, IncomingDocument) then
Error(AttachmentLinkedToAnotherDocumentErr);
VerifyCRUDIsPossible(DocumentRecordRef);
TransferToIncomingDocumentAttachment(TempAttachmentEntityBuffer, IncomingDocumentAttachment, TempFieldBuffer, false);
IncomingDocumentAttachment.Modify(true);
exit;
end;
Error(CannotModifyAnAttachmentThatDoesntExistErr);
end;
[Scope('Cloud')]
procedure PropagateModifyAttachmentWithoutDocumentType(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempFieldBuffer: Record "Field Buffer" temporary)
var
IncomingDocument: Record "Incoming Document";
IncomingDocumentAttachment: Record "Incoming Document Attachment";
begin
IncomingDocumentAttachment.SetAutoCalcFields(Content);
if not IncomingDocumentAttachment.GetBySystemId(TempAttachmentEntityBuffer.Id) then
Error(CannotModifyAnAttachmentThatDoesntExistErr);
IncomingDocument.Get(IncomingDocumentAttachment."Incoming Document Entry No.");
TransferToIncomingDocumentAttachment(TempAttachmentEntityBuffer, IncomingDocumentAttachment, TempFieldBuffer, false);
IncomingDocumentAttachment.Modify(true);
end;
procedure PropagateDeleteAttachment(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary)
var
DocumentAttachment: Record "Document Attachment";
IncomingDocument: Record "Incoming Document";
IncomingDocumentAttachment: Record "Incoming Document Attachment";
UnlinkedAttachment: Record "Unlinked Attachment";
DocumentRecordRef: RecordRef;
DocumentIdFilter: Text;
GLEntryNoFilter: Text;
begin
if TempAttachmentEntityBuffer."Attachment Type" = TempAttachmentEntityBuffer."Attachment Type"::"Document Attachment" then begin
DocumentAttachment.GetBySystemId(TempAttachmentEntityBuffer.Id);
DocumentAttachment.Delete(true);
exit;
end;
if FindUnlinkedAttachment(TempAttachmentEntityBuffer.Id, UnlinkedAttachment) then begin
UnlinkedAttachment.Delete(true);
exit;
end;
if not IncomingDocumentAttachment.GetBySystemId(TempAttachmentEntityBuffer.Id) then
Error(CannotDeleteAnAttachmentThatDoesntExistErr);
DocumentIdFilter := GetDocumentIdFilter(TempAttachmentEntityBuffer);
GLEntryNoFilter := GetGLEntryNoFilter(TempAttachmentEntityBuffer);
if DocumentIdFilter <> '' then begin
if GLEntryNoFilter <> '' then
FindParentDocument(GLEntryNoFilter, DocumentRecordRef)
else
FindParentDocument(DocumentIdFilter, DocumentRecordRef);
if not FindIncomingDocument(DocumentRecordRef, IncomingDocument) then
Error(AttachmentLinkedToAnotherDocumentErr);
VerifyCRUDIsPossible(DocumentRecordRef);
end;
DeleteLinkedAttachment(IncomingDocumentAttachment, IncomingDocument);
end;
procedure PropagateDeleteAttachmentWithDocumentType(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary)
var
DocumentAttachment: Record "Document Attachment";
IncomingDocument: Record "Incoming Document";
IncomingDocumentAttachment: Record "Incoming Document Attachment";
UnlinkedAttachment: Record "Unlinked Attachment";
DocumentRecordRef: RecordRef;
DocumentIdFilter: Text;
DocumentTypeFilter: Text;
ErrorMsg: Text;
begin
if TempAttachmentEntityBuffer."Attachment Type" = TempAttachmentEntityBuffer."Attachment Type"::"Document Attachment" then begin
DocumentAttachment.GetBySystemId(TempAttachmentEntityBuffer.Id);
DocumentAttachment.Delete(true);
exit;
end;
if FindUnlinkedAttachment(TempAttachmentEntityBuffer.Id, UnlinkedAttachment) then begin
UnlinkedAttachment.Delete(true);
exit;
end;
IncomingDocumentAttachment.SetRange(SystemId, TempAttachmentEntityBuffer.Id);
if not IncomingDocumentAttachment.FindFirst() then
Error(CannotDeleteAnAttachmentThatDoesntExistErr);
DocumentIdFilter := GetDocumentIdFilter(TempAttachmentEntityBuffer);
DocumentTypeFilter := GetDocumentTypeFilter(TempAttachmentEntityBuffer);
FindParentDocumentWithDocumentTypeSafe(DocumentIdFilter, DocumentTypeFilter, DocumentRecordRef, ErrorMsg);
if ErrorMsg <> '' then
Error(ErrorMsg);
if not FindIncomingDocument(DocumentRecordRef, IncomingDocument) then
Error(AttachmentLinkedToAnotherDocumentErr);
VerifyCRUDIsPossible(DocumentRecordRef);
DeleteLinkedAttachment(IncomingDocumentAttachment, IncomingDocument);
end;
procedure PropagateDeleteAttachmentWithoutDocumentType(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary)
var
DocumentAttachment: Record "Document Attachment";
IncomingDocument: Record "Incoming Document";
IncomingDocumentAttachment: Record "Incoming Document Attachment";
UnlinkedAttachment: Record "Unlinked Attachment";
begin
if TempAttachmentEntityBuffer."Attachment Type" = TempAttachmentEntityBuffer."Attachment Type"::"Document Attachment" then begin
DocumentAttachment.GetBySystemId(TempAttachmentEntityBuffer.Id);
DocumentAttachment.Delete(true);
exit;
end;
if FindUnlinkedAttachment(TempAttachmentEntityBuffer.Id, UnlinkedAttachment) then begin
UnlinkedAttachment.Delete(true);
exit;
end;
if not IncomingDocumentAttachment.GetBySystemId(TempAttachmentEntityBuffer.Id) then
Error(CannotDeleteAnAttachmentThatDoesntExistErr);
if not IncomingDocument.Get(IncomingDocumentAttachment."Incoming Document Entry No.") then
Error(AttachmentLinkedToAnotherDocumentErr);
DeleteLinkedAttachment(IncomingDocumentAttachment, IncomingDocument);
end;
procedure DeleteLinkedAttachment(var IncomingDocumentAttachment: Record "Incoming Document Attachment"; var IncomingDocument: Record "Incoming Document")
var
AdditionalIncomingDocumentAttachment: Record "Incoming Document Attachment";
DummyRecordID: RecordID;
LineNo: Integer;
IsDefault: Boolean;
IsMain: Boolean;
begin
LineNo := IncomingDocumentAttachment."Line No.";
IsDefault := IncomingDocumentAttachment.Default;
IsMain := IncomingDocumentAttachment."Main Attachment";
if (not IsDefault) and (not IsMain) then
IncomingDocumentAttachment.Delete(true)
else begin
IncomingDocumentAttachment.Default := false;
IncomingDocumentAttachment."Main Attachment" := false;
IncomingDocumentAttachment.Modify();
IncomingDocumentAttachment.Delete(true);
AdditionalIncomingDocumentAttachment.SetRange("Incoming Document Entry No.", IncomingDocument."Entry No.");
AdditionalIncomingDocumentAttachment.SetFilter("Line No.", '<>%1', LineNo);
if AdditionalIncomingDocumentAttachment.FindFirst() then begin
AdditionalIncomingDocumentAttachment.Validate(Default, IsDefault);
AdditionalIncomingDocumentAttachment.Validate("Main Attachment", IsMain);
AdditionalIncomingDocumentAttachment.Modify(true);
end;
end;
IncomingDocumentAttachment.Reset();
IncomingDocumentAttachment.SetRange("Incoming Document Entry No.", IncomingDocument."Entry No.");
if IncomingDocumentAttachment.FindFirst() then
exit;
if IncomingDocument.Posted then begin
IncomingDocument."Related Record ID" := DummyRecordID;
IncomingDocument."Posted Date-Time" := 0DT;
IncomingDocument.Posted := false;
IncomingDocument.Processed := false;
IncomingDocument.Status := IncomingDocument.Status::Released;
IncomingDocument."Document No." := '';
IncomingDocument."Document Type" := IncomingDocument."Document Type"::" ";
IncomingDocument."Posting Date" := 0D;
IncomingDocument.Modify(true);
end;
IncomingDocument.Delete(true);
end;
[Scope('OnPrem')]
procedure UpdateAttachments(var TempOldAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempNewAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; DocumentId: Guid)
begin
DeleteUnusedAttachments(TempOldAttachmentEntityBuffer, TempNewAttachmentEntityBuffer);
LinkNewAttachmentsToDocument(TempOldAttachmentEntityBuffer, TempNewAttachmentEntityBuffer, DocumentId);
end;
local procedure DeleteUnusedAttachments(var TempOldAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempNewAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary)
begin
if TempOldAttachmentEntityBuffer.FindSet() then
repeat
if not TempNewAttachmentEntityBuffer.Get(TempOldAttachmentEntityBuffer.Id) then
PropagateDeleteAttachment(TempOldAttachmentEntityBuffer);
until TempOldAttachmentEntityBuffer.Next() = 0;
end;
procedure InsertFromTempAttachmentEntityBufferToDocumentAttachment(var DocumentAttachment: Record "Document Attachment"; var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempFieldBuffer: Record "Field Buffer" temporary)
var
FileManagement: Codeunit "File Management";
begin
DocumentAttachment."Attached Date" := CurrentDateTime();
if HasRegisteredField(TempAttachmentEntityBuffer.FieldNo("Line No."), TempFieldBuffer) then
DocumentAttachment.Validate("Line No.", TempAttachmentEntityBuffer."Line No.");
if HasRegisteredField(TempAttachmentEntityBuffer.FieldNo("File Name"), TempFieldBuffer) then begin
DocumentAttachment.Validate("File Extension", FileManagement.GetExtension(TempAttachmentEntityBuffer."File Name"));
DocumentAttachment.Validate("File Name", CopyStr(FileManagement.GetFileNameWithoutExtension(TempAttachmentEntityBuffer."File Name"), 1, MaxStrLen(DocumentAttachment."File Name")));
end;
ConvertDocumentTypeToDocumentAttachment(TempAttachmentEntityBuffer, DocumentAttachment);
SetDocumentAttachmentNo(DocumentAttachment, TempAttachmentEntityBuffer);
if HasRegisteredField(TempAttachmentEntityBuffer.FieldNo("Document Flow Sales"), TempFieldBuffer) then
DocumentAttachment.Validate("Document Flow Sales", TempAttachmentEntityBuffer."Document Flow Sales");
if HasRegisteredField(TempAttachmentEntityBuffer.FieldNo("Document Flow Purchase"), TempFieldBuffer) then
DocumentAttachment.Validate("Document Flow Purchase", TempAttachmentEntityBuffer."Document Flow Purchase");
DocumentAttachment.Insert();
end;
procedure ModifyFromTempAttachmentEntityBufferToDocumentAttachment(var DocumentAttachment: Record "Document Attachment"; var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempFieldBuffer: Record "Field Buffer" temporary)
var
ExistingDocumentAttachment: Record "Document Attachment";
FileManagement: Codeunit "File Management";
RenameRecord: Boolean;
ModifyRecord: Boolean;
begin
ExistingDocumentAttachment.Copy(DocumentAttachment);
if HasRegisteredField(TempAttachmentEntityBuffer.FieldNo("Document Type"), TempFieldBuffer) then begin
ConvertDocumentTypeToDocumentAttachment(TempAttachmentEntityBuffer, DocumentAttachment);
RenameRecord := true;
end;
if HasRegisteredField(TempAttachmentEntityBuffer.FieldNo("Document Id"), TempFieldBuffer) then begin
SetDocumentAttachmentNo(DocumentAttachment, TempAttachmentEntityBuffer);
RenameRecord := true;
end;
if HasRegisteredField(TempAttachmentEntityBuffer.FieldNo("Line No."), TempFieldBuffer) then begin
DocumentAttachment."Line No." := TempAttachmentEntityBuffer."Line No.";
RenameRecord := true;
end;
if RenameRecord then begin
ExistingDocumentAttachment.Rename(DocumentAttachment."Table ID", DocumentAttachment."No.", DocumentAttachment."Document Type", DocumentAttachment."Line No.", DocumentAttachment.ID);
DocumentAttachment.Find();
end;
if HasRegisteredField(TempAttachmentEntityBuffer.FieldNo("Document Flow Sales"), TempFieldBuffer) then begin
DocumentAttachment.Validate("Document Flow Sales", TempAttachmentEntityBuffer."Document Flow Sales");
ModifyRecord := true;
end;
if HasRegisteredField(TempAttachmentEntityBuffer.FieldNo("Document Flow Purchase"), TempFieldBuffer) then begin
DocumentAttachment.Validate("Document Flow Purchase", TempAttachmentEntityBuffer."Document Flow Purchase");
ModifyRecord := true;
end;
if HasRegisteredField(TempAttachmentEntityBuffer.FieldNo("File Name"), TempFieldBuffer) then begin
DocumentAttachment.Validate("File Extension", FileManagement.GetExtension(TempAttachmentEntityBuffer."File Name"));
DocumentAttachment.Validate("File Name", CopyStr(FileManagement.GetFileNameWithoutExtension(TempAttachmentEntityBuffer."File Name"), 1, MaxStrLen(DocumentAttachment."File Name")));
ModifyRecord := true;
end;
if ModifyRecord then
DocumentAttachment.Modify(true);
end;
procedure SetDocumentAttachmentNo(var DocumentAttachment: Record "Document Attachment"; var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary)
var
DummySalesHeader: Record "Sales Header";
SalesInvoiceEntityAggregate: Record "Sales Invoice Entity Aggregate";
PurchInvEntityAggregate: Record "Purch. Inv. Entity Aggregate";
SalesCrMemoEntityBuffer: Record "Sales Cr. Memo Entity Buffer";
PurchCrMemoEntityBuffer: Record "Purch. Cr. Memo Entity Buffer";
DataTypeManagement: Codeunit "Data Type Management";
MainRecordRef: RecordRef;
FieldRefVar: FieldRef;
begin
MainRecordRef.Open(DocumentAttachment."Table ID");
case DocumentAttachment."Table ID" of
Database::"Sales Invoice Header":
begin
SalesInvoiceEntityAggregate.SetRange(Id, TempAttachmentEntityBuffer."Document Id");
SalesInvoiceEntityAggregate.FindFirst();
DocumentAttachment."No." := SalesInvoiceEntityAggregate."No.";
exit;
end;
Database::"Purch. Inv. Header":
begin
PurchInvEntityAggregate.SetRange(Id, TempAttachmentEntityBuffer."Document Id");
PurchInvEntityAggregate.FindFirst();
DocumentAttachment."No." := PurchInvEntityAggregate."No.";
exit;
end;
Database::"Sales Cr.Memo Header":
begin
SalesCrMemoEntityBuffer.SetRange(Id, TempAttachmentEntityBuffer."Document Id");
SalesCrMemoEntityBuffer.FindFirst();
DocumentAttachment."No." := SalesCrMemoEntityBuffer."No.";
exit;
end;
Database::"Purch. Cr. Memo Hdr.":
begin
PurchCrMemoEntityBuffer.SetRange(Id, TempAttachmentEntityBuffer."Document Id");
PurchCrMemoEntityBuffer.FindFirst();
DocumentAttachment."No." := PurchCrMemoEntityBuffer."No.";
exit;
end;
end;
MainRecordRef.GetBySystemId(TempAttachmentEntityBuffer."Document Id");
if not DataTypeManagement.FindFieldByName(MainRecordRef, FieldRefVar, DummySalesHeader.FieldName("No.")) then
Error(CannotFindParentKeyErr);
DocumentAttachment."No." := FieldRefVar.Value();
end;
local procedure LinkNewAttachmentsToDocument(var TempOldAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var TempNewAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; DocumentId: Guid)
var
IncomingDocumentAttachment: Record "Incoming Document Attachment";
UnlinkedAttachment: Record "Unlinked Attachment";
AttachmentId: Guid;
FileName: Text[250];
begin
if TempNewAttachmentEntityBuffer.FindSet() then
repeat
AttachmentId := TempNewAttachmentEntityBuffer.Id;
FileName := TempNewAttachmentEntityBuffer."File Name";
if not TempOldAttachmentEntityBuffer.Get(AttachmentId) then
case true of
FindUnlinkedAttachment(AttachmentId, UnlinkedAttachment):
begin
if FileName = '' then
FileName := UnlinkedAttachment."File Name";
LinkAttachmentToDocument(UnlinkedAttachment.SystemId, DocumentId, FileName);
end;
FindLinkedAttachment(AttachmentId, IncomingDocumentAttachment):
begin
IncomingDocumentAttachment.CalcFields(Content);
TempNewAttachmentEntityBuffer.Content := IncomingDocumentAttachment.Content;
TempNewAttachmentEntityBuffer.Modify(true);
CopyAttachment(TempNewAttachmentEntityBuffer, UnlinkedAttachment, true);
if FileName = '' then
FileName := NameAndExtensionToFileName(
IncomingDocumentAttachment.Name, IncomingDocumentAttachment."File Extension");
LinkAttachmentToDocument(UnlinkedAttachment.SystemId, DocumentId, FileName);
end;
else begin
CopyAttachment(TempNewAttachmentEntityBuffer, UnlinkedAttachment, false);
if FileName = '' then
FileName := UnlinkedAttachment."File Name";
LinkAttachmentToDocument(UnlinkedAttachment.SystemId, DocumentId, FileName);
end;
end
else
if TempNewAttachmentEntityBuffer."File Name" <> TempOldAttachmentEntityBuffer."File Name" then
if FindLinkedAttachment(AttachmentId, IncomingDocumentAttachment) then begin
FileNameToNameAndExtension(FileName, IncomingDocumentAttachment.Name, IncomingDocumentAttachment."File Extension");
IncomingDocumentAttachment.Modify(true);
end;
until TempNewAttachmentEntityBuffer.Next() = 0;
end;
local procedure LinkAttachmentToDocument(AttachmentId: Guid; DocumentId: Guid; FileName: Text[250])
var
TempFieldBuffer: Record "Field Buffer" temporary;
TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary;
UnlinkedAttachment: Record "Unlinked Attachment";
ErrorMsg: Text;
begin
UnlinkedAttachment.SetAutoCalcFields(Content);
UnlinkedAttachment.Get(AttachmentId);
TransferFromUnlinkedAttachment(TempAttachmentEntityBuffer, UnlinkedAttachment);
TempAttachmentEntityBuffer."Document Id" := DocumentId;
TempAttachmentEntityBuffer."File Name" := FileName;
RegisterFieldSet(TempAttachmentEntityBuffer.FieldNo("Created Date-Time"), TempFieldBuffer);
RegisterFieldSet(TempAttachmentEntityBuffer.FieldNo("File Name"), TempFieldBuffer);
RegisterFieldSet(TempAttachmentEntityBuffer.FieldNo(Content), TempFieldBuffer);
PropagateInsertLinkedAttachment(TempAttachmentEntityBuffer, TempFieldBuffer, ErrorMsg);
end;
local procedure LinkAttachmentToDocumentWithDocumentType(AttachmentId: Guid; DocumentId: Guid; DocumentType: Enum "Attachment Entity Buffer Document Type"; FileName: Text[250])
var
TempFieldBuffer: Record "Field Buffer" temporary;
TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary;
UnlinkedAttachment: Record "Unlinked Attachment";
ErrorMsg: Text;
begin
UnlinkedAttachment.SetAutoCalcFields(Content);
UnlinkedAttachment.Get(AttachmentId);
TransferFromUnlinkedAttachment(TempAttachmentEntityBuffer, UnlinkedAttachment);
TempAttachmentEntityBuffer."Document Id" := DocumentId;
TempAttachmentEntityBuffer."Document Type" := DocumentType;
TempAttachmentEntityBuffer."File Name" := FileName;
RegisterFieldSet(TempAttachmentEntityBuffer.FieldNo("Created Date-Time"), TempFieldBuffer);
RegisterFieldSet(TempAttachmentEntityBuffer.FieldNo("File Name"), TempFieldBuffer);
RegisterFieldSet(TempAttachmentEntityBuffer.FieldNo(Content), TempFieldBuffer);
PropagateInsertLinkedAttachmentWithDocumentType(TempAttachmentEntityBuffer, TempFieldBuffer, ErrorMsg);
end;
local procedure UnlinkAttachmentFromDocument(var IncomingDocumentAttachment: Record "Incoming Document Attachment")
var
TempFieldBuffer: Record "Field Buffer" temporary;
TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary;
begin
TransferFromIncomingDocumentAttachment(TempAttachmentEntityBuffer, IncomingDocumentAttachment, EmptyGuid);
RegisterFieldSet(TempAttachmentEntityBuffer.FieldNo("Created Date-Time"), TempFieldBuffer);
RegisterFieldSet(TempAttachmentEntityBuffer.FieldNo("File Name"), TempFieldBuffer);
RegisterFieldSet(TempAttachmentEntityBuffer.FieldNo(Content), TempFieldBuffer);
PropagateInsertUnlinkedAttachment(TempAttachmentEntityBuffer, TempFieldBuffer);
end;
procedure CopyAttachment(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var UnlinkedAttachment: Record "Unlinked Attachment"; GenerateNewId: Boolean)
begin
UnlinkedAttachment.TransferFields(TempAttachmentEntityBuffer);
Clear(UnlinkedAttachment.Id);
UnlinkedAttachment.Insert(true);
end;
procedure RegisterFieldSet(FieldNo: Integer; var TempFieldBuffer: Record "Field Buffer" temporary)
var
LastOrderNo: Integer;
begin
LastOrderNo := 1;
if TempFieldBuffer.FindLast() then
LastOrderNo := TempFieldBuffer.Order + 1;
Clear(TempFieldBuffer);
TempFieldBuffer.Order := LastOrderNo;
TempFieldBuffer."Table ID" := DATABASE::"Attachment Entity Buffer";
TempFieldBuffer."Field ID" := FieldNo;
TempFieldBuffer.Insert();
end;
local procedure HasRegisteredField(FieldNo: Integer; var TempFieldBuffer: Record "Field Buffer" temporary): Boolean
begin
TempFieldBuffer.SetRange("Field ID", FieldNo);
TempFieldBuffer.SetRange("Table ID", Database::"Attachment Entity Buffer");
exit(TempFieldBuffer.FindFirst());
end;
local procedure GetDocumentIdFilter(var AttachmentEntityBuffer: Record "Attachment Entity Buffer"): Text
var
DocumentIdFilter: Text;
begin
if IsNullGuid(AttachmentEntityBuffer."Document Id") then begin
DocumentIdFilter := AttachmentEntityBuffer.GetFilter("Document Id");
if DocumentIdFilter = '' then
DocumentIdFilter := Format(EmptyGuid);
end else
DocumentIdFilter := Format(AttachmentEntityBuffer."Document Id");
exit(DocumentIdFilter);
end;
local procedure GetDocumentTypeFilter(var AttachmentEntityBuffer: Record "Attachment Entity Buffer"): Text
var
DocumentTypeFilter: Text;
begin
if AttachmentEntityBuffer."Document Type" = AttachmentEntityBuffer."Document Type"::" " then
DocumentTypeFilter := AttachmentEntityBuffer.GetFilter("Document Type")
else
DocumentTypeFilter := Format(AttachmentEntityBuffer."Document Type");
exit(DocumentTypeFilter);
end;
local procedure GetGLEntryNoFilter(var AttachmentEntityBuffer: Record "Attachment Entity Buffer"): Text
var
GLEntryNoFilter: Text;
begin
if AttachmentEntityBuffer."G/L Entry No." = 0 then
GLEntryNoFilter := AttachmentEntityBuffer.GetFilter("G/L Entry No.")
else
GLEntryNoFilter := Format(AttachmentEntityBuffer."G/L Entry No.");
exit(GLEntryNoFilter);
end;
local procedure IsLinkedAttachment(DocumentIdFilter: Text): Boolean
begin
exit((DocumentIdFilter <> '') and (DocumentIdFilter <> Format(EmptyGuid)));
end;
local procedure IsPostedDocument(var DocumentRecordRef: RecordRef): Boolean
begin
exit(
(DocumentRecordRef.Number = DATABASE::"Sales Invoice Header") or (DocumentRecordRef.Number = DATABASE::"Purch. Inv. Header") or (DocumentRecordRef.Number = Database::"Sales Cr.Memo Header") or (DocumentRecordRef.Number = Database::"Purch. Cr. Memo Hdr."));
end;
local procedure IsGeneralJournalLine(var DocumentRecordRef: RecordRef): Boolean
begin
exit(DocumentRecordRef.Number = DATABASE::"Gen. Journal Line");
end;
local procedure IsGLEntry(var DocumentRecordRef: RecordRef): Boolean
begin
exit(DocumentRecordRef.Number = DATABASE::"G/L Entry");
end;
local procedure IsSalesInvoice(var DocumentRecordRef: RecordRef): Boolean
var
DocumentType: Option Quote,Invoice,"Journal Line","G/L Entry","Sales Order","Sales Credit Memo","Purchase Order","Purchase Credit Memo";
begin
if DocumentRecordRef.Number = DATABASE::"Sales Invoice Header" then
exit(true);
if DocumentRecordRef.Number = DATABASE::"Sales Header" then begin
GetDocumentType(DocumentRecordRef, DocumentType);
exit(DocumentType = DocumentType::Invoice);
end;
exit(false);
end;
local procedure IsPurchaseInvoice(var DocumentRecordRef: RecordRef): Boolean
var
DocumentType: Option Quote,Invoice,"Journal Line","G/L Entry","Sales Order","Sales Credit Memo","Purchase Order","Purchase Credit Memo";
begin
if DocumentRecordRef.Number = DATABASE::"Purch. Inv. Header" then
exit(true);
if DocumentRecordRef.Number = DATABASE::"Purchase Header" then begin
GetDocumentType(DocumentRecordRef, DocumentType);
exit(DocumentType = DocumentType::Invoice);
end;
exit(false);
end;
local procedure IsSalesQuote(var DocumentRecordRef: RecordRef): Boolean
var
DocumentType: Option Quote,Invoice,"Journal Line","G/L Entry","Sales Order","Sales Credit Memo","Purchase Order","Purchase Credit Memo";
begin
GetDocumentType(DocumentRecordRef, DocumentType);
exit(DocumentType = DocumentType::Quote);
end;
local procedure IsSalesOrder(var DocumentRecordRef: RecordRef): Boolean
var
DocumentType: Option Quote,Invoice,"Journal Line","G/L Entry","Sales Order","Sales Credit Memo","Purchase Order","Purchase Credit Memo";
begin
GetDocumentType(DocumentRecordRef, DocumentType);
exit(DocumentType = DocumentType::"Sales Order");
end;
local procedure IsPurchaseOrder(var DocumentRecordRef: RecordRef): Boolean
var
DocumentType: Option Quote,Invoice,"Journal Line","G/L Entry","Sales Order","Sales Credit Memo","Purchase Order","Purchase Credit Memo";
begin
GetDocumentType(DocumentRecordRef, DocumentType);
exit(DocumentType = DocumentType::"Purchase Order");
end;
local procedure IsSalesCreditMemo(var DocumentRecordRef: RecordRef): Boolean
var
DocumentType: Option Quote,Invoice,"Journal Line","G/L Entry","Sales Order","Sales Credit Memo","Purchase Order","Purchase Credit Memo";
begin
GetDocumentType(DocumentRecordRef, DocumentType);
exit(DocumentType = DocumentType::"Sales Credit Memo");
end;
local procedure IsPurchaseCreditMemo(var DocumentRecordRef: RecordRef): Boolean
var
DocumentType: Option Quote,Invoice,"Journal Line","G/L Entry","Sales Order","Sales Credit Memo","Purchase Order","Purchase Credit Memo";
begin
GetDocumentType(DocumentRecordRef, DocumentType);
exit(DocumentType = DocumentType::"Purchase Credit Memo");
end;
local procedure GetDocumentType(var DocumentRecordRef: RecordRef; var DocumentType: Option Quote,Invoice,"Journal Line","G/L Entry","Sales Order","Sales Credit Memo","Purchase Order","Purchase Credit Memo")
var
SalesHeader: Record "Sales Header";
PurchaseHeader: Record "Purchase Header";
begin
if DocumentRecordRef.Number = DATABASE::"Gen. Journal Line" then begin
DocumentType := DocumentType::"Journal Line";
exit;
end;
if DocumentRecordRef.Number = DATABASE::"G/L Entry" then begin
DocumentType := DocumentType::"G/L Entry";
exit;
end;
if DocumentRecordRef.Number = DATABASE::"Sales Invoice Header" then begin
DocumentType := DocumentType::Invoice;
exit;
end;
if DocumentRecordRef.Number = Database::"Sales Cr.Memo Header" then begin
DocumentType := DocumentType::"Sales Credit Memo";
exit;
end;
if DocumentRecordRef.Number = Database::"Purch. Cr. Memo Hdr." then begin
DocumentType := DocumentType::"Purchase Credit Memo";
exit;
end;
if DocumentRecordRef.Number = DATABASE::"Purch. Inv. Header" then begin
DocumentType := DocumentType::Invoice;
exit;
end;
if DocumentRecordRef.Number = DATABASE::"Purchase Header" then begin
DocumentRecordRef.SetTable(PurchaseHeader);
if PurchaseHeader."Document Type" = PurchaseHeader."Document Type"::Invoice then begin
DocumentType := DocumentType::Invoice;
exit;
end;
if PurchaseHeader."Document Type" = PurchaseHeader."Document Type"::Order then begin
DocumentType := DocumentType::"Purchase Order";
exit;
end;
if PurchaseHeader."Document Type" = PurchaseHeader."Document Type"::"Credit Memo" then begin
DocumentType := DocumentType::"Purchase Credit Memo";
exit;
end;
end;
if DocumentRecordRef.Number = Database::"Sales Header" then begin
DocumentRecordRef.SetTable(SalesHeader);
if SalesHeader."Document Type" = SalesHeader."Document Type"::Invoice then begin
DocumentType := DocumentType::Invoice;
exit;
end;
if SalesHeader."Document Type" = SalesHeader."Document Type"::Quote then begin
DocumentType := DocumentType::Quote;
exit;
end;
if SalesHeader."Document Type" = SalesHeader."Document Type"::Order then begin
DocumentType := DocumentType::"Sales Order";
exit;
end;
if SalesHeader."Document Type" = SalesHeader."Document Type"::"Credit Memo" then begin
DocumentType := DocumentType::"Sales Credit Memo";
exit;
end;
end;
end;
local procedure GetDocumentId(var DocumentRecordRef: RecordRef): Guid
var
SalesInvoiceHeader: Record "Sales Invoice Header";
SalesCrMemoHeader: Record "Sales Cr.Memo Header";
PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr.";
PurchInvHeader: Record "Purch. Inv. Header";
PurchInvAggregator: Codeunit "Purch. Inv. Aggregator";
SalesInvoiceAggregator: Codeunit "Sales Invoice Aggregator";
GraphMgtSalCrMemoBuf: Codeunit "Graph Mgt - Sal. Cr. Memo Buf.";
GraphMgtPurchCrMemo: Codeunit "Graph Mgt - Purch. Cr. Memo";
Id: Guid;
begin
case DocumentRecordRef.Number of
Database::"Sales Invoice Header":
begin
DocumentRecordRef.SetTable(SalesInvoiceHeader);
exit(SalesInvoiceAggregator.GetSalesInvoiceHeaderId(SalesInvoiceHeader));
end;
Database::"Sales Cr.Memo Header":
begin
DocumentRecordRef.SetTable(SalesCrMemoHeader);
exit(GraphMgtSalCrMemoBuf.GetSalesCrMemoHeaderId(SalesCrMemoHeader));
end;
Database::"Purch. Inv. Header":
begin
DocumentRecordRef.SetTable(PurchInvHeader);
exit(PurchInvAggregator.GetPurchaseInvoiceHeaderId(PurchInvHeader));
end;
Database::"Gen. Journal Line", Database::"G/L Entry":
begin
Evaluate(Id, Format(DocumentRecordRef.Field(DocumentRecordRef.SystemIdNo()).Value()));
exit(Id);
end;
Database::"Purch. Cr. Memo Hdr.":
begin
DocumentRecordRef.SetTable(PurchCrMemoHdr);
exit(GraphMgtPurchCrMemo.GetPurchaseCrMemoHeaderId(PurchCrMemoHdr));
end;
end;
Evaluate(Id, Format(DocumentRecordRef.Field(DocumentRecordRef.SystemIdNo()).Value()));
exit(Id);
end;
local procedure GetGLEntryNo(var DocumentRecordRef: RecordRef): Integer
var
DummyGLEntry: Record "G/L Entry";
DataTypeManagement: Codeunit "Data Type Management";
EntryNoFieldRef: FieldRef;
EntryNo: Integer;
begin
if DataTypeManagement.FindFieldByName(DocumentRecordRef, EntryNoFieldRef, DummyGLEntry.FieldName("Entry No.")) then
Evaluate(EntryNo, Format(EntryNoFieldRef.Value));
exit(EntryNo);
end;
procedure GetDocumentIdFromAttachmentId(AttachmentId: Guid): Guid
var
IncomingDocumentAttachment: Record "Incoming Document Attachment";
IncomingDocument: Record "Incoming Document";
DocumentRecordRef: RecordRef;
DocumentVariant: Variant;
begin
IncomingDocumentAttachment.SetFilter(SystemId, AttachmentId);
if not IncomingDocumentAttachment.FindFirst() then
exit(EmptyGuid);
IncomingDocument.Get(IncomingDocumentAttachment."Incoming Document Entry No.");
if not IncomingDocument.GetRecord(DocumentVariant) then
exit(EmptyGuid);
DocumentRecordRef.GetTable(DocumentVariant);
exit(GetDocumentId(DocumentRecordRef));
end;
procedure GetDocumentTypeFromAttachmentIdAndDocumentId(AttachmentId: Guid; DocumentId: Guid): Enum "Attachment Entity Buffer Document Type"
var
IncomingDocumentAttachment: Record "Incoming Document Attachment";
IncomingDocument: Record "Incoming Document";
GLEntry: Record "G/L Entry";
SalesHeader: Record "Sales Header";
PurchaseHeader: Record "Purchase Header";
AttachmentEntityBufferDocType: Enum "Attachment Entity Buffer Document Type";
begin
if not IncomingDocumentAttachment.GetBySystemId(AttachmentId) then
exit(AttachmentEntityBufferDocType::" ");
IncomingDocument.Get(IncomingDocumentAttachment."Incoming Document Entry No.");
case IncomingDocument."Document Type" of
IncomingDocument."Document Type"::Journal:
exit(AttachmentEntityBufferDocType::Journal);
IncomingDocument."Document Type"::"Sales Credit Memo":
exit(AttachmentEntityBufferDocType::"Sales Credit Memo");
IncomingDocument."Document Type"::"Sales Invoice":
if SalesHeader.GetBySystemId(DocumentId) then begin
if SalesHeader."Incoming Document Entry No." = IncomingDocument."Entry No." then begin
if SalesHeader."Document Type" = SalesHeader."Document Type"::Order then
exit(AttachmentEntityBufferDocType::"Sales Order");
if SalesHeader."Document Type" = SalesHeader."Document Type"::Quote then
exit(AttachmentEntityBufferDocType::"Sales Quote");
if SalesHeader."Document Type" = SalesHeader."Document Type"::Invoice then
exit(AttachmentEntityBufferDocType::"Sales Invoice");
if SalesHeader."Document Type" = SalesHeader."Document Type"::"Credit Memo" then
exit(AttachmentEntityBufferDocType::"Sales Credit Memo");
end;
end else
exit(AttachmentEntityBufferDocType::"Sales Invoice");
IncomingDocument."Document Type"::"Purchase Invoice":
begin
if PurchaseHeader.GetBySystemId(DocumentId) then
if PurchaseHeader."Incoming Document Entry No." = IncomingDocument."Entry No." then
if PurchaseHeader."Document Type" = PurchaseHeader."Document Type"::Order then
exit(AttachmentEntityBufferDocType::"Purchase Order");
exit(AttachmentEntityBufferDocType::"Purchase Invoice");
end;
IncomingDocument."Document Type"::"Purchase Credit Memo":
exit(AttachmentEntityBufferDocType::"Purchase Credit Memo");
IncomingDocument."Document Type"::" ":
begin
if GLEntry.Get(IncomingDocument."Related Record ID") then
exit(AttachmentEntityBufferDocType::Journal);
exit(AttachmentEntityBufferDocType::" ");
end;
end;
end;
local procedure VerifyCRUDIsPossibleSafe(var DocumentRecordRef: RecordRef; var ErrorMsg: Text)
var
SalesInvoiceEntityAggregate: Record "Sales Invoice Entity Aggregate";
SearchSalesInvoiceEntityAggregate: Record "Sales Invoice Entity Aggregate";
PurchInvEntityAggregate: Record "Purch. Inv. Entity Aggregate";
SearchPurchInvEntityAggregate: Record "Purch. Inv. Entity Aggregate";
SalesQuoteEntityBuffer: Record "Sales Quote Entity Buffer";
SearchSalesQuoteEntityBuffer: Record "Sales Quote Entity Buffer";
SalesOrderEntityBuffer: Record "Sales Order Entity Buffer";
SearchSalesOrderEntityBuffer: Record "Sales Order Entity Buffer";
SalesCreditMemoEntityBuffer: Record "Sales Cr. Memo Entity Buffer";
SearchSalesCreditMemoEntityBuffer: Record "Sales Cr. Memo Entity Buffer";
PurchaseOrderEntityBuffer: Record "Purchase Order Entity Buffer";
SearchPurchaseOrderEntityBuffer: Record "Purchase Order Entity Buffer";
GenJournalLine: Record "Gen. Journal Line";
GLEntry: Record "G/L Entry";
PurchCrMemoEntityBuffer: Record "Purch. Cr. Memo Entity Buffer";
SearchPurchCrMemoEntityBuffer: Record "Purch. Cr. Memo Entity Buffer";
DocumentId: Guid;
begin
DocumentId := GetDocumentId(DocumentRecordRef);
if IsGeneralJournalLine(DocumentRecordRef) then begin
GenJournalLine.SetRange(SystemId, DocumentId);
if not GenJournalLine.FindFirst() then begin
ErrorMsg := DocumentDoesNotExistErr;
exit;
end;
exit;
end;
if IsGLEntry(DocumentRecordRef) and IsNullGuid(DocumentId) then
exit;
if IsGLEntry(DocumentRecordRef) then begin
if not GLEntry.GetBySystemId(DocumentId) then begin
ErrorMsg := DocumentDoesNotExistErr;
exit;
end;
exit;
end;
if IsSalesInvoice(DocumentRecordRef) then begin
SalesInvoiceEntityAggregate.SetRange(Id, DocumentId);
if not SalesInvoiceEntityAggregate.FindFirst() then begin
ErrorMsg := DocumentDoesNotExistErr;
exit;
end;
SearchSalesInvoiceEntityAggregate.Copy(SalesInvoiceEntityAggregate);
if SearchSalesInvoiceEntityAggregate.Next() <> 0 then
ErrorMsg := MultipleDocumentsFoundForIdErr;
exit;
end;
if IsPurchaseInvoice(DocumentRecordRef) then begin
PurchInvEntityAggregate.SetRange(Id, DocumentId);
if not PurchInvEntityAggregate.FindFirst() then begin
ErrorMsg := DocumentDoesNotExistErr;
exit;
end;
SearchPurchInvEntityAggregate.Copy(PurchInvEntityAggregate);
if SearchPurchInvEntityAggregate.Next() <> 0 then
ErrorMsg := MultipleDocumentsFoundForIdErr;
exit;
end;
if IsSalesQuote(DocumentRecordRef) then begin
SalesQuoteEntityBuffer.SetRange(Id, DocumentId);
if not SalesQuoteEntityBuffer.FindFirst() then begin
ErrorMsg := DocumentDoesNotExistErr;
exit;
end;
SearchSalesQuoteEntityBuffer.Copy(SalesQuoteEntityBuffer);
if SearchSalesQuoteEntityBuffer.Next() <> 0 then
ErrorMsg := MultipleDocumentsFoundForIdErr;
exit;
end;
if IsSalesOrder(DocumentRecordRef) then begin
SalesOrderEntityBuffer.SetRange(Id, DocumentId);
if not SalesOrderEntityBuffer.FindFirst() then begin
ErrorMsg := DocumentDoesNotExistErr;
exit;
end;
SearchSalesOrderEntityBuffer.Copy(SalesOrderEntityBuffer);
if SearchSalesOrderEntityBuffer.Next() <> 0 then
ErrorMsg := MultipleDocumentsFoundForIdErr;
exit;
end;
if IsSalesCreditMemo(DocumentRecordRef) then begin
SalesCreditMemoEntityBuffer.SetRange(Id, DocumentId);
if not SalesCreditMemoEntityBuffer.FindFirst() then begin
ErrorMsg := DocumentDoesNotExistErr;
exit;
end;
SearchSalesCreditMemoEntityBuffer.Copy(SalesCreditMemoEntityBuffer);
if SearchSalesCreditMemoEntityBuffer.Next() <> 0 then
ErrorMsg := MultipleDocumentsFoundForIdErr;
exit;
end;
if IsPurchaseOrder(DocumentRecordRef) then begin
PurchaseOrderEntityBuffer.SetRange(Id, DocumentId);
if not PurchaseOrderEntityBuffer.FindFirst() then begin
ErrorMsg := DocumentDoesNotExistErr;
exit;
end;
SearchPurchaseOrderEntityBuffer.Copy(PurchaseOrderEntityBuffer);
if SearchPurchaseOrderEntityBuffer.Next() <> 0 then
ErrorMsg := MultipleDocumentsFoundForIdErr;
exit;
end;
if IsPurchaseCreditMemo(DocumentRecordRef) then begin
PurchCrMemoEntityBuffer.SetRange(Id, DocumentId);
if not PurchCrMemoEntityBuffer.FindFirst() then begin
ErrorMsg := DocumentDoesNotExistErr;
exit;
end;
SearchPurchCrMemoEntityBuffer.Copy(PurchCrMemoEntityBuffer);
if SearchPurchCrMemoEntityBuffer.Next() <> 0 then
ErrorMsg := MultipleDocumentsFoundForIdErr;
exit;
end;
ErrorMsg := DocumentDoesNotExistErr;
end;
local procedure VerifyCRUDIsPossible(var DocumentRecordRef: RecordRef)
var
ErrorMsg: Text;
begin
VerifyCRUDIsPossibleSafe(DocumentRecordRef, ErrorMsg);
ThrowErrorIfAny(ErrorMsg);
end;
local procedure FindLinkedAttachment(AttachmentId: Guid; var IncomingDocumentAttachment: Record "Incoming Document Attachment"): Boolean
begin
IncomingDocumentAttachment.SetRange(SystemId, AttachmentId);
exit(IncomingDocumentAttachment.FindFirst());
end;
local procedure FindUnlinkedAttachment(AttachmentId: Guid; var UnlinkedAttachment: Record "Unlinked Attachment"): Boolean
begin
exit(UnlinkedAttachment.Get(AttachmentId));
end;
local procedure FindParentDocumentSafe(DocumentIdFilter: Text; var DocumentRecordRef: RecordRef; var ErrorMsg: Text)
var
SalesHeader: Record "Sales Header";
SalesInvoiceHeader: Record "Sales Invoice Header";
PurchaseHeader: Record "Purchase Header";
PurchInvHeader: Record "Purch. Inv. Header";
GenJournalLine: Record "Gen. Journal Line";
GLEntry: Record "G/L Entry";
SalesInvoiceAggregator: Codeunit "Sales Invoice Aggregator";
PurchInvAggregator: Codeunit "Purch. Inv. Aggregator";
TypeHelper: Codeunit "Type Helper";
Value: Variant;
DummyGLEntryNo: Integer;
begin
if DocumentIdFilter = '' then begin
ErrorMsg := DocumentIDNotSpecifiedForAttachmentsErr;
exit;
end;
DummyGLEntryNo := 0;
Value := DummyGLEntryNo;
if TypeHelper.Evaluate(Value, DocumentIdFilter, '', 'en-US') then begin
GLEntry.SetFilter("Entry No.", DocumentIdFilter);
if GLEntry.FindFirst() then begin
DocumentRecordRef.GetTable(GLEntry);
exit;
end;
end;
GenJournalLine.SetFilter(SystemId, DocumentIdFilter);
if GenJournalLine.FindFirst() then begin
DocumentRecordRef.GetTable(GenJournalLine);
exit;
end;
SalesHeader.SetFilter(SystemId, DocumentIdFilter);
if SalesHeader.FindFirst() then begin
DocumentRecordRef.GetTable(SalesHeader);
exit;
end;
if SalesInvoiceAggregator.GetSalesInvoiceHeaderFromId(DocumentIdFilter, SalesInvoiceHeader) then begin
DocumentRecordRef.GetTable(SalesInvoiceHeader);
exit;
end;
PurchaseHeader.SetFilter(SystemId, DocumentIdFilter);
if PurchaseHeader.FindFirst() then begin
DocumentRecordRef.GetTable(PurchaseHeader);
exit;
end;
if PurchInvAggregator.GetPurchaseInvoiceHeaderFromId(DocumentIdFilter, PurchInvHeader) then begin
DocumentRecordRef.GetTable(PurchInvHeader);
exit;
end;
ErrorMsg := DocumentDoesNotExistErr;
end;
local procedure FindParentDocument(DocumentIdFilter: Text; var DocumentRecordRef: RecordRef)
var
ErrorMsg: Text;
begin
FindParentDocumentSafe(DocumentIdFilter, DocumentRecordRef, ErrorMsg);
ThrowErrorIfAny(ErrorMsg);
end;
local procedure FindParentDocumentWithDocumentTypeSafe(DocumentIdFilter: Text; DocumentTypeFilter: Text; var DocumentRecordRef: RecordRef; var ErrorMsg: Text)
var
SalesHeader: Record "Sales Header";
SalesInvoiceHeader: Record "Sales Invoice Header";
PurchaseHeader: Record "Purchase Header";
PurchInvHeader: Record "Purch. Inv. Header";
GenJournalLine: Record "Gen. Journal Line";
SalesCrMemoHeader: Record "Sales Cr.Memo Header";
GLEntry: Record "G/L Entry";
PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr.";
SalesShipmentHeader: Record "Sales Shipment Header";
ReturnReceiptHeader: Record "Return Receipt Header";
PurchRcptHeader: Record "Purch. Rcpt. Header";
ReturnShipmentHeader: Record "Return Shipment Header";
TransferHeader: Record "Transfer Header";
TransferShipmentHeader: Record "Transfer Shipment Header";
TransferReceiptHeader: Record "Transfer Receipt Header";
DirectTransHeader: Record "Direct Trans. Header";
SalesHeaderArchive: Record "Sales Header Archive";
PurchaseHeaderArchive: Record "Purchase Header Archive";
AssemblyHeader: Record "Assembly Header";
PostedAssemblyHeader: Record "Posted Assembly Header";
PhysInvtOrderHeader: Record "Phys. Invt. Order Header";
PstdPhysInvtOrderHdr: Record "Pstd. Phys. Invt. Order Hdr";
PhysInvtRecordHeader: Record "Phys. Invt. Record Header";
PstdPhysInvtRecordHdr: Record "Pstd. Phys. Invt. Record Hdr";
InvtShipmentHeader: Record "Invt. Shipment Header";
InvtReceiptHeader: Record "Invt. Receipt Header";
InvtDocumentHeader: Record "Invt. Document Header";
SalesInvoiceAggregator: Codeunit "Sales Invoice Aggregator";
PurchInvAggregator: Codeunit "Purch. Inv. Aggregator";
GraphMgtSalCrMemoBuf: Codeunit "Graph Mgt - Sal. Cr. Memo Buf.";
GraphMgtPurchCrMemo: Codeunit "Graph Mgt - Purch. Cr. Memo";
AttachmentEntityBufferDocType: Enum "Attachment Entity Buffer Document Type";
begin
if (DocumentIdFilter = '') or (DocumentTypeFilter = '') then begin
ErrorMsg := DocumentIDorTypeNotSpecifiedForAttachmentsErr;
exit;
end;
Evaluate(AttachmentEntityBufferDocType, DocumentTypeFilter);
case AttachmentEntityBufferDocType of
AttachmentEntityBufferDocType::Journal:
begin
if GLEntry.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(GLEntry);
exit;
end;
if GenJournalLine.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(GenJournalLine);
exit;
end;
end;
AttachmentEntityBufferDocType::"Sales Order", AttachmentEntityBufferDocType::"Sales Quote":
if SalesHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(SalesHeader);
exit;
end;
AttachmentEntityBufferDocType::"Sales Invoice":
begin
if SalesHeader.GetBySystemId(DocumentIdFilter) then
if SalesHeader."Document Type" = SalesHeader."Document Type"::Invoice then begin
DocumentRecordRef.GetTable(SalesHeader);
exit;
end;
if SalesInvoiceAggregator.GetSalesInvoiceHeaderFromId(DocumentIdFilter, SalesInvoiceHeader) then begin
DocumentRecordRef.GetTable(SalesInvoiceHeader);
exit;
end;
end;
AttachmentEntityBufferDocType::"Sales Credit Memo":
begin
if SalesHeader.GetBySystemId(DocumentIdFilter) then
if SalesHeader."Document Type" = SalesHeader."Document Type"::"Credit Memo" then begin
DocumentRecordRef.GetTable(SalesHeader);
exit;
end;
if GraphMgtSalCrMemoBuf.GetSalesCrMemoHeaderFromId(DocumentIdFilter, SalesCrMemoHeader) then begin
DocumentRecordRef.GetTable(SalesCrMemoHeader);
exit;
end;
end;
AttachmentEntityBufferDocType::"Purchase Invoice":
begin
if PurchaseHeader.GetBySystemId(DocumentIdFilter) then
if PurchaseHeader."Document Type" = PurchaseHeader."Document Type"::Invoice then begin
DocumentRecordRef.GetTable(PurchaseHeader);
exit;
end;
if PurchInvAggregator.GetPurchaseInvoiceHeaderFromId(DocumentIdFilter, PurchInvHeader) then begin
DocumentRecordRef.GetTable(PurchInvHeader);
exit;
end;
end;
AttachmentEntityBufferDocType::"Purchase Order":
if PurchaseHeader.GetBySystemId(DocumentIdFilter) then
if PurchaseHeader."Document Type" = PurchaseHeader."Document Type"::Order then begin
DocumentRecordRef.GetTable(PurchaseHeader);
exit;
end;
AttachmentEntityBufferDocType::"Purchase Credit Memo":
begin
if PurchaseHeader.GetBySystemId(DocumentIdFilter) then
if PurchaseHeader."Document Type" = PurchaseHeader."Document Type"::"Credit Memo" then begin
DocumentRecordRef.GetTable(PurchaseHeader);
exit;
end;
if GraphMgtPurchCrMemo.GetPurchaseCrMemoHeaderFromId(DocumentIdFilter, PurchCrMemoHdr) then begin
DocumentRecordRef.GetTable(PurchCrMemoHdr);
exit;
end;
end;
AttachmentEntityBufferDocType::"Purchase Quote",
AttachmentEntityBufferDocType::"Blanket Purchase Order",
AttachmentEntityBufferDocType::"Purchase Return Order":
if PurchaseHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(PurchaseHeader);
exit;
end;
AttachmentEntityBufferDocType::"Blanket Sales Order",
AttachmentEntityBufferDocType::"Sales Return Order":
if SalesHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(SalesHeader);
exit;
end;
AttachmentEntityBufferDocType::"Sales Shipment":
if SalesShipmentHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(SalesShipmentHeader);
exit;
end;
AttachmentEntityBufferDocType::"Return Receipt":
if ReturnReceiptHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(ReturnReceiptHeader);
exit;
end;
AttachmentEntityBufferDocType::"Purchase Receipt":
if PurchRcptHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(PurchRcptHeader);
exit;
end;
AttachmentEntityBufferDocType::"Purch. Return Shipment":
if ReturnShipmentHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(ReturnShipmentHeader);
exit;
end;
AttachmentEntityBufferDocType::"Transfer Order":
if TransferHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(TransferHeader);
exit;
end;
AttachmentEntityBufferDocType::"Transfer Shipment":
if TransferShipmentHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(TransferShipmentHeader);
exit;
end;
AttachmentEntityBufferDocType::"Transfer Receipt":
if TransferReceiptHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(TransferReceiptHeader);
exit;
end;
AttachmentEntityBufferDocType::"Posted Direct Transfer":
if DirectTransHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(DirectTransHeader);
exit;
end;
AttachmentEntityBufferDocType::"Sales Archive Quote",
AttachmentEntityBufferDocType::"Sales Archive Order",
AttachmentEntityBufferDocType::"Sales Archive Return",
AttachmentEntityBufferDocType::"Sales Archive Blanket Order":
if SalesHeaderArchive.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(SalesHeaderArchive);
exit;
end;
AttachmentEntityBufferDocType::"Purchase Archive Quote",
AttachmentEntityBufferDocType::"Purchase Archive Order",
AttachmentEntityBufferDocType::"Purchase Archive Return",
AttachmentEntityBufferDocType::"Purchase Archive Blanket Order":
if PurchaseHeaderArchive.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(PurchaseHeaderArchive);
exit;
end;
AttachmentEntityBufferDocType::"Assembly Order":
if AssemblyHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(AssemblyHeader);
exit;
end;
AttachmentEntityBufferDocType::"Posted Assembly Order":
if PostedAssemblyHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(PostedAssemblyHeader);
exit;
end;
AttachmentEntityBufferDocType::"Phys. Inventory Order":
if PhysInvtOrderHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(PhysInvtOrderHeader);
exit;
end;
AttachmentEntityBufferDocType::"Posted Phys. Inventory Order":
if PstdPhysInvtOrderHdr.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(PstdPhysInvtOrderHdr);
exit;
end;
AttachmentEntityBufferDocType::"Phys. Inventory Recording":
if PhysInvtRecordHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(PhysInvtRecordHeader);
exit;
end;
AttachmentEntityBufferDocType::"Posted Phys. Inventory Recording":
if PstdPhysInvtRecordHdr.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(PstdPhysInvtRecordHdr);
exit;
end;
AttachmentEntityBufferDocType::"Inventory Shipment",
AttachmentEntityBufferDocType::"Inventory Receipt":
if InvtDocumentHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(InvtDocumentHeader);
exit;
end;
AttachmentEntityBufferDocType::"Posted Inventory Shipment":
if InvtShipmentHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(InvtShipmentHeader);
exit;
end;
AttachmentEntityBufferDocType::"Posted Inventory Receipt":
if InvtReceiptHeader.GetBySystemId(DocumentIdFilter) then begin
DocumentRecordRef.GetTable(InvtReceiptHeader);
exit;
end;
AttachmentEntityBufferDocType::" ":
ErrorMsg := DocumentIDorTypeNotSpecifiedForAttachmentsErr;
end;
ErrorMsg := DocumentTypeInvalidErr;
end;
local procedure FindIncomingDocument(var DocumentRecordRef: RecordRef; var IncomingDocument: Record "Incoming Document"): Boolean
begin
if IsPostedDocument(DocumentRecordRef) or IsGLEntry(DocumentRecordRef) then
exit(IncomingDocument.FindByDocumentNoAndPostingDate(DocumentRecordRef, IncomingDocument));
exit(IncomingDocument.FindFromIncomingDocumentEntryNo(DocumentRecordRef, IncomingDocument));
end;
local procedure FindOrCreateIncomingDocument(var DocumentRecordRef: RecordRef; var IncomingDocument: Record "Incoming Document")
var
SalesInvoiceHeader: Record "Sales Invoice Header";
SalesHeader: Record "Sales Header";
GenJournalLine: Record "Gen. Journal Line";
GLEntry: Record "G/L Entry";
PurchaseHeader: Record "Purchase Header";
PurchInvHeader: Record "Purch. Inv. Header";
SalesCrMemoHeader: Record "Sales Cr.Memo Header";
PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr.";
begin
if FindIncomingDocument(DocumentRecordRef, IncomingDocument) then
exit;
IncomingDocument.Init();
IncomingDocument."Related Record ID" := DocumentRecordRef.RecordId;
if IsSalesInvoice(DocumentRecordRef) and IsPostedDocument(DocumentRecordRef) then begin
DocumentRecordRef.SetTable(SalesInvoiceHeader);
IncomingDocument.Description := CopyStr(SalesInvoiceHeader."Sell-to Customer Name", 1, MaxStrLen(IncomingDocument.Description));
IncomingDocument."Document Type" := IncomingDocument."Document Type"::"Sales Invoice";
IncomingDocument."Document No." := SalesInvoiceHeader."No.";
IncomingDocument."Posting Date" := SalesInvoiceHeader."Posting Date";
IncomingDocument."Posted Date-Time" := CurrentDateTime;
IncomingDocument.Status := IncomingDocument.Status::Posted;
IncomingDocument.Posted := true;
IncomingDocument.Insert(true);
exit;
end;
if IsGeneralJournalLine(DocumentRecordRef) then begin
DocumentRecordRef.SetTable(GenJournalLine);
IncomingDocument.Description := CopyStr(GenJournalLine.Description, 1, MaxStrLen(IncomingDocument.Description));
IncomingDocument."Document Type" := IncomingDocument."Document Type"::Journal;
IncomingDocument.Insert(true);
GenJournalLine."Incoming Document Entry No." := IncomingDocument."Entry No.";
GenJournalLine.Modify();
DocumentRecordRef.GetTable(GenJournalLine);
exit;
end;
if IsGLEntry(DocumentRecordRef) then begin
DocumentRecordRef.SetTable(GLEntry);
IncomingDocument.Description := CopyStr(GLEntry.Description, 1, MaxStrLen(IncomingDocument.Description));
IncomingDocument."Document No." := GLEntry."Document No.";
IncomingDocument."Posting Date" := GLEntry."Posting Date";
IncomingDocument.Status := IncomingDocument.Status::Posted;
IncomingDocument.Posted := true;
IncomingDocument.Insert(true);
exit;
end;
if DocumentRecordRef.Number = DATABASE::"Sales Header" then begin
DocumentRecordRef.SetTable(SalesHeader);
IncomingDocument.Description := CopyStr(SalesHeader."Sell-to Customer Name", 1, MaxStrLen(IncomingDocument.Description));
if SalesHeader."Document Type" = SalesHeader."Document Type"::"Credit Memo" then
IncomingDocument."Document Type" := IncomingDocument."Document Type"::"Sales Credit Memo"
else
IncomingDocument."Document Type" := IncomingDocument."Document Type"::"Sales Invoice";
IncomingDocument."Document No." := SalesHeader."No.";
IncomingDocument.Insert(true);
SalesHeader."Incoming Document Entry No." := IncomingDocument."Entry No.";
SalesHeader.Modify();
exit;
end;
if IsPurchaseInvoice(DocumentRecordRef) and IsPostedDocument(DocumentRecordRef) then begin
DocumentRecordRef.SetTable(PurchInvHeader);
IncomingDocument.Description := CopyStr(PurchInvHeader."Buy-from Vendor Name", 1, MaxStrLen(IncomingDocument.Description));
IncomingDocument."Document Type" := IncomingDocument."Document Type"::"Purchase Invoice";
IncomingDocument."Posting Date" := PurchInvHeader."Posting Date";
IncomingDocument."Document No." := PurchInvHeader."No.";
IncomingDocument."Posted Date-Time" := CurrentDateTime;
IncomingDocument.Status := IncomingDocument.Status::Posted;
IncomingDocument.Posted := true;
IncomingDocument.Insert(true);
exit;
end;
if DocumentRecordRef.Number = DATABASE::"Purchase Header" then begin
DocumentRecordRef.SetTable(PurchaseHeader);
IncomingDocument.Description := CopyStr(PurchaseHeader."Buy-from Vendor Name", 1, MaxStrLen(IncomingDocument.Description));
if PurchaseHeader."Document Type" = PurchaseHeader."Document Type"::"Credit Memo" then
IncomingDocument."Document Type" := IncomingDocument."Document Type"::"Purchase Credit Memo"
else
IncomingDocument."Document Type" := IncomingDocument."Document Type"::"Purchase Invoice";
IncomingDocument."Document No." := PurchaseHeader."No.";
IncomingDocument.Insert(true);
PurchaseHeader."Incoming Document Entry No." := IncomingDocument."Entry No.";
PurchaseHeader.Modify();
exit;
end;
if IsSalesCreditMemo(DocumentRecordRef) and IsPostedDocument(DocumentRecordRef) then begin
DocumentRecordRef.SetTable(SalesCrMemoHeader);
IncomingDocument.Description := CopyStr(SalesCrMemoHeader."Sell-to Customer Name", 1, MaxStrLen(IncomingDocument.Description));
IncomingDocument."Document Type" := IncomingDocument."Document Type"::"Sales Credit Memo";
IncomingDocument."Posting Date" := SalesCrMemoHeader."Posting Date";
IncomingDocument."Document No." := SalesCrMemoHeader."No.";
IncomingDocument."Posted Date-Time" := CurrentDateTime;
IncomingDocument.Status := IncomingDocument.Status::Posted;
IncomingDocument.Posted := true;
IncomingDocument.Insert(true);
exit;
end;
if IsPurchaseCreditMemo(DocumentRecordRef) and IsPostedDocument(DocumentRecordRef) then begin
DocumentRecordRef.SetTable(PurchCrMemoHdr);
IncomingDocument.Description := CopyStr(PurchCrMemoHdr."Buy-from Vendor Name", 1, MaxStrLen(IncomingDocument.Description));
IncomingDocument."Document Type" := IncomingDocument."Document Type"::"Purchase Credit Memo";
IncomingDocument."Posting Date" := PurchCrMemoHdr."Posting Date";
IncomingDocument."Document No." := PurchCrMemoHdr."No.";
IncomingDocument."Posted Date-Time" := CurrentDateTime;
IncomingDocument.Status := IncomingDocument.Status::Posted;
IncomingDocument.Posted := true;
IncomingDocument.Insert(true);
exit;
end;
end;
local procedure LoadLinkedAttachmentsToBuffer(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var IncomingDocument: Record "Incoming Document"; AttachmentIdFilter: Text)
var
IncomingDocumentAttachment: Record "Incoming Document Attachment";
TempBlob: Codeunit "Temp Blob";
LoadContent: Boolean;
begin
IncomingDocumentAttachment.SetRange("Incoming Document Entry No.", IncomingDocument."Entry No.");
LoadContent := AttachmentIdFilter <> '';
if LoadContent then
IncomingDocumentAttachment.SetFilter(SystemId, AttachmentIdFilter);
if not IncomingDocumentAttachment.FindSet() then
exit;
repeat
if LoadContent then
IncomingDocumentAttachment.CalcFields(Content); // Needed for transferring
TransferFromIncomingDocumentAttachment(TempAttachmentEntityBuffer, IncomingDocumentAttachment);
if not LoadContent then
IncomingDocumentAttachment.CalcFields(Content); // Needed for getting content length
TempBlob.FromRecord(IncomingDocumentAttachment, IncomingDocumentAttachment.FieldNo(Content));
TempAttachmentEntityBuffer."Byte Size" := GetContentLength(TempBlob);
TempAttachmentEntityBuffer.Modify(true);
until IncomingDocumentAttachment.Next() = 0;
end;
local procedure LoadAttachmentsToBuffer(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; AttachmentIdFilter: Text)
var
IncomingDocumentAttachment: Record "Incoming Document Attachment";
TempBlob: Codeunit "Temp Blob";
LoadContent: Boolean;
LoadedAttachmentCounter: Integer;
begin
LoadedAttachmentCounter := 0;
LoadContent := AttachmentIdFilter <> '';
if LoadContent then
IncomingDocumentAttachment.SetFilter(SystemId, AttachmentIdFilter);
if not IncomingDocumentAttachment.FindSet() then
exit;
repeat
if LoadedAttachmentCounter > AttachmentLoadUpperLimit() then
Error(AttachmentLoadLimitExceededErr, Format(AttachmentLoadUpperLimit()));
if LoadContent then
IncomingDocumentAttachment.CalcFields(Content); // Needed for transferring
TransferFromIncomingDocumentAttachment(TempAttachmentEntityBuffer, IncomingDocumentAttachment);
LoadedAttachmentCounter += 1;
if not LoadContent then
IncomingDocumentAttachment.CalcFields(Content); // Needed for getting content length
TempBlob.FromRecord(IncomingDocumentAttachment, IncomingDocumentAttachment.FieldNo(Content));
TempAttachmentEntityBuffer."Byte Size" := GetContentLength(TempBlob);
TempAttachmentEntityBuffer.Modify(true);
until IncomingDocumentAttachment.Next() = 0;
end;
local procedure AttachmentLoadUpperLimit(): Integer
begin
exit(100000);
end;
local procedure LoadUnlinkedAttachmentsToBuffer(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; AttachmentIdFilter: Text)
var
UnlinkedAttachment: Record "Unlinked Attachment";
TempBlob: Codeunit "Temp Blob";
LoadContent: Boolean;
begin
LoadContent := AttachmentIdFilter <> '';
if LoadContent then
UnlinkedAttachment.SetFilter(Id, AttachmentIdFilter);
if not UnlinkedAttachment.FindSet() then
exit;
repeat
Clear(TempAttachmentEntityBuffer);
if LoadContent then
UnlinkedAttachment.CalcFields(Content); // Needed for transferring
TransferFromUnlinkedAttachment(TempAttachmentEntityBuffer, UnlinkedAttachment);
if not LoadContent then
UnlinkedAttachment.CalcFields(Content); // Needed for getting content length
TempBlob.FromRecord(UnlinkedAttachment, UnlinkedAttachment.FieldNo(Content));
TempAttachmentEntityBuffer."Byte Size" := GetContentLength(TempBlob);
TempAttachmentEntityBuffer.Modify(true);
until UnlinkedAttachment.Next() = 0;
end;
local procedure TransferToIncomingDocumentAttachment(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var IncomingDocumentAttachment: Record "Incoming Document Attachment"; var TempFieldBuffer: Record "Field Buffer" temporary; IsNewAttachment: Boolean)
var
TempBlob: Codeunit "Temp Blob";
TypeHelper: Codeunit "Type Helper";
AttachmentRecordRef: RecordRef;
UpdateFileName: Boolean;
Name: Text[250];
Extension: Text[30];
begin
if not IsNewAttachment then begin
TempBlob.FromRecord(TempAttachmentEntityBuffer, TempAttachmentEntityBuffer.FieldNo(Content));
TempAttachmentEntityBuffer."Byte Size" := GetContentLength(TempBlob);
end;
TempFieldBuffer.SetRange("Field ID", TempAttachmentEntityBuffer.FieldNo("File Name"));
UpdateFileName := TempFieldBuffer.FindFirst();
if UpdateFileName then
FileNameToNameAndExtension(TempAttachmentEntityBuffer."File Name", Name, Extension);
AttachmentRecordRef.GetTable(IncomingDocumentAttachment);
TypeHelper.TransferFieldsWithValidate(TempFieldBuffer, TempAttachmentEntityBuffer, AttachmentRecordRef);
AttachmentRecordRef.SetTable(IncomingDocumentAttachment);
if UpdateFileName then begin
IncomingDocumentAttachment.Validate(Name, Name);
IncomingDocumentAttachment.Validate("File Extension", Extension);
end;
end;
local procedure TransferToUnlinkedAttachment(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var UnlinkedAttachment: Record "Unlinked Attachment"; var TempFieldBuffer: Record "Field Buffer" temporary; IsNewAttachment: Boolean)
var
TypeHelper: Codeunit "Type Helper";
AttachmentRecordRef: RecordRef;
begin
if not IsNewAttachment then
TempAttachmentEntityBuffer.CalcFields(Content);
AttachmentRecordRef.GetTable(UnlinkedAttachment);
TypeHelper.TransferFieldsWithValidate(TempFieldBuffer, TempAttachmentEntityBuffer, AttachmentRecordRef);
AttachmentRecordRef.SetTable(UnlinkedAttachment);
end;
procedure TransferFromIncomingDocumentAttachment(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var IncomingDocumentAttachment: Record "Incoming Document Attachment")
begin
Clear(TempAttachmentEntityBuffer);
TempAttachmentEntityBuffer.TransferFields(IncomingDocumentAttachment, true);
TempAttachmentEntityBuffer.Id := IncomingDocumentAttachment.SystemId;
TempAttachmentEntityBuffer."File Name" := NameAndExtensionToFileName(
IncomingDocumentAttachment.Name, IncomingDocumentAttachment."File Extension");
TransferDocumentTypeFromIncomingDocument(TempAttachmentEntityBuffer, IncomingDocumentAttachment);
TempAttachmentEntityBuffer.Insert(true);
end;
local procedure TransferFromIncomingDocumentAttachment(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var IncomingDocumentAttachment: Record "Incoming Document Attachment"; DocumentId: Guid)
begin
Clear(TempAttachmentEntityBuffer);
TempAttachmentEntityBuffer.TransferFields(IncomingDocumentAttachment, true);
TempAttachmentEntityBuffer."Document Id" := DocumentId;
TempAttachmentEntityBuffer.Id := IncomingDocumentAttachment.SystemId;
TempAttachmentEntityBuffer."File Name" := NameAndExtensionToFileName(
IncomingDocumentAttachment.Name, IncomingDocumentAttachment."File Extension");
TransferDocumentTypeFromIncomingDocument(TempAttachmentEntityBuffer, IncomingDocumentAttachment);
TempAttachmentEntityBuffer.Insert(true);
end;
procedure TransferFromUnlinkedAttachment(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; var UnlinkedAttachment: Record "Unlinked Attachment")
begin
Clear(TempAttachmentEntityBuffer);
TempAttachmentEntityBuffer.TransferFields(UnlinkedAttachment, true);
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::" ";
TempAttachmentEntityBuffer.Id := UnlinkedAttachment.SystemId;
TempAttachmentEntityBuffer.Insert(true);
end;
[Scope('Cloud')]
procedure GetContentLength(var TempBlob: Codeunit "Temp Blob"): Integer
var
ContentInStream: InStream;
begin
if not TempBlob.HasValue() then
exit(0);
TempBlob.CreateInStream(ContentInStream);
exit(GetContentLength(ContentInStream));
end;
local procedure GetContentLength(var ContentInStream: InStream): Integer
var
MemoryStream: DotNet MemoryStream;
ContentLength: Integer;
begin
MemoryStream := MemoryStream.MemoryStream();
CopyStream(MemoryStream, ContentInStream);
ContentLength := MemoryStream.Length;
MemoryStream.Close();
exit(ContentLength);
end;
local procedure ThrowErrorIfAny(ErrorMsg: Text)
begin
if ErrorMsg <> '' then
Error(ErrorMsg);
end;
local procedure FileNameToNameAndExtension(FileName: Text; var Name: Text[250]; var Extension: Text[30])
var
FileManagement: Codeunit "File Management";
begin
Extension := CopyStr(FileManagement.GetExtension(FileName), 1, MaxStrLen(Extension));
Name := CopyStr(FileManagement.GetFileNameWithoutExtension(FileName), 1, MaxStrLen(Name));
end;
local procedure NameAndExtensionToFileName(Name: Text[250]; Extension: Text[30]): Text[250]
begin
if Extension <> '' then
exit(StrSubstNo('%1.%2', Name, Extension));
exit(Name);
end;
local procedure TransferDocumentTypeFromIncomingDocument(var TempAttachmentEntityBuffer: Record "Attachment Entity Buffer" temporary; IncomingDocumentAttachment: Record "Incoming Document Attachment")
var
IncomingDocument: Record "Incoming Document";
SalesHeader: Record "Sales Header";
PurchaseHeader: Record "Purchase Header";
begin
IncomingDocument.Get(IncomingDocumentAttachment."Incoming Document Entry No.");
case IncomingDocument."Document Type" of
IncomingDocument."Document Type"::Journal:
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::Journal;
IncomingDocument."Document Type"::"Sales Credit Memo":
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Sales Credit Memo";
IncomingDocument."Document Type"::"Sales Invoice":
if SalesHeader.Get(IncomingDocument."Related Record ID") then begin
if SalesHeader."Incoming Document Entry No." = IncomingDocument."Entry No." then begin
if SalesHeader."Document Type" = SalesHeader."Document Type"::Order then
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Sales Order";
if SalesHeader."Document Type" = SalesHeader."Document Type"::Quote then
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Sales Quote";
if SalesHeader."Document Type" = SalesHeader."Document Type"::Invoice then
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Sales Invoice";
if SalesHeader."Document Type" = SalesHeader."Document Type"::"Credit Memo" then
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Sales Credit Memo";
end;
end else
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Sales Invoice";
IncomingDocument."Document Type"::"Purchase Invoice":
if PurchaseHeader.Get(IncomingDocument."Related Record ID") then begin
if PurchaseHeader."Incoming Document Entry No." = IncomingDocument."Entry No." then
if PurchaseHeader."Document Type" = PurchaseHeader."Document Type"::Order then
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Purchase Order"
else
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Purchase Invoice";
end else
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Purchase Invoice";
IncomingDocument."Document Type"::"Purchase Credit Memo":
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::"Purchase Credit Memo";
IncomingDocument."Document Type"::" ":
TempAttachmentEntityBuffer."Document Type" := TempAttachmentEntityBuffer."Document Type"::" ";
end;
end;
}