Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / View Existing Macros i...
Microsoft Dynamics GP (Archived)

View Existing Macros in GUI or in SQL

(0) ShareShare
ReportReport
Posted on by kmalone43 880

Quick question I hope.  One of our users is missing Macro shortcut keys (say f3 through f8 are all missing in the list of available shortcuts).  Outside of scrolling through the home navigation pane for that user and looking for links to macros, is there another location that the user can see existing macros or is there a series of 'macro' tables that can be viewed to see existing macros for all users?  My hunch is that in the process of that user adding/deleting macros, the deletes didn't complete correctly and those old macros are now partially holding shortcuts.

Thoughts?

Thank you,

Kyle

*This post is locked for comments

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: View Existing Macros in GUI or in SQL

    Kyle,

    I just came across a tool that I was made aware a while ago by some fellow GPUG member :

    AutoHotKey & MacroCreator..

    Those 2 tools are extremely powerful and free. You could even compile as full .EXE file and distribute the macros to your users without having them to install anything (I believe, check the documentation to be sure).

    Certainly worth having a look at it if you have a lot of screen automation to perform in GP.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: View Existing Macros in GUI or in SQL

    Hi, I see Beat has answered most of your question, but I would like to propose another idea. You can assign Nav List shortcut keys to a class of users. That way, all members of that class share the same name.

    Kind regards,

    Leslie

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: View Existing Macros in GUI or in SQL

    Hi Kyle,

    As the saying says.. : A picture is worth thousand words..

    Sorry that I didn't understand what you were talking about right upfront.. the 2 captures you're showing above are actually different (1st is for Macros & 2nd is for Shortcuts).. Technically it probably both run your .mac files... but the point is that you should be very careful about using F-Keys to assign to shortcuts or macros.. I'm basically staying away from this, since there is so many system interaction that could be intercepted by an F-key assignment... just thinking about my own screen capture software that has not less than 16 'hotkeys' assignments and those could all interfere with something else in the system (like a simple CTRL-P for print box dialog)..

    I know that shortcuts can be very useful for repeating tasks, and myself have a lot in my navigation pane on the left side, but none of them actually are assigned to a 'hotkey', since this can depend on the context you're running in.. Windows can sometimes be very strange.

    PS: I just tested this with my Screen Capture program, and the hotkey took precedence on the GP assigned macro/shortcut... so be aware about this.

  • kmalone43 Profile Picture
    kmalone43 880 on at
    RE: View Existing Macros in GUI or in SQL

    Trying that again w/ images

    Dev

    Prod_5F00_WorkflowShortcuts.png

    Prod

    Prod_5F00_WorkflowShortcuts.png

  • kmalone43 Profile Picture
    kmalone43 880 on at
    RE: View Existing Macros in GUI or in SQL

    Hi Béat,

    Hitting the CTRL + F8 tab is nifty and I did not know exists but we still are missing shortcut keys.

    In a dev environment, here are the list of available shortcuts for my user.

    In our production environment, here are the list of available shortcuts for my user.

    Notice that F5, 10 & 11 are missing.  In my home navigation pane, I've removed just about all shortcuts for this user & when I hit the F5, 10, & 11 keys nothing happens.

    Question is, where have these shortcuts gone?

    Thanks,

    Kyle

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: View Existing Macros in GUI or in SQL

    Hi Kyle,

    Macros are not stored in tables, but as files with extension .mac in the files system (shared or personal folder) for GP,  and to reach them the user has to press CTRL-F8 to open the file dialog box and pick the .mac file to run.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans