Dynamics 365 ERP - Development
Category
Oct 10, 2023
Published date
Text
Article Type
AI Summary
- The author initially believed that it was not possible to include a dynamic image like a QR code in a Microsoft Dynamics GP Report Writer report, as only static images can be stored in the dictionary and added to reports.
- The author received a request from a customer to implement instructions they found online to add a QR code to a GP report. However, the author identified several issues with the instructions, including the use of a prefix in a calculated field call to a custom RW function and the claim that the returned image would be a binary object (blob) containing the image.
- The customer revealed that the instructions were generated by ChatGPT, a language prediction engine, not a knowledge engine, leading the author to believe that adding a QR code to a GP report was not possible.
- The author had previously managed to add a standard barcode to a GP report using a barcode True Type font and VBA code to encode the data. Inspired by this experience, the author searched for a QR code font and encoder solution online.
- The author found two solutions, one using 1s and 0s to encode the QR code as bits and another using characters A to P to represent 4 vertical pixels.
- The author implemented the second solution, which required 15 calculated fields to be created and placed on the report. The IDAutomation2D Font was set to 8 point, and the fields were spaced vertically at 8 pixels apart.
- The author provided a demonstration of the project setup, including the RW function, the encoder scripts, and the cleanup script, along with the SOP Blank Invoice Form report.
- The author concluded by offering the example code for download and providing links to more information about GP Power Tools.Overall, the article discusses the author's experience with adding a QR code to a Microsoft Dynamics GP Report Writer report and provides a solution using a QR code font and encoder. The author demonstrates how to implement the solution and offers additional resources for further information.
Registered users can view the full text for FREE!
Sign In Now!