Mark Polino’s Weekly MS Connect Suggestion – Auto Deposit of Cash Receipts in Bank

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 adding an option to allow bank deposits to be automatically posted in Bank Reconciliation; this would be of great benefit if you’re receiving lots of individual payments hitting your bank account such as standing orders or BACS transfers which at present requires someone to post each one manually.

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

PrintFriendlyLinkedin

Microsoft Surface Announced

Ian Grieve1 minute read0 comment

MicrosoftAs recently rumoured, Microsoft announced a self-built tablet yesterday adding to their current hardware line which includes mice, keyboards and the XBox 360.

Branded the Microsoft Surface it is available as both Windows RT, arm powered 32 or 64GB memory, or as the Windows 8 Pro, powered by an Intel i5 and with either 64 or 128GB of memory with both versions coming with built in Micro SD slot for more, exchangeable memory;

Microsoft Surface

Continue reading “Microsoft Surface Announced”

PrintFriendlyLinkedin

Unknown Error Creating Demo Company

Ian Grieve1 minute read0 comment

Microsoft Dynamics GPThis is another mea culpa post; I’ve been doing enough of them I’m thinking of giving them their own tag.

I was created a virtual machine with the Fabrikam, Inc. demo company in it. When GP Utilities was processing I got this error pop up;

Microsoft Dynamics GP Utilities - An unknown error occurred when initialising tyhe conversion.

Continue reading “Unknown Error Creating Demo Company”

PrintFriendlyLinkedin

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.

PrintFriendlyLinkedin

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.

PrintFriendlyLinkedin

How To Recreate SQL Objects Using PSTL

Ian Grieve1 minute read3 Comments

Microsoft Dynamics GPAs well as rebuilding a corrupt GL00105, the Toolkit within the Professional Services Tools Library (PSTL) can be used to recreate SQL objects such as SQL Indexes or the Dex stored procedures.

Continue reading “How To Recreate SQL Objects Using PSTL”

PrintFriendlyLinkedin

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

PrintFriendlyLinkedin