2Q 2010 Newsletter

April/May/June 2010

Tips & Tricks

Correct Journal Entries

·        Reverse and Replace a Journal Entry using functionality found in Transactions>Financial>General>Correct.

·        Need help? - give us a call

Drilldown with Account Rollups

·        Account Rollups let you consolidate information from various accounts and then be able to drill down into the account details.

·        Useful for things like departmental totals with drilldowns.

·        Accounts do not have to be consecutive.

·        Rollups can include Actual, Budget and Calculated information.

·        Need help? - give us a call

Use Quick and Dirty Deferrals with Recurring Batches

·        For a large number of deferrals, Revenue/Expense Deferrals or Contracts are a better solution.

·        For a small number of deferrals, post the transaction to a deferral account and use Recurring GL Batches to recognize the deferred amount.

·        One batch per transaction.

·        Put an underscore (_) or a “z” at the beginning of the batch to move all deferred batches to the top or bottom of the batch list respectively.

Duplicate a Journal Entry

·        Use the Copy Journal Entry info in tip 1 to create a copy of a Journal entry.

·        This is great for duplicating an entry

·        Need help? - give us a call

Check Posting Types before Year End

·        It’s important to validate that Posting Type (Balance Sheet or Profit & Loss) is correct at year end.

·        A simple SmartList can show items in the wrong Posting Type.

·        Use the search feature to limit account numbers to Balance Sheet numbers and set Posting Type to Profit and Loss. This will show misclassified Balance Sheet Accounts.

·        Reverse to show misclassified P&L accounts.

·        Need help? - give us a call

Get Consistent Account Descriptions

·        Don’t setup accounts first, setup Segments in Tools->Setup->Financial->Segment.

·        Creating accounts will then auto populate the description based on the Segment descriptions.

·        This gives consistent chart descriptions and a warning when a segment doesn’t exist.

·        Need help? - give us a call

Speed up the Population of the JE numbers on the Correct Journal Entry Screen

·        Looking up Journal Entry corrections is slow because of the number of transactions.

·        GP provides an index for that table that can speed lookups.

·        KB 925326 contains a small SQL Script to apply a non-clustered index to the GL20000 and GL30000 tables and this solves the problem.

·        Need help? - give us a call

Microsoft Dynamics GP 2010 Debuts 

REDMOND, Wash. — April 20, 2010 — Microsoft Corp. today introduced Microsoft Dynamics GP 2010, an easy-to-use enterprise resource planning (ERP) solution for midsize businesses that want advanced functionality, strong business intelligence reporting options and interoperability with other line-of-business applications. The solution features new Role Centers, out-of-the-box Web services and the ability to complete tasks through other software people use every day. (Read more about GP2010 by scrolling down.)

SSG Adds to Dynamics CRM Team

Software Solutions Group announces the addition of John Cogovan as Senior Software Engineer.  He has over 19 years of experience in application development and has completed his Microsoft CRM certifications.

Latest News on FRx and Management Reporter

Microsoft is in the process of replacing FRx with Management Reporter.  Management Reporter will be a new financial report writer based on the functional concepts of FRx, but with improved features and capabilities.  This includes more powerful analytic capabilities, multiple distribution options, the ability to put logos/images on documents and so much more. It will be on a 64 bit version of SQL server on a .net platform written in C#. 

There will be a migration wizard download available in May that will help in the conversion of documents from FRx to Management Reporter.  Existing customers who have and are using FRx will have the option to continue on with it when they upgrade to GP2010, but will also have access to Management Reporter and are encouraged to consider using it as FRx will not supported in future versions of Dynamics GP.

More Microsoft Certifications for SSG Team

Software Solutions Group is pleased to announce that Coleen McNally has earned certification in Microsoft FRx Reporting Design and Rita Capozzi has earned certification in Microsoft Dynamics GP 10.0 Inventory & Order Processing.

Microsoft Dynamics GP 2010 Debuts (continued from top)

Enhancing Insight

Microsoft Dynamics GP 2010 includes personalized Role Centers, more than 400 built-in Microsoft SQL Server Reporting Services and Microsoft Excel reports, and enhanced interoperability with Microsoft SharePoint and new tools such as PowerPivot for Excel 2010.

“The new Role Centers and the ability to tap into SQL Server Analysis Services as well as SQL Server Reporting Services are significant. This allows for full drill-down capability — a level of insight that should be new and welcome for former QuickBooks users,” said Todd M. Bowlsby, senior Dynamics consultant, InterDyn – Remington Consulting, a consulting company specializing in Microsoft Dynamics service offerings.

Making It Easier

Microsoft Dynamics GP 2010 includes intuitive workflow processes making approval scenarios easier. For instance, customers can create professional-looking forms such as invoices from within Microsoft Word and quickly send them through e-mail. New features also simplify business operations, daily tasks, setup and IT administration processes, making it easier for people to perform their job tasks efficiently and effectively. Microsoft SharePoint technology extends access to business-critical information from Microsoft Dynamics GP 2010 to more people across an organization.

“By combining the power of business applications and productivity applications, we’re able to support how people really work in their everyday jobs,” said Crispin Read, general manager of Microsoft Dynamics ERP. “Microsoft Dynamics GP 2010 is an excellent choice for companies experiencing growing pains with their current accounting software and looking for a solution that can scale.”

Preparing for Availability

Registration keys for GP2010 are expected to be released by the end of May.  Customers can request an upgrade quote by contacting Amy Coddington at amy@softsolgrp.com or call (716) 568 – 2040 x117.  Please note – You will need to be on Office 2007 or 2010 to upgrade to GP2010.

Please contact Amy Coddington at amy@softsolgrp.com if you would like to be taken off this mailing list or if you know of someone who may benefit from being added to our list.