Author: Ian Grieve

Ian is a Microsoft Dynamics GP certified consultant specialising in the delivery of Microsoft Dynamics GP projects and currently the Lead ERP Consultant for ISC Software Ltd., a Microsoft Partner, VAR and ISV in England. Ian has worked with Microsoft Dynamics GP since 2003 and, over the nine years since, has dealt with all aspects of the product life-cycle from presales, to implementation, to technical and functional training, to post go-live support and subsequent upgrades and process reviews. In his spare time, Ian runs the azurecurve | Ramblings of a Dynamics GP Consultant blog dedicated to Microsoft Dynamics GP and related products.

SSRS GL Trial Balance Returning No Data

Ian Grieve2 minute read2 Comments

Microsoft Dynamics GPI was doing some testing to compare the SSRS Trial Balance against the standard report version but ran into a problem straight away when I found the SSRS version returned no data.

A quick search online found me this post SSRS: GL Trial Balance Summary report returns no data – Follow Up by Mariano Gomez where he discussed the exact problem I had encountered.

As Mariano says this has been fixed in the upcoming SP3 but for now there is a Knowledge Base article covering a workaround which is to alter the stored procedure (seeglPrintSRSTrialBalance) which is used for returning the data: GL Trial Balance SRS Reports return no data using Microsoft Dynamics GP.

Mark Polino’s Weekly MS Connect Suggestion – Copy and Paste from Excel to the GL Transaction Entry Window

Ian Grieve1 minute read0 comment

Microsoft Dynamics GPContinuing Mark Polino’s weekly DynamicAccounting.net series of posts recommending an MS Connect suggestion.

This weeks is a vote on allowing a Journal to be composed in Microsoft Office Excel and then copied and pasted into the General Ledger Transaction Entry window. This functionality would be useful for those people who don’t have Integration Manager – Financials.

If you’d be interested in seeing this change made, please go to Connect and vote.

Error Starting Microsoft Dynamics GP After Installing PSTL

Ian Grieve2 minute read1 Comment

Microsoft Dynamics GPI’m taking a slight detour away from posting the series of how to’s on the Professional Services Tools Library to highlight an installation error that I’ve recently seen when installing PSTL.

A client recently installed PSTL and reported receiving the below error message;

Microsoft Dynamics GP - A Get/Change Operation on Table 'gpAppEnabled' cannot find the table

I’d sent them the PSTL download along with the instructions on how to install it without realising that there was a missing part to me instructions (which has now been added).

When installing PSTL into a company for the first time, you must log into Microsoft Dynamics GP as the sa user as there are some tables which get created (covered in KB Article 861564 which is actually a retired article but does mention the issue and the resolution).

Mark Polino’s Weekly MS Connect Suggestion – Improve Intercompany

Ian Grieve2 minute read0 comment

Microsoft Dynamics GPContinuing Mark Polino’s weekly DynamicAccounting.net series of posts recommending an MS Connect suggestion.

This weeks is a vote on improving intercompany transactions. While, as Mark points out, the suggestion is a little on the vague side, voting to imProve intercompany will focus Microsoft’s gaze upon the subject of intercompany support.

If you’d be interested in seeing this change made, please go to Connect and vote.

As an aside, I’m at square one house wise now but had my time taken up With a side project (details to be announced soon) but I now aim to get back posting with some regularity.

Mark Polino’s Weekly MS Connect Recommendation — Debits Before Credits!

Ian Grieve1 minute read0 comment

Microsoft Dynamics GPMark Polino on DynamicAccounting.net recently started a series of weekly posts recommending an MS Connect suggestion.

This weeks is a vote on reordering the debit and credit columns in SmartLists so they match the ordering in the rest of the system.

If you’d be interested in seeing this change made, please go to Connect and vote.

Mark also follows up with a Microsoft Dynamics Community column discussing how ISVs can benefit from following the voting patterns on MS Connect.

How To Rebuild GL00105 Using PSTL

Ian Grieve1 minute read3 Comments

Microsoft Dynamics GPA while ago I posted a script that could be used to fix a corrupt Account Index Master (GL00105). However, the Toolkit within the Professional Services Tools Library (PSTL) can be used to do the same thing without resorting to a custom script.

Continue reading “How To Rebuild GL00105 Using PSTL”

Management Reporter 2012 for Microsoft Dynamics ERP Rollup 1 Released

Ian Grieve1 minute read4 Comments

Microsoft Dynamics GPI’m slightly late in posting this one but I figure it might still be a useful post to make.

On 30th April 2012 Microsoft released Rollup 1 for Management Reporter 2012 for Microsoft Dynamics ERP which includes an updated Migration Wizard [PDF] which was missing from Management Reporter 2012 until now.

Rollup 1 can be downloaded here (PartnerSource or CustomerSource login required).

Apology for Lack of Updates

Ian Grieve2 minute read0 comment

azurecurveJust a quick update to apologise for the lack of updates.

I’m currently stressing out about a house purchase I’m trying to get through as soon as possible (with concerns I may actually lose the house if it doesn’t exchange soon). For the regular readers out there (I assume there are some) I moved back to the NE in September last year to start a new job as consultant with Perfect Image, specialising in Microsoft Dynamics GP and sidelining in Dynamics CRM, and this is the final step for me to complete the move.

Once the purchase completes and I can stop stressing I’ll get back to posting; I have a backlog of posts not just related to the recently started series of posts on PSTL but also other areas of the system and related products.

Of course, once it does complete I’ll be project managing a renovation which will probably also cause me to stress out but I doubt as much as the purchase is (Bloody Hell I hope not anyway).

Hopefully back soon with some useful posts.