Microsoft Dynamics GP Macros: Playing A Macro Quickly

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPIn this series I am taking a look at how macros can be used to update data in Microsoft Dynamics GP.

As I said in the last post, which covered the playing of a macro, in this post I am going to show how the macro can be played quicker than using the standard Play option.

Credit for this one goes to MVP Leslie Vail, who blogged about it back in 2014. There is a Dex.ini setting which needs to be set to make this function available:

ShowAdvancedMacroMenu=TRUE

This needs to be configured on any client machine which will be used to run macros. If you are a user of the GP Power Tools you can use the Dex.ini Configuration to roll out this switch to all clients:

User Setup

Continue reading → Microsoft Dynamics GP Macros: Playing A Macro Quickly

● Categories: Dynamics, Microsoft ● Tags: , , , , , , , , , ,  ● Permalink ● Shortlink ●

MDGP 2018 RTM Feature of the Day: System Password Remembered

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 RTM; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily as well as adding my own commentary.

The series index for this series of posts is here.

The thirteenth Feature of the Day is System Password Remembered.

One of the big frustrations for people who maintain security in Microsoft Dynamics GP is having to type the System Password every single time a password protected window is opened.

This feature sees a change whereby the System Password, ocnce entered, is remembered for the rest of the session.

This feature is well overdue and is going to save so much frustration from having to enter the system password so many times when creating security roles and tasks.

Click to show/hide the MDGP 2018 RTM Feature of the Day Series Index

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

MDGP 2018 RTM Feature of the Day: Workflow Unplugged – Inside Microsoft Dynamics GP Guest Post by Ian Grieve

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPA week past Friday Pam Misialek did a Doc Attach Unplugged post reviewing the Document Attachment functionality of Microsoft Dynamics GP.

Well on Friday last week, she took a slightly different approach and asked me be a guest blogger and do the Workflow Unplugged post.

So this time, to read my post, you’ll need to head over to the Inside Microsoft Dynamics GP blog.

Click to show/hide the MDGP 2018 RTM Feature of the Day Series Index

● Categories: Dynamics, GP, Microsoft, Workflow ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

MDGP 2018 RTM Feature of the Day: Web Client Changes

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 RTM; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily as well as adding my own commentary.

The series index for this series of posts is here.

The twelfth Feature of the Day is Web Client Changes.

This feature combines three enhancements which have been made to the web client.

Firstly, the web client has been modified to have the same autocomplete functionality as the desktop client:

Customer Maintenance

Continue reading → MDGP 2018 RTM Feature of the Day: Web Client Changes

● Categories: Dynamics, GP, Microsoft, Web Client ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Microsoft Dynamics GP Macros: Playing A Macro

● Ian Grieve ●  ● 2 Comments   ● 

Microsoft Dynamics GPIn this series I am taking a look at how macros can be used to update data in Microsoft Dynamics GP.

Before moving onto manipulating the macro template I am going to cover how to play back the macro; this way once you have your template ready, you already know how to playback the macro.

To play back the macro, we need to recreate the circumstances in which the macro was recorded; for this example, this means having the User Setup window (Administration >> Setup >> System >> User) open.

To play back the macro, click the Tools button on the action pane, then expand the Macro menu and click Play…:

User Setup - play macro

Continue reading → Microsoft Dynamics GP Macros: Playing A Macro

● Categories: Dynamics, GP, Microsoft ● Tags: , , , ,  ● Permalink ● Shortlink ●

MDGP 2018 RTM Feature of the Day: Save Select Payment Settings

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 RTM; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily as well as adding my own commentary.

The series index for this series of posts is here.

The eleventh Feature of the Day is Save Select Payment Settings.

A new Payment Batch ID field has been added to the Build Payment Batch (formerly Select Cheques (or Checks)) window (Purchasing area page >> Transactions >> Build Payment Batch):

Build Payment Batch

This option allows you to save the entered restrictions for easy recall at a later date. I have mixed feelings on this one; my initial impressions was that this feature would be really useful, but when I thought more I can;t see many of my users making much use of this functionality.

Most of them only build a batch based on due date and there is no benefit saving the due date as the selection is for a specific date only.

If you do more complex batch building, such as using Vendor Class, Payment Priority, or a combination of restrictions, then this new option could save you a little time on every payment batch created.

Click to show/hide the MDGP 2018 RTM Feature of the Day Series Index

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

MDGP 2018 RTM Feature of the Day: Sorting

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 RTM; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily as well as adding my own commentary.

The series index for this series of posts is here.

The tenth Feature of the Day is Sorting. This feature adds sorting options to five windows in Purchasing, Sales and Bank Reconciliation:

Payables Transaction Inquiry - Vendor

Payables Transaction Inquiry - Vendor

Payables Transaction Inquiry - Document

Payables Transaction Inquiry - Document

Receivables Transaction Inquiry - Customer

Receivables Transaction Inquiry - Customer

Receivables Transaction Inquiry - Document

Receivables Transaction Inquiry - Document

Select Bank Transactions

Select Bank Transactions

I like this feature a lot. Clients have been asking about being able to reorder the enquiry windows for a long time; it’s nice that I’ll soon be able to tell them that they can now sort the data.

Click to show/hide the MDGP 2018 RTM Feature of the Day Series Index

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Microsoft Dynamics GP Macros: Recording A Macro

● Ian Grieve ●  ● 2 Comments   ● 

Microsoft Dynamics GPIn this series I am taking a look at how macros can be used to update data in Microsoft Dynamics GP.

Recording a macro is a fairly simple task, but I strongly recommend knowing the exact series of steps to be recorded, before starting to record the macro. I usually take a couple of practise runs before hitting record.

One of the common uses of macros for clients is to reset passwords when upgrading Microsoft Dynamics GP; due to versions of Windows and SQL Server supported by Dynamics GP, new servers are involved so these have different names (and the server name is used during encrypting the passwords.

So, in this series of posts, I am going to use resetting passwords as the example.

Macros are capable of opening and closing windows, but when resetting passwords this isn’t necessary so, before starting to record the macro, open the User Setup window (Administration >> Setup >> System >> User).

To record this macro, I am going to perform the following steps:

  1. Type a User ID.
  2. Type a new Password.
  3. Repeat this password in the Confirm Password field.
  4. Click Save.

To start recording the macro, click the Tools button on the action pane, then expand the Macro menu and click Record…:

User Setup

Continue reading → Microsoft Dynamics GP Macros: Recording A Macro

● Categories: Dynamics, GP, Microsoft ● Tags: , , , ,  ● Permalink ● Shortlink ●

MDGP 2018 RTM Feature of the Day: Rename Payment Run Windows

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 RTM; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily as well as adding my own commentary.

The series index for this series of posts is here.

The ninth Feature of the Day is a feature requested by Mariano Gomez and that is to rename the payment run windows.

So instead of them being named Check or Cheque, depending on the installed language pack, they will now be named Payment:

Purchasing menu

The windows which have been renamed are:

  • Select Payables Checks -> Build Payments Batch
  • Edit Payables Check Batch -> Edit Payment Batch
  • Edit Payables Check -> Edit Vendor Payment
  • Print Payables Checks -> Print Payment Documents
  • Post Payables Checks -> Post Payment Documents

In the UK, virtually no-one uses cheques anymore; payments are made by BACS which is a form of EFT. Renaming these windows

Click to show/hide the MDGP 2018 RTM Feature of the Day Series Index

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

Microsoft Dynamics GP Macros: Limitations of Macros

● Ian Grieve ●  ● 2 Comments   ● 

Microsoft Dynamics GPIn this series I am taking a look at how macros can be used to update data in Microsoft Dynamics GP.

Macros can be a quick and easy way of inserting or updating information in Microsoft Dynamics GP, but there are some limitations to macros which need to be considered before using them.

A macro works by recording the exact series of actions taken by the user after clicking record; this means it is best to practise the series of steps the macro should record before clicking record.

When the macro is played, it repeats the exact steps as recorded. The way I typically explain this to clients, is to say that the macro pretends to be them typing very quickly. Which is a fair description of what the macro does; it records any typing and then plays back the typing; depending on what actions were recorded in the macro, you will see windows open and close and fields typed into.

This means that when a macro is being played back, Microsoft Dynamics GP must retain cursor focus or the macro will crash.

A macro plays back the exact steps as recorded and does not tolerate any deviation; this means that if the macro plays back and encounters a difference, such as a popup message dialog, the macro will crash and stop running. Any data updated will remain updated, so restarting the macro will likely require updated data to be removed from the macro file.

A frequent question asked by users is if they can build in conditions within the macro. The short answer is no, you can’t as macros simply play back a series of steps. There is a longer answer which I will cover when in the posts on producing a macro from a macro template using Excel and SQL.

When recording a macro which will open windows, it is best to use the drop down menus at the top to open the window, as using the area page menu will often fail as this used the exact mouse position; when users using the same macro have different access configured, the menu option will be in different locations and therefore cause the macro to fail.

Click to show/hide the Microsoft Dynamics GP Macros Series Index

Microsoft Dynamics GP Macros
Limitations of Macros
Recording A Macro
Playing A Macro
Playing A Macro Quickly
● Categories: Dynamics, GP, Microsoft ● Tags: , , , ,  ● Permalink ● Shortlink ●