Preparing your reports for 2013 - Dynamics Corporate Performance Management - Site Home - MSDN Blogs

April Olson looks at Preparing your reports for 2013 at Dynamics Corporate Performance Management

Get the Microsoft Dynamics GP 2013 Table and Field Reference Now!

Get the Microsoft Dynamics GP 2013 Table and Field Reference Now! My complete, Excel-based table and field reference is now available for Microsoft Dynamics GP 2013. This is a free resource. Follow this link and download it now.

This resource is based on the final, released version, NOT a preview release. It will be couple of days before this is up in the Downloads section so follow the link to get.

 

 

 

 

 

How To Realign Trial Balance Summary Modified Report Columns | azurecurve

Ian Grieve looks at How To Realign Trial Balance Summary Modified Report Columns

Additional Field Information (How to find what goes into a column that contains static values) - Accidental Administrator - GP Non-Technical Blogs - Microsoft Dynamics Community

John Lowther explains Additional Field Information (How to find what goes into a column that contains static values)

Reporting Resources for Dynamics GP | Dynamics GP Insights

Christina Phillips lays out Reporting Resources for Dynamics GP

Choose Wisely: Which Microsoft Dynamics GP Reporting Tool is Right for the Job? | MSDynamicsWorld.com

My new article, Choose Wisely: Which Microsoft Dynamics GP Reporting Tool is Right for the Job? is up now at MSDynamicsWorld.com

GP2themax - Helping users get the 'max' from Dynamics GP: How do we add new reports to My Reports?

Frank Hamelly explains How do we add new reports to My Reports?

Clearing the Reporting Clutter - GPUG Magazine

The Fall 2012 edition of GPUG magazine is out. I've got an article on Clearing the Reporting Clutter in there starting on page 14. Make sure you check out this edition's other great articles too.

Customizing My Reports Lists in GP 2010 | onza blog

Amanda Wong looks at Customizing My Reports Lists in GP 2010

Feature of the Day: Alternate Modified Forms and Reports Window - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

An improved Alternate Modified Forms and Reports Window is the latest GP2013 Feature of the Day.

Going Beyond Management Reporter with deFacto Corporate Performance Management | Dynamics Care Services

My look at Going Beyond Management Reporter with deFacto Corporate Performance Management is up now at DynamicsCare. This is the second part in a 2 part series.

Using Reporting Groups in GP 2010 | onza blog

Amanda Wong shows covers Using Reporting Groups in GP 2010 | onza blog

Imagine There is No Excel

A recent CFO.com headline asked us to Imagine there is No Excel. The article goes on to discuss how companies are dealing with analytics and the rise of big data.The beauty of Excel is not just it’s power and ease of use but it’s ubiquity. You can’t throw a rock in a Finance or Accounting department without hitting an Excel spreadsheet so it’s not going to go quietly into the night.
The CFO.com article touches on analysis products for big companies (Hyperion, Cognos) and for startups (QuickBooks users) but curiously leave out mid-sized companies.
I’ve been spending time lately with deFacto Performance Management and frankly, it does a great job of tackling many of the items discussed in the article for mid-sized firms.
deFacto is integrated corporate reporting, budgeting, forecasting and planning including consolidations and eliminations. The interface isn’t “Excel-Like” the interface IS Excel tied to SQL analytics for nice mix of power and simplicity. deFacto compares very nicely to the Hyperions and Cognoses of the world without the budget blowing price tag and ridiculously long project times. Plus it integrates well with Dynamics GP and Dynamics AX.
We like it so much that we’re using it in house at I.B.I.S. I expect that you’ll hear more from me about this subject soon but if you’re looking for serious Corporate Performance Management for GP or AX you need to look at deFacto.

Changing Open-Year In Financial Statement Reports | azurecurve

Ian Grieve looks at Changing Open-Year In Financial Statement Reports

Working with My Reports in Dynamics GP 2010 | Dynamics GP Insights

Christina Phillips explores Working with My Reports in Dynamics GP 2010 over at Dynamics GP Insights

Yes Virginia, you CAN post to a closed fiscal period! » Summit Group Software Blog

Gina Hoener has a though provoking post at The Summit Group’s blog. Her post, Yes Virginia, you CAN post to a closed fiscal period!, complains that when posting manual payments, a client posted a transaction with the subledger transaction date in a closed period but since the GL period was open the transaction posted.

I replicated Gina’s event and what’s happening is that the posting date is properly coming from the batch based on system settings. The batch posting date was for a future period that was open for both the subledger and GL so this transaction properly posted. The key is that the posting date in the subledger and in the GL are both in the open period.

Even if when posting outside of a batch, the transaction date is not necessarily the posting date. For transactional posting, the posting date comes from the posting date behind the expansion button on the transaction date. They may default to the same date but they don’t have to be the same.

For proper balancing you have compare posting date in the subledger to posting date in the GL NOT transaction date.

We understand this intuitively in Payables. An invoice that is six month old suddenly shows up in the mail. We date the invoice six months ago for proper aging but it posts to the current period.

Francisco…Where is my stuff?

Francisco helps you find your stuff in Dynamics GP. Hey Francisco…Where is my stuff?

Quick Comparison Report Testing Tip - Blog - Kuntz Consulting

Kuntz Consulting gives us a Quick Comparison Report Testing Tip especially with upgrades.

Screen Output Magnification Defaults | Interesting Findings & Knowledge Sharing

Sivakumar reminds us how to set the Screen Output Magnification Defaults.

Dynamics GP Land: Reporting Puzzle (2 of 2)- Report Options and Report Groups

In reporting puzzle 2, Christina Phillips finds inconsistencies in Report Options and Report Groups.

This is  just obscure enough to make me sit up and take notice. We found some unrelated obscure things recently. Maybe it’s something in the air.