Dynamics GP Training/Tutorial 101 - Youtube Video Series!

For all of the new/un-guided Dynamics GP users out there, this one’s for you!

Introducing the “Learn Dynamics GP - 101 Series” now up on YouTube! A lot of time and effort has gone into these tutorials but I’m happy to finally roll them out and make them official.

The 101 series is what you would think but is broken down core module by core module and includes some bonus 101 series training/tutorials (Fixed Assets, Navigation, etc.).

The hope is that these videos can serve as an introduction to Microsoft Dynamics GP and get you or your team up to speed very quickly. If you ever have questions or are looking for more in-depth & hands-on trainings, let our team help you out.

The 101 series is just the beginning and more videos are to come! Let us know what you think in the comments below or on the YouTube channel and do us a favor and SUBSCRIBE to stay up to date with our future releases.

Enjoy!

Youtube - GP Training/Tutorial 101 Series

https://www.youtube.com/playlist?list=PLYaFvNBJI6Dq8HQP3gr9tr2c3F9Sa6seP

GP-Training-Tutorial-101-Series.png

Re-Enable New Account Segment Notification in Dynamics GP

If you've ever integrated new accounts via Integration Manager, you've probably found that the notification that prompts users that a Chart of Account segment does not exists and that prevents you being able to add accounts easily.  The easiest and quickest solution for this problem is to quickly select 'Yes, add segment' and 'Do not display this message again'.  No harm no foul.

The downside of this is that the notification window exists for a reason and that reason is to ensure that users are not accidentally adding unnecessary COA segments.  Once you've selected 'Do not notify me again', GP listens and will no longer notify that user.

However, via SQL, we can reverse these effects and force GP to forget what we told it earlier.

Step 1. View users that currently have disabled this notification window

- Select * from {CompID}..SY01401 where coDefaultType = 13

Step 2. Create database backup or table backup

- Select * into SY01401_backup_MMddYY from SY01401

Step 3. Run delete statement

- This delete statement removes the records that suppress the notification window from appearing

- Delete from (CompID}..SY01401 where coDefaultType = 13

- To filter for one specific user, add the filter "and UserID = {User}"

Step 4. Run select to confirm records have been removed

- Select * from {CompID}..SY01401 where coDefaultType = 13

Step 5. Add a non-existent COA segment in GP & ensure the prompt window appears

Seems minor but notifications like these are valuable in ensuring account structures remain clean in consistent in an environment.

Simple solution to a simple problem?  Let us know in the comments below.