Join Amber Bell on a heroic GP Adventure!

At each turn you will see how you how your choices can make things easier…or lead to unexpected challenges and misadventures. Don’t worry Amber will guide you to safety and new treasures in GP!

This edition of my Microsoft Dynamics GP User Event Session Archive highlights the session - ‘DUG Webinar: Choose Your Own Adventure - A Dynamics GP Treasure Hunt’ that was presented at the July 2023 DUG Webinars hosted by the DUG and MSDW (Microsoft Dynamics World).

Check out the link to view the DUG Webinar: Choose Your Own Adventure - A Dynamics GP Treasure Hunt presentation slides. You can also watch a recording by clicking this link.

If you have any questions, comments, or feedback, feel free to contact me!

GP User to GP Superhero

This edition of my Microsoft Dynamics GP User Event Session Archive highlights the session - ‘GP User to GP Superhero - 2023 Summit Edition’ that was presented at the October 2023 Community Summit in Charlotte, NC hosted by the Community Summit GP.

Check out the link to view the GP User to GP Superhero presentation slides. If you have any questions, comments, or feedback, feel free to contact me!

An Exciting Adventure Across the "Great Plains"

In this edition of Amber Bell's Microsoft Dynamics GP User Event Session Archive, we are highlighting the session ‘Choose Your Own GP Adventure’ that was presented at the October 2023 Community Summit in Charlotte, NC hosted by the Community Summit GP.

Here is the link to the presentation, An Exciting Adventure Across the “Great Plains.”

If you have any questions, comments, or feedback, let me know!

How to Train Your "New to GP" Employees - Tips/Tricks to Creating Training Assets

This edition of my Microsoft Dynamics GP User Event Session Archive highlights the session - ‘How Do We Teach GP?’ that was presented at the October 2023 Community Summit in Charlotte, NC hosted by the Community Summit GP.

Check out the link to view the How to Train Your “New to GP” Employees Tips and Tricks to Creating Training Assets presentation slides. If you have any questions, comments, or feedback, feel free to contact me!

SQL View for Microsoft Dynamics GP General Ledger Accounts

Microsoft Dynamics GP - SQL View for GL Account Review

Hello everyone!

It’s been far too long since my last blog post. I have lots of updates but I wanted to just get to the good stuff first.

I will be sharing a tip at the 2022 Community Summit and I wanted to give you all access to a SQL View that I found and improved. I had a customer with thousands and thousands of accounts that were setup when they first setup GP. Their partner took every possible combo of each segment value and created accounts. This created Balance Sheet accounts for each subdivision/site. Many accounts were never used. They had no easy way to find them! I found a SQL View on the Microsoft Communities site. I added some additional fields and it was perfect!

I have a contest and a survey to help me figure out what I should focus on next. Here’s a link to the survey: Training Dynamo Survey

To learn how to load SQL Views and use them with SmartList Designer or SmartList Builder, visit and subscribe to my YouTube Channel: youtube.com/c/trainingdynamo

--The SQL Script below started here  https://community.dynamics.com/gp/f/microsoft-dynamics-gp-forum/144447/gl-account-numbers--cleanup-of-accounts-not-used
--Amber Bell from Training Dynamo added the "Created Date" and "Account Type" and turned into a SQL View


CREATE VIEW _GLAccountLastUsed
AS


SELECT  B.ACTNUMST 'Account Number' ,
        A.ACTDESCR 'Account Description' ,
	 A.CREATDDT 'Created Date',
	 A.ACTINDX 'Account Index',
	  A.ACCTTYPE 'Account Type',
	  A.ACTIVE 'Active',
        CASE WHEN ISNULL(D.TRX_Date, 0) < A.CREATDDT THEN 'Yes'
             ELSE ''
        END AS NeverUsed ,
        ISNULL(D.TRX_Date, 0) AS 'Last Used' ,
        DATEDIFF(YY, ISNULL(D.TRX_Date, 0), GETDATE()) 'Not Used Since (In Years)' ,
        DATEDIFF(MM, ISNULL(D.TRX_Date, 0), GETDATE()) 'Not Used Since (In Months)' ,
        DATEDIFF(DD, ISNULL(D.TRX_Date, 0), GETDATE()) 'Not Used Since (In Days)'
FROM    dbo.GL00100 AS A
        LEFT OUTER JOIN dbo.GL00105 AS B ON A.ACTINDX = B.ACTINDX
        LEFT OUTER JOIN ( SELECT    ACTINDX ,
                                    MAX(TRX_Date) TRX_Date
                          FROM      ( SELECT    ACTINDX ,
                                                MAX(TRXDATE) AS TRX_Date
                                      FROM      dbo.GL20000
                                      GROUP BY  ACTINDX
                                      UNION ALL
                                      SELECT    ACTINDX ,
                                                MAX(TRXDATE) AS TRX_Date
                                      FROM      dbo.GL30000
                                      GROUP BY  ACTINDX
                                    ) AS C
                          GROUP BY  C.ACTINDX
                        ) AS D ON B.ACTINDX = D.ACTINDX

GO
GRANT SELECT ON _GLAccountLastUsed TO DYNGRP