Tag Archives: General Ledger

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: Copy AA Trx Dimensions For POP, SOP And GL

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

The sixty second feature they’ve announced is Copy AA Trx Dimensions for POP, SOP And GL.

In Microsoft Dynamics GP 2013 when you copy a Sales Transaction (SOP) or Purchase Order (POP), you can now include the Analytical Accounting Transaction Dimension information;

Copy a Sales Order

Continue reading

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

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: Journal Entry History Inquiry

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

The forty first feature they’ve announced is Journal Entry History Inquiry.

In versions prior to Microsoft Dynamics GP 2013, the only Journal Entry Inquiry was on open year journals. Microsoft Dynamics GP 2013 introduces the ability to perform an inquiry on historical years.

This feature modifies the Journal Entry Inquiry window to display information for both open and historical year journal entries;

Journal Entry History Inquiry

In the past I’ve directed users to the SmartList for doing a lookup on historical year journals, but this amended inquiry provides a quick, and much simpler, way for users to do this lookup.

This new feature is targeted at the following roles:

  • CFO
  • Accounting Manager
  • Controller
  • Accountant
Posted in Dynamics, GP, Microsoft | Tagged , , , , , , | 1 Comment

MDGP 2013 Feature of the Day: Saved GL Batch Approval

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

The thirty seventh feature they’ve announced is Saved GL Batch Approval.

The Year-To_Date Transaction Open (GL20000) and Account Transaction History (GL30000) tables have been updated with new columns to store the approval user (APRVLUSERID) and date (APPRVLDT) in order to enhance tracking; this information will be passed from Posting Definitions Master (SY00500) when the batch is posted.

These two new columns can be used on reports;

SQL Server Management Studio

This new feature is targeted at the following roles:

  • Accounting Manager
  • Accountant
  • Controller & CFO
Posted in Dynamics, GP, Microsoft | Tagged , , , , , , | Leave a comment

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: 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