Tag Archives: Payables Management

Update Debtor Addresses From CSV To Work Around An Integration Manager Bug

Posted on 9th March 2012 by Ian Grieve

Earlier this week I posted about a bug in Integration Manager where it added extra zeros into the phone and fax number fields when importing creditors. Well, the same bug also affects debtors but a similar script to update debtors via a CSV is also possible.

Continue reading →

Posted in Dynamics, GP, Microsoft | Tagged Creditors, Debtors, Integration Manager, Integration Manager 10, Microsoft Dynamics GP 10, Microsoft Dynamics GP 2010, Microsot Dynamics GP, Payables Management, Purchasing, Receivables Management, Sales, SQL Script, TSQL | 2 Comments

Update Creditor Addresses From CSV To Work Around An Integration Manager Bug

Posted on 7th March 2012 by Ian Grieve

I was doing some work for a client recently where we were loading lists of new creditors into Microsoft Dynamics GP from CSV files via Integration Manager. There is, however, a bug in IM 10 where it adds extra zeros to the phone and fax number fields of both creditors and debtors. These extra characters are, rather bizarrely, not always at the end but can be interspersed in the phone number.

The easiest work around was to put together a SQL script for loading the phone and fax numbers from CSV file which I did while on site which updated only a single address on the PM Creditor Master (PM00200) and PM Address Master (PM00300) tables.

Continue reading →

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged Creditors, Debtors, Integration Manager, Integration Manager 10, Microsoft Dynamics GP 10, Microsoft Dynamics GP 2010, Microsot Dynamics GP, Payables Management, Purchasing, Receivables Management, Sales, SQL Script, TSQL | 2 Comments

Enabling Email Cheque Remittances For All Suppliers

Posted on 19th October 2011 by Ian Grieve

In two previous posts I discussed testing Microsoft Dynamics GP 2010′s new Email Remittance functionality; first, by setting up creditors with an internal email address and, then, by transferring the email address from the INET1 field to the new EmailToAddress field.

The other script which I used, and forgot to post, was the one which configures all of the creditors, who are not currently configured for email remittances Continue reading →

Posted in Dynamics, GP, Microsoft | Tagged Check Remittance, Creditors, Email, GP, Microsoft Dynamics GP 2010, Payables Management, Payment Run, Purchasing, SQL Script | 3 Comments

eConnect Error: Unrecognized error 232 (0xe8)

Posted on 7th October 2011 by Ian Grieve

A couple of weeks ago, a client was testing Microsoft Dynamics GP 2010 R2 and reported that some of their postings from an external system were not arriving in GP (these postings are transferred using eConnect).

When I installed eConnect I enabled Journalling on the econnect_incoming queue so we would have a record of messages which had been submitted. After receiving the error I went to make sure the messages had reached the GP server (Start menu >> Control Panel >> Administrative Tools >> Computer Management >> Services and Applications >> Message Queuing >> Private Queues >> econnect_incoming >> Journal Messages) Continue reading →

Posted in Dynamics, eConnect, GP, Microsoft | Tagged eConnect, eConnect 11, Errors, Financials, General Ledger, Integration, Payables Management, Purchasing | 2 Comments

Missing Transaction In Cashbook Bank Management?

Posted on 5th October 2011 by Ian Grieve

I dealt with an issue yesterday where a manual payment had been entered into Payables Transaction Entry (Transactions >> Purchasing >> Transaction Entry) but was not showing up in Bank Management’s Reconciliation screen (Transactions >> Financial >> Bank Management >> Reconciliation).

The reason for this is actually quite simple, but I can’t help but feel it is a little bug like. Only payments made directly via Transaction Entry or those produced during the payment run (Transactions >> Purchasing >> Select Cheques) are posted to Bank Management. If you need to do a manual payment into Payables, or a manual receipt into Receivables, then this needs to be done via CBM Batch Entry (Transactions >> Financial >> Bank Management >> Batches) Continue reading →

Posted in Dynamics, GP, Microsoft | Tagged Cashbook Bank Management, Financials, GP, Microsoft Dynamics GP 2010, Payables Management, Payment Run, Purchasing, Receivables Management, Sales, Transaction Entry | 2 Comments

Locked Payables Transaction: You cannot display this record while another user is editing it

Posted on 29th September 2011 by Ian Grieve

With sites using Microsoft Dynamics GP over Citrix Presentation or XenApp, where they have set Citrix to time users out after a certain period of inactivity, we occasionally see the following error message when another user tries to open the voucher in Payables Transaction Entry (Transactions >> Purchasing >> Transaction Entry);

This document number already exists. Please enter a new document number.

Continue reading →

Posted in Dynamics, GP, Microsoft | Tagged Errors, GP, Payables Management, Purchasing, SQL Script, Transaction Entry | 2 Comments

Feature Explained: Reporting Ledgers

Posted on 27th September 2011 by Ian Grieve

In Microsoft Dynamics GP 2010, Microsoft introduced the Reporting Ledger functionality which allows journals to be posted to one of three reporting ledgers; base, local, or International Financial Reporting Standards (IFRS).

This functionality is controlled via the General Ledger Setup window (Microsoft Dynamics GP menu >> Tools >> Setup >> Financial >> General Ledger);

Reporting Ledgers: Enabling via General Ledger Setup

Continue reading →

Posted in Dynamics, GP, Microsoft | Tagged Configuration, Enquiry/Inquiry, Financials, General Ledger, GP, Microsoft Dynamics GP 2010, Payables Management, Purchasing, Reports | 1 Comment

Integrations Via eConnect Disappearing

Posted on 23rd September 2011 by Ian Grieve

As well as using eConnect to integrate journals from an external system into the GL, we also use it to integrate invoices into Payables Management. Overall we have far fewer problems integrating transactions via eConnect than we had in the past using Integration Manager, but we do still encounter some problems; usually with transactions being posted in the external system and then disappearing.

This is sometimes a more exotic reason but is usually an issue with the eConnect service needing to be restarted. When we first started using eConnect we often had problems when the server was rebooted as the eConnect service was starting before the MSMQ service and didn’t then function correctly.

To fix this issue we added a dependency to MSMQ on the eConnect service which ensures the eConnect one does not start until MSMQ is ready. This particular fix has just resulted in a site posting invoices in an external system which didn’t arrive in Microsoft Dynamics GP. Continue reading →

Posted in Dynamics, eConnect, GP, Microsoft | Tagged eConnect, GP, Integration, Microsoft Dynamics GP 2010, Payables Management, Purchasing | 3 Comments

Check Remittance Run-time error ’13′ – Type Mismatch: Follow Up

Posted on 1st September 2011 by Ian Grieve

Microsoft Dynamics GP We heard back from the Development Team in Fargo, who David Musgrave contacted regarding the issue we encountered with the Microsoft ActiveX Data Objects 2.7 Library.

They recommend that packages should be moved around using the Customisation Maintenance (Microsoft Dynamics GP menu >> Tools >> Customise >> Customisation Maintenance) to Import/Export the modified reports. Rather than doing this, which runs the potential risk of leaving client machines with an outdated REPORTS.dic we have been pointing the clients at a centralised REPORTS.dic on a server and copying only the Dynamics.vba to each client (we change the reports more often than the VBA).

Using Customisation Maintenance to Import the package file to each client would have prevented the problem as it would use the Microsoft ActiveX Data Objects 2.7 Library reference on the local machine. Doing it the way we do, by copying the VBA, transfers the reference within the VBA file.

This is an issue for internal discussion and we perhaps need to change the process we use for dictionary files.

Posted in Dynamics, GP, Microsoft | Tagged Check Remittance, Customisations, Errors, GP, Microsoft Dynamics GP 2010, Modified Reports, Payables Management, Payment Run, Purchasing, Report Writer, VBA | 1 Comment

Check Remittance Run-time error ’13′ – Type Mismatch

Posted on 31st August 2011 by Ian Grieve

Microsoft Dynamics GP I implemented the VBA workaround for cheque remittances on a test system for another client site, to make sure they don’t see the undefined symbol error, the other day after I upgraded Microsoft Dynamics GP 10 to GP 2010 and tested the remittance to ensure it worked. amend VBA on Server 2008 R2 SP1

When the client came to test the remittance themselves on the test Citrix Server they got a type mismatch error;