Get Data from Microsoft Dynamics GP to Excel – Part 4 of 4 (with Video)

This is the last of the 4-part series on getting the GL Account segment description into Excel.  As I’ve said before, it doesn’t matter what you want, if it’s in Dynamics GP, you can get it into Microsoft Excel.  This time we’ll use the 3rd party product by eOne called Excel Builder.  I’ll create an Excel Refreshable Report that lives in the same location as the “out of the box” Excel Reports, either in a folder or in SharePoint.

This is the last of the 4-part series on getting the GL Account segment description into Excel.  As I’ve said before, it doesn’t matter what you want, if it’s in Dynamics GP, you can get it into Microsoft Excel.  This time we’ll use the 3rd party product by eOne called Excel Builder.  I’ll create an Excel Refreshable Report that lives in the same location as the “out of the box” Excel Reports, either in a folder or in SharePoint.

Continue reading “Get Data from Microsoft Dynamics GP to Excel – Part 4 of 4 (with Video)”

Printing from Dynamics GP in Bulk

In this video, I review how to setup Report Groups and Combined Reports. This will help when you need to print multiple reports on a regular basis (e.g. Period End Reports, Audit Reports, etc. using Microsoft Dynamics GP. 

Originally Posted 5/21/11

In this video, I review how to setup Report Groups and Combined Reports. This will help when you need to print multiple reports on a regular basis (e.g. Period End Reports, Audit Reports, etc. using Microsoft Dynamics GP.

Continue reading “Printing from Dynamics GP in Bulk”

Where were these invoices I’m paying expensed in Dynamics GP?

In this video, I show you 3 options for extracting Check Registers from Payables Management. 1 option even shows you all the GL account numbers that were used for the invoices being paid using Microsoft Dynamics GP. 

Originally Posted 5/22/11

In this video, I show you 3 options for extracting Check Registers from Payables Management. 1 option even shows you all the GL account numbers that were used for the invoices being paid using Microsoft Dynamics GP.

Continue reading “Where were these invoices I’m paying expensed in Dynamics GP?”

Get Data from Microsoft Dynamics GP to Excel – Part 3 of 4 (with Video)

This is the continuation of the 4-part series on getting the GL Account segment description into Excel.  As I’ve said before, it doesn’t matter what you want, if it’s in Dynamics GP, you can get it into Microsoft Excel.  This time we’ll use the 3rd party product by eOne called SmartList Builder.  I’ll create a SmartList object, that can drilldown into the GL Account Segment Setup Window and/or export to Excel.

This is the continuation of the 4-part series on getting the GL Account segment description into Excel.  As I’ve said before, it doesn’t matter what you want, if it’s in Dynamics GP, you can get it into Microsoft Excel.  This time we’ll use the 3rd party product by eOne called SmartList Builder.  I’ll create a SmartList object, that can drilldown into the GL Account Segment Setup Window and/or export to Excel.

Continue reading “Get Data from Microsoft Dynamics GP to Excel – Part 3 of 4 (with Video)”

Get Data from Microsoft Dynamics GP to Excel – Part 2 of 4 (with Video)

This is the continuation of the 4-part series on getting the GL Account segment description into Excel.  As I’ve said before, it doesn’t matter what you want, if it’s in Dynamics GP, you can get it into Microsoft Excel.

Continue reading “Get Data from Microsoft Dynamics GP to Excel – Part 2 of 4 (with Video)”

3 Tips to Make Financials calculate faster in Jet Reports

Watch this video to find 3 ways to make Jet Reports calculate faster for Microsoft Dynamics GP data. The first 2 tips apply to the free (Jets Basics) and the paid (Jet Reports) versions. The final tip is for the Jet Reports version only.

Watch this video to find 3 ways to make Jet Reports calculate faster for Microsoft Dynamics GP data.  The first 2 tips apply to the free (Jets Basics) and the paid (Jet Reports) versions.  The final tip is for the Jet Reports version only.

 

Continue reading “3 Tips to Make Financials calculate faster in Jet Reports”

Get Data from Microsoft Dynamics GP to Excel – Part 1 of 4 (with Video)

I was recently asked how to get the Microsoft Dynamics GP General Ledger Account Segments into an Excel file.  I thought, I’ll just do a four-part series.  It doesn’t matter what you want, if it’s in Dynamics GP, you can get it into Microsoft Excel. 

I was recently asked how to get the Microsoft Dynamics GP General Ledger Account Segments into an Excel file.  I thought, I’ll just do a four-part series.  It doesn’t matter what you want, if it’s in Dynamics GP, you can get it into Microsoft Excel. Design

Continue reading “Get Data from Microsoft Dynamics GP to Excel – Part 1 of 4 (with Video)”