Open Forum

Hello -

Just wanted to share my recent blog on how to use a macro to process NSF.

Out of the 13,000 records we drafted there were 300+ transactions with No Sufficient Fund (NSF) or bank account was not yet ready to be drafted. In this video I will show you how to create a macro to save you time and energy in processing NSF in Dynamics GP.   Here's the link. 

Hope this helps!

------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.
------------------------------

Hi @Cecile Dinh

Thanks for posting the forum thread and your blog article.

​Here is more information on this technique from my 2008 blog article: 

https://winthropdc.wordpress.com/2008/10/29/how-to-use-word-mail-merge-and-macros-to-import-data/

We should also mention John Arnold's Replicator Tool which makes this technique extremely easy:

http://rnoldz.com/replicator.html

A final point.  Macros cannot perform any action that need conditional processing, such as only entering specific fields when the data has this checkbox selected. Talking about checkboxes, Macros always toggle the checkbox, they cannot set it to true or false as it just clicks on it and does not know what the previous value was. If you want integration with conditional functionality, I would suggest using GP Power Tools with Dexterity scripting to drive the user interface. As the code can read the previous data and have conditional code, you have lots of extra capability.

Bonus point: If you have GP Power Tools installed, you will have an option to Play Fast on the Macro menu which can run macros about 3 times faster than the standard Play option.

Hope this is useful information.

Regards

David

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

Managing Director
Winthrop Development Consultants

Perth, Western Australia

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

Original Message:
Sent: Jan 31, 2023 03:14 PM
From: Cecile Dinh
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hello -

Just wanted to share my recent blog on how to use a macro to process NSF.

Out of the 13,000 records we drafted there were 300+ transactions with No Sufficient Fund (NSF) or bank account was not yet ready to be drafted. In this video I will show you how to create a macro to save you time and energy in processing NSF in Dynamics GP.   Here's the link. 

Hope this helps!

------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.
------------------------------

Hi @David Musgrave,

Thanks for sharing this additional info, this is very helpful!

I found out from my last GPUG ​Chapter meeting that there are many users doing the NSF process manually.  That's why having this techniques resurface will definitely help our community.


------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.
------------------------------

Original Message:
Sent: Feb 01, 2023 02:14 AM
From: David Musgrave
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hi @Cecile Dinh

Thanks for posting the forum thread and your blog article.

​Here is more information on this technique from my 2008 blog article: 

https://winthropdc.wordpress.com/2008/10/29/how-to-use-word-mail-merge-and-macros-to-import-data/

We should also mention John Arnold's Replicator Tool which makes this technique extremely easy:

http://rnoldz.com/replicator.html

A final point.  Macros cannot perform any action that need conditional processing, such as only entering specific fields when the data has this checkbox selected. Talking about checkboxes, Macros always toggle the checkbox, they cannot set it to true or false as it just clicks on it and does not know what the previous value was. If you want integration with conditional functionality, I would suggest using GP Power Tools with Dexterity scripting to drive the user interface. As the code can read the previous data and have conditional code, you have lots of extra capability.

Bonus point: If you have GP Power Tools installed, you will have an option to Play Fast on the Macro menu which can run macros about 3 times faster than the standard Play option.

Hope this is useful information.

Regards

David

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

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com

Original Message:
Sent: Jan 31, 2023 03:14 PM
From: Cecile Dinh
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hello -

Just wanted to share my recent blog on how to use a macro to process NSF.

Out of the 13,000 records we drafted there were 300+ transactions with No Sufficient Fund (NSF) or bank account was not yet ready to be drafted. In this video I will show you how to create a macro to save you time and energy in processing NSF in Dynamics GP.   Here's the link. 

Hope this helps!

------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.
------------------------------

Hello - 

 What a quick turn around! :)  I got in touch with Mr. Replicator @John Arnold and we did a video on how to use the Replicator.  This is very helpful to our community. ​Please check this out.

------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.
------------------------------

Original Message:
Sent: Feb 01, 2023 12:39 PM
From: Cecile Dinh
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hi @David Musgrave,

Thanks for sharing this additional info, this is very helpful!

I found out from my last GPUG ​Chapter meeting that there are many users doing the NSF process manually.  That's why having this techniques resurface will definitely help our community.


------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.

Original Message:
Sent: Feb 01, 2023 02:14 AM
From: David Musgrave
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hi @Cecile Dinh

Thanks for posting the forum thread and your blog article.

​Here is more information on this technique from my 2008 blog article: 

https://winthropdc.wordpress.com/2008/10/29/how-to-use-word-mail-merge-and-macros-to-import-data/

We should also mention John Arnold's Replicator Tool which makes this technique extremely easy:

http://rnoldz.com/replicator.html

A final point.  Macros cannot perform any action that need conditional processing, such as only entering specific fields when the data has this checkbox selected. Talking about checkboxes, Macros always toggle the checkbox, they cannot set it to true or false as it just clicks on it and does not know what the previous value was. If you want integration with conditional functionality, I would suggest using GP Power Tools with Dexterity scripting to drive the user interface. As the code can read the previous data and have conditional code, you have lots of extra capability.

Bonus point: If you have GP Power Tools installed, you will have an option to Play Fast on the Macro menu which can run macros about 3 times faster than the standard Play option.

Hope this is useful information.

Regards

David

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

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com

Original Message:
Sent: Jan 31, 2023 03:14 PM
From: Cecile Dinh
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hello -

Just wanted to share my recent blog on how to use a macro to process NSF.

Out of the 13,000 records we drafted there were 300+ transactions with No Sufficient Fund (NSF) or bank account was not yet ready to be drafted. In this video I will show you how to create a macro to save you time and energy in processing NSF in Dynamics GP.   Here's the link. 

Hope this helps!

------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.
------------------------------

@Cecile Dinh Great job working with @John Arnold to create the video.

Glad you liked his awesome tool.

David​​

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

Managing Director
Winthrop Development Consultants

Perth, Western Australia

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

Original Message:
Sent: Feb 01, 2023 06:31 PM
From: Cecile Dinh
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hello - 

 What a quick turn around! :)  I got in touch with Mr. Replicator @John Arnold and we did a video on how to use the Replicator.  This is very helpful to our community. ​Please check this out.

------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.

Original Message:
Sent: Feb 01, 2023 12:39 PM
From: Cecile Dinh
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hi @David Musgrave,

Thanks for sharing this additional info, this is very helpful!

I found out from my last GPUG ​Chapter meeting that there are many users doing the NSF process manually.  That's why having this techniques resurface will definitely help our community.


------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.

Original Message:
Sent: Feb 01, 2023 02:14 AM
From: David Musgrave
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hi @Cecile Dinh

Thanks for posting the forum thread and your blog article.

​Here is more information on this technique from my 2008 blog article: 

https://winthropdc.wordpress.com/2008/10/29/how-to-use-word-mail-merge-and-macros-to-import-data/

We should also mention John Arnold's Replicator Tool which makes this technique extremely easy:

http://rnoldz.com/replicator.html

A final point.  Macros cannot perform any action that need conditional processing, such as only entering specific fields when the data has this checkbox selected. Talking about checkboxes, Macros always toggle the checkbox, they cannot set it to true or false as it just clicks on it and does not know what the previous value was. If you want integration with conditional functionality, I would suggest using GP Power Tools with Dexterity scripting to drive the user interface. As the code can read the previous data and have conditional code, you have lots of extra capability.

Bonus point: If you have GP Power Tools installed, you will have an option to Play Fast on the Macro menu which can run macros about 3 times faster than the standard Play option.

Hope this is useful information.

Regards

David

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

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com

Original Message:
Sent: Jan 31, 2023 03:14 PM
From: Cecile Dinh
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hello -

Just wanted to share my recent blog on how to use a macro to process NSF.

Out of the 13,000 records we drafted there were 300+ transactions with No Sufficient Fund (NSF) or bank account was not yet ready to be drafted. In this video I will show you how to create a macro to save you time and energy in processing NSF in Dynamics GP.   Here's the link. 

Hope this helps!

------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.
------------------------------

It may be good to turn off 'made for kids' on the video so that it can be saved in YouTube.  When 'made for kids' is turned on, videos can't be saved.

------------------------------
Steve Friebe
CIO
Areaware
Columbus OH
------------------------------

Original Message:
Sent: Jan 31, 2023 03:14 PM
From: Cecile Dinh
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hello -

Just wanted to share my recent blog on how to use a macro to process NSF.

Out of the 13,000 records we drafted there were 300+ transactions with No Sufficient Fund (NSF) or bank account was not yet ready to be drafted. In this video I will show you how to create a macro to save you time and energy in processing NSF in Dynamics GP.   Here's the link. 

Hope this helps!

------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.
------------------------------

Hi @Steve Friebe,

Thanks for the info. I just updated the YouTube settings .  Please try again.


------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.
------------------------------

Original Message:
Sent: Feb 02, 2023 08:10 AM
From: Steve Friebe
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

It may be good to turn off 'made for kids' on the video so that it can be saved in YouTube.  When 'made for kids' is turned on, videos can't be saved.

------------------------------
Steve Friebe
CIO
Areaware
Columbus OH

Original Message:
Sent: Jan 31, 2023 03:14 PM
From: Cecile Dinh
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hello -

Just wanted to share my recent blog on how to use a macro to process NSF.

Out of the 13,000 records we drafted there were 300+ transactions with No Sufficient Fund (NSF) or bank account was not yet ready to be drafted. In this video I will show you how to create a macro to save you time and energy in processing NSF in Dynamics GP.   Here's the link. 

Hope this helps!

------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.
------------------------------

Thanks!  I was able to save it :D

------------------------------
Steve Friebe
CIO
Areaware
Columbus OH
------------------------------

Original Message:
Sent: Feb 02, 2023 10:25 AM
From: Cecile Dinh
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hi @Steve Friebe,

Thanks for the info. I just updated the YouTube settings .  Please try again.


------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.

Original Message:
Sent: Feb 02, 2023 08:10 AM
From: Steve Friebe
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

It may be good to turn off 'made for kids' on the video so that it can be saved in YouTube.  When 'made for kids' is turned on, videos can't be saved.

------------------------------
Steve Friebe
CIO
Areaware
Columbus OH

Original Message:
Sent: Jan 31, 2023 03:14 PM
From: Cecile Dinh
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hello -

Just wanted to share my recent blog on how to use a macro to process NSF.

Out of the 13,000 records we drafted there were 300+ transactions with No Sufficient Fund (NSF) or bank account was not yet ready to be drafted. In this video I will show you how to create a macro to save you time and energy in processing NSF in Dynamics GP.   Here's the link. 

Hope this helps!

------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.
------------------------------

You're welcome! :D

------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.
------------------------------

Original Message:
Sent: Feb 02, 2023 11:24 AM
From: Steve Friebe
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Thanks!  I was able to save it :D

------------------------------
Steve Friebe
CIO
Areaware
Columbus OH

Original Message:
Sent: Feb 02, 2023 10:25 AM
From: Cecile Dinh
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hi @Steve Friebe,

Thanks for the info. I just updated the YouTube settings .  Please try again.


------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.

Original Message:
Sent: Feb 02, 2023 08:10 AM
From: Steve Friebe
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

It may be good to turn off 'made for kids' on the video so that it can be saved in YouTube.  When 'made for kids' is turned on, videos can't be saved.

------------------------------
Steve Friebe
CIO
Areaware
Columbus OH

Original Message:
Sent: Jan 31, 2023 03:14 PM
From: Cecile Dinh
Subject: Blog: How to use a macro to process 300+ NSF in Dynamics GP in minutes

Hello -

Just wanted to share my recent blog on how to use a macro to process NSF.

Out of the 13,000 records we drafted there were 300+ transactions with No Sufficient Fund (NSF) or bank account was not yet ready to be drafted. In this video I will show you how to create a macro to save you time and energy in processing NSF in Dynamics GP.   Here's the link. 

Hope this helps!

------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.
------------------------------