ERP Software Logo

Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

Posts Tagged ‘Excel’

Investing in a Budgeting Solution is also an Investment in Staff Morale

Who likes to sit down to endure a stream of several e-mails, research on unstable variables, and a consolidation of departmental, divisional data into a budget?  It might be because the process is somewhat naturally tedious, but it also could be related to the software budget managers are relying on to tackle the task.  Manual […]

continue reading...

F9 is Back at the Popular Table – or is it?

F9 was originally released in the second half of the 1980s – and developed as an add-in for DOS, but was soon converted for Microsoft Windows. This simple Excel add-in financial reporting tool it is experiencing a resurgence of popularity recently, according to talk amongst partners. This boomerang shift is perhaps due to a dissatisfaction […]

continue reading...

OLAP Cube vs. Data Warehouse

Data continues to trend upward as a topic in the world of business as the quantity of data that a company maintains, evaluates, and organizes continues to expand.  Holding onto and utilizing pertinent information is vital for analyzing company strengths and weaknesses, while preparing for successful maturation in the future.  That said, without having IT […]

continue reading...

A Free Tool for Dynamics GP That Microsoft Excel Users Will Love

In my experience, people who use Microsoft Dynamics LOVE Microsoft Excel. (This applies to people considering using Microsoft Dynamics GP too.) Excel tools for Microsoft Dynamics GP are always popular but we just found out about a new one that is FREE. Hard to believe but true. Jet Express, a new self-service reporting solution from […]

continue reading...

Excel Based Reports and ODCs in Dynamics GP

In Dynamics GP version 10, Microsoft released a set of Excel based reports that use connections into the GP databases to pull data directly into Excel spreadsheets. There is a set of reports for each module in the GP system (Purchasing, Sales, Financial, etc.). This allows us to pull live data from the database into […]

continue reading...

Ad hoc Reporting Made Easy with Smartlist, Excel, and Dynamics GP

Not only can end users create and save predefined list based reports, but Smartlist also gives them the ability to export directly to Microsoft Excel or Word.

continue reading...

Dynamics GP v10 Quirk Fixed for Dynamics GP 2010

With the release of GP2010, Microsoft has again raised the bar by improving on a comprehensive ERP solution.  But while the new features are great, Microsoft has addressed the quirks from GP10 that were easily worked around to add to the improved user experience. Recently one of Micro Force's Microsoft Certified Solution Specialists encountered a […]

continue reading...

Three FRx Tips To Help With Your New Year’s Budgets And Reports

For those of you who will be using Microsoft’s FRx Report Writer for your year-end reports and 2010 budgets, here are some helpful shortcuts from one of our FRx experts at the TM Group, a Microsoft Dynamics partner in Michigan:  Tip #1  A common request this time of year is to provide a copy of the trial […]

continue reading...

How to Use Microsoft Dynamics GP SmartList in the Hunt for Unrecorded Liabilities

One of our clients wanted a simple way to generate a report to determine if they had accounted for all necessary accruals for recently closed accounting periods through their accounts payable system.  A popular test in accounting is the search for unrecorded liabilities, normally done by an outside auditor to ensure that all liabilities are accrued […]

continue reading...
 

 
 
Live chat by BoldChat