Skip to main content

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

by Linda Rosencrance
Contributing Writer, MSDW
December 01 2014

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 ...

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

About Linda Rosencrance

Linda Rosencrance is a freelance writer/editor in the Boston area. Rosencrance has over 25 years experience as an reporter/investigative reporter, writing for many newspapers in the metropolitan Boston area. Rosencrance has been writing about information technology for the past 16 years.

She has covered a variety of IT subjects, including Microsoft Dynamics, mobile security issues such as data loss prevention, network management, secure mobile app development, privacy, cloud computing, BI, big data, analytics, HR, CRM, ERP, and enterprise IT.

Rosencrance is the author of six true crime books for Kensington Publishing Corp.