GP Web Services PMTransaction duplicate voucher numbers

(0) Share

Report

Posted on by AndrewHN

125

Hello everyone,

I'm using the GP Web Services to send payables transactions to GP. I have a situation where i need to have multiple transactions with the same voucher number. The web service fails when trying to do this (validation exception: key already exists in PM Keys Master.)

It makes sense to me why the web service does not allow this, but i have not been using it for very long and i thought someone more experienced with the web service might be able to tell me for sure whether or not I can i can get around this problem and create multiple transactions with the same voucher number ... or if i need to look into a different solution. Is there anything i am missing that could help me out, or am I stuck?

Thanks!

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: GP Web Services PMTransaction duplicate voucher numbers

In table PM key master the primary key is combination of voucher number and document type. Therefore, for same document type the voucher number cannot be same. The voucher number can be same for different document type. That is there can be an invoice and payment with voucher number say 1234 but not two invoices can be of same voucher numbers.

If it is helpful in your case, the document numbers can duplicate. You can turn on Allow Duplicate Invoices Per Vendor setting payable setup for vendors.