Little Microsoft Dynamics GP VBA Scripts mean a lot! 4.34 Hours a Year!

This video shows how and where I use VBA (Visual Basics for Applications) in Microsoft Dynamics GP to save me TONS of time. I built this script MANY years ago and I still cannot live without it. It copies whatever I enter of the “Paid To” or “Received From” line to the “Description Line. 

Originally Posted 4/5/11

This video shows how and where I use VBA (Visual Basics for Applications) in Microsoft Dynamics GP to save me TONS of time. I built this script MANY years ago and I still cannot live without it. It copies whatever I enter of the “Paid To” or “Received From” line to the “Description Line.

Keep in mind you need Customized Site License or Modifier for this to work for you.

Continue reading “Little Microsoft Dynamics GP VBA Scripts mean a lot! 4.34 Hours a Year!”

Microsoft Dynamics GP Posting Accounts and Unit Accounts, Oh My!

This video spends a little extra time in the Maintenance windows for both Microsoft Dynamics GP Posting and Unit Accounts. 

Originally Posted 4/20/2011

This video spends a little extra time in the Maintenance windows for both Microsoft Dynamics GP Posting and Unit Accounts.

When using the system day to day, it’s easy to forget that there are some benefits that exist that you may not be using.

Continue reading “Microsoft Dynamics GP Posting Accounts and Unit Accounts, Oh My!”

Microsoft Dynamics GP Allocation Accounts, Take my work away

This video spends a little extra time in the Microsoft Dynamics GP Allocation Account Maintenance windows for both Fixed Allocation Accounts and Variable Allocation Accounts.

Originally Posted 4/21/11

This video spends a little extra time in the Microsoft Dynamics GP Allocation Account Maintenance windows for both Fixed Allocation Accounts and Variable Allocation Accounts.

These little beauties can save you time on month-end Entries, if using 1 allocation account each month saves you 2 minutes a month, that’s 24 minutes a year.

I’ll take those 24 minutes and add them to my “40 hours a year” saving quest, which takes me to savings of 371 minutes a year (6.18 hours) with the first 3 entries alone!

Continue reading “Microsoft Dynamics GP Allocation Accounts, Take my work away”

I can’t believe I see the whole Microsoft Dynamics GP Budget!

Want to see your entire Microsoft Dynamics GP budget for all 12 periods? Use the Excel Budget Wizard! 

Originally Posted 4/27/11

Want to see your entire Microsoft Dynamics GP budget for all 12 periods? Use the Excel Budget Wizard!

Continue reading “I can’t believe I see the whole Microsoft Dynamics GP Budget!”

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)”