How to install 64-bit Data Access Component Engine on a machine with 32-bit office components.

Error:
You cannot install the 64-bit version of Microsoft access Database engine 2010 because you currently have 32-bit office products installed

Solution:

Install in passive mode

Remove the registry reference to mmo.dll

Original post

http://knowledge.autodesk.com/support/autocad-civil-3d/troubleshooting/caas/sfdcarticles/sfdcarticles/How-to-install-64-bit-Microsoft-Database-Drivers-alongside-32-bit-Microsoft-Office.html

Related Errors:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

SQL - How to get the day name of a date

select DATENAME( dw, CONVERT( date, getdate(), 103 ) ) as BDay

Replace getdate() with your field

Dynamics GP - How to fix discrepancies between GL and Subledger

• Smartlist the GL for the transaction Value to determine if the transactions may have gone to the wrong account.
• If a transaction exists in the Subledger, and not in the GL
• Manually enter a GL journal for the distribution.
• If a transaction exists in the GL and not in the subledger
• Void/reverse the GL transaction, and re-enter the transaction from the subledger
• If a transaction is not being displayed in your Bank rec, but is in the gl and not in the subledger
• Void/reverse the GL transaction, and re-enter the transaction from the Bank transaction entry screen.
• If a transaction is not being displayed in your Bank rec, but is in the gl and in the subledger
• Void/reverse the Subledger transaction, and re-enter the transaction from the Bank transaction entry screen.

Dynamics GP - Security Task Setup Window Locations. Where is the task located?

Reason Codes - Microsoft Dynamics GP>Windows>Company
Reason Code Setup - Microsoft Dynamics GP>Windows>Company

Dynamics GP - How to Reprint Outstanding Bank Transactions Before and After GP 2013 R2

Before GP2013 R2

This method using the smartlist

http://gp.rosebizincblogs.com/2010/05/outstanding-bank-transactions.html


After GP2013R2

There is a new report available
https://community.dynamics.com/gp/b/gpteamblog/archive/2014/05/15/microsoft-dynamics-gp-2013-r2-feature-of-the-day-reprint-outstanding-transaction-in-bank-reconciliation.aspx

Dynamics GP - picture printing is not available without the desktop experience feature

Enable the Desktop Experience Feature on windows server


go to Server Manager> Add Features>Features>User Interfaces and Infrastructure>Tick Desktop Experience

Dynamics GP - Smartlist Export Error - "Excel cannot open the file [filename] because the file format or file extension is not valid."

We got this error happening because one of the text fields was using "[" and "]" and "(" and ")" characters that was causing the smartlist to export incorrectly.

We removed the characters and everything exported fine.