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

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Creating transactions with Dexterity

(0) ShareShare
ReportReport
Posted on by

It has been a while since I have done a lot of Dexterity integration work but I need to be able to create new SOP transactions using Dexterity.  I know there is eConnect that can be used through VSTools and SQL but am not sure if there is something similar or a way to access the eConnect stored procedures through Dexterity.  I have done it in the past by adding records to all of the affected tables but am hoping things have changed and there is a better way to do this as this method does not enforce any built in business logic the way eConnect does.

Can anyone point me to any links for learning how to do this?

Thanks!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mariano Gomez Profile Picture
    26,225 on at
    RE: Creating transactions with Dexterity

    You can call eConnect stored procedures from Dexterity via one of two mechanisms:

    1. You can create a prototype procedure (sproc) from Dex for the eConnect stored proc. Take a look at my article dynamicsgpblogster.blogspot.com/.../calling-sql-server-stored-procedures.html

    2. You can use pass-through SQL from Dex. This old thread shows how to use the SQL_Execute(), microsoft.public.dynamics.gp.developer.narkive.com/.../complex-database-queries-in-dexterity

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans