Tag: Microsoft

Why should you integrate data into your ERP instead of manual data entry?

The first question to ask is what do you mean by integrate data into your ERP?  When I say integrate data into your ERP what I am talking about is taking out the step of manual entry of transactions to loading large batches at once.  There are multiple ways to integrate data into your ERP software and you can integrate all types of data. 

Read More »

Troubleshooting Locked Records in Dynamics GP

In this month’s blog, I wanted to address the primary reasons records may be locked in Dynamics GP and various ways to unlock the records.  The causes of records being locked in Dynamics GP may happen for a variety of reasons, but the fix is quite similar.  Two of the primary reasons records may be locked in Dynamics GP are from batches having issues while being posted and records being edited by a user.   The records remain locked until the batch is posted or the user has saved their changes.  If something happens during these processes, the lock may not be released and the record could remain locked. 

Read More »

IT for Accountants: What is RDP and why do I need it?

So, its 4pm on Thursday and you’re having an issue with payroll in GP. You’re not sweating it because you know that you have an amazing VAR who is going to get this all straightened out for you. You call in and get your consultant on the phone and they tell you they are going to use RDP to get on your machine and see what the problem is. You sit there confused but not wanting to let them know that you have no idea what’s happening. A million thoughts race through your head… “What’s RDP? Should I have this? Do I need it? Why don’t I know?” 

Read More »

DCAA Compliance and First Audit – This Should Be a Happy (But Careful) Time

I recently attended a workshop that was so spot-on I’ll even mention the speaker and his company: Kevin Grimes of CFO Leasing. I never met Kevin prior to that workshop but was very impressed with how clearly and succinctly he conveys the pitfalls and nuances of becoming DCAA compliant. 

Getting a notice that you are going to be audited by DCAA should not be frightening, but should be a joyful notice. The fact that your company has gotten the attention of DCAA means that you are about to be awarded a large contract or your business has grown so successfully that you are a larger federal contractor; both reasons to be happy, not frightened. However, at this point, you need to understand that: 

Read More »

Five Things to Consider When Moving to the Cloud

News about the cloud is everywhere, the sales pitch for cloud computing is simple. 


Companies pay a third-party vendor to run one or more of their systems, like email or payroll, on its own servers, saving tons of money.  

Read More »

How to close the fiscal year in Microsoft Dynamics GP

Companies that operate on a fiscal year instead of a calendar year have to do two year end closes in their ERP software.  One close is for the calendar year for 1099 and tax filing and the other close would be for the company year end close.  Most people ask what is the purpose of two closings.  This is a great question the main purpose for two closing is to tax filings that are calendar related for example 1099 processing.  The next question that is asked is what happens to within my ERP when I close the fiscal year and that is what we are going to go thru below:

Read More »

How to create a Drop Point in PaperSave

A Drop Point in PaperSave is a method of capturing documents and sending them to a PaperSave workflow.   Each Drop Point can be associated to a single workflow, but a workflow may have several Drop Points.  The reason a workflow may have several Drop Points is to capture documents from different methods, such as Email, drag and drop, scan, etc.

Read More »

Upcoming Updates to SQL in 2016

Coming in 2016, the newest upgrades and features to SQL have developers everywhere speculating about the future. Microsoft has designed the 2016 release of SQL to be easy to use, traditional in application appearance and control, and most importantly data-secure. The most exciting new feature for SQL in 2016 is called Always Encrypted. Microsoft has created an extra layer of data security so that even when you are working with sensitive data such as social security numbers or credit card numbers, the data is secure. This ensures that even at the most vulnerable time for an attack, while data is being used, a person’s identity and company’s reputation are safe. The best part about this upgrade and its new features is that it will not hinder the performance of the application. 

Read More »

Visualizing your Financial Statement with a Waterfall Chart

In July, Microsoft introduced six new chart types that will be available as part of Office 2016. Today, I’m will show you how to take advantage of the waterfall chart, one of the most popular visualization tools used in small and large businesses by modifying Dynamics GP’s Excel Financial Dashboard with Excel 2016 to add a Waterfall chart.  A waterfall chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values and is very useful in analyzing an income statement.  

Read More »

The Benefits of CRM Systems and Microsoft Dynamics CRM improved Integration with Outlook

My question to you is; why wouldn’t you be using a CRM system?

CRM’s refer to allons between a business and its customers.  CRM systems not only help manage your business and relationships with clients it also provides s number of important benefits to both small and large companies including increasing revenue and decreasing costs.  What business or business owner wouldn’t want to do that?

Read More »