September 6, 2011

Taking you to the Fourth Dimension . . .

Here's a little trick I ran across a couple weeks ago. I have a client that needed more dimensions on certain accounts. They'd been using the first two User Defined Fields (UDF) in the account card but needed more, and needed to be able to pull this data into SmartList. Unfortunately, the canned SmartLists expose only the first two UDFs. So, here's how we resolved the issue.

* click image to enlarge

First, you need to use SmartList Builder to use this solution. That's because UDF #3 and #4 for some strange reason are not exposed in the canned SmartLists even though they are stored in the same table as UDF #1 and #2 - GL00100. Go figure.

Next, replicate the appropriate canned SmartList using SmartList Builder and expose UDF #3 and #4 in your new SmartList. (UDF #3 and #4 are identified in GL00100 as USRDEFS1 and USRDEFS2).

Finally, change the UDF labels in the General Ledger Setup window (Financial>>Setup>>General Ledger) and enter the appropriate field values for all UDF's in your account cards.

Now you can run your SmartList and sort and filter on all four UDFs instead of just two.

August 15, 2011

What's New in GP 2010 PO Returns? Replace Returned Goods!!

You can process returns against both Purchase Order Processing receipts and Inventory receipts. Items that have been received on a shipment or shipment/invoice receipt are available to be returned as a Return or a Return w/Credit document type. Items that have been transferred to another site, added to inventory through an inventory adjustment or variance, or returned by a customer are available to be returned in Purchase Order Processing as an Inventory or Inventory w/Credit document type.  New to GP 2010, Replace Returned Goods automatically updates the PO that the items were received on originally to allow the items to be re-received.

 * click image to enlarge

August 4, 2011

Anyone hate the new Knowledgebase search on PartnerSource?

Sometimes improvements just don't work out.  For those of you who, like myself, prefer the old KB search interface over the new one, instead of navigating through Support>>Knowledgebase, navigate through Deployment>>Knowledgebase.  It will take you to the old search window.

Cheers!

July 28, 2011

International Financial Reporting Standards - Are You Ready?

Major accounting changes are coming to the U.S. as generally accepted accounting principles (GAAP) and international financial reporting standards (IFRS) converge in the next several years.  And the impact should concern more than just accountants. A change of this magnitude will impact analysis models, accounting software, and training.  Companies of all sizes, but especially publicly-held companies who will see the changes first, need to understand that using a different accounting method can create different financial results and, potentially, increased tax liabilities.
 
There are two projects going on simultaneously.  The first one is the move to IFRS. The second is a draft of a new statement presentation format.  The change in statement presentation format will probably happen sooner than the change to IFRS, but both of these changes demand attention because they will affect everything we do in analyzing financial statements.
 
And if you are a Microsoft Dynamics GP customer, it will also be important to understand whether your version can support the coming IFRS requirements.

The New Statement Presentation Format
The presentation format of the financial statement will include the following changes:
  • The balance sheet, income statement, and cash flows each will be divided into five sections: business, discontinued operations, financing, income taxes, and equity.
  • A fourth statement will reconcile the statements of comprehensive income and cash flows.
  • The business section of each statement will be further divided into operating and investing assets and liabilities, income, and cash flows.
Where accounts are placed will be based on where management believes they should fall.  The operating section will have anything that's integral to the company's business.  The investing section will include investments considered fundamental to business activities.  So if you're a manufacturer, for instance, the operating section should have your labor costs, your cost of goods sold, your inventories receivable.  If the company believes that its accounts receivables are investments, however, it very well could appear in the investment section.
  • The Balance Sheet will not list total assets and liabilities. Instead, assets and liabilities will be broken out into financing and business assets and liabilities. Business numbers will be further broken out as operating and investing assets and liabilities. Rather than equalizing assets with liabilities plus equity, assets will be netted against liabilities to come up with equity.
  • The Income Statement will disaggregate information far more than the traditional income statement today with considerably more detail on the statement of comprehensive income. Most of the work on this change in format was based on input from equity analysts and rating agencies.
  • In the reconciliation of the statements of comprehensive income and cash flows, cash flow is going to be actual cash. When looking at this, it will give actual cash balance, actually what's happening with cash, what is in accrual, and what is a ‘fair value' change. The new format will challenge financial analysts who are more familiar with GAAP statements. Because of its disaggregation, the new financial statement format requires a lot of searching and adding things up to get what is available by just looking at GAAP statement. Under the new format, current assets and liabilities are in the operating segment, the investing segment, the financing segment, the tax segment, and the discontinued operations segment. But because there will still be interest in current cash requirements, current liabilities, and how current assets pair up with those, there will have to be some arithmetic to figure out a company's total assets and total liabilities.
The Convergence of GAAP and IFRS
Besides the format differences in presenting financial information in IFRS, there will be an underlying difference in philosophy that will give management greater discretion in preparing statements.  IFRS is described as being ‘principles-based'.  So far, neither extensive application guidelines nor comprehensive, industry-specific guidelines exist, and there are not as many rules to follow as exist under GAAP.
 
With the complexity of modern financial instruments, however, there is a concern about judgment. Management will need to include explanations of their judgments and analytics in footnotes, which could increase notes three- or fourfold over GAAP statements.
 
Other changes include the following:
  • Under GAAP, extraordinary items can be shown on the income statement. Under IFRS, that doesn't exist. Those items have to be apportioned to whatever business line they are appropriate in.
  • LIFO accounting for inventory will not be allowed. Only FIFO or weighted-average cost will be used. There's going to be a major impact on companies with large deferred tax liabilities that have been created by LIFO accounting and how they manage the treatment of those liabilities. According to Mary Ann Lawrence, senior VP of Commercial Credit Risk Review at KeyBank, United Technologies has estimated that if it can't use LIFO accounting, it will have a $4 billion tax liability for the first year. The impact is significant.
  • Under GAAP, fixed assets are recorded at historical cost. Under IFRS, fixed assets can be revalued. There's a lot of concern about fair valuation of fixed assets. It creates another noncash element that has to be backed out to determine if the company is actually earning money or increasing income due to the valuation of its fixed assets.
  • Research and development are expensed under GAAP. Under IFRS, research costs are expensed but development costs are capitalized. As an example, companies in the pharmaceutical industry may see large swings in profitability because of the capitalization of their development costs.
  • Under IFRS, goodwill and inventory can be written down and then written back up again. All of these things introduce additional noise under the financial statement, especially when it comes to cash flow analysis.
  • Operating leases are not included in IFRS statements. Instead, you have what is called a 'right of use' of an asset. Renting a building will show up as a 'right to use your office facility.' This will allow companies to capitalize the present value of the future lease payment and show the liability on the other side as the present value of the lease payments.
Using a different accounting method will create different financial results. According to industry experts, when companies on IFRS are compared with those on GAAP, on average, the earnings are 6% to 8% higher under IFRS than under GAAP.
 
Who Will Be Affected - When and Why?
The move to IFRS is a joint project between IASB (International Accounting Standards Board) and FASB (Financial Accounting Standards Board).  The IASB has, for now, excluded nonprofits and private companies.  They are working on a different set of accounting standards for them.  FASB says it hasn't made the decision yet as to whether this change will apply to private companies or only to public companies.
 
One timeline, published by Deloitte LLP, has U.S. public companies partially converting to the new accounting standards by 2013. The U.S. Securities and Exchange Commission has approved IFRS accounting for foreign companies listing on U.S. stock exchanges without having to reconcile to GAAP standards.  EU countries, Canada, India, and Japan are ahead of the U.S. in adopting the IFRS standard.  This has fueled the drive for convergence as the world's investors, businesses, and governments complain that different accounting systems are an economic cost that would prefer not to bear.
 
The primary factor driving the movement toward IFRS is that about 100 countries are on IFRS and only one is on U.S. GAAP - the U.S.  Many of the people at FASB acknowledge that IFRS will most likely be the global accounting standard moving forward.
 
The convergence of GAAP and IFRS is likely to be costly and difficult.  Analysis models, accounting software, and training will need to change to reflect the new standards.  Given the impact this change could have on your organization, especially if you're publicly held, if you're not yet reviewing how the transition to IFRS from GAAP will affect your accounting and reporting system requirements, you need to be soon.
 
The good news is, if you're already running Dynamics GP 2010, you're covered for IFRS reporting.  GP 2010 introduced ‘Reporting Ledgers' that enables recording transactions in compliance with IFRS rules.  If your company has not yet upgraded to GP 2010, the transition to IFRS is one more compelling reason to do so.

July 18, 2011

Your Shore or Mine?

is the title of an article published by an associate of mine, Dave Turbide, in the current edition of APICS Magazine.  It's a very interesting piece that explains why 'on-shoring' of manufacturing back to the U.S. is being considered by more companies than ever.  Here's an excerpt from the article:

Reconsidering the decision to outsource
Several years ago, it was almost fashionable to outsource to low-wage areas of the world to reduce costs. Business leaders developed the mind-set of “off shoring is always cheaper” and they scarcely looked beyond unit cost plus transportation.

Fast-forward to 2008 and 2009, and witness the costly and embarrassing problems surrounding the discovery of lead in children’s toys, contaminated baby formula, and toxic drywall. Also consider recent oil price shocks and the earthquake and tsunami that severely disrupted supplies of many critical electronic and automotive parts in 2011. The US dollar has been on a downward path, making imports increasingly more expensive – and, on top of all this, wages in China are skyrocketing. Is it any wonder that company decision makers are taking another look at the costs of off shoring . . .

Click this link to read the full article.  Enjoy!

July 13, 2011

Sharpen the Axe - Enhance your GP Knowledge

A few weeks back I ran a survey querying users as to what they thought were the primary reasons their organizations were not getting all the 'bang for the buck' out of their Dynamics GP system.  The responses indicated overwhelmingly (67%) that users believe that lack of post-implementation training is what limits their ability to extract more value from GP.  These findings support the anecdotal evidence I've observed over the years and I'm sure every GP consultant out there would concur - management typically does not fully appreciate the value of recurrent training of any sort, let alone that for their ERP system users.

Unfortunately, this places the onus on individual users to enhance their skills on their own.  Fortunately, their are myriad resources available to those users who have the desire and motivation to engage in some self-learning exercises.  To that end, the PowerPoint document below is an update to a presentation I gave at MSDynamicsWorld Decisions 2010 that is chock-full of learning resources for Dynamics GP.   I hope you find it beneficial.

Please pardon the formatting errors.  Not all formatting survives the upload to Google Docs :(

July 5, 2011

Extending Microsoft Dynamics GP Manufacturing: Six Add-Ons for Process and Industry Needs

Microsoft Dynamics GP's Manufacturing module is best known for its discrete manufacturing capabilities and does an admirable job of meeting the requirements of discrete manufacturers in mid-market to enterprise-level organizations.  Although I've seen it used in process manufacturing industries such as food, cosmetics, and life sciences, application in these industries is not in playing to the Manufacturing module's strengths . . .

Read the rest of my latest article at MSDynamicsWorld by clicking on the gears. 




July 3, 2011

Jivtesh Singh our latest Dynamics GP MVP!!

Congratulations Jivtesh.  This is a very well deserved award that you have attained.  I personally have benefited from your contributions to the forums many times.


And, congratulations also to Mariano Gomez for being awarded the MVP designation for the fourth year in a row.  Way to go amigo!!

June 30, 2011

Microsoft Dynamics GP 2010 Cookbook: LITE

I just finished a pass through the Mr. Polino's latest work, mainly because, being the kind of person who likes to get to the bottom line quickly, I'm attracted to literary works that include the word LITE in the title.  Well, this latest version of the Cookbook may be light in weight but it is chock full of all the best tips from the full version of the GP 2010 Cookbook.


From Personalizing GP to Organizing GP to Automating GP, this book, in an hour or less, will make you the envy of your GP peers with the new found skills you'll have acquired.

I highly recommend this book to every GP user, administrator and consultant.  It should be on your desk now.  And you can get it in either print or ebook format from Amazon or Packt Publishing.

June 29, 2011

Resize the left pane in SmartList

The inability to re-size this pane has been a pain to me since the first time I saw SmartList.  Well, here's a solution from Nicole Albertson of Microsoft, compliments of the GPUG Weekly News.  

Click on this link, follow the instructions to Save, Unzip and install the code, set security to the modified SmartList window and bingo, bango, bongo, that annoying pane is cut down to size - Click Here.

And, if you're not a member of GPUG - you should be, so you can get these weekly tips firsthand.

May 28, 2011

May is Packt Publishing's Dynamics Month

If you're looking for a deal on Dynamics books, have a look at Packt's Dynamics Month promotion here- http://www.packtpub.com/article/exclusive-offer-microsoft-dynamics-books.
Packt offers titles from authors such as Mark Polino, MVP, Victoria Yudin, MVP and others so you're sure to find extremely valuable insight into the Dynamics product line with any of their books.

Happy reading!

May 17, 2011

Microsoft Dynamics GP 2010 Reporting

I just finished my first trip through this new book on GP 2010 reporting and all I can say is - incredible.  This work, written by David Duncan and Christopher Liley of IBIS and reviewed by my dear friends Amy Walsh and Christine Belding, also of IBIS, provides an extremely well thought-out, well written, thorough look at the state of the art in reporting in GP 2010.

The book not only covers all the reporting options available in GP 2010 but also provides a framework for developing a cohesive reporting strategy for your organization.

From SmartList to Report Writer, from Excel Report Builder to Management Reporter, Microsoft Dynamics GP 2010 Reporting provides an overview of all of the report types, plus technical instruction on how to use and get the most of each of the report development tools.

Whether you're a GP report developer or a GP user who's curious about the myriad reporting options now provided in the application, this book needs to be in your library.  I highly recommend it.

You can purchase Microsoft Dynamics GP 2010 Reporting from PackT Publishing (http://www.packtpub.com/microsoft-dynamics-gp-2010-reporting/book) or on Amazon.

May 16, 2011

Required Fields

If you're having trouble with Required Fields not showing as Bold, Red, or Italicized, even after making the appropriate settings in User Preferences, check to make sure that "Show Required Fields" on the Help menu is checked.


May 12, 2011

Why do you think your company's utilization of GP is not optimal?

We ran this survey over the last 3 weeks and here are the results:


It's interesting to note that fully two thirds of the responses (67%) indicate lack of training after implementation. This supports my personal observation over a decade of software implementations that most companies don't understand or appreciate the value of recurrent education for their employees.  I truly believe that the difference between a good company and a great one is the investment made in employees.  

So how do we address this issue?  That's going to be the topic of a future blog post so stay tuned . . .