From the Microsoft Dynamics GP Blogs: CBM Cash Receipts; Refreshable Excel reports; 2014 Year End for GL; Data cleansing essentials

A selection of the latest insight from the Dynamics GP blogs:

• CBM Cash Receipt AA Journal Issue & Resolution;
• Create a Refreshable Excel Report Based on a SQL Server Stored Procedure;
• Microsoft Dynamics GP Year-End Release 2014: General Ledger
• Data Cleansing Essentials Series-Chart of Account Analysis "Unused Accounts";

CBM Cash Receipt AA Journal Issue & Resolution

On his Microsoft Dynamics Learn & Discuss blog, Vaidhyanathan Mohan says recently, a user reported an issue trying to open the CBM Cash Receipts window. The error message said: "Please wait the Cash Receipts Posting Journal is still printing."

"For all other users, when they posted any Cash Receipt, an Analytical Accounting Journal report would open with some entries on it; particularly with five cash receipts. The user, who reported the issue, confirmed that the records shown on AA journal report were posted by her and only after posting them, she got the error message. "

You can find out what the problem was - and the solution - here.

Create a Refreshable Excel Report Based on a SQL Server Stored Procedure: Victoria Yudin tells us on her Ramblings and Musings of a Dynamics GP MVP blog explores Excel reporting capabilities for the GP Reports Viewer. She explains that you can set up an Excel report based on a stored procedure to allow users to enter parameters and also to improve the performance of the reports.

"While it's not too terribly difficult to do, ...