Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Modifier not enable in...
Microsoft Dynamics GP (Archived)

Modifier not enable in Report Writer, but OK in GP form

(0) ShareShare
ReportReport
Posted on by William Kow 3,795

I am new to Modifier. I have entered the valid GP license key which enable the Modifier. The problem is, the Modifier is not allowed to be used in Report Writer (see the first link), but the Modifier can be selected in GP (see second attachement). Please advise what have I missed to activate the Modifier for Report Writer.

http://img80.imageshack.us/img80/8240/20100709163458.png

http://img80.imageshack.us/img80/2943/20100709163645.png

When I try to run the "Visual Basic Editor" under any modified report, it will prompt warning message: You do not have sufficient privileges on this system to modify the VBA Project.

Even if I run GP with Local Administrator Right. Please advise, many thanks in advance.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Modifier not enable in Report Writer, but OK in GP form

    You will need to:

    1. Modify the following registry keys:
    • HKEY_CLASSES_ROOT\Clsid
    • HKEY_CLASSES_ROOT\Typelib
    • HKEY_CLASSES_ROOT\Interface
    • HKEY_LOCAL_MACHINE\Software\Classes\CLSID
      • Log on as an administrator. 
      • Start Registry Editor. To do this, click Start, click Run, type regedt32.exe, and then click OK.
      • Locate the following registry key:
        HKEY_CLASSES_ROOT\Clsid
      • On the Security menu, click Permissions.

        Note The Registry Key Permissions window appears.
      • Click Add, add the users or the groups, and then click to select the Full Control check box to specify the type of access.
      • Click OK to close the Registry Key Permissions window.
      • Repeat steps 3 through 6 for the remaining registry keys. 
      • Exit Registry Editor. 

        Note When you exit Registry Editor, the other users for whom you changed permissions can register type libraries, Component Object Model (COM) objects, and other objects.
    2. Give users full access to Microsoft Dynamics GP folder
  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Re: Re: Modifier not enable in Report Writer, but OK in GP form

    No, no extra licenses are needed. If you are already licensed for Modifier, that's it!

    Take a look at the following articles to help you out:

    Automating the Distribution of Customizations - Part 1

    Automating the Distribution of Customizations - Part 2

    Using VBA with Report Writer

    This week, free Visual Basic for Applications workshop with the Dynamics GP Blogster

    There's also tons of resources on my blog that will get you moving in the right direction (you can get to my blog with the last link I provided).

  • William Kow Profile Picture
    William Kow 3,795 on at
    Re: Re: Modifier not enable in Report Writer, but OK in GP form

    Thank you so much to Leslie and Mariano.

    BTW, if I managed to do VBA programming for a modified report, i would like to know whether need to pay extra fee/license for VBA code use in the Modified report ? It is the same way, by importing the Package on other workstation, the VBA codes goes together with the package ?

    Many thanks in advance.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Modifier not enable in Report Writer, but OK in GP form

    Modifier = modified windows

    Report Writer = modified/custom reports

    Modifier <> Report Writer.

    You can use VBA with both Modifier and Report Writer.

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    Re: Modifier not enable in Report Writer, but OK in GP form

    Hi William,

    Modifier is only for changing windows, so it shouldn't be available in Report Writer. In order to access VBA in Report Writer you need to have first added the report to VB. Under the Tools menu when you have a report layout open you should see the 'Add to Visual Basic' option. Once you add the report to VB, you should be able to open the VB Editor. You need to make sure you have added any necessary fields too.

    Kind regards,

    Leslie

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans