News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Creating transactions ...

Microsoft Dynamics GP (Archived)

Creating transactions with Dexterity

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

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

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Mariano Gomez 26,225 on at

Like (0)

Report

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

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans