Tag Archives: Financials

MDGP 2013 Feature of the Day: Reconcile Bank Reconciliation to General Ledger

Microsoft have started the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The twenty sixth feature they’ve announced is Reconcile Bank Reconciliation to General Ledger.

In Microsoft Dynamics GP 2013, Microsoft have added the Bank Reconciliation module to the Reconcile to GL routine, which was first introduced in Microsoft Dynamics GP 10, to help users analyse differences between the checkbook balances in the Checkbook Balance Inquiry window and the associated General Ledger cash account for the checkbook.

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , , , | 1 Comment

MDGP 2013 Feature of the Day: SSRS Reports On Forms

Microsoft have started the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The sixteenth feature they’ve announced is SSRS Reports On Forms.

This feature allows users to print SQL Server Reporting Services (SSRS) reports directly from a window in Microsoft Dynamics GP. This has been made available on a range of windows across General Ledger, Receivables Management, Sales Order Processing, Payables Management, Inventory Management, Human Resources and Payroll.

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , , , , , , , , , , , | 1 Comment

MDGP 2013 Feature of the Day: Fixed Assets Historical Depreciation Report

Microsoft have started the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The thirteenth feature they’ve announced is Fixed Assets Historical Depreciation Report.

This feature was one of the most requested features for the Fixed Asset Management series for quite a while so it is nice for it to arrive.

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , | 1 Comment

MB3-859 Microsoft Dynamics GP 2010 Financials Certification Acquired

Microsoft Certified Technology SpecialistWell, I’m just back from the Prometric test centre with an updated Microsoft Dynamics GP certification. I gained the Microsoft Dynamics GP 10 Financials certification a few years back and, as it was about to expire, I’ve just been and passed the GP 2010 replacement.

The new one is MB3-859 Microsoft Dynamics GP 2010 Financials.

A bit like the GP 2010 Installation & Configuration certificate I passed the other week, I can’t help but feel the timing is bad with the new version about to expire, it is driven by the certiifcation requirements of Microsoft for partners.

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , , , , , | 1 Comment

MDGP 2013 Feature of the Day: Three New GL Year End Close Options

Microsoft have started the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The sixth feature they’ve announced is Three New GL Year End Close Options.

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , | 1 Comment

MDGP 2013 Feature of the Day: EFT Format Enhancements

Microsoft have started the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The second feature they’ve announced is EFT Format Enhancements.

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , | 1 Comment

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

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

Posted in Dynamics, GP, Microsoft | Tagged , , , , , | Leave a comment

SSRS GL Trial Balance Returning No Data

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

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , , , | 2 Comments

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

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

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , | Leave a comment

How To Recreate SQL Objects Using PSTL

As 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

Posted in Dynamics, GP, Microsoft, Professional Services Tools Library | Tagged , , , , , , , | 3 Comments