Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Is it possible to assi...
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) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Is it possible to assign a voucher number (VCHRNMBR/VCHNUMWK) for a bill which is synced using Enter/Match Invoice to GP using eConnect.

    Thanks a lot for your response Almas..!!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Is it possible to assign a voucher number (VCHRNMBR/VCHNUMWK) for a bill which is synced using Enter/Match Invoice to GP using eConnect.

    Thanks a lot for the response Vaidy Mohan..!

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

  • Verified answer
    Vaidy Mohan Profile Picture
    Vaidy Mohan 351 on at
    RE: Is it possible to assign a voucher number (VCHRNMBR/VCHNUMWK) for a bill which is synced using Enter/Match Invoice to GP using eConnect.

    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.

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: Is it possible to assign a voucher number (VCHRNMBR/VCHNUMWK) for a bill which is synced using Enter/Match Invoice to GP using eConnect.

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Is it possible to assign a voucher number (VCHRNMBR/VCHNUMWK) for a bill which is synced using Enter/Match Invoice to GP using eConnect.

    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.

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: Is it possible to assign a voucher number (VCHRNMBR/VCHNUMWK) for a bill which is synced using Enter/Match Invoice to GP using eConnect.

    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?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Is it possible to assign a voucher number (VCHRNMBR/VCHNUMWK) for a bill which is synced using Enter/Match Invoice to GP using eConnect.

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Is it possible to assign a voucher number (VCHRNMBR/VCHNUMWK) for a bill which is synced using Enter/Match Invoice to GP using eConnect.

    Can some one please suggest!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans