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

Download and install office 2007 data connectivity components

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

Dynamics GP - Integration Manager "This item is not effective"

When trying to integrate an item, you get an error saying "This item is not effective".

This is because the item is not activated in the manufacturing module.
To activate the item go to

Cards>Manufacturing>Inventory>Engineering Data>Enter Item>Change Status to Active

The Best Free Apps List

Antivirus - Avast http://www.avast.com/en-au/free-antivirus-download
Photo Editor - PhotoScape http://www.photoscape.org/ps/main/index.php
Remote Assistance - Teamviewer http://www.teamviewer.com/en/index.aspx?cdsplit=C
Scheduled Tasks - Splinterware System Scheduler http://www.splinterware.com/products/wincron.htm
Torrents - uTorrent http://www.utorrent.com/
Virtual Drive - Virtual Clone Driver http://www.slysoft.com/en/virtual-clonedrive.html
Zip / compression - 7zip http://www.7-zip.org/
Process Maps - yED http://www.yworks.com/products/yed/download

VM Recipes - Windows 2003 R2 with SP2 32-bit, SQL2k5, Dynamics GP 10, Business Portal 4.0 SP2

Business Portal 4.0 CANNOT be installed on 64-bit.

Business Portal 4.0 works on 32-bit only.

• Download Windows Server 2003 R2 with SP2
• https://msdn.microsoft.com/en-gb/subscriptions/securedownloads/hh442898#searchTerm=windows%20server%202003%20standard&ProductFamilyId=0&Languages=en&PageSize=10&PageIndex=0&FileId=0 
• Download SQL 2005
• https://msdn.microsoft.com/en-us/subscriptions/securedownloads/hh442898#searchTerm=sql%20server%202005%20standard%2032&ProductFamilyId=0&Languages=en&PageSize=10&PageIndex=0&FileId=0
• Download Business Portal 4.0
• Download GP 10
• https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp2010_release_download.htm?printpage=false&sid=y4f4120zeb5hzlxdaeomdu2t&stext=product release downloads for Microsoft Dynamics GP 10
• Download Business Portal Service Pack 2
• https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp10_bpservicepacks.htm?printpage=false
• Download Windows Sharepoint Services 3.0x64 SP2
• http://www.microsoft.com/download/en/confirmation.aspx?id=5719 
• Install and configure Windows Server
• Rename the computer to something normal
• Set the ip manually 
• Run DCPROMO
• Install and configure SQL
• Install GP 
• Enable IIS on your Windows Server
• Install WSS
• Install Business Portal

Dynamics GP - Download Product

Go to partnersource.
Search for Product Release downloads

https://mbs2.microsoft.com/PartnerSourceApp/search.aspx?qu=product+release+downloads

Dynamics GP - Data Connection is blank after installing client on 64 bit machine

The machine is a 64 bit machine, and the Dynamics GP install does not create a 64-bit odbc connection.

You have to manually create a 32-bit odbc data connection for GP.

The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
Run it and create your odbc.
Connect to your sql server using sa
untick all checkboxes on all windows as you go through the setup
next next next
You should see your data connection when you run GP.

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

Dynamics GP - Pre-Requisites

Hardware and Software Requirements for Dynamics GP 2010 R2

https://mbs.microsoft.com/partnersource/documentation/systemrequirements/mdgp2010_technology_requirements.htm?printpage=false&sid=gkpquo3wv0x0z4rpb5gky00r&stext=System Requirements for Microsoft Dynamics GP 2010 r2

Dynamics GP Version Release Numbers

http://www.jivtesh.com/2008/01/great-plains-service-pack-versions.html

Dynamics GP Report Writer - Images on Reports

1) Edit your picture to fit within the requirements here. Keep the pixels in multiples of 50 eg. 100x150 or
250 x 300, 900x300 otherwise the pictures will come out blurry. Large images will be auto-resized by GP, and will look better than small images.

https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb$en-us$854470

2) Open report writer, go to your report, open layout. Select your image from inside editor. Copy.
Paste your picture in report writer. Name it.

3) If you need to use this picture for other reports, on the main toolbar, click the little image icon (third on bottom left) then click in your report, then choose the image name you created before, then click "ok".

Dynamics GP - Un-Allocate or De-Allocate inventory from an SOP transaction

Change the site on the line item for every line item.

How to make and schedule a Batch file to make backup copies of a folder, and log it.

Create a batch file like this
---------------------------------------------------------------------------------------


Echo.  >>c:\somelogfile.txt
Echo.=================== >>c:\somelogfile.txt
echo.%Date% >>c:\somelogfile.txt
echo.%Time% >>c:\somelogfile.txt

rem out this line if you want to log every single file in the logfile
@echo off


xcopy C:\Copythisfolder /c /s /r /y /i C:\Tothisfolder


------------------------------------------------------------------

Download System Scheduler from
http://www.splinterware.com/download/index.htm


Schedule to run batch file every night

Create your own Barcodes

Install the 3 of 9 font here. It supports all characters, digits and upper case letters
http://dl.dropbox.com/u/45910856/BARCOD39.TTF

To get the scanners to scan properly, you must use * before and after any data you are barcoding.

For Example, to create a simple barcode in Excel for 34567
Open Excel, Enter  *34567* and switch it to 3 of 9 font
You can now scan this barcode with any standard scanner.

Dynamics GP - Free any records locked by users

Use this script for all errors pertaining to locks / shares

Ensure all users log out of GP, then run
------------------------------------------------------------------------------

DELETE FROM [DYNAMICS].[dbo].[ACTIVITY]
DELETE FROM [DYNAMICS].[dbo].[SY00800]
DELETE FROM [DYNAMICS].[dbo].[SY00801]
DELETE FROM [tempdb].[dbo].[DEX_LOCK]
DELETE FROM [tempdb].[dbo].[DEX_SESSION]

------------------------------------------------------------------------------
If it says a batch is stuck / being edited, and there is no one else in the system

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'

If you can't get everyone to log off, you can use this script which removes activity locks for anyone who isn't currently logged in.

---------------------------------------------------------------------------------------------------------------------

-- Dexterity Sessions Table
delete S
-- select * 
from tempdb..DEX_SESSION S
where not exists (
 select * from DYNAMICS..ACTIVITY A 
 where S.session_id = A.SQLSESID)


-- Dexterity Locks Table
delete L
-- select *
from tempdb..DEX_LOCK L
where not exists (
 select * from DYNAMICS..ACTIVITY A 
 where L.session_id = A.SQLSESID)


-- Batch_Headers table in each company
exec sp_MSforeachdb
' use [?]
if exists ( select INTERID from DYNAMICS..SY01500 D where INTERID = ''?'' )
begin 
 update S set BCHSTTUS = 0, MKDTOPST = 0, USERID = ''''
 -- select *
 from SY00500  S
 where BCHSTTUS in (1,2,3,4,5,6)
 and not exists (
  select * from DYNAMICS..ACTIVITY A 
  JOIN DYNAMICS..SY01500 C ON C.CMPNYNAM = A.CMPNYNAM
  where S.USERID = A.USERID and C.INTERID = db_name()) 
 and exists (
  select * from DYNAMICS..SY00800 B 
  where not exists (
   select * from DYNAMICS..ACTIVITY A 
   where B.USERID = A.USERID and B.CMPNYNAM = A.CMPNYNAM)
  and S.BCHSOURC = B.BCHSOURC and S.BACHNUMB = B.BACHNUMB)
 print ''''
 print ''('' + ltrim(str(@@ROWCOUNT)) + '' row(s) affected) - Database '' + db_name()
end
'


-- SY_Batch_Activity_MSTR table
delete  B 
-- select * 
from DYNAMICS..SY00800 B
where not exists (
 select * from DYNAMICS..ACTIVITY A 
 where B.USERID = A.USERID and B.CMPNYNAM = A.CMPNYNAM)


-- SY_ResourceActivity table
delete  R 
-- select * 
from DYNAMICS..SY00801 R
where not exists (
 select * from DYNAMICS..ACTIVITY A 
 JOIN DYNAMICS..SY01500 C ON C.CMPNYNAM = A.CMPNYNAM
 where R.USERID = A.USERID and R.CMPANYID = C.CMPANYID) 


--------------------------------------------------------------------------------------------------------------------------------

SQL execute command line and return results to a table

DECLARE
@CMD CHAR(200),

SELECT @CMD = 'DIR c:\'

INSERT INTO HILOCSV
EXEC MASTER.DBO.XP_CMDSHELL @CMD

EOne Smartpost does not post every night

The nightly date change prompt prevents smartpost from posting.

Disable the 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 - 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