Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Post Credit Payments to Dynamics GP

Posted on by Microsoft Employee

With eConnect can we post the bill payments which are made using Credits to GP?

Please let me know the details on this.

For example if I create a vendor credit of $100

I create a bill for $100 for the same vendor

I make the bill payment using the vendor credit $100

I would like to know if the same can be done through API - using the vendor credits for bill payments and post that to GP.

I referred to the documentation at: https://msdn.microsoft.com/en-us/library/ff623996.aspx 

<taPMManualCheck>

But here I see the payment type as only: 

Payment entry type:

PYENTTYP  

0=Check;

1=Cash;

2=Credit card

Similarly do we have anything which can post the credit payments to GP.

Please share your thoughts..!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Post Credit Payments to Dynamics GP

    Thank you Leslie for your response..!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Post Credit Payments to Dynamics GP

    From your earlier responses I understand that we can use taPMManualCheck node to import the payments (payment entry types: 0=Check; 1=Cash; 2=Credit card).

    And later use the taPMManualCheck_POST SQL Server stored procedure to create the apply record(s) for the payment. (Infact, today we use Precipio APApply library to do this).

    I just wanted to confirm if taPMManualCheck_POST SQL Server stored procedure can also be used to create the apply records for the payment which are made using CREDITS.

    Since I do not see a payment entry type as Credits (we see only payment entry types: 0=Check; 1=Cash; 2=Credit card) for taPMManualCheck I am unsure if this can be done.

    Apologies if my understanding is wrong and if I am putting too many questions..!

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Post Credit Payments to Dynamics GP

    I don't really think you are paying attention to what I wrote or are simply reading over it.

    As I said before, there isn't a node to do the apply. You need to extend the stored procedure I previously indicated to do the apply yourself and use the User Defined fields in the node to pass in the invoices you are going to apply against.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Post Credit Payments to Dynamics GP

    Hi,

    I do not believe there is a node for applying credit documents or payment types.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Post Credit Payments to Dynamics GP

    taPMTransactionInsert node can be used to import credit memos by setting the DOCTYPE=5.

    But my question is about using these credits - paying bills using these credits.

    I would like to know if I can import the credit payments to GP through API.

    Thanks a lot for your time Mariano..!

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Post Credit Payments to Dynamics GP

    And as I mentioned in my previous response, yes, you can! The credits can be imported using the taPMTransactionInsert node and setting the DOCTYPE value to 5.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Post Credit Payments to Dynamics GP

    Thanks for your response..!

    Sorry for the terminology which caused confusion.

    I mean to ask if we can import the payments to GP which are made using vendor credits.

    we use taPMManualCheck in which the payment entry types available are:

    0=Check;

    1=Cash;

    2=Credit card

    Similarly I would like to know if there is any way that we can import the credit payments (NOT Credit Card) to GP.

  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Post Credit Payments to Dynamics GP

    Let's get the terminology right first, before any help can be provided.

    With eConnect you import transactions into GP. Posting a transaction is a totally separate operation, which eConnect is not capable of handling.

    You can effectively import the vendor invoice using the taPMTransactionInsert node. In this node a DOCTYPE value of 1 is used for importing invoices. Once you import the invoice, you can use the taPMManualCheck node to import your credit card payments.

    Unfortunately, there isn't a node to apply the payment, but you can extend the taPMManualCheck_POST SQL Server stored procedure to create the apply record(s) for the payment, if you somehow manage to specify the list of invoices you need to apply against. The way I resolved this part was by using a text field, like the USRDEFND4 field on that node to pass in the list of invoices, separated by some delimiter, i.e., IVC1;IVC2;IVC3, etc., which can easily be parsed out. The USRDEFND4 field supports up to 8000 characters, if you need more, you can also use the USRDEFND5 field, which, when combined with the USRDEFND4, now gives you access to 16000 characters.

    If you need to automatically post the transaction after imported, you will need something like Batch Posting Services Toolkit from David Musgrave overall at Winthrop Development Consultants. This tool uses the Service Based Architecture platform (REST services exposing WCF endpoints) to send the posting instructions to the application.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Post Credit Payments to Dynamics GP

    Can any one please shed some light on this..?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Post Credit Payments to Dynamics GP

    Any one please share some inputs here..

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans