Tales From a myGPcloud 14 Day Journey – Step 8

Picture Reporting and BI is really what makes a system valuable. Collecting the data is fine but if it’s not accessible or available in the format required the data is mostly useless. Dynamics GP is pretty good with reporting and is getting even better with each version release. In GP 2010 you can even use word templates for invoices etc.

Other sources of reporting besides the standard reports in Report Writer is SQL Server Reporting Services (SSRS) and Crystal Reports (check out Victoria Yudin, the queen of Crystal). If you chose the myGPcloud version that has Smartlist Builder you can also do innumerable queries right to the SQL tables.

If you are not familiar with any of these reporting tools I’d suggest staying with the default reports until a need arises.

**Note – Default reports can be modified using the Report Writer tool to add many fields that are desired but not on the report out of the box. Send any report to the screen then press the modify button and it will go to the Report Writer tool. (Much cussing and swearing has come from this tool. Use it with caution and do a backup before messing with any report in question). MyGPcloud has a nightly backup run on the modified reports file so contact the support line if a restore is needed.


Step 8 – Accessing the over 200+ standard reports

I’ve looked over the documentation on reporting. I didn’t really believe there was over 200+ standard reports but after looking further I suppose this is correct. Each module has quite a few options and each option has several variables.

Running reports is pretty straight forward and the documentation leads through generating reports.

I never like printing reports to the printer first. I usually go to the screen but this can be annoying to click on destination each time and change it from printer to screen. I often do something like this post says.

I never print posting journals either. I turn them off in the posting setup window (Microsoft Dynamics GP>>tools>>setup>>posting>>posting>>uncheck the reports in the process you are doing.)


Some of the most useful reports are listed below:


  • Trial Balance – GL trial balance in summary and detail
  • Cross-Reference – Where to reprint posting journals
  • Checkbook – Checkbook register found here
  • Bank posting journals – Any bank related reprints



  • Trial Balance – AR trial balance. Choose the one with options. I hardly ever use the one without options. Historical report can calculate back to a specific date. Should tie to GL Trial Balance AR amount.
  • History –  Sales transaction history etc. I often use Smartlist over this option
  • Analysis – Sales doc analysis etc. Same as history
  • Posting Journals – Reprint any sales related posting


  • Trial Balance – AP Trial Balance both Historical and open. Should tie to GL Trial Balance AP amount.
  • History – Any purchasing or AP history. I often use Smartlist over this option
  • Analysis – Cash requirements (what AP transactions are due for payment), Received / Not Invoiced report (should tie to Accrued Purchases account at GL),
  • Posting Journals – Reprint AP posting journals



  • Item – Any item setup information
  • Serial/Lots – Anything related to serial and lots (thus the name)
  • Activity – Stock Status Report and Historical Stock Status report, Historical IV Trial Balance (New to 2010 so don’t really know how well it works)
  • Analysis – Turnover report
  • History – Transaction and Distribution history
  • Posting Journal – Reprint any transactions related to Inventory

imageDon’t go cross eyed or get overwhelmed. I suggest going through each module looking for reports you need. If a report is similar to the requirements consider using it as a base then modifying in Report Writer. Before using Report Writer make a backup of the report by going to Microsoft Dynamics GP>>Tools>>Customize>>Customization Maintenance. Select the report then choose export. You’ll be glad you did.


If you try to use Report Writer and get errors…call me and I’ll cuss with you. Then we can figure it out together.

, , , , ,

3 Responses to Tales From a myGPcloud 14 Day Journey – Step 8

  1. Steve Chapman September 1, 2010 at 8:41 am #

    There are a lot of reports, ready to use. I always recommend that people try out all the reports that might pertain to their business, and select the ones that make the most sense to them, and are the closest to what they want. If they want to personalize the report for their own use, often this can be done with a little effort using Report Writer.

  2. Mike Feori September 2, 2010 at 9:12 am #

    My good friend Doug Pitcher’s post about step 6 of his journey is right on. However, coming from my back ground of numerous Microsoft Dynamics GP implementations, I tend to take a more cautious approach with posting setups and new users to GP. There are two check boxes (Post to General Ledger and Post Through General Ledger Files) are VERY important settings. If Post to GL is not checked, then no general ledger posting will be sent to t the general ledger. Your subsidiary module (in this case Payables) will not agree with your general ledger (bad situation). If Post Through GL Files is not checked, then a general ledger batch will be created in the Financial module, but the batch will sit in the Financial module unposted until manually posted by a user. This can also cause the subsidiary module to not agree with the general ledger if the user responsible for posting the Financial batch forgets to do so.

    There is a similar Posting Setup screen for the Financial module with a General Entry for the origin. I recommend that users print the General Posting Journal to the screen. I like this option because there are situations (while quite rare) where posting interruptions or data entry errors in the original module may cause the Financial batch not to post or partially post. I always tell new users to make sure they “see” the General Posting Journal. If they don’t see it presented, it indicates that a problem has occurred and the user MUST investigate the cause for not receiving a GL Posting Journal.

  3. Doug Pitcher September 2, 2010 at 3:23 pm #

    I am a bit cavalier in my comments. I say I don’t print them out. I do however follow Mike’s “Old Dog” approach and tell new clients to print everything out.

    Thanks for keeping me honest.


Leave a Reply