web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / eConnect and EFT
Microsoft Dynamics GP (Archived)

eConnect and EFT

(0) ShareShare
ReportReport
Posted on by Stanley Glass Jr 215
I am trying to get an EFT record into the system via eConnect. I am using the taPMManualCheck XML. However, I get the error "The Payment Entry Type (PYENTTYP) is invalid - 0=Check, 1=Cash, 2=Credit Card". In previous questions I was told I can just set the PYENTTYP = 3 for EFT. Is there something else I need to set to make this work? Is something not set up to make this work? Thanks, Stanley

*This post is locked for comments

I have the same question (0)
  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    You may be able to use the taPMManualCheck Post econnect stored procedure to override the payment type to 3.

  • Stanley Glass Jr Profile Picture
    Stanley Glass Jr 215 on at

    Thanks Mariano, but I am not sure what you mean. Does it make sense to just add an insert statement in th POST sproc? If so what table does the taPMManualCheck sproc hit? Since the normal sproc is encrypted I am unable to tell where the data should go. Does the data just get inserted into PM20000? If not what table does the data get inserted into?

     Thanks,

    Stanley

  • Stanley Glass Jr Profile Picture
    Stanley Glass Jr 215 on at

    Ok I see how eConnect will allow you to use the Pre and Post sprocs to do custom business logic, but I am still lost on what tables I need to insert the data into? Is there something that maps the transaction to the right tables? Since the sproc (original one) is encrypted I cannot see what tables are effected. And after doing some research I see where you can create you own eConnect sprocs and your own XML docs to be processed through eConnect, but no where can I find what tables I would need to insert the data into.

     Thanks

    Stanley

  • Community Member Profile Picture
    Community Member on at

    This bug still exists in GP2015. I was not able to use the POST procedure to override it as the values are already set in the database by the time the POST executes.

    Instead, I had to decrypt and modify the taPMManualCheck procedure. See the following line numbers and modifications below:

    Line 542:

    IF (

    @I_vPYENTTYP < 0

    OR @I_vPYENTTYP > 3

    )

    Line 553:

    IF (@I_vPYENTTYP in (0,3))

    Line 823:

    IF (@I_vPYENTTYP IN (0,3))

    Line 1071:

    WHEN (@I_vPYENTTYP = 0 OR @I_vPYENTTYP = 3)

    Line 1121:

    WHEN (@I_vPYENTTYP = 0 OR @I_vPYENTTYP = 3)

    I know modifying the encrypted procedures is not recommended, but it was the only thing that worked for me in this case.

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    Chad, I suggest you open a (non-chargeable) support case and report this to Microsoft. This is the only way this is going to get fixed permanently. You can reference this whole discussion thread in your case to help set the stage for the problem.

  • Community Member Profile Picture
    Community Member on at

    Mariano remember our conversation re SmartConnect and creating EFT files from a manual payment entry - I'm having the exact same issue I have manually edited the node list to include payment type 3 for EFT but its only accepting 0, 1 or 2 types - any ideas how to get round this?

  • Community Member Profile Picture
    Community Member on at

    Mariano remember our conversation re SmartConnect and creating EFT files from a manual payment entry - I'm having the exact same issue I have manually edited the node list to include payment type 3 for EFT but its only accepting 0, 1 or 2 types - any ideas how to get round this?

    KP

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans