Microsoft Dynamics GP User Defined Fields can make reporting easier

Both Microsoft Dynamics GP Payables Vendors and Microsoft Dynamics GP Receivables Customers can have 2 user defined fields setup in Microsoft Dynamics GP “Out of the box.” User Defined field 1 can even be used in sorting on options on GP reports. 

Originally Posted 5/8/2011

 

Both Microsoft Dynamics GP Payables Vendors and Microsoft Dynamics GP Receivables Customers can have 2 user defined fields setup in Microsoft Dynamics GP “Out of the box.” User Defined field 1 can even be used in sorting on options on GP reports.

Watch this video to see where they are set up, and how they can be used in reports.

Continue reading “Microsoft Dynamics GP User Defined Fields can make reporting easier”

Throw out the calculator when using Microsoft Dynamics GP

There is a feature that has been in Microsoft Dynamics GP since version 1 that you probably forgot about. .. 
Fixed Allocation Accounts 
These are fake accounts, nothing ever gets posted there, but they can save you time. 

Originally Posted in 2011

There is a feature that has been in Microsoft Dynamics GP since version 1 that you probably forgot about. ..
Fixed Allocation Accounts
These are fake accounts, nothing ever gets posted there, but they can save you time.
Continue reading “Throw out the calculator when using Microsoft Dynamics GP”

Correct or copy a Microsoft Dynamics GP GL entry

To continue with this week’s topic on making mistakes, use the correct feature to fix a Microsoft Dynamics GP GL entry. 

To continue with this week’s topic on making mistakes, use the correct feature to fix a Microsoft Dynamics GP GL entry.

Continue reading “Correct or copy a Microsoft Dynamics GP GL entry”

Default Distributions in Microsoft Dynamics GP Payables?

Use default Microsoft Dynamics GP GL accounts with Vendors to make entering distributions easier in Payables. If you are not currently doing this, you are wasting time. 


Use default Microsoft Dynamics GP GL accounts with Vendors to make entering distributions easier in Payables. If you are not currently doing this, you are wasting time.

Continue reading “Default Distributions in Microsoft Dynamics GP Payables?”

Bring out your reports, Bring (send) out your Microsoft Dynamics GP reports (Video)

This video shows a new feature of GP2010 R2, emailing reports directly from Microsoft  Dynamics GP. It’s fast and simple. Here I am sending out an Aged Trial Balance with Options from Microsoft Dynamics GP Payables Management. 

Originally Posted 5/16/2011 

This video shows a new feature of GP2010 R2, emailing reports directly from Microsoft  Dynamics GP. It’s fast and simple. Here I am sending out an Aged Trial Balance with Options from Microsoft Dynamics GP Payables Management.

Continue reading “Bring out your reports, Bring (send) out your Microsoft Dynamics GP reports (Video)”

Microsoft Dynamics GP Budget Transactions & Adjusted Budgets (Video)

In this Video I show how to maintain Budget Transaction History, Enter Budget Transactions and how I use multiple Microsoft Dynamics GP Budgets in FRx (although it could be Management Reporter, Jet Reports, or any financial reporting tool). 

Originally Posted 5-18-2011

In this Video I show how to maintain Budget Transaction History, Enter Budget Transactions and how I use multiple Microsoft Dynamics GP Budgets in FRx (although it could be Management Reporter, Jet Reports, or any financial reporting tool).
Continue reading “Microsoft Dynamics GP Budget Transactions & Adjusted Budgets (Video)”

Microsoft Dynamics GP GL Summaries vs. GL Budgets (Video)

In this video, I use a custom T-SQL script to exact both summaries from my Microsoft Dynamics GP General Ledger account numbers and my Budgets.  Feel free to download the script and create your own view; or simply use the script within Microsoft Excel Query Editor, as I did.  See the blog post for the script.

In this video, I use a custom T-SQL script to exact both summaries from my Microsoft Dynamics GP General Ledger account numbers and my Budgets.  Feel free to download the script and create your own view; or simply use the script within Microsoft Excel Query Editor, as I did.  See the blog post for the script.

Continue reading “Microsoft Dynamics GP GL Summaries vs. GL Budgets (Video)”