MDGP 2015 Feature of the Day: Employee Self Service Purchase Requisitions

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The thirty fourth Feature of the Day is Employee Self Service Purchase Requisitions. Dynamics GP 2015 Purchase Requisitions lets a user enter a requisition which ties in with Purchase Order Processing functionality.

As part of the Employee Self Service functionality, navigation is streamlined for the requester to see a requisition status or enter a requisition.

Users are able to quickly see important information right from their Home Page using the Saved, Ready for Purchase, Pending User Action, Rejected Workflow, and Approval tiles:

Home page

Continue reading

MDGP 2015 Feature of the Day: Management Reporter Data Integration

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The thirty third Feature of the Day is Management Reporter Data Integration. In Microsoft Dynamics GP 2015, the user can determine the data that is available to the Microsoft Dynamics Management Reporter DataMart, improving the performance and giving the user control over the data selected.

The user can choose per company (including sample company) if they want the General Ledger data available for reporting.

The user also has the ability to include or exclude Analytical Accounting data for each company:

Company Setup Options

I am slightly puzzled by this feature of the day as you can simply not import a company into Management Reporter if you don;t want to report on it. While I steer clients away from AA where possible, I am not entirely opposed to it, but I do wonder who would want to report on AA without also wanting to be able to report on the GL.

The roles targeted by this feature are:

  • All

Click to show/hide MDGP 2015 Feature of the Day Series Index

MDGP 2015 Feature of the Day: Project Employee Expense Report Entry

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The thirty second Feature of the Day is Project Employee Expense Entry. Project Accounting employees can create expense reports for any projects to which they are assigned. Employees can also be set up to allow delegates to enter expense reports on their behalf.

Workflow approvals and task assignments are defined for expense reports; workflow actions are executed on the documents from the Expense Entry window or from the Navigation lists.

Employee Expenses navigation list

Continue reading

MDGP 2015 Feature of the Day: Intercompany Journal Entry Inquiry

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The thirty first Feature of the Day is Void Intercompany Journal Entries. In Microsoft Dynamics GP 2015, one of the improvements to the intercompany functionality is the ability to view the intercompany distributions of a journal entry from another company.

Having the Intercompany Journal Entry Inquiry window eliminates the need for users to switch between companies to view all originating- and destination-company distributions of an intercompany journal entry. All distributions can be viewed from one company.

The Intercompany Journal Entry Inquiry window is launched from the Journal Entry Inquiry (Financial area page >> Inquiry >> Journal Entry) using the Intercompany button at the bottom of the window:

Journal Entry Inquiry

Continue reading

Professional Services Tools Library – DBMS Error 4920

Microsoft Dynamics GPI ws recently doing some work for a client, one part of which was to configure Microsoft Dynamics GP to duplicate creditors created in one company into another using the PM Master Trigger functionality in the Professional Services Tools Library (PSTL).

When I tried to enable the trigger I received the following error message:

Microsoft Dynamics GP - The stored procedure failed to enable taVendorInsert returned the following results: DBMS: 4920, Microsoft Dynamics GP: 0Microsoft Dynamics GP – The stored procedure failed to enable taVendorInsert returned the following results: DBMS: 4920, Microsoft Dynamics GP: 0

Continue reading

MDGP 2015 Feature of the Day: Edit Email on Historical Transactions

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The thirtieth Feature of the Day is Edit Email on Historical Transactions. In Microsoft Dynamics GP 2015 when you want to send an e-mail for a historical document you can add additional e-mail addresses and choose which e-mail addresses you wish to send to.

On Navigation Lists, you can mark a group of historical documents and e-mail them to a different e-mail address. So, if a customer wants a copy of a number of invoices, you can mark them, and e-mail them to the specific address.

Edit E-mail Detail is available for Receivables statements, Sales Order transactions, Purchase Orders and Payables remittances:

Reprint Statements

Continue reading

MDGP 2015 Feature of the Day: Void Intercompany Journal Entries

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The twenty ninth Feature of the Day is Void Intercompany Journal Entries. In Microsoft Dynamics GP 2015, one of the improvements to the intercompany functionality is the ability to view the intercompany distributions of a journal entry from another company.

Having the Intercompany Journal Entry Inquiry window eliminates the need for users to switch between companies to view all originating- and destination-company distributions of an intercompany journal entry. All distributions can be viewed from one company.

The Intercompany Journal Entry Inquiry window is launched from the Journal Entry Inquiry (Financial area page >> Inquiry >> Journal Entry) using the Intercompany button at the bottom of the window:

Journal Entry Inquiry

Continue reading

MDGP 2015 Feature of the Day: Business Analyzer Cross Platform

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The twenty seventh Feature of the Day is Business Analyzer Cross Platform. This features enables tablet users on Windows, iOS or Android to install and use the Microsoft Dynamics Business Analyzer app.

Microsoft Dynamics Business Analyzer is a cross Dynamics Business Intelligence app that enables AX, GP and SL customers the ability to view and take action on key business information right at their fingertips.

Microsoft Dynamics Business Analyzer was initially released in January 2013 to the Windows Store.  The application has been a huge success within the Dynamics community with over 20,000 downloads since the initial release!  We are excited about the continued success of the app as we expand its availability to more platforms and devices.

Cross Platform

The roles targeted by this feature are:

  • All

Click to show/hide MDGP 2015 Feature of the Day Series Index

MDGP 2015 Feature of the Day: Management Reporter in Business Analyzer

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The twenty sixth Feature of the Day is Management Reporter in Business Analyzer.This features enables users to add Management Reporter content to the Microsoft Dynamics Business Analyzer app:

Companion Application Services Configurator

Continue reading

Scripts to Reset System and Budget Passwords

Microsoft Dynamics GPIf a user forgets the password set against a Budget it cannot be amended through Microsoft Dynamics GP, but can be removed through SQL Server; the same stands true for the System Password as well.

The first script in this post, removes the password of a budget; this SQL is not mine, but was posted by Leslie Vail in this post on the Dynamics Community forum.

To run this script change the highlighted section to the name of the budget which needs the password reset:

UPDATE
	GL00200
SET
	BUDPWRD = 0x00202020202020202020202020202020
WHERE
	BUDGETID = 'budget id'
GO

A very similar script can be used to reset the System Password. If you are using a Named System Database, change the highlighted DYNAMICS text to the name of your System Database:

USE DYNAMICS
GO
UPDATE
	SY02400
SET
	Password = 0X00202020202020202020202020202020
GO