A get/change first operation on table 'ASI_MSTR_Explorer_Favorites' cannot find the table.

Error when opening GP:
A get/change first operation on table 'ASI_MSTR_Explorer_Favorites' cannot find the table.


Possible reason for issue:
The Dynamics.dic file may not be synchronized with the account framework.

To Fix:
To resolve this problem, resynchronize the Dynamics.dic file to the account framework. To do this, follow these steps:

1. Locate the Dex.ini file on the computer. To locate the file, follow the appropriate step:
   
   • If you are using Microsoft Dynamics GP 10.0 or Microsoft Dynamics GP 2010, the Dex.ini is in the Data folder of the installation folder. By default the installation folder is C:\Program Files\Microsoft Dynamics\GP.
   • If you are using Microsoft Dynamics GP 9.0, the Dex.ini is in the installation folder. By default the installation folder is C:\Program Files\Microsoft Dynamics\GP.
2. Open the file in Notepad.
3. Change the Synchronize parameter as follows:
   Synchronize=TRUE
4. On the File menu, click
   Save.
5. On the File menu, click
   Exit.
6. To start the synchronization process, start Microsoft Dynamics GP Utilities.

Cannot browse to SQL when creating odbc connection

Turn off Firewall

Ensure TCPIP is enabled in SQL Configuration for that instance of Dynamics.

Ensure remote connections to SQL is enabled in the connections page of SQL Properties,

SQL Stored Procedure Error Table

Dynamics..taErrorCode

this provides a listing of error codes and details of what the error is.

Integration Manager Error - "Please check and reenter date"

Ok, so you are importing transactions in Integration Manager.

The integrations keep failing and saying the captioned error.

The Possible Issue:
- Date Format on Computer is different from that in GP and that from your data file.

My issue:
- GP date 2018-01-31
-System date 2018-Jan-31

To Fix:
- Change the date setting in the system to match GP  i.e. 2018-01-31

Voila!

Dynamics GP workflow emails

To tie a windows login to an email address you need to:
- Go to Active Directory.
-Open the user
-Go to the general tab
-Fill in a name as well as email account

-Voila!

Integration using stored procedure and smartconnect

So you run your integration file which is using a stored procedure instead of a table.

Then you get error messages in the form of a number. You check Event Viewer and find nothing.

For example '7' or '50997'.

To figure out what this means you have to run the below select statement:

SELECT * FROM DYNAMICS..taErrorCode

GP 2013R2 Upgrade stuck in loop "Budiness Intelligence reports were not deployed"

This error occurs when you previously deployed the Excel Reports but have moved servers or the location where you originally installed them is no longer in place.


If you are just doing a test upgrade you can just exit GP Utilities.

GP would have been upgraded already. You can always re-deploy the reports within GP.