Tag Archives: Financials

MB3-701 Microsoft Dynamics GP 2013 Financials Certification Acquired

Microsoft Certified Technology SpecialistAfter updating one of my Microsoft Certifications earlier this month , I have today taken and passed the MB3-701 Microsoft Dynamics GP 2013 Financials exam.

This gives me both of the current Microsoft Dynamics GP 2013 certifications which are available. I am looking out for an update to the Inventory & Order Processing certification in the hopes Microsoft produce one.

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

Review of Microsoft Dynamics GP 2013 Implementation by Victoria Yudin

Victoria Yudin, the longest serving Microsoft(R) Most Valuable Professional for Microsoft Dynamics GP, has just released Microsoft Dynamics GP 2013 Implementation via Packt Publishing.

This is an update of the Microsoft Dynamics GP 2010 book she wrote a few years ago, which has been updated for Microsoft Dynamics GP 2013:

Microsoft Dynamics GP 2013 Implementation by Victoria Yudin

In brief this book covers:

  • Plan, install, and implement Microsoft Dynamics GP 2013 with real-world advice from a Microsoft Dynamics GP MVP
  • Learn how to set up the core modules in Microsoft Dynamics GP effectively following detailed, step-by-step instructions
  • Discover additional tools and resources available for your Dynamics GP

Continue reading

Posted in Dynamics, GP, Integration Manager, Microsoft, Packt Publishing, Review, SQL Server | Tagged , , , , , , , , , , , , | 1 Comment

MDGP 2013 Feature of the Day: Encumber General Journal Transactions

Microsoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The eighty fourth feature they’ve announced is Encumber General Journal Transactions.

In Microsoft Dynamics GP 2013 you can integrate Encumbrance Management with General Ledger. When you enter a General Journal Entry, the system will look at previously posted amounts, previously encumbered amounts, and the amount of the transaction to determine if there is budget available for the transaction.

Transaction Entry

Continue reading

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

How To Realign Trial Balance Summary Modified Report Columns

I was recently asked to assist the Support team to look into an issue with the Trail Balance Summary modified report. The problem was that when sent to screen or printer the report was fine, but when exported to Tab Delimited file, the columns didn;t match up with the totals at the bottom.

Trial Balance Summary on Screen shows as aligned;

Trial Balance Summary - Screen Output

Continue reading

Posted in Dynamics, GP, Microsoft, Report Writer | Tagged , , , , , , , , , , | 3 Comments

Management Reporter 2012 RU3 Now Available (With Included Web Client)

On the 12th November, RU3 for Management Reporter 2012 was released.

Full information available here and it can be downloaded here.

Management Reporter 2012 RU3 brings a web client (reports can be deployed to a network share or to SharePoint depending on preference), the Financial Reporting Data Mart for Dynamics GP (good for dealing with large datasets), the ability to report against Dynamics GP General Ledger and Analytical Accounting information using a single company as well as more than 35 bugs.

I’ll be doing some more posts on MR 2012 RU3 over the coming couple of weeks so stay tuned.

Posted in Analytical Accounting, Dynamics, GP, Management Reporter, Microsoft | Tagged , , , , , , , , , , , , | 4 Comments

MDGP 2013 Feature of the Day: Consolidate Revenue Recognition to Single GL Entry

Microsoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The fifty seventh feature they’ve announced is Consolidate Revenue Recognition to Single GL Entry.

The contract revenue recognition process creates a General Ledger batch named LIABI which contains the account information from all marked contracts to be posted. Prior to this change, a journal entry was created for each unique contract number. Now, this batch will contain one journal entry consolidating the account information by fiscal period and year, and you will still be able to see the account detail for each contract line within the single transaction.

Continue reading

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

MDGP 2013 Feature of the Day: BAI Format Added To Electronic Reconcile

Microsoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The forty ninth feature they’ve announced is BAI Format Added To Electronic Reconcile.

The BAI file format, developed by the Bank Administration Institute (BAI), is a common format used to perform electronic cash management balance reporting. Many banks use the format for electronic account balance reporting. However, the Electronic Reconcile module in Microsoft Dynamics GP was not compatible with the format.

This feature makes the necessary updates to the Electronic Reconcile module needed to be compatible with the BAI format. Fields and record types required by the format have been added to the configurator, and related forms and processes to enable reading files in the BAI format.

Electronic Reconcile Format Configurator

This new feature is targeted at the following roles:

    • CFO
    • Accounting Manager
    • Controller
    • Accountant
Posted in Dynamics, GP, Microsoft | Tagged , , , , , , | 2 Comments

MDGP 2013 Feature of the Day: Fixed Assets Batches

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

The thirty third feature they’ve announced is Fixed Assets Batches.

This feature provides a significant change to the process of posting Fixed Assets transactions to the General Ledger. Up to Microsoft Dynamics GP 2010 there was no way to review the batch of postings from Fixed Assets to the General Ledger; with this new GP 2013 feature, users are now able to build and review Fixed Assets batches prior to posting to the GL which provides for much greater control, accuracy and flexibility;

Fixed Assets General Ledger Posting

Continue reading

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

MDGP 2013 Feature of the Day: Mass Depreciation Reversal

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

The thirtieth feature they’ve announced is Mass Depreciation Reversal.

At present depreciation can only be reversed one asset at a time. This new Microsoft Dynamics GP 2013 feature provides users with the ability to back out depreciation for all, or a group, of assets which saves the time consuming process of doing it one asset at a time.

Continue reading

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

MDGP 2013 Feature of the Day: Intercompany Asset Transfer

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

The twenty eighth feature they’ve announced is Intercompany Asset Transfer.

Fixed Asset Management has been enhanced in Microsoft Dynamics GP 2013 to allow assets to be transferred between companies.

The new functionality automates the process of retiring an asset in the originating company, and setting it up for depreciation in the new company. The process can be done for either a single asset or a group of assets, saving the user time on performing these processes manually.

Continue reading

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