DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
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

Archives

 
SOP Extended price not updating

I have written a customization for the sop entry window. Basically, when the qty on an item changes I populate the unit price based on some logic. This is all working fine, but I would expect the extended price to calculate after the unitprice is updated but its not. Is there somethign I need to do after setting the unitprice value to trigger the extended price to calculate?
How to read and use an xsd file in C#

I would like to know the C# equivalent of this VB code and if it will easily translate:

Dim sXsdDoc As New Xml.XmlDocumentsXsdDoc.Load("C:\\Program Files\\Common Files\\Microsoft Shared\\eConnect 10\\XML Sample Documents\\Incoming XSD Schemas\\eConnect.xsd");

 

I am receiving the following eConnect error which does not make sense when reviewing the xml:

System.ApplicationException: Root element (<eConnect>) not found. Please verify xml document.
<ROOT><eConnect><SOPTransactionType><taSopLineIvcInsert_Items>
<taSopLineIvcInsert><SOPTYPE>3</SOPTYPE><CUSTNMBR>04012147-P0000</CUSTNMBR><DOCDATE>2010-11-22T00:00:00</DOCDATE><ITEMNMBR>5898620000002</ITEMNMBR><UNITPRCE>3.75000</UNITPRCE><XTNDPRCE>487.50000</XTNDPRCE>
<QUANTITY>130</QUANTITY><LNITMSEQ>16384</LNITMSEQ><DOCID>INV</DOCID><KitCompMan>1</KitCompMan></taSopLineIvcInsert>
<taSopLineIvcInsert><SOPTYPE>3</SOPTYPE><CUSTNMBR>04012147-P0000</CUSTNMBR><DOCDATE>2010-11-22T00:00:00</DOCDATE><ITEMNMBR>5898620020003</ITEMNMBR><UNITPRCE>3.75000</UNITPRCE><XTNDPRCE>390.00000</XTNDPRCE>
<QUANTITY>104</QUANTITY><LNITMSEQ>32768</LNITMSEQ><DOCID>INV</DOCID><KitCompMan>1</KitCompMan></taSopLineIvcInsert>
</taSopLineIvcInsert_Items><taSopLineIvcInsertComponent_Items><taSopLineIvcInsertComponent><SOPTYPE>3</SOPTYPE><CUSTNMBR>04012147-P0000</CUSTNMBR><ITEMNMBR>58986100229</ITEMNMBR><QUANTITY>1</QUANTITY><LNITMSEQ>16384</LNITMSEQ>
</taSopLineIvcInsertComponent><taSopLineIvcInsertComponent><SOPTYPE>3</SOPTYPE><CUSTNMBR>04012147-P0000</CUSTNMBR><ITEMNMBR>E2-713</ITEMNMBR><QUANTITY>1</QUANTITY><LNITMSEQ>16384</LNITMSEQ></taSopLineIvcInsertComponent>
<taSopLineIvcInsertComponent><SOPTYPE>3</SOPTYPE><CUSTNMBR>04012147-P0000</CUSTNMBR><ITEMNMBR>L-5137</ITEMNMBR><QUANTITY>1</QUANTITY><LNITMSEQ>16384</LNITMSEQ></taSopLineIvcInsertComponent>
<taSopLineIvcInsertComponent><SOPTYPE>3</SOPTYPE><CUSTNMBR>04012147-P0000</CUSTNMBR><ITEMNMBR>M-75735</ITEMNMBR><QUANTITY>1</QUANTITY><LNITMSEQ>16384</LNITMSEQ></taSopLineIvcInsertComponent>
<taSopLineIvcInsertComponent><SOPTYPE>3</SOPTYPE><CUSTNMBR>04012147-P0000</CUSTNMBR><ITEMNMBR>M-78119</ITEMNMBR><QUANTITY>1</QUANTITY><LNITMSEQ>16384</LNITMSEQ></taSopLineIvcInsertComponent>
<taSopLineIvcInsertComponent><SOPTYPE>3</SOPTYPE><CUSTNMBR>04012147-P0000</CUSTNMBR><ITEMNMBR>54460000035</ITEMNMBR><QUANTITY>1</QUANTITY><LNITMSEQ>32768</LNITMSEQ>
</taSopLineIvcInsertComponent><taSopLineIvcInsertComponent><SOPTYPE>3</SOPTYPE><CUSTNMBR>04012147-P0000</CUSTNMBR>
<ITEMNMBR>L-5137</ITEMNMBR><QUANTITY>1</QUANTITY><LNITMSEQ>32768</LNITMSEQ></taSopLineIvcInsertComponent>
<taSopLineIvcInsertComponent><SOPTYPE>3</SOPTYPE><CUSTNMBR>04012147-P0000</CUSTNMBR><ITEMNMBR>M-74236</ITEMNMBR><QUANTITY>1</QUANTITY><LNITMSEQ>32768</LNITMSEQ></taSopLineIvcInsertComponent>
<taSopLineIvcInsertComponent><SOPTYPE>3</SOPTYPE><CUSTNMBR>04012147-P0000</CUSTNMBR><ITEMNMBR>M-93085</ITEMNMBR><QUANTITY>1</QUANTITY><LNITMSEQ>32768</LNITMSEQ></taSopLineIvcInsertComponent>
</taSopLineIvcInsertComponent_Items><taSopHdrIvcInsert><SOPTYPE>3</SOPTYPE><DOCID>INV</DOCID><DOCDATE>2010-11-22T00:00:00</DOCDATE>
<CUSTNMBR>04012147-P0000</CUSTNMBR><SUBTOTAL>877.50000</SUBTOTAL><DOCAMNT>877.50000</DOCAMNT><BACHNUMB>INV_Feb  2 2011</BACHNUMB></taSopHdrIvcInsert></SOPTransactionType></eConnect></ROOT>

Server stack trace:
   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.eConnect_EntryPoint(String ConnectionString, ConnectionStringType ConnectionType, String sXML, SchemaValidationType ValidationType, String eConnectSchema)
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.eConnect_EntryPoint(String ConnectionString, ConnectionStringType ConnectionType, String sXML, SchemaValidationType ValidationType, String eConnectSchema)
   at EconnectIntegration.Gateway.EconnectGateway.CreateInvoice() in H:\Finance\AutoBilling\eConnectIntegration\Gateway\EconnectGateway.cs:line 65

 
Salesperson not sticking on SOP Line Item
Hello all,

I'm currently migrating an Integration Manager process to one that uses eConnect like the rest of our integrations (GP10, eConnect10).

I've been fighting with some default requirements that eConnect requires, but Integration Manager didn't.  For example, IM doesnt require the Unit of Measure to be defaulted, but eConnect does.  Luckily eConnect would display the error to point me straight to the UofM as the issue.

Now however i'm now faced with not being able to set the Salesperson and Sales Territory (just DEFAULT) on the line item.  Below is the XML i'm using.  There is no error from eConnect, and the invoice & lines do get inserted, however these fields are blank on the "Sales Item Detail Entry" screen.

I've tried using a newly created salesperson, and i've traced eConnect to the taSopLineIvcInsert stored proc, but since its encrypted i cant see why it cant locate and set the Salesperson.

Has anyone else experienced any problems like this before?  Any other ideas on places to look?

Thanks for your help!
Checking security

Is it possible to add/hide menu items on a screen based on a users security. And if so, how do you get the users security?
How to do RE-visible operation for a Global Field?

On Receiving Transaction Entry form there is a Print button named: Print Button N .. which is a global field. Mistakenly i changed its VISIBLE property to FALSE using modifier. Now its not appearing on the form at all. How can i change its VISIBLE to TRUE again????
Your attempt to log into the server failed because the user ID you entered is already logged in. Remove the login record from the server and attempt to log in again.

Your attempt to log into the server failed because the user ID you entered is already logged in. Remove the login record from the server and attempt to log in again.

Wow. I was stuck on this for hours. I don't know exactly what happened, but I have enough information to be helpful.

Inactivate Direct Deposit in PayRoll

I recently developed an eConnect solution for Employee Maintenance. Everything is working well, except when an Employee is terminated, the Direct Deposit is not getting inactivated. I did not write anything specific to accomplish that. I assumed that eConnect somehow would handle it, behind the scenes.[:)]

The eConnect Schemas that I used for my purpose for Employee Termination are below:

UPR Create Employee schema
UPR Create Employee Benefit schema
UPR Create Employee Deduction schema
UPR Create Employee Pay Code schema
UPR Create Employee Local Tax schema
UPR Create Employee State Tax schema

I researched some and was unable to find to date any schema (eConnect nodes) etc to pass that information to inactivate Direct Deposit for an Employee. Am I missing something here?

 Please help. Any guidance would be appreciated.

Thanks!!! 

 
Windows firewall

Recently a colleague called to ask about getting Dynamics access to SQL through the firewall on a 2008 Server. I'm a little lazy, I usually just turn off the firewall. But, this machine is hosted remotely, so we thought better of that.

At any rate:

In order for GP 2010 clients to connect using the SQL Native client and the data connection that is created when GP installs, I  created inbound and outbound rules through the firewall port  (Domain only) for 1433 and 1434.
Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool.

Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool.

 I love my job. Really.

I'm used to seeing something like this in GP10, but this is GP2010. The eConnect WCF service that I use is local, there is no 'network communication' as far as the code is concerned.

Service cannot be started. The handle is invalid

GP2010:

Service cannot be started. The handle is invalid

and

The communication object, System.ServiceModel.ServiceHost, cannot be used for communication because it is in the Faulted state.

The bottom line is that I can't get the eConnect Servie to start. Grrrr.

how to add MDA transaction through eConnect9.0

HI,

I am using eConnect9.0 serialization to  enter new PM transaction to GP but we have a new requirement to add MDA for each distribution account. It means we need to add new record on DTA10100 and DTA10200 technically. I have no idea how to accomplish this. Please help. Thanking you.

Neerman
FRx Resources

FRx is... not really my thing. I never really had a customer ask me to help with it.

But today I have the task of taking a company from GP9 to GP2010 and I'm strambling for resources. Here's a list of what I'm using, so I don't lose it.

Note: Some of thes links may require a PartnerSource login.

How to move Microsoft FRx 6.7 to a new server

How to Install the Full Version of Microsoft FRx 6.7 - Knowledge Base Article

Microsoft Dynamics FRx 6.7 Service Pack Overview

Edit 2/18/2011:

From my friend Bob McAdam of GPUG fame:

Don’t forget, c’mon, that just because one upgrades to GP 2010 does NOT mean they have to upgrade FRx to Management Reporter (MR).  FRx will be supported thru 2012.
 
Also, MR does not work with GP v10, just GP 2010.

 


 
Time Matrix

Y'all know that I'm not a GP consultant, I'm a GP developer. I don't (generally) do the installs, they call me when the customer say something like: "In Quickbooks we use to <insert random insane request>" (Come on, you know you've heard that)

I make those things happen.

So, I don't generally get involved in setting up third party products. But in doing a GP9 to GP2010 upgrade I found myself having to upgrade quite a few, and having to call all these people for help.

I just had the best experience with the people at Time Matrix Time Clock (http://business-computers.com/). The did a screen share and held my hand through the entire test upgrade. Great service, kudos to Rick and team.

How can we use Batch feature in Banking module?

On any of the Bank Transaction screens, there is no option for batches. Is there any way of having batches in Bank transactions? is there any add-on or some custom app for this?
How to remove requisitions from Business Portal

This script will remove requisitions from Business Portal. Tested against GP10

Before proceding, *** backup up the DYNAMICS database.

 
eConnect 11

I'm trying to update my Web Apps that use eConnect to communicate with GP.

With eConnect 10 I was able to add the references right in and go from there...

However with eConnect 11 I keep getting the following error: 

Could not load file or assembly 'Microsoft.Dynamics.GP.eConnect' or one of its dependencies. An attempt was made to load a program with an incorrect format.

Anyone figured this one out?  I even tried building a new app that doesn't do anything but just has the .dlls for eConnect included as references...same thing.

 Thanks,

David Norvell
Can we use GP2010 VST to customize GP10?

Hello,

I've to customize GP10 using Visual Studio 2010. Unfortunately, i couldnt find any VST templates for VS2010. So i installed VST for GP2010 and it involved templates for VS2010. Can i use this GP2010 VST to customize GP10?
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3