Month: November 2014

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

Ian Grieve2 minute read0 comment

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: Edit Email on Historical Transactions”

MDGP 2015 Feature of the Day: Void Intercompany Journal Entries

Ian Grieve2 minute read0 comment

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, users will have the ability to void an intercompany journal entry, including entries posted in destination companies, by voiding the original entry in the originating company. This eliminates the need to void an entry in both the originating company, and individually in each destination company as separate steps. When the user voids the entry in the originating company, intercompany entries are also created automatically in destination companies to void the original intercompany entries.

Void Open Payables Transactions Posting Journal

The roles targeted by this feature are:

  • All

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

MDGP 2015 Feature of the Day
General Ledger Batch Approval
Payables Management Batch Approval
Receivables Management Batch Approval
Vendor Approval
Project Employee Expense Report
Organizational Accounts User Authentication
Invoicing in the Web Client
Service Based Architecture
Service Based Architecture Deployment
Service Based Architecture Deployment
.NET Interop
Employee Benefits
Employee Self Service Functionality
Employee Profile, Skills & Training
HRP Workflow Pending Approval Navigation List
Employee W4 and Workflow
Direct Deposit and Workflow
Employee Paystubs
Fixed Assets Year-End Closing Report
Canadian Payroll Web Client
Create Refreshable Excel Reports In SmartList Designer
Payment Terms – Transaction Calculation
Payment Terms – Discount Date Calculation
Copy Home Page and Area Page
Management Reporter Integration
Management Reporter Integration Setup
Management Reporter in Business Analyzer
Business Analyzer Cross Platform
Void Intercompany Journal Entries
Edit Email on Historical Transactions
Intercompany Journal Entry Inquiry
Project Employee Expense Report Entry
Management Reporter Data Integration
Employee Self Service Purchase Requisitions
Existing Purchase Order Warning

MDGP 2015 Feature of the Day: Business Analyzer Cross Platform

Ian Grieve2 minute read2 Comments

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 the MDGP 2015 Feature of the Day Series Index

MDGP 2015 Feature of the Day
General Ledger Batch Approval
Payables Management Batch Approval
Receivables Management Batch Approval
Vendor Approval
Project Employee Expense Report
Organizational Accounts User Authentication
Invoicing in the Web Client
Service Based Architecture
Service Based Architecture Deployment
Service Based Architecture Deployment
.NET Interop
Employee Benefits
Employee Self Service Functionality
Employee Profile, Skills & Training
HRP Workflow Pending Approval Navigation List
Employee W4 and Workflow
Direct Deposit and Workflow
Employee Paystubs
Fixed Assets Year-End Closing Report
Canadian Payroll Web Client
Create Refreshable Excel Reports In SmartList Designer
Payment Terms – Transaction Calculation
Payment Terms – Discount Date Calculation
Copy Home Page and Area Page
Management Reporter Integration
Management Reporter Integration Setup
Management Reporter in Business Analyzer
Business Analyzer Cross Platform
Void Intercompany Journal Entries
Edit Email on Historical Transactions
Intercompany Journal Entry Inquiry
Project Employee Expense Report Entry
Management Reporter Data Integration
Employee Self Service Purchase Requisitions
Existing Purchase Order Warning

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

Ian Grieve1 minute read0 comment

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 “MDGP 2015 Feature of the Day: Management Reporter in Business Analyzer”

Remote Desktop Connection – An Authentication Error Has Occurred

Ian Grieve2 minute read0 comment

Windowsthis is an off topic post which I’m posting mainly as a memory prompt for myself. I was working with a set of virtual machines the other day on my test server and received the following error when I tried logging in:

Remote Desktop Connection - An authentication error has occurred. The Local Security Authority cannot be contacted. Remote computer: azc-gp2013-wc-8Remote Desktop Connection
An authentication error has occurred.
The Local Security Authority cannot be contacted
Remote computer: azc-gp2013-wc-8

I logged onto the Hyper-V server and launched the VM from Hyper-V Manager and was able to log in without issue. I did some fiddling around and realised that my Domain Controller wasn’t accepting connection requests.

One quick reboot later and I was able to log into the VM without error.

Scripts to Reset System and Budget Passwords

Ian Grieve2 minute read0 comment

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

System Requirements For Microsoft Dynamics GP 2015 Now Available

Ian Grieve2 minute read1 Comment

Microsoft Dynamics GPThe System Requirements for Microsoft Dynamics GP 2015 are now available from CustomerSource (login required).

The stand out items for me is that support has been dropped for several older versions of Windows, SQL Server and Office:

  1. Windows:
    • Windows XP all editions
    • Windows Vista all editions
    • Windows Server 2003 all editions
  2. SQL Server:
    • 2008 all editions (including R2)
  3. Office:
    • Office 2007

The only surprise on the above list is that some of the software listed as no longer supported was also listed as no longer supported with Dynamics GP 2013; in fact only SQL Server 2008 is new to the list.

Apart from the above retired software, the recommendations look pretty much the same as Dynamics GP 2013; Windows 8.1 and SQL Server 2014 have been added as supported.

SQL Script To Add A Linked Server

Ian Grieve2 minute read2 Comments

Microsoft SQL ServerAfter doing a little work linking databases together for a report, I ended up creating a script to be used within a stored procedure to quickly and easily re-add the linked server (which is required after a reboot of the SQL Server.

To run the script, change the three highlighted fields (server-name, username and password) and click Execute in SQL Server Management Studio:

DECLARE @Server AS VARCHAR(50)
DECLARE @Username AS VARCHAR(50)
DECLARE @Password AS VARCHAR(50)

SET @Server = 'server-name'
SET @Username = 'username'
SET @Password = 'password'

CREATE TABLE #linkedservers
	(SRV_NAME VARCHAR(50)
	,PROV_NAME VARCHAR(50)
	,SRV_PROD VARCHAR(50)
	,SRV_DATA VARCHAR(50)
	,SRV_STRING VARCHAR(50)
	,SRV_LOC VARCHAR(50)
	,SRV_CAT VARCHAR(50))

INSERT INTO #linkedservers
EXEC sp_linkedservers

IF (SELECT COUNT(*) FROM #linkedservers WHERE SRV_NAME = @Server) < 1
	EXEC sp_addlinkedserver @Server, 'SQL Server'

DROP TABLE #linkedservers

EXEC sp_addlinkedsrvlogin @Server, 'false', NULL, @Username, @Password

MDGP 2015 Feature of the Day: Management Reporter Integration Setup

Ian Grieve2 minute read0 comment

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 fifth Feature of the Day is Management Reporter Integration Setup. This feature created a new navigation list for accessing Management Reporter reports from within the Financial and Administration Navigation buttons.

The Management Reporter navigation list becomes enabled once the location of the Management Reporter service is defined in the Reporting Tools Setup window:

Reporting Tools Setup

The location of the Report Designer Application is an optional field and when defined, will enable users to launch the designer from the Management Reporter navigation list if they have permissions to application.

The navigation list displays a list of reports the current user has security access to and enables them to view the reports in the Management Reporter Viewer with just a click of a button.

The roles targeted by this feature are:

  • All

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

MDGP 2015 Feature of the Day
General Ledger Batch Approval
Payables Management Batch Approval
Receivables Management Batch Approval
Vendor Approval
Project Employee Expense Report
Organizational Accounts User Authentication
Invoicing in the Web Client
Service Based Architecture
Service Based Architecture Deployment
Service Based Architecture Deployment
.NET Interop
Employee Benefits
Employee Self Service Functionality
Employee Profile, Skills & Training
HRP Workflow Pending Approval Navigation List
Employee W4 and Workflow
Direct Deposit and Workflow
Employee Paystubs
Fixed Assets Year-End Closing Report
Canadian Payroll Web Client
Create Refreshable Excel Reports In SmartList Designer
Payment Terms – Transaction Calculation
Payment Terms – Discount Date Calculation
Copy Home Page and Area Page
Management Reporter Integration
Management Reporter Integration Setup
Management Reporter in Business Analyzer
Business Analyzer Cross Platform
Void Intercompany Journal Entries
Edit Email on Historical Transactions
Intercompany Journal Entry Inquiry
Project Employee Expense Report Entry
Management Reporter Data Integration
Employee Self Service Purchase Requisitions
Existing Purchase Order Warning