Article

From the Dynamics GP Blogs: Excel Tip in Migration from QuickBooks; General Ledger Enhancements; New SharePoint Licensing Guide; How to Solve ‘Illegal Error” After Service Pack

by Jared Berezin
,

Excel Tip: Converting QuickBooks to Dynamics GP: While helping a partner with a conversion, specifically trying to map the QuickBooks chart of accounts to the GP chart of accounts, the folks at Dynamics GP Land had to identify how many "levels" the QuickBooks account had (e.g. Account: Sub-Account: Department...), and determine the maximum number of "levels" in the accounts:

"Since there is a colon between each level, I just needed to count the number of colons in the cell, and then add one... But I am pretty sure I've never had to count the number of occurrences of a value in a single cell.  I've used the SEARCH function to determine whether a value exists at all, but never had to count the occurrences of that value. With Google to the rescue, I stumbled across a Microsoft Support article that provided several examples of how to count the occurrences of a string in an Excel file.

General Ledger Enhancements in GP2010: GP2theMax provides a helpful list of key GL enhancements in GP2010 designed to improve usability and clarity when working in GP. Here are a few of the capabilities: 

  • Exclude Inactive Accounts in Accounts Lookup:You can now exclude all inactive account records from the Accounts lookup window.
  • Clear recurring batch amounts:You can now clear the distribution amounts for all ...

    FREE Membership Required to View Full Content:

    Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
    Learn more about us here

    Get full access
Dynamics GP QuickBooks
About Jared Berezin
Jared Berezin serves as a contributing writer to MSDynamicsWorld.com. With combined interests in technology and science, Jared previously served as a writer for Dana-Farber Cancer Institute, drafting scientific narrative reports on the latest advancements in cancer research. Jared has also served as associate marketing specialist for International Data Corporation (IDC), a market research firm. In this position, he planned and executed strategic marketing initiatives for IDC's software and services research programs, and wrote outbound communications to the press, existing clients, and prospects. Jared also has experience working for several local newspapers in eastern Massachusetts. Jared graduated with honors from Colby College with a BA in English and creative writing.
More about Jared Berezin