Integration Manager Error: ADO Field Is Nothing

Microsoft Dynamics GPIt seems it is a week for Integration Manager errors. Another client has logged an error when using Integration Manager. In this case, they were attempting to load a payroll journal using the GL Trx One Source File integration Continue reading “Integration Manager Error: ADO Field Is Nothing”

Integration Manager Error: Source Document ‘GJ’ Does Not Exist

Microsoft Dynamics GPI like dealing with Microsoft Dynamics GP as it is easy to use and is a very flexible system. I don’t enjoy using some of the related systems as much and most especially Integration Manager.

We have a few customers who use it for importing journals or invoices into the system from elsewhere and occasionally they encounter errors which are more than an incorrectly formatted file so they contact the helpdesk to log a call.

One such involved the below error message regarding the source document ‘GJ’ not existing Continue reading “Integration Manager Error: Source Document ‘GJ’ Does Not Exist”

Windows 7: Working With Images Leading to FFFFFFFUUUUUUUUU

WindowsOne of the issues which has annoyed me about Windows 7 for a while now has, since I started writing this blog, moved on from being an annoyance to being seriously aggravating. It’s a meme I don’t really like but it does perfectly convey my emotions;

FFFFFFUUUUUUUU

Continue reading “Windows 7: Working With Images Leading to FFFFFFFUUUUUUUUU”

Management Reporter Migration Wizard: ACE.OLEDB.12.0 Provider Is Not Registered On The Local Machine

Microsoft Dynamics GPThis particular problem is going to occur if you either do not have Microsoft Office installed or, on an x64 OS, you have installed the x86 version of Microsoft Office when you try to install the Management Reporter Migration Wizard (in particular Microsoft Access);

Management Reporter Migration Wizard: ACE.OLEDB.12.0 Provider Is Not Registered On The Local Machine

Continue reading “Management Reporter Migration Wizard: ACE.OLEDB.12.0 Provider Is Not Registered On The Local Machine”

Problem Posting General Ledger Batches In Test Company

Microsoft Dynamics GPI recently fielded a call from a client who had copied their live database across to test so they could do a reconciliation of Purchase Order Processing accruals to the General Ledger accrual account without having to chase a moving target as new transactions were processed. Continue reading “Problem Posting General Ledger Batches In Test Company”

Not Privileged To Run this Report Error in Payables Select Checks

Microsoft Dynamics GPI upgraded a customer to Microsoft Dynamics GP 2010 a couple of weeks ago and they have started to explore some of the new features. After fixing their payment run problem they enabled the new functionality for emailing remittances. Continue reading “Not Privileged To Run this Report Error in Payables Select Checks”

Journals Submitted To eConnect Vanishing

Microsoft Dynamics GPWe use eConnect to post journals from external systems into Microsoft Dynamics GP. After working fine for over a year, a customer site recently had transactions posted via eConnect vanishing.

There were no entries in the Journal messages under eConnect_Incoming Private message queue in Computer Management or in the eConnect section of the Windows Event Viewer. Once the message had left the client machine no trace could be found.

Continue reading “Journals Submitted To eConnect Vanishing”

Check Remittance Undefined Symbol Error When Upgrading to Microsoft Dynamics GP 2010

Microsoft Dynamics GPThe customer I recently upgraded from Microsoft Dynamics GP 10 to GP 2010 have encountered an error during the payment run at the cheque remittances step;

Undefined Symbol F01343D00789 Sequence Num

Continue reading “Check Remittance Undefined Symbol Error When Upgrading to Microsoft Dynamics GP 2010”

Microsoft Dynamics GP 2010 Utilities: BCP Utility Error

Microsoft Dynamics GPI have just returned from customer site where I did an upgrade of Microsoft Dynamics GP 10 to Microsoft Dynamics GP 2010 (I wish they’d called it GP 11 as the current nomenclature confuses customers) and got the error I often get when upgrading or installing GP on Windows 7 or Windows Server 2008 systems and have forgotten to do one of two very simple things. The explanation of the two things later, but first, the error message;

An error occurred while using the BCP utility--data was not correctly copied to the server. Please verify your ODBC settings and that BCP has been correctly installed. Microsoft Dynamics Utilities will now exit.

Continue reading “Microsoft Dynamics GP 2010 Utilities: BCP Utility Error”