Author: Belinda Allen

Belinda Allen (Microsoft MVP) is both a Microsoft Certified Professional for Dynamics GP (MCP) and a Microsoft Certified Trainer (MCT). She is also the co-founder of Smith & Allen Consulting, Inc. (www.saci.com), a business management software consulting firm for over 24 years. Belinda began implementing ERP systems so long ago that Windows was not an operating system, but an application. Larger businesses used old Main Frames with monitors that were Green and Black and smaller business did accounting by hand. Having seen the evolution that has taken place over the years from pieces of paper to analytics, Belinda still gets excited every time she helps a business improve. Belinda is also well known for her Blog www.BelindaTheGPcsi.com. Her blog is about sharing really useful information about the product quickly and succinctly. She has earned the nickname GP CSI because she excels at reviewing GP problems and figuring what went wrong and why. With followers all over the Globe she is able to share knowledge and achieve her mission: “To Improve the Lives and Business Success of my Followers.” In her time off, Belinda enjoys sailing, woodturning, crochet/knitting, sewing/quilting, reading and playing the ukulele (Belinda often participates in Ukulele Jams in NYC.)

Easy way to kind close a period in Microsoft Dynamics GP (with Video)

Need to stop people from entering and posting information Microsoft Dynamics GP for a period that has already completed with final Financial Statements?

Originally Posted 5/6/14

Need to stop people from entering and posting information Microsoft Dynamics GP for a period that has already completed with final Financial Statements?

Continue reading “Easy way to kind close a period in Microsoft Dynamics GP (with Video)”

Microsoft Dynamics GP – Make Excel Data refreshing easier (video)

This is part 7 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Originally Posted 12/16/13

This is part 7 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Continue reading “Microsoft Dynamics GP – Make Excel Data refreshing easier (video)”

Microsoft Dynamics GP – Why avoid 3D charts in Excel? (video)

This is part 6 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

This is part 6 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Continue reading “Microsoft Dynamics GP – Why avoid 3D charts in Excel? (video)”

Microsoft Dynamics GP – Open Purchase Order Table (with video)

This is part 5 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Originally Posted 12/2/13

This is part 5 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Continue reading “Microsoft Dynamics GP – Open Purchase Order Table (with video)”

Microsoft Dynamics GP – Inventory Item Reorder Dashboard (with video)

This is part 4 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Originally Posted 11/25/2013

This is part 4 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Continue reading “Microsoft Dynamics GP – Inventory Item Reorder Dashboard (with video)”

Microsoft Dynamics GP – Excel Power Pivot SOP Dashboard (with video)

This is part 3 of a 7-part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Originally Posted 11/18/13

This is part 3 of a 7-part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Continue reading “Microsoft Dynamics GP – Excel Power Pivot SOP Dashboard (with video)”

Microsoft Dynamics GP 2013–Lookup feature (with video)

When looking up master records in Microsoft Dynamics GP, you can save any custom sort order you create.

Belinda Allen from Njevity, Inc. shares information on Microsoft Dynamics GP.

Originally Posted 11/13/13

When looking up master records in Microsoft Dynamics GP, you can save any custom sort order you create.   Watch this very short video on how to do it.

Continue reading “Microsoft Dynamics GP 2013–Lookup feature (with video)”

Microsoft Dynamics GP – Excel AR Trial Balance with SQL (with video)

In this video, I create a Summary Aged Trial Balance for Receivables Management using a custom SQL view created by Microsoft Dynamics GP MVP, Victoria Yudin.

Originally Posted 11/11/13

This is part 2 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

In this video, I create a Summary Aged Trial Balance for Receivables Management using a custom SQL view created by Microsoft Dynamics GP MVP, Victoria Yudin. The view can be located on her blog posting below:

Continue reading “Microsoft Dynamics GP – Excel AR Trial Balance with SQL (with video)”

Microsoft Dynamics GP–Purchase Order (POP) warning feature (with video)

In Microsoft Dynamics GP there is a little feature with a BIG benefit. You can setup Purchase Order Processing or POP to warn you if you try to close a Purchase Order when there are remaining quantities received but not invoiced.

Originally Posted 11/7/2013

In Microsoft Dynamics GP there is a little feature with a BIG benefit.  You can setup Purchase Order Processing or POP to warn you if you try to close a Purchase Order when there are remaining quantities received but not invoiced.  This can save you a BIG reconciliation headache.

Continue reading “Microsoft Dynamics GP–Purchase Order (POP) warning feature (with video)”