Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Chris McGregor]

I have been tasked with creating a field on an invoice that will show data from a SQL table outside of the GP tables. If I’m understanding right, the only way to do this is through VBA.

I am not a programmer at all and I have never touched VBA before, so I’m starting on the ground floor  basement parking garage on all this. I found this online that seems to be the right thing: Using ADO with VBA with Report Writer but the post is almost 10 years old, so I’m not sure if it will still even work in GP 2015.

Does anyone have any experience in using VBA to do this sort of thing in Report Writer? Any how-tos or tips on how to do this is very much appreciated. Thanks!

——————————
Chris McGregor
Office Coordinator
Conference Technologies, Inc.
East Peoria IL
——————————

[Timothy Lally]

Believe it or not that code is still valid

——————————
Timothy Lally
President
KTL Solutions, Inc
Frederick MD
——————————
——————————————-

[David Musgrave]

Hi Chris

As Tim mentioned, the latest version of the code on my old blog should still work as the methods have not changed since then.

Please note that VBA does not work on the web client.  An alternate approach that is web client compatible is to use GP Power Tools and its ability to create custom report writer functions which can then be accessed using calculated fields.

This can be used to pull data for any other Dynamics table using Dexterity or from a SQL only table by using SQL Script in combination with the Dexterity script.

For more information

GP Power Tools Portal: http://WinthropDC.com/GPPT

Examples of GPPT RW Functions:

• https://blogs.msdn.microsoft.com/developingfordynamicsgp/2011/09/08/how-to-display-more-than-80-characters-of-an-extender-long-string-field-in-reports-using-the-support-debugging-tool/
• https://blogs.msdn.microsoft.com/developingfordynamicsgp/2011/05/23/how-to-add-item-category-long-descriptions-to-reports-using-the-support-debugging-tool/

While the above articles refer to the Support Debugging Tool, they are valid as GP Power Tools replaced the discontinued Support Debugging Tool.

If you need any help, just let me know.

Thanks

David

——————————
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
——————————
——————————————-

[Chris McGregor]

Thanks for the feedback, it is very helpful. 

The biggest challenge I am facing is how to implement the code in the report once I have it set up. As I said, I’m not a programmer so even the most basic stuff is new and confusing to me. 

——————————
Chris McGregor
Office Coordinator
Conference Technologies, Inc.
East Peoria IL
——————————
——————————————-

[Brenner Klenzman]

Hi Chris-

WilloWare has a small Report Writer add-on that allows adding any data to any report.  You just need to be able to do a tiny bit of sql scripting.

It’s part of our Consulting Toolkit: https://willoware.com/products/consulting-toolkit/#rex

Regards,
Brenner

——————————
Brenner Klenzman
Owner/Principle
WilloWare, Inc.
Wapella IL
——————————
——————————————-

[Leslie Vail]

Willoware’s solution rocks!
Read the instruction manual carefully, but you will surprise yourself once you see what he has made possible.
Kind regards,
Leslie

——————————
Leslie Vail
Accounting Systems Consulting, Inc.
Dallas TX
——————————
——————————————-