DynDeveloper.com

The first line of code is the hardest. Where to start?

Our mission here is RAD. Rapid Development. To that end, without much discussion, you'll find below the first code that you'll need to write a VSTools modification. The sample code is on the PM Vendor Maintenance window, but any window will do.

If you've been around here for any length of time, you'll know that we're not fond of long, overly wordy articles. Our job is to get you coding quickly.

This article contains a snippet of code that will use  to get the next IV Transfer number

Today a user asked us for some ADODB example, code to call a stored procedure with parameters. I saw that we didn't have an existing article, so I'm adding it.

Our job here is not to teach you the in-depth machinations of how code works. Our job is to give you code examples so that you can get back to the business of coding faster.

Enjoy.

Error: Unable to update/create PO Line record - POP10110 table

En los próximos meses la expresa va a migrar de GP a NAV. Mi pregunta es si en este sitio se podrá hacer consultas sobre Dynamics Nav?

Saludos.

La ventana de cheques Micelanios , que se encuentra en el menú transacciones -> Finanzas no permite crearle un acceso directo ya que esta opción aparece desactivada en el menú File.

La pregunta es : Es posible habilitar esta opción y como se hace?

Miscellaneous checks window , (Transactions > Financial > Miscellaneous Checks) does not allow create you a shortcut as this option is disabled in the File menu. The question is : Can you enable this

Hi All :

 Is there a way we can get Checkbook balance based on CheckbookID through GP web service ?

 I am trying to retrieve the value related to Checkbook balance in Checkbook maintaince screen ?

Thank You ,

Jaswanth

I have a function to update the Location Code in a SO transaction which is working properly but the problem is that the SO transaction's contact info was changed too. I'm not even touching the sop transaction's address  fields. Maybe I have to...I don't know.

why the transaction's contact info is being modified? how is GP selecting the new contact info?
what are the minimum transactions fields do I need to specify when I want to update the SO transaction?

here is my code

 Sub ModifWarehouse(ByVal strSOPNUMBE As String, ByVal intSOPTYPE As Int16, ByVal strDOCID As String, ByVal strCUSTNMBR As String, ByVal dtDocDate As String, ByVal strBACHNUMB As String, ByVal loc As String, ByVal poNum As String)
        Try
            Dim sConnectionString = ConfigurationManager.ConnectionStrings("eConnectConnectionString").ConnectionString
            Dim intNumberOfLines As Int16 = 0 '0 = 1 line
            Dim salesOrderDocument As String
            'declare our eConnect classes
            Dim oeConnectType As New Microsoft.Dynamics.GP.eConnect.Serialization.eConnectType
            Dim oSOPTransactionType As New Microsoft.Dynamics.GP.eConnect.Serialization.SOPTransactionType
            'this is our custom eConnect Class, you can find it here: http://dyndeveloper.com/thread.aspx?Threadid=1117
            Dim eConCall As New eConnectMethods
            'Done Serializing
            '************************* 
            ReDim Preserve oeConnectType.SOPTransactionType(0)
            oeConnectType.SOPTransactionType(0) = oSOPTransactionType

            Dim z As Integer = 0
            Dim itemList As List(Of taSopLineIvcInsert_ItemsTaSopLineIvcInsert) = ModifWarehouseInOrderLines(strSOPNUMBE, intSOPTYPE, loc, strDOCID, dtDocDate, poNum, strCUSTNMBR)


            For Each item As taSopLineIvcInsert_ItemsTaSopLineIvcInsert In itemList
                ReDim Preserve oSOPTransactionType.taSopLineIvcInsert_Items(z)
                oSOPTransactionType.taSopLineIvcInsert_Items(z) = item
                z = z + 1
            Next

            'create the document header
            Dim otaSopHdrIvcInsert As New Microsoft.Dynamics.GP.eConnect.Serialization.taSopHdrIvcInsert
            'populate the header
            With otaSopHdrIvcInsert
                'these are the required fields
                .SOPNUMBE = strSOPNUMBE
                .SOPTYPE = intSOPTYPE
                .DOCID = strDOCID
                .CUSTNMBR = strCUSTNMBR
                .DOCDATE = dtDocDate
                .BACHNUMB = strBACHNUMB
                .UpdateExisting = 1
                'this is the field that we're updating. 
                .LOCNCODE = loc
                .CSTPONBR = poNum
            End With
            'assign the header to the master
            oSOPTransactionType.taSopHdrIvcInsert = otaSopHdrIvcInsert
            ReDim Preserve oeConnectType.SOPTransactionType(0)
            oeConnectType.SOPTransactionType(0) = oSOPTransactionType

            Dim xmldoc As Xml.XmlDocument = eConnectOrderToXMLDocument(oeConnectType)
            salesOrderDocument = xmldoc.OuterXml

            eConCall.UpdateTransactionEntity(sConnectionString, salesOrderDocument)
        Catch ex As System.ServiceModel.FaultException(Of eConnectSqlErrorCollection)
            Dim strMessage = ex.Detail(0).Message
            MsgBox(ex.Message + ". In ModifWarehouse method")
        Catch ex As System.ServiceModel.FaultException(Of Microsoft.Dynamics.GP.eConnect.eConnectFault)
            Dim strMessage = ex.Detail.Message
            MsgBox(ex.Detail.Message + ". In ModifWarehouse method")
        Catch ex As Exception
            MsgBox(ex.Message + ". In ModifWarehouse method")
        Finally
        End Try
    End Sub

---------------------------------------------

Function ModifWarehouseInOrderLines(SOPNUMBE As String, SOPTYPE As Int16, ByVal newLoc As String, ByVal strDOCID As String, ByVal strDocDate As String, ByVal poNum As String, ByVal strCUSTNMBR As String) As List(Of taSopLineIvcInsert_ItemsTaSopLineIvcInsert) ' Microsoft.Dynamics.GP.eConnect.Serialization.taSopLineIvcInsert_ItemsTaSopLineIvcInsert
        Dim val As Boolean = False
        Dim itemList As New List(Of taSopLineIvcInsert_ItemsTaSopLineIvcInsert)
        Dim sConnectionString = ConfigurationManager.ConnectionStrings("eConnectConnectionString").ConnectionString
        Dim oeConnectType As New Microsoft.Dynamics.GP.eConnect.Serialization.eConnectType
        Dim oSOPTransactionType As New Microsoft.Dynamics.GP.eConnect.Serialization.SOPTransactionType
        Try
            'get an XML document that represents the customer 
            'this uses our SalesTransactionRetrieve class documented here
            'http://dyndeveloper.com/articleview.aspx?ArticleID=173
            Dim oSalesTransactionRetrieve As New SalesTransaction
            oSalesTransactionRetrieve.retrieveSalesTransaction(SOPNUMBE, SOPTYPE)
            Dim strSOPTrans As String = oSalesTransactionRetrieve.SOPDoc

            '==========================================================
            'parse the line
            '==========================================================
            'strSOPTrans is an XML document in string form
            'parse it into XDocument form
            Dim doc = XDocument.Parse(strSOPTrans)

            'use Linq-to-XML to select just one sop line in the document. 
            Dim query = _
                From c In doc.<root>.<eConnect>.<SO_Trans>.<Line>
                Select c

            'turn it back into a string so we can edit it a little
            Dim line As String
            For Each element As System.Xml.Linq.XElement In query
                RemoveAllInecesaryNodes(element) 
                line = element.ToString
                line = Replace(line, "Line", "taSopLineIvcInsert_ItemsTaSopLineIvcInsert")

                Dim sopNumber = element.Element("SOPNUMBE").Value
                Dim qty = element.Element("QUANTITY").Value
                Dim itemnum = element.Element("ITEMNMBR").Value
                Dim PRCLEVEL = element.Element("PRCLEVEL").Value
                Dim myReader As New StringReader(line)
                'Deserialize the XML node from the StringReader into the taSopLineIvcInsert_ItemsTaSopLineIvcInsert object.
                Dim oXmlSerializer As New XmlSerializer(GetType(taSopLineIvcInsert_ItemsTaSopLineIvcInsert))
                'Cast the deserialized object to a taSopHdrIvcInsert serialization object
                Dim otaSopLineIvcInsert As taSopLineIvcInsert_ItemsTaSopLineIvcInsert = CType(oXmlSerializer.Deserialize(myReader), taSopLineIvcInsert_ItemsTaSopLineIvcInsert)
                With otaSopLineIvcInsert
                    .LOCNCODE = newLoc
                    .CUSTNMBR = strCUSTNMBR
                    .DOCID = strDOCID
                    .DOCDATE = strDocDate
                    .SOPNUMBE = sopNumber
                    .SOPTYPE = SOPTYPE
                    .QUANTITY = qty
                    .ITEMNMBR = itemnum
                    'these fields are not required, but they will be 0 or '' if the value is not set
                    .PRCLEVEL = PRCLEVEL
                    otaSopLineIvcInsert.UpdateIfExists = 1
                End With

                itemList.Add(otaSopLineIvcInsert)
            Next
        Catch ex As Exception
            Throw New Exception(ex.Message)
        End Try
        Return itemList
    End Function

Please note that the Primary Vendor ID is 03822 for item 549535.      Where is the Primary Vendor ID assigned and maintained ?  And which GP table ?

Thank you,

K. Koehle

Deseo aprender a crear add-ins en visual estudio, pero por mas que intento instalar los componentes no logro que me funcione. no me aparece dynamic en new proyect.

yo utilizo GP10.0, Visial estudio 2010 y windows 7. podrian ayudarme para lograr configurar mi maquina e iniciar las practicas con add-ins. 

I want to learn how to create add-ins in Visual Studio, but I try to install more components that I can not work for me . I do not appear in new 'Dynamics' project.

I'm using GP 10, Visual Studio 2010 and Windows 7. Can you help me to set up my machine and start practices with add- ins.

HI All

I write a stored procedure to get check book balance using checkbook id.

How to call the store procedure in .NET application  using econnect.

Thank You ,

Prakash

I have a third-party database that resides on my GP Server.  I'd like to create a Smartlist using Smartlist Designer.  It appears that I can't add the tables for the third-party application.  Instead, I will have to create views to the third-party application within the GP Database.  

Is that accurate?  For some reason, I thought that Smartlist Designer would let me touch any database/table on the Dynamics SQL server.  

Thanks 

We are running GP 2010 and using eConnect to integrate inventory adjustment transactions.  We want to force the unit cost per line item on the transaction, but GP seems to be changing our specified costs to the current cost somewhere in the background.  Below is the XML we are submitting.  For the line with item number 07T-10501 we are passing $17.15 as the unit cost.  The integration goes through without error, but then when we look at the transaction in GP the cost is showing $16.71 (the current cost of that item).  How can we get it to persist to the number we are passing, $17.15?