Copy qrcodeimage from salesheader to salesinvoiceheader

(3) Share

Report

Posted on by LA-02071030-0

275

i used same fieldid for both tables salesheader and salesinvoiceheader

field(50199; "QRCodeImage"; Blob)
{
    Caption = 'QR Code Image';
}

in this field of sales header  i saved qrcodeimage and i want after posting it also saved in salesinvoiceheader table how is it possible

i also write eventhandler but it cannot work   [EventSubscriber(
    ObjectType::Codeunit,
    Codeunit::"Sales-Post",
    'OnBeforeSalesInvHeaderInsert',
    '',
    false,
    false)]
local procedure CopyQRCodeToPostedInvoice(
    var SalesInvHeader: Record "Sales Invoice Header";
    SalesHeader: Record "Sales Header")
var
    InStr: InStream;
    OutStr: OutStream;
begin
    // Copy QR code image
    if SalesHeader.QRCodeImage.HasValue() then begin
        SalesHeader.QRCodeImage.CreateInStream(InStr);
        SalesInvHeader.QRCodeImage.CreateOutStream(OutStr);
        CopyStream(OutStr, InStr);
    end;
 
end;
 

2. how we generate qr code image  through TLV string without any external api in business central

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

OussamaSabbouh 6,321 on at

Like (1)

Report

Hello,

Copying the QR code Blob after posting didn’t work because either the event didn’t fire, the Blob wasn’t loaded, or the value was overwritten later in posting. The reliable approach is to copy the Blob after the Sales Invoice Header is inserted, call CalcFields on the Sales Header Blob, copy the stream, and then Modify the posted invoice header to persist it.

Generating a QR code from a TLV string without external APIs is supported in BC Cloud by building the TLV, converting it to Base64, and using Business Central’s built-in QR/Barcode generation to create an image stream and store it in a Blob. No .NET or external services are required.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No