How to add Nodes in Smartconnect after Installation.

Smartconnect
-After installation of Smartconnect Application
-Register Smartconnect
-Install GP Smartconnect
-Process Cache in GP Smartconnect
-Then go back into Smartconnect application
-Create GP Connector
-Run System Maintenance

-BOOM! Nodes added!

Management Reporter - Couldn't retrieve the list of available databases: The connection attempt failed.

You get the error as seen below when trying to deploy the Management Reporter Data Mart under the "Database GP Connection Information" section.

"Couldn't retrieve the list of available databases: The connection attempt failed."

I experienced it with MR CU16 and other persons have experienced with older versions of MR. 

What to do:

To resolve the Dexterity Shared Components 12 needs to be installed. You can retrieve this from a GP2013R2 install file.

Once installed you can complete the MR Data Mart deployment.

Unable to access SQL after straight install from Azure

So you get your new VM and you see SQL installed. You try to connect to SQL and dont know the sa password. So you use the Windows domain account but cannot get in either.

Reason is because the domain may not have been setup yet so you need to connect with the local admin account.

• Thus you sign in to the machine as the local admin account. 
• Sign in to SQL. 
• Change the Properties to Mixed Mode. 
• Then enable the sa user in security. 
• Then set the password.

GP Web Client First Log in - Error Received "A get/change operation on table 'syUserDefaults' failed accessing SQL data dynamics gp"

So you set up web client
Try to log in for the first time and get:

"A get/change operation on table 'syUserDefaults' failed accessing SQL data dynamics gp"
More Info : "The server principal "(username)" is not able to access the database "DYNAMICS" under the current security context."


To Resolve:
- Run grant scripts against Dynamics and Company Databases
-Give your web client sql user account DYNGRP access to DYNAMICS database.

Management Reporter - Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only

So you are trying to install Management Reporter
You have installed the services
You are trying to deploy the data mart or the legacy and no matter how many times you put in the sa password you get the error above.

How to fix?
-Use a higher version of Management Reporter. The version you are using is possibly not compatible with your SQL version.

Analytical Accounting Error - Assigned amount does not equal the distrbution amount

So you are posting a journal and get the error only when posting not when you print an edit list.

What is wrong? The distributions in the AA Work tables are mixed up.

Review these tables and manually update where you see the credit and debit or even the percentage allocation is incorrect.

Tables:

• AAG10000
• AAG10001
• AAG10002

Revalue vs Non Revalue Items

When an item is not set to be revalued the following happens.

Scenario A with Non Revalued Item:

• Item Purchased and Received into stock at $500.
• Some of the item is subsequently sold
• Item is Invoiced through purchasing at different unit cost say $550.

End Result for Scenario A of Non Revalued Item:

• GL Updated with Inventory value of $500 from the Purchase Receipt
• GL reduced with the Inventory and Cost of sale based on the purchase receipt i.e. $500.
• Sub-ledger reflects the purchase receipt cost i.e. $500.
• Invoice difference is reflected in the purchase price variance account. This does not affect inventory sub-ledger as the cost remains the receipted cost and the inventory account matches this value in the sub-ledger as the difference is posted to the purchase price variance account instead of inventory.
• In the end the sub-ledger and GL balances but at the Receipt Cost.

When an item is set to be revalued the following happens.

Scenario B with Revalued Item

• Item Purchase and Received into stock at $500
• Some of the item is subsequently sold
• Item is Invoiced through purchasing at different unit cost say $550.

End Result for Scenario B with Revalued Item

• GL Updated with Inventory value of $500 from the Purchase Receipt
• GL reduced with the Inventory and Cost of sale based on the purchase receipt i.e. $500.
• Sub-ledger reflects the purchase receipt cost i.e. $500.
• Purchase Invoice difference Debits the Inventory sub-ledger for the $50 as well as the GL (instead of the purchase price variance account used in Scenario A). 
• The system automatically creates a journal to update the cost of sale and inventory where sales transactions were posted from this receipt layer. 
• In the end the sub-ledger and the GL balances but at the Invoice Cost.

In the end it is all dependent on what you want to see in your General Ledger. 

And no - Revalue Inventory does not result in your sub ledger to general ledger being out of balanced.

Note the snip below is for the Revalued Item at 600 and not 500 as listed in the example scenario above.

Management Reporter Error - Change Tracking not enabled for tables GL00100, GL00102, etc

So you are deploying Management Reporter Data mart and get the change tracking error.

Now this would result in you having to set each table noted to have change tracking enabled.

Instead of doing this you can -
Go straight to GP,
Admin -> Setup-> Company-> Company, click the Options button, turn off Enable GL Reporting and Turn it back on. This will reset the change tracking and you can proceed.

Some tables your error would note:
GL00100
GL00102
GL00200
GL00201
GL10000
GL10001
GL10100
GL10101
GL12000
GL12001
GL20000
GL30000
GL32000
GL40000
GL40200
MC00200
MC40000
MC40600
SY00300
SY40100
SY40101

Unable to Mount iso image

Unable to mount iso image from a mapped drive, error received as below.

You need to move the file to the c drive and then try again. You are not allowed to mount an iso from a mapped drive..

Error: 'There was a problem mounting the file"

MR Deployment Error

MR takes long to complete initialization.

The error below is found in the service deployment log

Sequence contains no elements
--- Exception Dump ---
Caught Exception: [Microsoft.Dynamics.Integration.Service.Tasks.RecordException] Sequence contains no elements
Stack trace:




To resolve execute the below on the Management Reporter database.

MERGE Reporting.ControlCompanyIntegration AS TARGET
USING Reporting.ControlCompany AS SOURCE ON (TARGET.ID = SOURCE.ID)
WHEN NOT MATCHED BY TARGET AND GLEntityID not in ('5F878A3C-5F4C-4806-B786-5CAB52C98F0F')
--Update the “1” as needed based on value in Reporting.ControlIntegrationSource
THEN INSERT (ID, SourceID) VALUES (SOURCE.ID, 1);

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.

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.

Moving and Upgrading Integration Manager

Moving from server running GP2013  to a new server with GP2016.

Process for moving integrations to the new server:

Integration Manager can be migrated to a new location by moving the Integration Manager database. The location of the database file can be found by viewing the options menu window in the Default Integration Manager Database field on Integration Manager.

After this file has been moved to the new server, you should use the Convert Database tool in Integration Manager to convert the database to the newest version, matching the installation of Integration Manager.

All paths in the integration will not change automatically. This part will have to be done manually.

An error occurred while loading or initializing an addin. Ask your administrator to check the Windows event log for more details. Dynamics will now close.

So you are trying to upgrade GP 2013 to GP 2013R2.

You launch GP and get the message as per subject.

When you check event viewer you get 'An exception occurred while trying to load or initialize the add in located at Excel Builder'


Reason for issue:
Your client gives you a mismatched database to GP folder.


To Resolve:
- Ensure the SLB from eone is installed
-Remove the excel related add ins from the Add In Folder in GP.
- Manually add the SLB module in the add remove of GP
-Launch GP. You will be fine.