Finance | Project Operations, Human Resources, ...

How do I generate QR code to Sales invoice report

(0) Share

Report

Posted on by faiz7049

2,430

Hi Experts,

By below code QR code is generated on Form grid whenever I type any text in Description field.

How to generate QR code in Sales invoice report.

Please guide me. I check processreport method in SalesInvoiceDP but there is only super method.

In QR code, I need to add Customer Name, Customer Code and Total Amount.

public void modified()
{
    BinData binData = new BinData();
    Image Imgobj;
    System.Drawing.Image img;
    System.Drawing.Bitmap obj;
    FilePath _path;
    MessagingToolkit.QRCode.Codec.QRCodeEncoder encoder = new MessagingToolkit.QRCode.Codec.QRCodeEncoder();

    super();

    obj = new System.Drawing.Bitmap(encoder.Encode(SampleQRCode.Description));
    obj.Save(@"C:\newPhoto.bmp",System.Drawing.Imaging.ImageFormat::get_Bmp());

    _path="C:\newPhoto.jpg";
    img = new System.Drawing.Bitmap(obj);
    binData.loadFile(@"C:\newPhoto.bmp");
    SampleQRCode.QRCode=binData.getData();
}

Thanks,

Faiz

I have the same question (0)

All responses (5)

Answers (0)

Sort by

huijij 19,811 on at

Like (0)

Report
Copy link

Link copied!
Hi,

To generate QR Code on Sales Invoice and add Customer Name, Customer Code and Total Amount

you may add parameters to System.Drawing.Bitmap() like

System.Drawing.Bitmap(encoder.Encode(CustomerName" "Customer Code" "TotalAmount));

https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/292311/qr-code-in-ax-2009/839395

regards

Was this reply helpful? Yes No
Suggested answer

Hossein.K 6,648 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Did you find the report and data source of it. in this data source there is a init or execute method to write your code.

Was this reply helpful? Yes No
faiz7049 2,430 on at

Like (0)

Report
Copy link

Link copied!
Hi Experts,

I have created Display() method under table custInvoiceJour as given below.

display container qrcode() { Bindata bindata = new Bindata(); Image Imgobj; System.Drawing.Image img; System.Drawing.Bitmap obj; Filepath _path; container con; str Qty,InvDate,GRate,CustName,CustNumber,GTot,PONo; MessagingToolkit.QRCode.Codec.QRCodeEncoder encoder = new MessagingToolkit.QRCode.Codec.QRCodeEncoder(); ; CustNumber=this.custTable_InvoiceAccount().AccountNum; CustName=this.custTable_InvoiceAccount().name(); obj = new System.Drawing.Bitmap(encoder.Encode(CustNumber " " CustName)); obj.Save(@"C:\temp\newPhoto.bmp",System.Drawing.Imaging.ImageFormat::get_Bmp()); bindata.loadFile(@"C:\temp\newPhoto.bmp"); con = bindata.getData(); return con; }

And New Field created under SalesInvoiceTmp 'QRCode' type container(ExtendedDataType=Bitmap). then in report class salesInvoiceDP I added
if (_custInvoiceTrans) { salesInvoiceTmp.LineHeader = this.parmLineHeader(); } //custInvoiceTrans salesInvoiceTmp.Name = _custInvoiceTrans.Name; SalesInvoiceTmp.QRCode=_custInvoiceJour.qrcode(); salesInvoiceTmp.Qty = _custInvoiceTrans.Qty;

dispay qrcode method in insertIntoSalesInvoiceTmp(). and added to Report.

When I run it. Getting error

Was this reply helpful? Yes No
Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report
Copy link

Link copied!

Did you try "Microsoft.Dynamics.QRCode.Encoder"

community.dynamics.com/.../how-to-create-qr-code-barcode-and-print-on-ssrs-report-in-dynamics-ax

Was this reply helpful? Yes No
faiz7049 2,430 on at

Like (0)

Report
Copy link

Link copied!

Hi Experts,

Issue has been resolved after restart the AOS.

Thanks,

Faiz

Was this reply helpful? Yes No