DynDeveloper.com - Your Dynamics GP Questions, Answered

Search the GP Tables

Search by TABLE NAME

Search by FIELD NAME

These are our SOP scripts. All of our scripts for Dynamics GP can be found here

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

Archives

Trying to create a db connection in vb.net using active GP user credentials

I am running the latest GP version. In GP's VB editor, if I added validation to a field by checking its value against conditions for data in other tables, I would use UserInfoGet.CreateADOConnection to create a connection to query the SQL server. Since that VB code doesn't work on Windows Server 2019 and after, I have decided to code the validation for the field in vb.net using Visual Studio 2022. I have added the GP tools to VS, created a GP vb.net project, added GPConn, GPConnNet, and Dynamics.ModifiedForms to the Project, coded Imports for GPConn and Microsoft.Dexterity. GPConnection. I need a way to pass the user's credentials to create a data connection in vb.net, as UserInfoGet is not recognized in vb.net with the references I have installed. I don't want to have to hard code sa credentials in the script or call an ODBC connection (that uses sa credentials) to run a simple query.

Could someone show a good way with vb.net to pass the active GP user credentials to a data connection so I can run a SQL query? If not, should I use C#, and what would the options be there?

Thank you.

AP Manual Payment

I am fairly new to GP and would like to know the specific eConnect node that should be utilized for importing AP Manual Payment data.

AP Payments and Apply Import

Hello,

Do you know of a way to import payables payment transactions to be applied to posted invoices?

Thank you!

Automatically close RemoteApp GP sessions so that the user is logged out

I am running GP on a 2022 Windows server and publish it to users as a RemoteApp. That RDP server is set to reboot every weeknight in the early morning. Sometimes users won't close out GP before they shut their laptops and go home for the night. I am looking for a way to force the close of open GP RemoteApp sessions that logs the user out of GP properly, so that a license is not held hostage by the user's forgetfulness. I had written a powershell script to run as a Scheduled Task on the RDP server that would look for open RemoteApp sessions that had the Dynamics process running. It would call focus to the main Dynamics window and use SendKeys to run a logout and close macro. However, RemoteApps doesn't allow the AppActivate method to set focus and doesn't allow the Win32 ShowWindowAsync and SetForegroundWindow methods to pull the needed MainWindowTitle or MainWindowHandle properties to set focus.

I feel like I'm banging my head against a brick wall. Is there any good way to properly close GP out in a RemoteApp session? I really like RemoteApps and don't want to have to send users back to the full Remote Desktop experience to use GP, but users forgetting to close out properly is causing problems.

Any help is appreciated!

Table Definition Quick Links

All Tables

SOP Tables

RM Tables

GL Tables

POP Tables

HR Tables

PM Tables

UPR Tables

IV Tables

Olympic Tables