When exec wfDeployCLRAssemblies Just Isn’t Enough

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPI’ve posted a few times about errors in Workflow requiring the wfDeployCLRAssemblies stored procedure to be run again (1 2 3), but the Dynamics GP Support and Services Blog has posted an article about how this is sometimes not sufficient to resolve the problem and the procedures, functions and assemblies deployed by the wfDeployCLRAssemblies stored procedure need to be deleted.

To this end, the blog post contains a series of scripts which need to be run before thew wfDeployCLRAssemblies stored procedure is executed. There are versions of the script for Microsoft Dynamics 2013 R2, 2015 (including 2015 R2) and 2016 (including 2016 R2).

If your problem still isn’t fixed, then a support case would need to be raised.

● Categories: Dynamics, GP, Microsoft, Workflow ● Tags: , , , , , , , , , ,  ● Permalink ● Shortlink ●

Dexterity Development ‘Unhandled script exception’ on data area

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPI’ve been doing some work recently on upgrading some Dexterity code to work with Microsoft Dynamics GP 2016 (both the RTM and R2). After compiling the new dictionary, I started Microsoft Dynamics GP and as the home page was loading got the following error:

MIS_AMS_Ext_160.dic - Unhandled script exception: SCRIPTS - data area. EXCEPTION_CLASS_SCRIPT_MISSING

MIS_AMS_Ext_160.dic

Unhandled script exception:
SCRIPTS - data area

EXCEPTION_CLASS_SCRIPT_MISSING

Continue reading → Dexterity Development ‘Unhandled script exception’ on data area

● Categories: Dexterity, Dynamics, GP, Microsoft ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Web Services Runtime SQL Server Prerequisite

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

I’ve encountered this particular issue around the prerequisites so rarely, that I usually forget to mention it.

When installing the Web Services for Microsoft Dynamics GP there is a step where the SQL Server Connection Information is entered. This is the server where the Dynamics Security data will be stored.

You will receive the following message when clicking Next if the Windows user account you’re logged in as, is not a SQL Server sysadmin:

Invalid SQL Information - The current user must be a member of the sysadmin SQL role.

Invalid SQL Information

The current user must be a member of the sysadmin SQL role.

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Web Services Runtime SQL Server Prerequisite

● Categories: Dynamics, GP, Microsoft, Web Services ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Management Reporter Fact Check

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPFollowing the announcement by Microsoft back in June last year of a partnership with Jet Reports, the future of Management Reporter has been a topic of conversation amongst the community with rumours constantly swirling that Management Reporter would disappear from the Microsoft Dynamics GP space.

On the Inside Microsoft Dynamics GP team blog, Pam Misialek has posted a Management Reporter Fact Check:

  • Management Reporter is available and fully supported by Microsoft. It is still included in the Starter Pack and will continue to be.
  • Management Reporter will ship with GP Next later this calendar year and will ship in future releases as well.
  • Microsoft are looking for any feature enhancements ideas which can be added to the product.
  • HTTP support was added for Microsoft Dynamics GP 2016 R2
  • Management Reporter will not go fully to the cloud in a multi-tenant environment. It can be used in the cloud, with a RDP connection.

Management Reporter is technically a separate product because it works across all Dynamics products. So what? Who cares? It works great at creating financial statements.

● Categories: Dynamics, GP, Management Reporter, Microsoft ● Tags: , , , , ,  ● Permalink ● Shortlink ●

The Microsoft Dynamics GP Directory

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPI’ve just found a page on CustomerSource called the Microsoft Dynamics GP Directory and it looks like it has been in existence for quite a while as it has links to information on Microsoft Dynamics GP 2010 through to 2016 R2.

The links include Top Reasons to Buy Microsoft Dynamics GP, Top Reasons to Upgrade as well as links to the Feature Blog Series, System Requirements, Service Pack, Hotfix and Compliance Update Patch Releases and much more.

I got to the page from the Dynamics GP Support and Services Blog post on the which I got to through David Musgraves post on Microsoft Dynamics GP 2016 R2 New Features .

Just shows it is worth reading around the blogs on Dynamics GP.

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Save Fixed Assets With Suffix

● Ian Grieve ●  ● 4 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components and also look at the new functionality introduced; the index for this series can be found here.

in this post, I am “hands on” with the Save Fixed Assets With Suffix Feature of the Day, which was the fifteenth feature.

When this feature was announced, I said I was puzzled by it as I thought you already could, but when testing found that in GP 2016 R1, you could change the Suffix, but GP wasn’t happy and produced a number of errors.

Mark Polino also thought this was not a new feature, but the return of a , possibly inadvertently, removed feature.

The Asset General Information window (Financial >> Cards >> Fixed Assets >> General) now allows you to overtype the Suffix field (to the right of the Asset ID field:

Asset General Information

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R2 Series Index

Hands On With Microsoft Dynamics GP 2016 R2
Install Dynamics GP Client
Deploy System Database
Desktop Client First Run
Create A Company
Install eConnect
Install Integration Manager
Integration Manager First Run
Add Web Client Runtime
Install Web Client Single-Machine Deployment
Configure Web Components
Install Web Components Help
Manage Web Client SQL Server Login
Test Web Client
Install GP Web Resource Cache
Web Services Runtime SQL Server Prerequisite
Web Services Runtime SQL Server Prerequisite
Web Services Runtime SQL Server Prerequisite
Install Web Services Runtime
Configure Web Services
Verify Web Services
Install Companion Application Service
Install GP PowerShell
Use GP PowerShell To Create a Company
Install GP Add-in for Microsoft Word
Install GP OData Service
Configure & Use OData Service
Create Installation Package
Add Service Based Architecture Feature
Install Service Based Architecture Web Components
Configure Web Components For Service Based Architecture
Add Analysis Cubes Client
Install Analysis Cubes Server
Configure Analysis Cubes
SmartList Designer Favorites In Advanced Lookups
SmartList Favourite Protection
Cancel A Purchase Order Linked To A Purchase Requisition
Batch Edited Message
Purchase Requisition Inquiry Icon
Display Tax Percent for Historical Sales Transactions
GL Distribution Line Display UI change
Link Credit Card Invoices To Original Invoice
Receivables & Payables Distribution Line Display UI Change
Bank Reconciliation Tracks History
Bank Reconciliation Tracks History
POP To FA Link Includes Taxes
Save Fixed Assets With Suffix
● Categories: Dynamics, Fixed Asset Management, GP, Microsoft ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: POP To FA Link Includes Taxes

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components and also look at the new functionality introduced; the index for this series can be found here.

The thirteenth Feature of the Day I am going “hands on” with is POP to FA Link to Include Taxes.

This feature will be popular with some of our clients who deal with non-recoeverable VAT (VAT is a UK sales tax charged at a standard rate of 20%) as non-rec VAT means they would need to depreciate the gross value of the asset including VAT where in previous versions the asset would be created net and need to be amended.

To use this feature, the Include Tax in Acquisition Cost checkbox on the Fixed Assets Company Setup window (Financial >> Setup >> Fixed Assets >> Company) under the Purchasing Options:

Fixed Assets Company 	Setup

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: POP To FA Link Includes Taxes

● Categories: Dynamics, Fixed Asset Management, GP, Microsoft ● Tags: , , , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Bank Reconciliation Tracks History

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components and also look at the new functionality introduced; the index for this series can be found here.

The tenth Feature of the Day I’m going “hands on” with is the Bank Reconciliation Tracks History one which introduced a new window on the Financial Routines menu:

Reconciled Transaction Maintenance

To use this feature, decide if all, a range or one Checkbook should have its reconciliation history moved to history.

Mark the checkbox next to the type of transactions which should be moved and enter a Cut Off date; although the date field is aligned with the Reconciled Deposit Transactions, it apples to all of the transaction types.

Click Process to perform the move of reconciled transactions to history.

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R2 Series Index

Hands On With Microsoft Dynamics GP 2016 R2
Install Dynamics GP Client
Deploy System Database
Desktop Client First Run
Create A Company
Install eConnect
Install Integration Manager
Integration Manager First Run
Add Web Client Runtime
Install Web Client Single-Machine Deployment
Configure Web Components
Install Web Components Help
Manage Web Client SQL Server Login
Test Web Client
Install GP Web Resource Cache
Web Services Runtime SQL Server Prerequisite
Web Services Runtime SQL Server Prerequisite
Web Services Runtime SQL Server Prerequisite
Install Web Services Runtime
Configure Web Services
Verify Web Services
Install Companion Application Service
Install GP PowerShell
Use GP PowerShell To Create a Company
Install GP Add-in for Microsoft Word
Install GP OData Service
Configure & Use OData Service
Create Installation Package
Add Service Based Architecture Feature
Install Service Based Architecture Web Components
Configure Web Components For Service Based Architecture
Add Analysis Cubes Client
Install Analysis Cubes Server
Configure Analysis Cubes
SmartList Designer Favorites In Advanced Lookups
SmartList Favourite Protection
Cancel A Purchase Order Linked To A Purchase Requisition
Batch Edited Message
Purchase Requisition Inquiry Icon
Display Tax Percent for Historical Sales Transactions
GL Distribution Line Display UI change
Link Credit Card Invoices To Original Invoice
Receivables & Payables Distribution Line Display UI Change
Bank Reconciliation Tracks History
Bank Reconciliation Tracks History
POP To FA Link Includes Taxes
Save Fixed Assets With Suffix
● Categories: Dynamics, GP, Microsoft, Uncategorized ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Receivables & Payables Distribution Line Display UI Change

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components and also look at the new functionality introduced; the index for this series can be found here.

The feature I am going “hands on” with is the ninnth Feature of the Day, GL Distribution Line Display UI change.

The status of the scrolling window on the Payables or Distribution Zoom window are remembered:

As with the GL Distribution Line Display UI Change feature, the settings for this feature are stored in the SY01402 table (System User Defaults) in the system database, which is typically called DYNAMICS.

Again is closed and 1 is expanded; the Payables Management setting is where the syDefaultType column is equal to 107 and Receivables Management is 111.

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R2 Series Index

Hands On With Microsoft Dynamics GP 2016 R2
Install Dynamics GP Client
Deploy System Database
Desktop Client First Run
Create A Company
Install eConnect
Install Integration Manager
Integration Manager First Run
Add Web Client Runtime
Install Web Client Single-Machine Deployment
Configure Web Components
Install Web Components Help
Manage Web Client SQL Server Login
Test Web Client
Install GP Web Resource Cache
Web Services Runtime SQL Server Prerequisite
Web Services Runtime SQL Server Prerequisite
Web Services Runtime SQL Server Prerequisite
Install Web Services Runtime
Configure Web Services
Verify Web Services
Install Companion Application Service
Install GP PowerShell
Use GP PowerShell To Create a Company
Install GP Add-in for Microsoft Word
Install GP OData Service
Configure & Use OData Service
Create Installation Package
Add Service Based Architecture Feature
Install Service Based Architecture Web Components
Configure Web Components For Service Based Architecture
Add Analysis Cubes Client
Install Analysis Cubes Server
Configure Analysis Cubes
SmartList Designer Favorites In Advanced Lookups
SmartList Favourite Protection
Cancel A Purchase Order Linked To A Purchase Requisition
Batch Edited Message
Purchase Requisition Inquiry Icon
Display Tax Percent for Historical Sales Transactions
GL Distribution Line Display UI change
Link Credit Card Invoices To Original Invoice
Receivables & Payables Distribution Line Display UI Change
Bank Reconciliation Tracks History
Bank Reconciliation Tracks History
POP To FA Link Includes Taxes
Save Fixed Assets With Suffix
● Categories: Dynamics, GP, Microsoft, Uncategorized ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Link Credit Card Invoices To Original Invoice

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components and also look at the new functionality introduced; the index for this series can be found here.

The eighth Feature of the Day, which I am “hands on” with in this post, was Link Credit Card Invoices To Original Invoice.

To test this feature, I entered, posted and paid an invoice for Attractive Telephone Co. for $1,000:

Payables Transaction Inquiry - Vendor

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Link Credit Card Invoices To Original Invoice

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●