ERROR: System.Data.SqlClient.SqlError: Procedure 'taAnalyticsDistribution' expects parameter '@I_vDOCNMBR'

When you use Integration Manager for Microsoft Dynamics GP to run a General Journal integration with Analytical Accounting data mapped, you receive the following error message: ERROR: System.Data.SqlClient.SqlError: Procedure 'taAnalyticsDistribution' expects parameter '@I_vDOCNMBR'

Resolution: https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYYMYQKSYMXOSOOUMLVPZRNUSTZQRSNZUXRVTRPLZRSWRPMUYR

Integration Manager 10 and Analytical Accounting

Integration Manager 10 using the Dynamics GP eConnect adaptor GL Journal, is able to import Dynamics GP Journals with Analytical Accounting Dimension Codes. You must specify the journal number however in your source file to prevent issues. Other adaptors such as Sales Journals for SOP also have this ability. I know this was a problem before and really relieved that that this is available

Mail Merge and Dynamics GP Macro

I know Dynamics GP is coming on with leaps and bounds with all the new technology tied in with Office 2007 but some modules such as Analytical Accounting do not have integration manager import access. So what do we do. We use the good old faithful Macro and word mail merge.

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYPKZPWNYYQNZZXYLWRONSRMONWZOWWVSVVMSQKOONNYYUZWUY#ECH

:) Macros will be around for a while but please comment if you know this is excluded in version 11