MDGP 2013 R2 Feature of the Day: Copy And Paste To General Ledger Transaction Entry

The Inside Microsoft Dynamics GP blog started a series of Microsoft Dynamics GP 2013 R2 Feature of the day posts the other day. As they did with the Microsoft Dynamics GP 2013 Feature of the Day posts they are doing them as short posts containing a PowerPoint slide show. I am translating these from the PowerPoints into posts; you can find my series index here.

The fourth Feature of the Day covered is Copy and Paste to General Ledger Journal Entry. This feature gives users the ability to quickly copy data from an excel file and paste into the Genera Ledger Transaction Entry (Financials >> Transactions >> General) window.

Highlight the data in Excel and copy to the clipboard and then in the GP window click Paste on the ribbon:

Transaction Entry

The data will be validated and a validation error report printed if there are any errors encountered so the end-user can easily make corrections correct.

It is nice to see this feature introduced as a core piece of functionality. Previously we have introduced this functionality to users by implementing the Dynamics Innovations Excel Copy and Paste tool. This tool is still useful as it allows copy and paste into other windows and modules in GP, unlike this new feature which is restricted to only the General Legder.

Click to show/hide the Microsoft Dynamics GP 2013 R2 Feature of the Day Series Index

Click to show/hide the Microsoft Dynamics GP 2013 R2 Feature of the Day Series Index

Microsoft Dynamics GP 2013 R2 Feature of the Day
MDGP 2013 R2 Feature of the Day: SmartList Designer Go To's
MDGP 2013 R2 Feature of the Day: Identity Management - Login
MDGP 2013 R2 Feature of the Day: Purchase Requisitions
MDGP 2013 R2 Feature of the Day: Copy And Paste To General Ledger Transaction Entry
MDGP 2013 R2 Feature of the Day: Workflow
MDGP 2013 R2 Feature of the Day: Workflow Types
MDGP 2013 R2 Feature of the Day: Workflow User Delegation
MDGP 2013 R2 Feature of the Day: Default Fixed Asset ID From The Asset Class
MDGP 2013 R2 Feature of the Day: Identity Management - Scalability Groups
MDGP 2013 R2 Feature of the Day: Workflow Calendar
MDGP 2013 R2 Feature of the Day: Reprint Outstanding Transaction in Bank Reconciliation
MDGP 2013 R2 Feature of the Day: Requisition Management Integration Points
MDGP 2013 R2 Feature of the Day: Default Sort Order for Checks
MDGP 2013 R2 Feature of the Day: Document Attach - Scan
MDGP 2013 R2 Feature of the Day: Workflow History
MDGP 2013 R2 Feature of the Day: Workflow Email Notifications
MDGP 2013 R2 Feature of the Day: Azure Backups
MDGP 2013 R2 Feature of the Day: Suggested Item Enhancements - Analysis and Assignment
MDGP 2013 R2 Feature of the Day: Suggested Item Enhancements - Sales Script and Additional Information
MDGP 2013 R2 Feature of the Day: Dashboards
MDGP 2013 R2 Feature of the Day: Management Reporter Web Viewer
MDGP 2013 R2 Feature of the Day: Take Company Offline
MDGP 2013 R2 Feature of the Day: Encumbrance SQL Reporting Services Reports
MDGP 2013 R2 Feature of the Day: Email Or Print Any Report In Word Format
MDGP 2013 R2 Feature of the Day: Reverse Year End Close
MDGP 2013 R2 Feature of the Day: Document Attachment On Payables Transactions
MDGP 2013 R2 Feature of the Day: Roll Down Segment Changes
MDGP 2013 R2 Feature of the Day: Assign An Item To Multiple Sites
MDGP 2013 R2 Feature of the Day: Replace OLE Note With Document Attachment
MDGP 2013 R2 Feature of the Day: OLE Notes Migration Utility
MDGP 2013 R2 Feature of the Day: Purchase Order Prepayment Additions
MDGP 2013 R2 Feature of the Day: Print Remaining Documents
MDGP 2013 R2 Feature of the Day: Email By Document Type

Microsoft Dynamics GP 2013 R2 Coming Soon

The next version of Microsoft Dynamics GP, 2013 R2, is going to be released soon. I can hardly wait, but, unfortunately, I have to :(

The Dynamics GP Support and Services Blog have posted an article today outlining their intended blog post schedule where they are going to run through the upgrade process and all of the new features which are due in the coming version.

  • April 29 – Lifecycle
  • May 1 – Upgrade Planning
  • May 6 – Known Upgrade Issues
  • May 8 – Version Checks & Upgrades
  • May 13 – Database Upgrade
  • May 15 – Modified Dictionary Upgrade
  • May 20 – Upgrade Troubleshooting
  • May 22 – GP is upgraded – what’s next?
  • May 27 – Upgrading Web Client
  • May 29 – Tables Changes in R2 – Review the SDK
  • June 3 – Identity Management
  • June 4 – Azure Backups
  • June 5 – New Workflow
  • June 10 – Requisition Management
  • June 11 – OLE Document Attach
  • June 12 – Human Resource Time Entry
  • June 17 – Project Accounting Time Entry
  • June 18 – General Ledger
  • June 19 – Payables Management
  • June 24 – Receivables Management
  • June 25 – Bank Reconciliation
  • June 26 – Analytical Accounting
  • July 1 – Fixed Assets
  • July 2 – Sales Order Processing
  • July 3 – Inventory Control
  • July 8 – Purchase Order Processing/Encumbrance Management
  • July 9 – Email or Print any report in Word
  • July 10 – SmartList Designer 2.0
  • July 15 – Office 365
  • July 16 –Take Company Offline
  • July 17 – Ribbons in Desktop

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.

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

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

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

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.

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

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

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