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.

Re-open Closed Fiscal Period

Scenario

• Closed February and March accidentally in AP.
• Only February should have been closed in AP.

 

Resolution:

• Have users log out of SL
• Execute the below SQL statement on Test Company first. (Assuming March is the third period for Fiscal Year 2018)
• update apsetup set CurrPerNbr = 201803, PerNbr = 201803
• Test entering transaction for March 2018. Confirm all is well.
• Complete same steps on live company.