Notifications
Announcements
No record found.
I need to create Payment/Receipts for the Customer and Vendor ID and add it to a Batch with the Help of Econnect SQL SP.And the Payment Method is EFT. Can Some one guide me in this , what are all the Econnect Stored procedure should I have to use for creating Payments/Receipts and which window will it Affect in GP.
Below is the DOCS link for econnect Schema:
docs.microsoft.com/.../ff623651(v=msdn.10)
For Payables, you can integrate manual checks (Transactions | Purchasing | Payables | manual checks).
For Receivables, you can integrate in cash receipts (Transactions | Sales | Receivables | Cash receipts).
Here are some other community posts you may find helpful:
community.dynamics.com/.../payments-integration
community.dynamics.com/.../how-to-add-a-payable-transaction-using-econnect
I hope that helps,
Cheryl W
Dynamics GP support
Cheryl, there appears to be no eConnect node to import credit memos and apply them to AP invoices. Even importing manuals checks does not give you a mechanism to accomplish this.
Under Transactions | Purchasing | Transaction entry (eConnect node for Transactions), you can then specify the Document type for Invoices, Finance charges, Misc charge, Return or Credit memo. So I would assume that all those types would fall user the taPMTransactionInsert node, and you would select the appropriate doc type. Take a look at that to see.
Yes, that is true but there is nothing you can specify to which apply the credit memo.
You may be correct on the apply piece. It can bring in the credit memo, so you'll just have to manually apply it then.
Rm has a separate 'Apply' integration, but it doesn't appear that PM does. So you'd have to process the credit memo in RM, and then apply it separately.
Cheryl, there are over 300 of these credit memos to apply. I am going to need to do a direct record creation in the payables apply table.
By the way, I just ran the integration for the first time. I am receiving error codes :
769 Account number string does not exist
936 Vendor Number does not exist
I have dumped the xml to the screen and the GL account is correct and so is the vendor, they both exist with no extra spaces. When I enter the transaction in GP it goes in with these code. Any suggestions?
Hello Richard,
Both of the errors are under the taPMDistribution node, so you'll want to make sure the vendor ID in your test file exists in the PM00200 table. You also have the option to pass either the account index or the account string. If you are passing the account number, make sure it exists identical to what is in the ACTNUMST column in the GL00105 table. The string has to match there. It should work as long as they exist the same in those tables. If you still can't get it, it may be best to open a support case so an engineer can review your data with you.
Cheryl, we are making progress here. I checked the connect string just before calling eConnect and it was pointing the the TWO database. I think what I am going to do is import all these credit memos and then create s stored procedure to go through each one in the batch and create a record in the payables apply table.
Cheryl, after I back fill all these PM apply documents how do I get them into history? Will AP reconcile move them to history? That is the ultimate goal of all of this. They have 6 years of credit memos to remove.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 664 Most Valuable Professional
André Arnaud de Cal... 522 Super User 2025 Season 2
Sohaib Cheema 303 User Group Leader
