Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

eConnect: user defined fields

Posted on by Microsoft Employee

I am using taPopEnterMatchInvHdr and taPopEnterMatchInvLine_ItemsTaPopEnterMatchInvLine

to sync a POP invoice to GP.

I am using eConnect to do this.

I set values for the USRDEFND1 for both taPopEnterMatchInvHdr and taPopEnterMatchInvLine_ItemsTaPopEnterMatchInvLine, but I am not sure where these values are actually stored in GP when I send the POP invoice to GP.

Can some one please let me know.

I would like to have some column in POP10300 table and that value should persist to table PM20000 when the pop invoice is posted  ( similar to DOCNUMBR) so that I use the value from this column for some reference later.

Kindly, suggest! 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect: user defined fields

    Sorry for being not clear enough in my earlier message!

    My requirement is not specific to user defined fields.

    My requirement is basically which I raised in other query: https://community.dynamics.com/gp/f/32/p/233196/637659#637659

    We sync the entities from GP to and fro our application.

    So for example if we sync a bill from GP to our application, the bill have the VCHRNMBR which is unique.

    And say if a bill is syncing from our application to GP the bills are stored in the batch and later user may post a bill.

    For normal bills (Purchasing->Transaction Entry) when we sync a bill from our application to GP, we get the nextVoucherNumber (using the stored procedure: taGetPMNextVoucherNumber) and set it in the taPMTransactionInsert VCHNUMWK field and we save this voucher number in our application DataBase as well.

    Now we are implementing the POP invoice sync in our application.

    So when we create a POP invoice in our application, we are syncing the bill to GP using taPopEnterMatchInvHdr and taPopEnterMatchInvLine_ItemsTaPopEnterMatchInvLine.

    Here the API do not have a facility to set the nextVoucherNumber in these nodes.

    So our application DB will not have the reference of this bill.

    So what I was trying to do is: 

    if there is a column where I can set some value from our DB and later when the user posts the bill, if this column value is persistent (in PM20000 table) we can take the reference and send back the VCHRNMBR to our DB.

    Hope this is now clear..

  • Vaidy Mohan Profile Picture
    Vaidy Mohan 351 on at
    RE: eConnect: user defined fields

    I am confused to be honest. Could you please explain how the user defined values should flow from your app to GP and back to your app?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect: user defined fields

    Thanks a lot for quick response!

    But the purpose is not for reporting.

    We usually sync the invoice from our application to GP and then sync back the VCHRNMBR from PM20000 table to our application database.

    Being it is a POP invoice, I would not get this VCHRNMBR when I send the POP invoice (it is still in batch) to GP from my application (using eConnect) there should be some reference from my application to later sync back the VCHRNMBR from GP once posted.

    Hope you understand the purpose.

    Please let me know if I can achieve this by any means. It would be of great help to me.

  • Verified answer
    Vaidy Mohan Profile Picture
    Vaidy Mohan 351 on at
    RE: eConnect: user defined fields

    Though, posting POP invoice automatically create & post a PM invoice, both are still totally different transactions in GP technically. Which means, you won't get to see POP user defined values in POP10306 automatically in PM20000. Bad news, this is not possible either.

    However, if this is purely for reporting purposes, you could link PM20000 to POP30300, and POP30300 to POP10306. I am against any unnecessary customisation, so this is probably your best bet.

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans