#MSCONNECT GP – Bug in taGetPMNextVoucherNumber causes duplicate voucher numbers to be issued

Time to vote.

This is the fourth in a series of blog posts where I will be highlighting Microsoft Connect product suggestions that need the community’s support. If you agree with the product suggestion, please help get as many votes as you can.

The issue which is the subject of today’s article is eConnect calls for getting the next transaction number generating duplicate numbers, submitted by Steve Endow.

This issue affects sites using eConnect where they have a high throughput of documents happening at the same time. The code that provides the next transaction number is not contained in a SQL Transaction which means it does not detect if the code is being executed more than once at the same time and so two independent calls can receive the same next transaction number. This will cause the second of the transactions to fail to import with a duplicate number error.

I know that Steve’s product suggestion references the Payables Management script (taGetPMNextVoucherNumber), but I would like all of the related “GetNextNumber” scripts reviewed and fixed if necessary.

For more information on the issue, see Steve’s blog post:

• eConnect Error: Voucher Number already exists in PM Keys Master Table PM00400

So if you think it is important that these eConnect scripts are fixed so they can handle the multi user concurrency issues without returning duplicate numbers, please vote using the links below.

Click on the link below:

• GP – Bug in taGetPMNextVoucherNumber causes duplicate voucher numbers to be issued

Here is the URL for the link

• https://connect.microsoft.com/dynamicssuggestions/feedback/details/2743832/bug-in-tagetpmnextvouchernumber-causees-duplicate-voucher-numbers-to-be-issued

Note: If the link does not work for you, go to https://connect.microsoft.com/directory/ and sign in with your Microsoft Account (MSA) and then find Microsoft Dynamics – Microsoft Dynamics GP in the list and click Join. Then try the links above again.Thanks

David

This article was originally posted on http://www.winthropdc.com/blog.