Category: ERP

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 »

Why Are ERP Systems Sticky?

Congratulations! You are the executive chosen to spearhead the effort to select and implement a new ERP system to replace the one that your organization originally installed a number of years ago. As you plan for this project, you may find it helpful to know what others in your position have experienced so you know what to anticipate and can craft a better plan to unstick the existing ERP system. 

Read More »

Uploading Vendors into Acumatica ERP

One of the most difficult decisions that has to be made during a new system implementation is how much and what kind of data to migrate from your old system to the new. How many years do we bring over? Do we bring over detailed or summarized data? Is it reconciled? Will we have access to old system for historical reporting purposes? These are all questions that are posed and answers that are debated during the process of making the decision.

Read More »

Top 5 Reasons to Use Microsoft Dynamics GP Project Accounting

Microsoft Dynamics GP’s Project Accounting suite is a robust, highly configurable and flexible module which is fully integrated with other modules within the Dynamics GP product suite. The flexibility of configuration, setup and integration to other modules makes it an attractive choice for tracking financial data by contract, project and cost category. It allows you to maintain complete control over project costs and execution, while also maintaining control over project budgets. 

Read More »

Financial Forecasting, Planning, and Adjusting– Is it Really Necessary?

Forecasting, budgeting, business planning; what is the big deal?  It is an important topic and at our User Conference, we had sessions and speakers talking about this. In the past, some mid-sized and most small companies have managed to grow and be profitable without formal planning and strategic visions.  For some executives, budgeting and planning seems like a lot of wasted effort to creating fictional numbers that are a guess today and completely irrelevant in six months!  

Read More »

Zero in on ZIP code risk

Internet and mobile sales continue to grow in popularity among shoppers and profitability for retailers. Last year, online sales in the U.S. topped $307 billion. The lucrative internet marketplace has also led to more online crime. Recent cyberattacks on U.S. businesses, which affected such titans of industry as Target, JPMorgan Chase, Home Depot and Premera, has Congress scrambling to craft laws to protect businesses and consumers against data breaches. And in 2014, businesses lost an estimated $3.5 trillion globally from retail fraud. Online sellers took the biggest hit, according to LexisNexis, primarily due to losses from card-not-present (CNP) transactions. 

Read More »

Non for Profit .. What options are there out there for you using Dynamics GP

Fund accounting by definition is an accounting system emphasizing accountability rather than profitability.  This is used by non-profit organizations and governments.  Most ERP systems are designed to emphasize on profitability not accountability.  Dynamics GP has options for this that will assist you in spending less time managing funding and accounting processes and more time on your mission.  The modules available in Dynamics GP are interfund accounting, control account management, encumbrance management, commitments, and grant management.  Below we will give you the details of each module and how it can help. 

Read More »

PAYING EMPLOYEE EXPENSES BY EFT PART 4

In part 1 – We went thru the Steps to setup the Company EFT Information.  In part 2 – We went thru the Steps to setup the Employee as a Vendor and the Steps to setup the Employee Bank / EFT Information.  In part 3 – We went thru the Steps to Generate an EFT PreNote File to send to the Bank and the Steps to Enter the Employee Expenses.   In this Section we will go thru the Steps to pay the Employee Expenses via EFT and send the File to the Bank.  

Read More »