web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Add Report to Visual B...
Microsoft Dynamics GP (Archived)

Add Report to Visual Basic from Report Writer results in the report being listed twice in Customization Maintenance, and VBA doesn't run on the report

(0) ShareShare
ReportReport
Posted on by Ross Carlson 24

Hello, GP2018R2 (18.00.0704) generates a modified report twice (screenshot below), one with and one without VBA after adding the report to Visual Basic from Report Writer.  

To recreate, I open Report Writer, choose a report, click “Insert”, then select it and click “Open”, “Layout”, then Tools/Add Report to Visual Basic.  Then I close Report Writer and GP, save the VBA changes at the dialog, relaunch and the report displays twice under Customization Maintenance.  I have deleted all .vba files, deleted the REPORTS.DIC, and logged in as an Administrator.  This happens with any reports dictionary I try (GP, HR, PA), and it happens on my local install as well as a client install on a server in another domain.  It also happens if I upgrade a reports dictionary with VBA from GP2015, or import it from Customization Maintenance or from Report Writer.  

DupReports.png.

Any help to get this resolved so my VBA will work on a report will be greatly appreciated.  Thank you in advance for your time!

*This post is locked for comments

I have the same question (0)
  • Ross Carlson Profile Picture
    Ross Carlson 24 on at

    More info for what it's worth... I can write a simple VBA script that works fine on a modified window.  VBA is still not working on the modified reports however.  I have updated permissions on the 4 registry keys and the client install directory, turned off UAC, and re-installed VBA from the redist folder on the install DVD.  Still no joy.

  • Verified answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at

    when we modify report and also have vba code for it, Customer Maintenance show same report twice once to show report is modified and another to mention vba part, it's okey. What else you are having as issue?

  • Ross Carlson Profile Picture
    Ross Carlson 24 on at

    Thanks for the response Almas!!  The modified report displays when run but the vba on the report did not. Previous versions of GP did not display the report twice, so I thought this may be related.  Your response encouraged me to look further into my vba, and I discovered that it was running but I didn't re-add my fields to visual basic.  Now that the fields have been added my vba is working.  Thank you for your help!!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans