Management Reporter Crash when Importing Reports

You click Building Block Groups and go to import some reports, when you navigate to the file and click import everything freezes.

This is an issue caused by a microsoft update. It was resolved in versions of Management Reporter 2012 CU13 and higher. If you are unable to use a version higher then all you have to do is not place your mouse icon into the area where the reports are on the import window.

Hence, just click import, navigate to the location and click select all and then proceed with the import, do not put your cursor in the top window or anything as this is what causes the application to crash. Seems to be some pop up message issue cause by a microsoft windows update.

Smartconnect Map runs in one company but does not run in another company

So you created a map, run it to test on your test company and it works.

Then you run it on the live company and boom, nothing happens. Smartconnect just counts your records and does not import any.

In your mapping you have a GP Rolling column created. You need to delete it and re-create it with your mapping on the live company (this is defined in the companies window in the front). This will make the rolling column look at the correct company.
Re-run integration and it will work now.

Dynamics SL Backups Required

 Here’s what should be backed up daily:

1. The Dynamics SL application database
2. The Dynamics SL system database
3. The FRx 6.7 folder in the Dynamics SL installation area (if you are still using FRx)
4. The Usr_Rpts folder in the Dynamics SL installation area

Backing up Custom Dynamics SL Reports

If there are any customized reports in the system they will be located in the Usr_Rpts folder in the SL Program Files.

Typically, this path is something like C:\Program Files (x86)\Microsoft Dynamics\SL\Applications.

To back them up - Make a copy of the Usr_Rpts somewhere and put it in a different location than the SL program files.

Workflow error Dynamics GP

I had Workflow working in Purchase Requisition processing up to the last time i used my vm.  Started using it today and when I submit a purchase requisition for approval I get the error below.  Note no changes had been made and this error appears now where everything worked previously:

"[Microsoft][SQL Server Native Client 10.0][SQL Server]A .NET Framework error occurred during execution of user-defined routine or aggregate "SendWorkflowCompletionEmail". System.IO.FileLoadException": Could not load file or assembly 'System.DirectorSer[..." Error gets cut off at the end.

Resolution:

STEP 1:

Go to Microsoft Dynamics GP>> Maintenance>> SQL

Scroll to User Messages in the DYNAMICS db, insert and click 'create stored procedure'.

STEP 2:

Go to SQL and run the following script against DYNAMICS (system database)

exec wfDeployClrAssemblies

Unable to click arrows in SSRS

From IE 10 and up you will not be able to click on the drop down arrows in SSRS.

To resolve this issue you have to add the page to compatibility in ie.

How -
Go to the Menu bar in Internet Explorer then click Tools> Compatibility View Settings>> Click Add.

This will add the page to compatibility view and you will be able to click on those arrows now.

Scheduled Smartconnect map not running automatically only manually

So you have a schedule setup. File in folder ready for running but the file does not import. You look at smartconnect and see the map showing it ran but it didnt.

If you run it manually it works.

So what to do?
Restart eone service and then it will work.

A save operation on table PM_Transaction_Open has created a duplicate key

So you post a batch and it gets stuck in batch recovery. Try to clear it and it cannot come out. When you click 'more details' on the error it tells you about the save operation creating a duplicate key.

What to do?

Backup company and system database and then run checklinks on the Payables Logical and Vendor tables. Run this twice and the keys will be recreated, you may have to delete the batch after if the transaction was posted and resulted in an extra record.

Dynamics GP - Sales Order has been removed

So you tried saving a sales document, lost connection, forced to exit the system. Sign back in and cannot access the document.

Do an item inquiry and see the stock allocated.

What next?

In this order:
Run Checklinks on Sales Work
Run Reconcile on Inventory for the specific item.

Then run both a second time, the first time the sales order will correct itself, the second time the stock will be corrected. So yes, you have to run checklinks on sales work, then inventory reconcile then checklinks on sales work and then inventory reconcile again, in this order.

Smartconnect - Collection could not be initialized

So you get the above error and a long string of the fields used in the integration when you try to save the map you created.

To Resolve, export all setups from smartconnect.
Uninistall Smartconnect
Reinstall and 'run as admin'.

All will be fine now.
Trust me ;)

Import Segment Descriptions Dynamics GP

Ok so you have this long listing of segment numbers and segment descriptions to update to your financial setup and dont know how to begin.

You can either use the import method suggested by azurecurve or follow the mailmerge method below. 

What you need:

1. Spreadsheet data source with columns -  segment_number (the segment position in the chart - segment 2 or 3 for example); segment_value (the segment value within the chart so if it is revenue the number may be 4000 for example); and segment_description.

2. Word merge template

3. End result - SQL Statement

The Word mail merge template will use the spreadsheet as the data source for the mail merge.  In this scenario we have a single statement:

update gl40200 set dscriptn = '«segment_description»' where sgmtnumb = '«segment_number»' and sgmntid = '«segment_value»'

The resulting merged data could then be saved as a SQL query and run against the relevant company database.  Note that it is best practice to validate database updates in a test environment and to have a current database backup in place before running update statements.  Given those warnings, here are the first four lines from a set of sample data:

update gl40200 set dscriptn = 'SC Contracted' where sgmtnumb = '2' and sgmntid = '101'

update gl40200 set dscriptn = 'SC I/H Janitorial' where sgmtnumb = '2' and sgmntid = '102'

update gl40200 set dscriptn = 'SC I/H Janitorial Misc' where sgmtnumb = '2' and sgmntid = '103'

update gl40200 set dscriptn = 'SC I/H HVAC Service' where sgmtnumb = '2' and sgmntid = '104'

Dynamics GP Workflow Emails not sending anymore

So your workflow emails used to send but suddenly it stopped.

Reason - Windows password saved on the worflow maintenance window is invalid. Now the system will not tell you this.

All you need to do is go to Admin - Setup  - System - Worflow and update the password of the account saved there. Send your test mail and you shall receive it now.

Voila!

Capture Login Issues

Ok so you run the capture login script and then get the below message.

supplied parameter sid is in use

you then try to remove the sid from the syslogins table but you get some message related to 'adhoc' something is not allowed.

then you try to create the record manually and get 'the server principal already exists'


How to fix run the below and replace name with the name of the record you have the issue with. You should be fine now.

EXEC sp_droplogin 'namehere'

SmartList Builder Security

All SmartList Builder windows are denied access by default. To use SmartList Builder, the user must be in a POWERUSER role, or be granted access to the following windows in a Microsoft Dynamics GP Security Task:

First go to Security Tasks and select the following as seen in screen below.

Product: Smartlist Builder

Type: Windows

Series: Project

               Go To

               Set Field Options (3 windows)

               SmartList Builder

Second change series to System and select the below as per screen:

·        Background

·        Copy List

·        Display SQL

·        Preview

·        Process Queue

·        Resource Lookup

·        Smartlist Builder Progress

·        Smartlist Lookup

·        Table Details

·        Table Finder(2 items)

·        Upgrade Modified SmartLists

Third - Beyond the Window permissions, there are SmartList Builder Permissions that need to be granted as well.  These SmartList Builder Permissions can be granted in the Microsoft Dynamics GP Security Task as well.

 In same security task change Product to SmartList Builder, Type to SmartList Builder Permissions and Series to SmartList Builder.

·        Create a Go To that opens a Dynamics GP Form

·        Create a Go To that opens a file

·        Create a Go To that opens a website

·        Create a Go To that opens another SmartList

·        Create a Go To that runs a procedure

·        Create SmartLists with SQL Tables

·        Enter Calculated Fields

·        Update SmartList

·        View SmartLists with SQL Tables

Integration manager - Invalid string

Error: The destination could not be initialized due to the following problem input string 


This happens when you run IM as admin and GP as admin BUT - your GP company as a default company marked so when you sign in you have to switch the company you signed in to.

To resolve, remove the 'remember this company' mark from your account just by unclicking it on the sign in window.

Then run GP as admin and select the correct company before getting in and then run IM as admin as well.

Voila!!

It worked for me. Hope it works for you!

Management Reporter Database in Suspect Mode

So you check SQL and notice your backups stop running.

Only to notice it is because your MR database is in suspect mode. To resolve the issue i would first suggest, removing MR from the database backup plan and complete your GP backups.

Then run the below script to resolve the MR suspect mode issue. Then create your separate plan for MR backups.

Script:

EXEC sp_resetstatus ManagementReporter;

ALTER DATABASE ManagementReporter SET EMERGENCY

DBCC checkdb(ManagementReporter)

ALTER DATABASE ManagementReporter SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB (ManagementReporter, REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE ManagementReporter SET MULTI_USER

Dynamics GP Letter Writing Assistant; where are the reports pointing to?

You can identify where the system is looking to for the Letters by going to the Dex ini file in the Data folder of Dynamics GP on the C drive.

The user could not be added to one or more databases. Dynamics GP

This error usually goes away by deleting the user login from the security area for the specified database in SQL. Then re-add the user to the User Security in GP.

If that doesnt resolve the issue, the below will help:
In SQL Server Security=>Logins=>User Mapping, to uncheck the Map checkbox on the restored company.  After doing that the User Access function in GP will allow you to add the users to the company.

FRx Invalid work drive error

Unable to generate reports in FRx due to work drive error


The path may be changed from within the FRx Designer: 
On the Admin menu,click Processing Options.
Click thearrow in the Optional Work Drive box.
Browse to the desired path. 
Click OK. 
Close Designer, and then open it again - the error should no longer occur.

An error occurred while using the BCP utility-data was not correctly copied to the server.

You receive the below error when launching GP Utilities.

You must right click and run as admin and then the error will go away.

the microsoft.ace.oledb.12.0 provider is not registered

You receive the above error when running the FRx to MR Migration Wizard.

You must install the "AccessDatabaseEngine_x64"

Upgrading GP2010 SP4 to GP2015R2

You can go straight from GP 2010 SP4 (11.00.2390) to GP2015R2 (14.00.778) by taking the database backup from 2010 and restoring to SQL 2014SP1 and then installing GP2015R2 and then running utilities.

Please ensure you update the Dex.ini file with 'Synchronize=TRUE'. before running utilities.

FP: Bad component offset Form: 22010Wind

In upgrading GP you receive the following error message. 

To resolve, you need to go to the Dex.ini file and change the "Synchronise" to 'TRUE'. 

The synchronize with change back to FALSE once GP is run. So if you need to do it over again you will have to update a second time.

Sales Document unapplied but showing unapplied amount zero ($0)

Your document (return, credit, payment) was not applied to an invoice.
You go to Apply Sales Documents and you see your document but you cannot apply it to an invoice as there is no amount remaining for application on this document.
You run checklinks and this does not resolve your document but fixes other documents.

Have no fear! Do the below:
Run Reconcile on the Customer from the Reconcile Receivables Amounts window (Tools | Utilities | Sales | Reconcile).
Run the reconcile on both Current Customer Information and Outstanding Documents Amounts, for the customer with the issue.

Voila!

Management Reporter - Can't connect to the Management Reporter server. Do you want to specify a different server address?

You receive the above message when trying to access Management Reporter.
Your user has been granted access to MR in security.
You entered the correct connection information.
Your event viewer shows no issues.
Your MR services are running.
You can connect to MR on the server alone.
Domain firewall is off.
Port rule added for 4712 incoming connections.
Everything looks good but you cannot connect!!!!


Reason - The time on the client machines are different from the time on the server by a value greater than 5 minutes.
Once you change the times to match you will be able to connect.
You're Welcome!

See Cause 4 in link below:
https://support.microsoft.com/en-us/kb/2862020

Dynamics GP Workflow - Line Details do not print in email notification

So you add lines in the document line tab and they do not show up on your email.

To enable the document line details to show you need to ensure you have this line in your message body.

Error Dex.dic version 11.xxxxx is not compatible with executable version 11.xxx+1

You receive the above error when installing a service pack for your current GP version.

Dex.dic version 11.00.0218.000 is not compatible with executable version 11.00.0364.000


To resolve

• Go to program files>GP (relevant version)
• rename the dex.dic to dex_old.dic
• there will be a dex_us.dic file in there, copy the dex_us.dic
• rename the copy to dex.dic
• rerun the service pack

GP 2013 Unable to Save Fixed Asset on General Window

There is a bug with Gp2013 that crashes the system when you click save on the asset card window.
This happens when you have over 150 assets numbered consecutively.

The resolution would be to upgrade.
The workaround is to click on the next record button and let the system prompt you to save the record.

MSI Error 1317: 'An error occurred while attempting to create the directory' during installation

So you are trying to add a sub feature of Dynamics GP and you were able to do so via control panel.

You are now trying to launch GP for the cnk file to load and then you get the above error.

You check permissions and find that you have full admin permissions to the GP folder.

In my instance the issue was the 'SYSTEM' user did not have access. Once i added this user to have access to the folder the install completed.

Integration Manager Error - Item already exists in collection

You are on GP 2015R2 and try running any integration and get the above error.

You need to install the Hotfix for 2015R2 and this will resolve the error.

Invalid Versions! This version of Professional Services Tools is only compatible on GP 2013

So you are on GP 2015.

On signing in to GP you continuously get the message to include new code no matter what you do.

Then you launch PSTL and it says "Invalid Versions! This version of PSTL is only compatible on GP 2013".

You need to remove PSTL from control panel and follow steps from this guy. please note that you cannot just delete the SY07130 table as it will remove all third party applications. So try to delete only those for "Customer Exception"

https://community.dynamics.com/gp/b/dynamicsgpessentials/archive/2015/02/21/dynamics-gp-2015-rtm-pstl-invalid-versions

Update Include in Lookups on Chart of Accounts

Providing that your include in lookups are laid out like this, the combinations below will apply.
Sales
Inventory
Purchasing
Payroll

Combination	SQL Value
NNNN	0X0
XNNN	0X1
NXNN	0X2
XXNN	0X3
NNXN	0X4
XNXN	0X5
NXXN	0X6
XXXN	0X7
NNNX	0X8
XNNX	0X9
NXNX	0XA
XXNX	0XB
NNXX	0XC
XNXX	0XD
NXXX	0XE
XXXX	0XF

Have the combination matched to each account.

Import the chart of accounts to the system.

Extract the chart of accounts after upload including the account index.

Use the following script and update in SQL it must include same spaces and apostrophe as seen below.

update GL00100 Set dsplkups =0x4 where actindx ='1'

Dynamics GP Upgrading from a version to its R2 version

SCENARIO:
You need to upgrade from GP2015 to GP2015R2 for example.
You have downloaded the media and on running the file you are only allowed to add/remove features or repair.

WHAT TO DO:
Run the file in the Updates folder and this will get you on the new release. Then run utilities as admin so the tables can be updated.

REASON:
You are already on the main version of the software and its just a patch/service pack that needs to be added.

Fiscal Period Setup Error "The date cannot be part of a different fiscal year"

Confirm there are no fiscal years setup with incorrect dates in the same Fiscal Period window.

Then run Reconcile in Admin for Fiscal Periods. (Microsoft Dynamics GP>Tools>Utilities>System>Reconcile, then select Fiscal Period and insert into the list)

The report will tell you where there were errors, go back to the Fiscal Period window and fix the corrupt year, then create the new year.

You will then be required to run a reconcile on GL, AR and AP.

Dynamics SL "Date must be in an open 1099 year, please reenter"

User is unable to print cheques in January although your fiscal year is set to span calendar years.

1099 setup looks at calendar year. Hence, if the years in your 1099 setup window is not the current calendar year you have to purge the oldest year so the current and next years can be updated on the system.

To Purge Go to: Financial> AP> Setup> Processes> 1099 Calendar Year Control. Purge the oldest year and this would update the Current and Next Year values.

You will then be able to print your cheques.