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
PrintFriendlyLinkedin

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.

PrintFriendlyLinkedin

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
PrintFriendlyLinkedin

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
PrintFriendlyLinkedin

MDGP 2015 Feature of the Day: Management Reporter Integration

Ian Grieve2 minute read1 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 fourth Feature of the Day is Management Reporter Integration. This feature created a new navigation list for accessing Management Reporter reports from within the Financial and Administration Navigation Lists.

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

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:

Management Reporter Reports

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
PrintFriendlyLinkedin

MDGP 2015 Feature of the Day: Copy Home Page and Area Page

Ian Grieve1 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 third Feature of the Day is Copy Home Page and Area Page. This feature provides the ability to copy the Home Page Role, Home Page Content, or Area Page Settings from one user to another.

User Setup

Continue reading “MDGP 2015 Feature of the Day: Copy Home Page and Area Page”

PrintFriendlyLinkedin

MDGP 2015 Feature of the Day: Payment Terms – Discount Date Calculation

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 second Feature of the Day is Payment Terms – Discount Date Calculation. With the changes for the transaction due date, we’ve extended the options for the discount date also in Microsoft Dynamics GP2015.

Now you have the same calculation options for discount date that you do for transaction due date. You choose among calculation options like annual, next month or month/date and being able to add days, months, or years to the calculation gives you greater flexibility when setting up your payment terms:

Payment Terms Setup

Continue reading “MDGP 2015 Feature of the Day: Payment Terms – Discount Date Calculation”

PrintFriendlyLinkedin

MDGP 2015 Feature of the Day: Payment Terms – Transaction Calculation

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 first Feature of the Day is Payment Terms – Transaction Calculation. In Microsoft Dynamics GP 2015 you now have greater flexibility to configure payment terms for the transaction due date.

A new selection was added to calculate the transaction due date from the transaction date or from the discount date and additional calculation options like annual or month/date and being able to add days or months to the calculation gives you greater flexibility when setting up your payment terms:

Payment Terms Setup

Continue reading “MDGP 2015 Feature of the Day: Payment Terms – Transaction Calculation”

PrintFriendlyLinkedin

MDGP 2015 Feature of the Day: Create Refreshable Excel Reports In SmartList Designer

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 twentieth Feature of the Day is Create Refreshable Excel Reports in SmartList Designer. This feature will enable users to create refreshable Excel reports using SmartList Designer. Reports created from SQL views may be published to the Excel report library.   

By publishing a refreshable report, the user can open the report in Excel and the data will always be up to date:

I like the look of this feature. The out-of-the-box Excel Reports are of somewhat limited utility as they return all data for the report which means that for a transaction SmartList there can be vast sums of data returned. But with these SmartList Designers you should be able to define a filter in the report so it only includes, for example, the current or previous months transactions.

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
PrintFriendlyLinkedin

MDGP 2015 Feature of the Day: Canadian Payroll Web Client

Ian Grieve2 minute read1 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 nineteenth Feature of the Day is Canadian Payroll Web Client. With Microsoft Dynamics GP 2015 you can now deploy Canadian Payroll functionality for your web client installs.

This allows the full functionality of Canadian Payroll for those customers who wish to have users access Microsoft Dynamics GP through the web browser:

Payroll Employee Setup - Canadian

The roles targeted by this feature are:

  • Payroll Administrator
  • Payroll Clerk

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
PrintFriendlyLinkedin