Microsoft Dynamics GP (Archived)

Is it possible to assign a voucher number (VCHRNMBR/VCHNUMWK) for a bill which is synced using Enter/Match Invoice to GP using eConnect.

(0) Share

Report

Posted on by Community Member

Hi,

I am sending bills for Purchase Orders to GP using eConnect (taPopEnterMatchInvHdr).

For those bills is it possible that we assign a voucher number?

I am only able to get the voucher number after posting the bills.

For a normal transaction entry, I usually get the nextVoucherNumber and assign the voucher number to the bill even before posting the bill.

I would like to have the same for PO linked bills.

I would like to assign the voucher number while syncing the PO linked bills to GP.

Kindly, suggest me.

Thanks in advance..!

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

Can some one please suggest!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I tried setting the value for VCHRNMBR in POP10300 table. But still when we post the batch, GP do not seem to consider the VCHRNMBR I set it here.

Was this reply helpful? Yes No
Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

what exactly you are trying to achieve? your question is not clear. With which eConnect node you are linking your VCHRNMBR? What is exactly bill, which GP document you are calling bill? from where you get the next voucher number that you assigned to the bill?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I am using taPopEnterMatchInvLine_ItemsTaPopEnterMatchInvLine to match the invoice lines.

when we post the batch, we get the PM20000 table updated with a new row for invoice and we see VCHRNMBR here.

I would like to set this voucher number before posting the purchasing batch.

I use the stored procedure: taGetPMNextVoucherNumber to get the next Voucher number.

For a Purchasing Transaction Entry, we use taPMTransactionInsert and here we can set VCHNUMWK (that is the nextvoucherNumber which I get from GP)

I would like to achieve the same for POP Invoice as well.

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

This is what I get from your post, you are creating purchase receipt invoices through eConnect and wants to create the payables at the same time. You are correctly using taGetPMNextVoucherNumbe all you have to do is to extend your calling script and create voucher same time when you are creating receiving invoice.

Was this reply helpful? Yes No
Verified answer

Vaidy Mohan 351 on at

Like (0)

Report
Copy link

Link copied!

When you post a POP matching invoice, it posts a PM invoice with an auto-generated voucher number at runtime. I don't think you have a control over this process. The VCHRNMBR field in POP10300/POP30300 table is merely a link field which will get updated with the voucher number once a corresponding PM invoice is created in PM20000 table.

Because voucher number is referred in several control related tables within Payables/POP modules, it's not wise to write triggers to overwrite the auto-generated value.

I'd recommend to store your voucher number value somewhere else, if it is not something you can do away.

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot for the response Vaidy Mohan..!

It is now confirmed that assigning voucher number for POP invoices is not in our control.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot for your response Almas..!!

Was this reply helpful? Yes No