Dynamics GP - Disable Nightly Date Change Prompt

Add the following line above the "[Install]" section of the Dex.ini file.

SuppressChangeDateDialog=TRUE

The prompt will not appear, and the date will never change in GP.

Dynamics GP Integration Manager: Run Integrations Automatically / On a schedule

1) Create a batch file with this line

"C:\Program Files (x86)\Microsoft Dynamics\Integration Manager 11\Microsoft.Dynamics.GP.IntegrationManager.IMRun.exe" /I "MYINTEGRATION"

Where MYINTEGRATION is the name of the integration you want to run

1A) If you are using an eConnect Integration map, GP does not need to be running.
1B) If you are using a normal integration map, GP must be running and logged in. Create a login macro if you want it to autologin with a reboot. http://dynamicsstarter.liferozana.com/?p=102

2) Download System Scheduler Free version. Windows scheduler is crap. It will not run your batch file properly.
http://www.splinterware.com/download/index.htm

3) Schedule your batch file to run.

Dynamics GP Integration Manager: Prices need to be recalculated

Myridas Aggregate pricing causes this error to come up.

The transaction integrates anyway

Dynamics GP 2010 Integration Manager - error type_e_cantloadlibrary

The following problem was encountered during destination uninitialization:
 - Argument 'Number' is not a valid value.
Argument 'Number' is not a valid value.
Unable to cast COM object of type 'MSScriptControl.ErrorClass' to interface type 'MSScriptControl.IScriptError'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{70841C78-067D-11D0-95D8-00A02463AB28}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).


OR



Opening source query...
Establishing source record count...
Beginning integration...
DOC 1 ERROR: Unable to cast COM object of type 'MSScriptControl.ErrorClass' to interface type 'MSScriptControl.IScriptError'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{70841C78-067D-11D0-95D8-00A02463AB28}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
DOC 1 ERROR: Argument 'Number' is not a valid value. - Argument 'Number' is not a valid value.
DOC 1 ERROR: Unable to cast COM object of type 'MSScriptControl.ErrorClass' to interface type 'MSScriptControl.IScriptError'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{70841C78-067D-11D0-95D8-00A02463AB28}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
Integration Failed
Integration Results
    1 documents were read from the source query.
    1 documents were attempted:
        0 integrated without warnings.
        0 integrated with warnings.
        1 failed to integrate.

To resolve this issue

RUN CMD AS ADMINISTRATOR

Register the MSScript.ocx file. To do this, click Start, click Run, type regsvr32 C:\Windows\System32\MSScript.ocx in the Open box, and then click OK
Note If you are on a 64-bit computer, use this command: regsvr32 C:\Windows\sysWOW64\MSScript.ocx.


http://support.microsoft.com/kb/942750

The Microsoft.ace.oledb.12.0 provider is not registered on the local machine

Install this

http://www.microsoft.com/download/en/confirmation.aspx?id=23734

EOne Smartconnect - Scheduler does not fire on 29 Feb for Leap Years

Scheduler does not schedule correctly if the maps are setup on the 29th of Feb.

1. To resolve it, open up the Scheduler Master Maintenance Window.  (Maps – Scheduled Maps)
2. Double-click on the first map in the list which will open the actual scheduler window
3.  Click Save on this window, which will update the next run time with today’s date. 
4. You will need to do this to each map you have scheduled. 

EOne Smartconnect - Could not retrieve this map

This happens if the Smartconnect log file is too large.

1) Backup the smartconnect database
2) Switch the database backup type from full to simple