Small and medium business | Business Central, N...

how to convert PDF from BLOB, and the same pdf needs to attached in document attachment for sales invoice

(0) Share

Report

Posted on by MohitMalik8085

100

Hello Folks,

Greetings for the Day!

First of all thanks in Advance!

I need your help to get solution for converting a PDF file from a Base64 code and the same file I need to attach in posted sales invoice.

I have done the customization for store base64 code in a BLOB field, from where I need to convert it into PDF and the same need to attach in Document Attachment table.

during my investigation I got to know that we have Media type field in document attachment table for which I tried to use Base64 code conversion with BASE64 Convert codeunit with function FromBase64, which was not working out or might be I am missing something, I have used the TempBlob codeunit for doing the same, but the thing is somehow the PDF is loosing the format converted, becasue after attachment when I am getting open the same by downloading PDF file is giving error "Could not load the file format.

Could anyone help me in this regards. basically I wants to know is it possible to convert the Base64 into PDF and the same can be attach in Media type field.

any help will be appreciated. Thanks!

Below is code while attaching the file

procedure ConvertBase64toPDF(VAR RecpostedSalesInvoice: Record "Sales Invoice Header")

var

CUBase64Convert: Codeunit "Base64 Convert";

CUtempBlob: Codeunit "Temp Blob";

TempOStream: OutStream;

TempInstream: InStream;

recref: RecordRef;

RecDocAttached: Record "Document Attachment";

FileName: text;

InvoiceData: Record "EInvoice Data"; //this is my custom table with Blob value

begin

IF invoiceData.Get(RecpostedSalesInvoice."No.") then BEGIN

invoiceData.CalcFields(invoiceData.Blob);

if InvoiceData.Blob.HasValue then begin

CUTempBlob.CreateOutStream(TempOStream);

CUTempBlob.FromRecord(invoiceData, invoiceData.FieldNo(Blob));

CUtempBlob.CreateInStream(TempInstream);

RecRef.GetTable(RecpostedSalesInvoice);

FileName := StrSubstNo('E-Invoice_%1.PDF', RecpostedSalesInvoice."No.");

if FileName <> '' then

RecDocAttached.SaveAttachmentFromStream(TempinStream, RecRef, FileName);

end;

All responses (3)

Answers (0)

Netjacker2097 263 on at

Like (0)

Report

how to convert PDF from BLOB, and the same pdf needs to attached in document attachment for sales invoice

Hi,

just guessing here, try adding the after: if FileName <> '' then

RecDocAttached.INIT;
RecDocAttached."Table ID" := RecpostedSalesInvoice."Table ID";
RecDocAttached."No." := RecpostedSalesInvoice."No.";
RecDocAttached."File Name" := FileName;
RecDocAttached."Media Type" := 'application/pdf'; // Set the appropriate media type
RecDocAttached."Attachment" := TempInstream.Blob;
RecDocAttached."File Size" := LENGTH(TempInstream.Blob);
RecDocAttached."Date/Time" := CURRENTDATETIME;
RecDocAttached.INSERT;

give it a try.

Regards,

M
Community member 12 on at

Like (0)

Report

how to convert PDF from BLOB, and the same pdf needs to attached in document attachment for sales invoice

Navigating the intricacies of converting a PDF from a BLOB for sales invoices led me to seek solutions. Thankfully, I found assistance at https://pdfflex.com/pptx-to-pdf, simplifying my pptx-to-pdf needs. Integrating the converted file seamlessly into document attachments streamlines the sales process, offering efficiency and precision. Grateful for this resource that eases the complexities of document management.
Suggested answer

Andy Sather on at

Like (0)

Report

RE: how to convert PDF from BLOB, and the same pdf needs to attached in document attachment for sales invoice

Hello - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

I will open this up to the community in case they have something to add.