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

 
SQL - Group by Grouping Sets examples

I’m trying to get the hang of the ‘Group By Grouping Sets’ syntax, and I’m always having to look it up. Here is a quick little bit of example code that will get you started

GROUPING SETS ( )

Specifies multiple groupings of data in one query. Only the specified groups are aggregated instead of the full set of aggregations that are generated by CUBE or ROLLUP. The results are the equivalent of UNION ALL of the specified groups. GROUPING SETS can contain a single element or a list of elements. GROUPING SETS can specify groupings equivalent to those returned by ROLLUP or CUBE. The <grouping set item list> can contain ROLLUP or CUBE.

( )

The empty group generates a total
Excel - Code to populate a spreadsheet from a dataset and selectively format

Earlier, we created a video tutorial on populating an Excel spread sheet with data from a data set. 

A new requirement has come in to format some of the rows (in our case, the 'total' rows). 

The code sample below builds on the earlier video tutorial and shows how to format cells, too
eConnect - SOP Create Order

This is a code sample for how to create a SOP order in eConnect. 

Objects used: SOPTransactionType, taSopHdrIvcInsert, taSopLineIvcInsert_ItemsTaSopLineIvcInsert.

You'll need the eConnectFunctions class located here: http://dyndeveloper.com/thread.aspx?Threadid=1117

 
Web Services - GetVendorByKey example

This is a working code example for how to get a vendor in Dynamics GP 2010 Web Services. We use the getVendorByKey method to return a vendor object.
Creating a Windows Service in Visual Studio 2010 Part 2

This is the second article on Creating a Windows Service in Visual Studio. The first article is located here, and covers creating the service. 

This article will cover creating the Setup and Deployment project. 

 
How to insert images on DynDeveloper.com

This is a short walk through on how to insert images into a post or article in DynDeveloper.com
Telerik - How To Create A Line Chart And Save It To Disk

This article will show how to create a line chart using the Telerik Win Form charting controls and save it to disk

In a recent project I needed to set out statistics to users. I had the idea of creating a chart, saving it to disk, and then emailing it out nightly. In the code sample below I walk through the process of creating the chart and then saving it. 

In a separate article I'll cover how to include it in an email. 

It's all pretty self explanatory, but one difficulty I had was in dealing with the dates. The chart doesn't handle date types, you have to convert them to Julian dates in the SQL query to get them to work, like this:

datediff(day,'1/1/1900',logdate) + 2 as julianDate

You'll also see 'ToAODate()' in the code, that's the VB way of doing the same thing. 
Web Services - GetSalesInvoiceByKey

This code example shows how to code the retrieve a sales invoice using the GetSalesInvoiceByKey endpoint.
System.XML.Serialization Serialize a Class into an XML Document

Here is a simple code example showing how to take a VB Class object and use Xml.Serialization to turn it into an XML string. I had a little trouble finding this code because all the examples wanted to write the XML to disk using a StreamWriter… I needed it in memory as a string 

The resulting string looks like this:
Decrypt a SQL Stored Procedure

This article shows a SQL Script that will decrypt stored procedures in SQL. I've only test this in SQL 2000 but the author (noted in the script) claims that it will work on 2005 and 2008 also. 

 
SQL - Determining the size of tables

This stored procedure will print out the size of the tables in a SQL database. It has been tested on SQL 2000, 2005, and 2008.
Excel - Format a Column As Numeric

This short code example shows how to format a column as numeric in Excel

Problem with taSOPDistribution

Error Message:

taSopDistribution expects parameter @I_vSOPTYPE

The following is the XML and each distribution has SOPTYPE specified. Where is the error?

<?xml version="1.0" ?>
    <SOPTransactionType>
        <eConnectProcessInfo xsi:nil="true"/>
        <taRequesterTrxDisabler_Items xsi:nil="true"/>
        <taUpdateCreateItemRcd xsi:nil="true"/>
        <taUpdateCreateCustomerRcd xsi:nil="true"/>
        <taCreateCustomerAddress_Items xsi:nil="true"/>
        <taSopSerial_Items xsi:nil="true"/>
        <taSopLotAuto_Items xsi:nil="true"/>
        <taSopLineIvcInsert_Items>
            <taSopLineIvcInsert>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>INV0001819</SOPNUMBE>
                <CUSTNMBR>1000694</CUSTNMBR>
                <DOCDATE>11/1/2011</DOCDATE>
                <LOCNCODE>WAREHOUSE</LOCNCODE>
                <ITEMNMBR>Date</ITEMNMBR>
                <QUANTITY>1</QUANTITY>
                <ITEMDESC>Completed: 1/1/1990</ITEMDESC>
                <DOCID>STDINV</DOCID>
            </taSopLineIvcInsert>
            <taSopLineIvcInsert>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>INV0001819</SOPNUMBE>
                <CUSTNMBR>1000694</CUSTNMBR>
                <DOCDATE>11/1/2011</DOCDATE>
                <LOCNCODE>WAREHOUSE</LOCNCODE>
                <ITEMNMBR>MISC</ITEMNMBR>
                <UNITPRCE>125.0000</UNITPRCE>
                <XTNDPRCE>125.00</XTNDPRCE>
                <QUANTITY>1</QUANTITY>
                <ITEMDESC>Removal of Gran Mattino S/N 51201840</ITEMDESC>
                <DOCID>STDINV</DOCID>
            </taSopLineIvcInsert>
            <taSopLineIvcInsert>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>INV0001819</SOPNUMBE>
                <CUSTNMBR>1000694</CUSTNMBR>
                <DOCDATE>11/1/2011</DOCDATE>
                <LOCNCODE>WAREHOUSE</LOCNCODE>
                <ITEMNMBR>SF-WO</ITEMNMBR>
                <UNITPRCE>30.0000</UNITPRCE>
                <XTNDPRCE>30.00</XTNDPRCE>
                <QUANTITY>1</QUANTITY>
                <ITEMDESC>Service Fee for Work Order</ITEMDESC>
                <DOCID>STDINV</DOCID>
            </taSopLineIvcInsert>
        </taSopLineIvcInsert_Items>
        <taSopLineIvcInsertComponent_Items xsi:nil="true"/>
        <taSopTrackingNum_Items xsi:nil="true"/>
        <taSopCommissions_Items xsi:nil="true"/>
        <taSopLineIvcTaxInsert_Items>
            <taSopLineIvcTaxInsert>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>INV0001819</SOPNUMBE>
                <CUSTNMBR>1000694</CUSTNMBR>
                <TAXDTLID>WD-IL-SALES-TX</TAXDTLID>
                <ACTINDX>42</ACTINDX>
                <STAXAMNT>2.48</STAXAMNT>
                <TDTTXSLS>30.0000</TDTTXSLS>
                <TXDTOTTX>2.48</TXDTOTTX>
            </taSopLineIvcTaxInsert>
        </taSopLineIvcTaxInsert_Items>
        <taCreateSopPaymentInsertRecord_Items xsi:nil="true"/>
        <taSopUserDefined xsi:nil="true"/>
        <taSopDistribution_Items>
            <taSopDistribution>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>INV0001819</SOPNUMBE>
                <DISTTYPE>9</DISTTYPE>
                <ACTINDX>42</ACTINDX>
                <CRDTAMNT>2.48</CRDTAMNT>
                <CUSTNMBR>1000694</CUSTNMBR>
            </taSopDistribution>
            <taSopDistribution xsi:nil="true"/>
            <taSopDistribution>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>INV0001819</SOPNUMBE>
                <DISTTYPE>2</DISTTYPE>
                <ACTINDX>4</ACTINDX>
                <DEBITAMT>157.48</DEBITAMT>
                <CUSTNMBR>1000694</CUSTNMBR>
            </taSopDistribution>
            <taSopDistribution>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>INV0001819</SOPNUMBE>
                <DISTTYPE>1</DISTTYPE>
                <ACTINDX>63</ACTINDX>
                <CRDTAMNT>125.0000</CRDTAMNT>
                <CUSTNMBR>1000694</CUSTNMBR>
            </taSopDistribution>
            <taSopDistribution>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>INV0001819</SOPNUMBE>
                <DISTTYPE>1</DISTTYPE>
                <ACTINDX>64</ACTINDX>
                <CRDTAMNT>30.0000</CRDTAMNT>
                <CUSTNMBR>1000694</CUSTNMBR>
            </taSopDistribution>
            <taSopDistribution>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>INV0001819</SOPNUMBE>
                <DISTTYPE>13</DISTTYPE>
                <ACTINDX>122</ACTINDX>
                <CRDTAMNT>20.0000</CRDTAMNT>
                <CUSTNMBR>1000694</CUSTNMBR>
            </taSopDistribution>
            <taSopDistribution>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>INV0001819</SOPNUMBE>
                <DISTTYPE>13</DISTTYPE>
                <ACTINDX>114</ACTINDX>
                <DEBITAMT>20.0000</DEBITAMT>
                <CUSTNMBR>1000694</CUSTNMBR>
            </taSopDistribution>
            <taSopDistribution>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>INV0001819</SOPNUMBE>
                <DISTTYPE>13</DISTTYPE>
                <ACTINDX>120</ACTINDX>
                <CRDTAMNT>125.0000</CRDTAMNT>
                <CUSTNMBR>1000694</CUSTNMBR>
            </taSopDistribution>
            <taSopDistribution>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>INV0001819</SOPNUMBE>
                <DISTTYPE>13</DISTTYPE>
                <ACTINDX>121</ACTINDX>
                <DEBITAMT>125.0000</DEBITAMT>
                <CUSTNMBR>1000694</CUSTNMBR>
            </taSopDistribution>
        </taSopDistribution_Items>
        <taAnalyticsDistribution_Items xsi:nil="true"/>
        <taSopMultiBin_Items xsi:nil="true"/>
        <taSopHdrIvcInsert>
            <SOPTYPE>3</SOPTYPE>
            <DOCID>STDINV</DOCID>
            <SOPNUMBE>INV0001819</SOPNUMBE>
            <ORIGNUMB>0</ORIGNUMB>
            <TAXSCHID>WD-IL-ST-SCHD</TAXSCHID>
            <SHIPMTHD>GROUND</SHIPMTHD>
            <TAXAMNT>2.48</TAXAMNT>
            <LOCNCODE>WAREHOUSE</LOCNCODE>
            <DOCDATE>11/1/2011 12:00:00 AM</DOCDATE>
            <CUSTNMBR>1000694</CUSTNMBR>
            <CSTPONBR>Kraft WO: 0552120</CSTPONBR>
            <ShipToName>Walgreens # 9674 (District 258)</ShipToName>
            <ADDRESS1>133 West 8Th Avenue</ADDRESS1>
            <CITY>Homestead</CITY>
            <STATE>PA</STATE>
            <ZIPCODE>15120</ZIPCODE>
            <SUBTOTAL>155.0000</SUBTOTAL>
            <DOCAMNT>157.48</DOCAMNT>
            <BACHNUMB>eCON3051429</BACHNUMB>
            <PRBTADCD>PRIMARY</PRBTADCD>
            <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
            <CREATEDIST>0</CREATEDIST>
            <CURNCYID>Z-US$</CURNCYID>
            <FREIGTBLE>3</FREIGTBLE>
        </taSopHdrIvcInsert>
        <taSopToPopLink xsi:nil="true"/>
        <taSopUpdateCreateProcessHold xsi:nil="true"/>
        <taCreateSOPTrackingInfo xsi:nil="true"/>
        <taMdaUpdate_Items xsi:nil="true"/>
    </SOPTransactionType>
</eConnect>
Integration Manager 2010 - The destination specified by this integration uses and adopter that is not installed

I'm trying to code a project accounting integration in Integration Manager 2010. When I open the sample integration provided I get this error message:

The destination specified by this integration uses an adapter that is not installed.
The destination will be removed from this integration.
Please contact your system administrator to remedy this problem.

Moniker is:

Microsoft.Dynamics.GP.IntegrationManager.IMGPeConnect
Version=11.0.0.0
Culture=neutral
PublicKeyToken=...

Microsoft.Dynamics.GP.IntegrationManager.IMGPeConnect.eConnectProvider
Project Accounting
Timesheet Entry
GP Web Services - Sales Payments

I am writing an integration between Counterpoint POS and GP.  The requirements are for sales invoices to originate in CP and be moved to GP.  I have written web services code that creates a sales invoice, line items, lot number, serials and payments.  The problem is when I run the update code when an invoice has changed.  What is the procedure for updatng payments when they change and in some cases removing the payments from the invoice and adding totally new payments? I found the DeleteonUpdate, but I can not seem to get that to work the way I need it to.


Thanks,

Darren

Edited 11/8/2011

Related errors:

A validation exception has occurred.
Validation Errors:
- PaymentAmount does not match deposits + payments for document.
- Unable to update the existing SOP Header record
Dynamics Security Console Error

Greetings.

I am running GP Web Services V10 - SP5.

We are testing an application that integrates salesforce.com with GP.

Everything was running great. Then a new developer got involved - now I have situation where the web services runs fine - we can create customers, invoices, etc.

However, I was asked to change a behavior on the Create Customer Policy - when I try to launch the Security Console - application lauches - I select the service - and I get this error message: (it's really longer this is the gist of it)..........

The Console file is corrupted or contains invalid data.could not access the securityservice service.System.InvalidOperationException choose the select application action to specify the service and application you wish to administer."

the new guy must have tweaked something - any suggestions where to start troubleshooting?

 
Integrate Sales Invoices with Credit Card payments

Using GP2010 Web Services - Create Invoice Policy.

This policy doesn't allow me to create a Payment (at least I'm not seeing it - should I be able to?) and have payment attached to the invoice I am integrating from the website.

Can anyone knowledge share best method for using GP Web Services and integrating web sales with payments into GP?

Thank you in advance.......
eConnect - SOP unit price and extended price not populating

I'm writing an eConnect integration in GP2010 and the SOP unit price and extended price are not populating. I'd like to get them to default from the item/customer setup. 

If I key the document manually in Dynamics, they populate there...


Sub CreateSOPOrder()
    Try
        Dim strSqlServer As String = System.Configuration.ConfigurationManager.AppSettings("SQLServer")
        Dim strDB As String = System.Configuration.ConfigurationManager.AppSettings("Database")
        Dim strDocID As String = System.Configuration.ConfigurationManager.AppSettings("DOCID")
        Dim strLocationCode As String = System.Configuration.ConfigurationManager.AppSettings("3PlLocationCode")
 
        'declare our eConnect classes
        Dim oeConnectType As New Microsoft.Dynamics.GP.eConnect.Serialization.eConnectType
        Dim oSOPTransactionType As New Microsoft.Dynamics.GP.eConnect.Serialization.SOPTransactionType
        Dim oeConnectFunctions As New GP11.eConnectFunctions(strSqlServer, strDB)
 
        'create the document header
        Dim otaSopHdrIvcInsert As New Microsoft.Dynamics.GP.eConnect.Serialization.taSopHdrIvcInsert
 
        'populate the header
        With otaSopHdrIvcInsert
            .SOPTYPE = 2
            .DOCID = strDocID
            .CUSTNMBR = CUSTNMBR
            .BACHNUMB = "WEB" & Now.ToString("yyyyMMdd")
            .DOCDATE = Now.ToShortDateString
            .CSTPONBR = _BEG.PurchaseOrderNumber
            .PRSTADCD = PRSTADCD
            .PRBTADCD = PRSTADCD
            .ReqShipDate = RequestedShipDate
            .LOCNCODE = strLocationCode
        End With
 
        'assign the header to the master
        oSOPTransactionType.taSopHdrIvcInsert = otaSopHdrIvcInsert
        Dim intCurrentLine As Int16 = 0
        'create the document details
        For Each line As PO1 In _lstPO1
            'declare an object for the detail line
            Dim oItemsTaSopLineIvcInsert As New Microsoft.Dynamics.GP.eConnect.Serialization.taSopLineIvcInsert_ItemsTaSopLineIvcInsert
 
            'populate the detail line
            With oItemsTaSopLineIvcInsert
                oItemsTaSopLineIvcInsert.SOPTYPE = 2
                oItemsTaSopLineIvcInsert.ITEMNMBR = line.ITEMNMBR
                oItemsTaSopLineIvcInsert.QUANTITY = line.quantity
                oItemsTaSopLineIvcInsert.CUSTNMBR = CUSTNMBR
                oItemsTaSopLineIvcInsert.DOCDATE = Now.ToShortDateString
                oItemsTaSopLineIvcInsert.LOCNCODE = strLocationCode
                oItemsTaSopLineIvcInsert.INTEGRATIONID = line.Pack
 
                ReDim Preserve oSOPTransactionType.taSopLineIvcInsert_Items(intCurrentLine)
                oSOPTransactionType.taSopLineIvcInsert_Items(intCurrentLine) = oItemsTaSopLineIvcInsert
 
            End With
            intCurrentLine += 1
        Next
 
 
        ReDim Preserve oeConnectType.SOPTransactionType(0)
        oeConnectType.SOPTransactionType(0) = oSOPTransactionType
        Dim strDoc As String = oeConnectFunctions.CreateTransactionEntity(oeConnectType)
 
    Catch ex As Exception
        Throw ex
    End Try
 
End Sub
Sales Taxes - How to integrate

I previously posted seeking assistance on how to apply payments to documents and your assistance was invaluable. I certainly hate to request further assistance - but here goes...........I can't seem to get the handle on how to apply taxes to either a document or a line item. I would prefer the line item - i couldn't get it to work (at item) so I switched and thought document level might be easier.

Here's the current error message:

A validation exception has occurred.
Validation Errors:
 - Tax Detail does not equal the TaxAmount.
 - Tax Detail does not equal the TaxAmount.
 - Sum of the Sales Document Line tax does not equal the TaxAmount.

Here's the code: (Note - Behaviour is set to 'provide taxes') Tax schedule = 'ALL' Tax DetailID = 'NOTAX' - the document total = $56.80 (what tax value should this be?) the taxes are $3.88 (or $1.94 per line item) is this value = tax.amount or taxes? Very confusing......


essentially GP is setup to let user manually enter tax amount. Our source is a web site that calculates tax - I simply want to bring it into GP (prefer line level) - trying to get anything to work. Code works great if tax stuff is commented out.

Error seems to indicate that it expects values at line item level (Tax Detail error - listed twice and I have 2 line items on the invoice) - do I have to have line item detail? If so, how should I code it?


    <record_id>8587798</record_id>
        <CompanyKey>
            <Id>3</Id>
        </CompanyKey>
        <Id>8587798</Id>
    </Key>
    <Comment xmlns="http://schemas.microsoft.com/dynamics/gp/2006/01">8587798</Comment>
    <ShippingMethodKey xmlns="http://schemas.microsoft.com/dynamics/gp/2006/01">
        <CompanyKey>
            <Id xmlns="http://schemas.microsoft.com/dynamics/2006/01">3</Id>
        </CompanyKey>
        <Id>USPS</Id>
    </ShippingMethodKey>
    <FreightAmount xmlns="http://schemas.microsoft.com/dynamics/gp/2006/01">
        <Currency>USD</Currency>
        <Value>10.9400</Value>
        <DecimalDigits>2</DecimalDigits>
    </FreightAmount>
    <TaxScheduleKey xmlns="http://schemas.microsoft.com/dynamics/gp/2006/01">
        <CompanyKey>
 
 
 </CompanyKey>
        <Id>ALL</Id>
    </TaxScheduleKey>
        <Currency>USD</Currency>
        <Value>56.8000</Value>
        <DecimalDigits>2</DecimalDigits>
    </TaxAmount>
        <SalesDocumentTax>
            <TaxAmount>
                <Currency>USD</Currency>
                <Value>3.8800</Value>
                <DecimalDigits>2</DecimalDigits>
            </TaxAmount>
            <IsBackoutTax xsi:nil="true"/>
            <IsTaxableTax xsi:nil="true"/>
            <Key>
                <CompanyKey>
                    <Id xmlns="http://schemas.microsoft.com/dynamics/2006/01">3</Id>
                </CompanyKey>
                <TaxDetailKey>
                    <CompanyKey>
                        <Id xmlns="http://schemas.microsoft.com/dynamics/2006/01">3</Id>
                    </CompanyKey>
                    <Id>NOTAX</Id>
                </TaxDetailKey>
            </Key>
        </SalesDocumentTax>
    </Taxes>
    <InvoiceDate xmlns="http://schemas.microsoft.com/dynamics/gp/2006/01">2010-12-28T18:00:00-06:00</InvoiceDate>
    <DocumentTypeKey xmlns="http://schemas.microsoft.com/dynamics/gp/2006/01">
        <CompanyKey>
            <Id>3</Id>
        </CompanyKey>
        <Type>Invoice</Type>
        <Id>WARRIOR</Id>
    </DocumentTypeKey>
        <CompanyKey>
            <Id>3</Id>
        </CompanyKey>
        <Id>C101</Id>
    </CustomerKey>
        <CompanyKey>
            <Id>3</Id>
        </CompanyKey>
        <ISOCode>USD</ISOCode>
    </CurrencyKey>
        <SalesInvoiceLine>
            <UnitPrice>
                <Currency>USD</Currency>
                <Value>19.9900</Value>
                <DecimalDigits>2</DecimalDigits>
            </UnitPrice>
            <Quantity>
                <Value>1</Value>
                <DecimalDigits>0</DecimalDigits>
            </Quantity>
            <IsNonInventory>false</IsNonInventory>
            <UofM>Each</UofM>
            <ItemKey>
                <CompanyKey>
                    <Id>3</Id>
                </CompanyKey>
                <Id>885166162874</Id>
            </ItemKey>
            <Discount>
                <Amount>
                    <Currency>USD</Currency>
                    <Value>0.0000</Value>
                    <DecimalDigits>2</DecimalDigits>
                </Amount>
            </Discount>
        </SalesInvoiceLine>
        <SalesInvoiceLine>
            <UnitPrice>
                <Currency>USD</Currency>
                <Value>21.9900</Value>
                <DecimalDigits>2</DecimalDigits>
            </UnitPrice>
            <Quantity>
                <Value>1</Value>
                <DecimalDigits>0</DecimalDigits>
            </Quantity>
            <IsNonInventory>false</IsNonInventory>
            <UofM>Each</UofM>
            <ItemKey>
                <CompanyKey>
                    <Id>3</Id>
                </CompanyKey>
                <Id>739980982845</Id>
            </ItemKey>
            <Discount>
                <Amount>
                    <Currency>USD</Currency>
                    <Value>0.0000</Value>
                    <DecimalDigits>2</DecimalDigits>
                </Amount>
            </Discount>
        </SalesInvoiceLine>
    </Lines>
        <SalesPayment>
            <PaymentAmount>
                <Currency>USD</Currency>
                <Value>56.8000</Value>
                <DecimalDigits>2</DecimalDigits>
            </PaymentAmount>
            <PaymentCardTypeKey>
                <CompanyKey>
                    <Id xmlns="http://schemas.microsoft.com/dynamics/2006/01">3</Id>
                </CompanyKey>
                <Id>Amex-Warrior</Id>
            </PaymentCardTypeKey>
            <Type>Payment Card Payment</Type>
        </SalesPayment>
    </Payments>
</SalesInvoice>
eConnect & Tax Report

Hi,

I'm posting an XML document to eConnect, but I'm having trouble getting it to create a record in two tables within Dynamics GP.

  1. PA10704
  2. POP10360

If I don't have records in those two tables then this purchase doesn't show on the VAT report.

If I view the record in the Receivings Transaction Entry screen within Dynamics it puts in a record, but doesn't calculate the values and just puts them as Zero.

I feel I maybe missing something so that even Dynamics can't work out the values correctly to insert them when I view the record, but I'm not really sure. I'm very new to this system!

My XML:

<?xml version="1.0" encoding="utf-16"?>
<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <POPReceivingsType>
    <eConnectProcessInfo xsi:nil="true" />
    <taRequesterTrxDisabler_Items xsi:nil="true" />
    <taUpdateCreateItemRcd xsi:nil="true" />
    <taUpdateCreateVendorRcd xsi:nil="true" />
    <taCreateVendorAddress_Items xsi:nil="true" />
    <taPopRcptLotInsert_Items xsi:nil="true" />
    <taPopRcptSerialInsert_Items xsi:nil="true" />
    <taPopRcptLineInsert_Items>
      <taPopRcptLineInsert>
        <POPTYPE>3</POPTYPE>
        <POPRCTNM>RPT88</POPRCTNM>
        <ITEMNMBR>AFEE</ITEMNMBR>
        <ITEMDESC>AFEE</ITEMDESC>
        <VENDORID>UKN0001</VENDORID>
        <VNDITNUM>AGENT FEE</VNDITNUM>
        <VNDITDSC>AFEE</VNDITDSC>
        <UNITCOST>10.0000</UNITCOST>
        <EXTDCOST>10.0000</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <QTYSHPPD>1</QTYSHPPD>
        <QTYINVCD>1</QTYINVCD>
        <Purchase_IV_Item_Taxable>3</Purchase_IV_Item_Taxable>
        <Purchase_Item_Tax_Schedu>PX</Purchase_Item_Tax_Schedu>
        <Purchase_Site_Tax_Schedu>PX</Purchase_Site_Tax_Schedu>
        <LOCNCODE>ASSOSIA</LOCNCODE>
        <receiptdate>05 Oct 2011</receiptdate>
        <ProjNum>1004DRINUK     </ProjNum>
        <CostCatID>AGENT FEE</CostCatID>
      </taPopRcptLineInsert>
    </taPopRcptLineInsert_Items>
    <taPopRcptMultiBin_Items xsi:nil="true" />
    <taPopRcptLineTaxInsert_Items>
      <taPopRcptLineTaxInsert>
        <VENDORID>UKN0001</VENDORID>
        <POPRCTNM>RPT88</POPRCTNM>
        <TAXDTLID>PX</TAXDTLID>
        <TAXTYPE>0</TAXTYPE>
        <TOTPURCH>10.0000</TOTPURCH>
      </taPopRcptLineTaxInsert>
    </taPopRcptLineTaxInsert_Items>
    <taPopRctUserDefined xsi:nil="true" />
    <taPopDistribution_Items xsi:nil="true" />
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taPopRcptHdrInsert>
      <POPRCTNM>RPT88</POPRCTNM>
      <POPTYPE>3</POPTYPE>
      <VNDDOCNM>VDN88</VNDDOCNM>
      <receiptdate>05 Oct 2011</receiptdate>
      <BACHNUMB>BCH20111117122139</BACHNUMB>
      <VENDORID>UKN0001</VENDORID>
      <TRDISAMT>0</TRDISAMT>
      <DISAVAMT>0</DISAVAMT>
      <Tax_Date>17 Nov 2011</Tax_Date>
      <AUTOCOST>1</AUTOCOST>
      <TAXSCHID>PX</TAXSCHID>
      <Purchase_Freight_Taxable>3</Purchase_Freight_Taxable>
      <Purchase_Misc_Taxable>3</Purchase_Misc_Taxable>
      <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
      <RATEEXPR>0</RATEEXPR>
      <DYSTINCR>0</DYSTINCR>
      <TRXDTDEF>0</TRXDTDEF>
      <RTCLCMTD>0</RTCLCMTD>
      <CDOCNMBR>PNO151223</CDOCNMBR>
    </taPopRcptHdrInsert>
    <taMdaUpdate_Items xsi:nil="true" />
  </POPReceivingsType>
</eConnect>

Any help greatly appreciated!

eConnect doesn't generate any errors when I post my XML document, but I don't get those records I need for the VAT Report. Any ideas anyone?

Regards,

David Watkins
Integration Manager Scripts

I have an integration (GP2010) I inherited that used to properly update a SQL table with the value "READ" after a document has been successfully integrated.

The script is as follows:

Dim GP

 Set objRec = CreateObject("ADODB.Recordset")

 GP = Sourcefields("PORECEIPTS_LINES.PONO")

 sSQL = "Update RBI_POReceipts set ReadByGP = 'READ' where PONO= '" & GP & "'"

 Set objRec = GetVariable("Connection").Execute(sSQL)

 

Does anybody have any thoughts? Does anybody have an example of a script they use that I could review?

 

 
CRM - the word breaker for language (1033) is not installed

I'm getting this error when trying to install CRM 2011:

The word breaker for language (1033) is not installed

Can anyone offer any advice?
CRM: Error : instance name must be same as computer name while installing CRM 2011

I'm getting this error when installing CRM 2011:

Error : instance name must be same as computer name while installing CRM 2011

Can anyone offer any help?
Telerik - How To Create A Line Chart And Save It To Disk

This article will show how to create a line chart using the Telerik Win Form charting controls and save it to disk

In a recent project I needed to set out statistics to users. I had the idea of creating a chart, saving it to disk, and then emailing it out nightly. In the code sample below I walk through the process of creating the chart and then saving it. 

In a separate article I'll cover how to include it in an email. 

It's all pretty self explanatory, but one difficulty I had was in dealing with the dates. The chart doesn't handle date types, you have to convert them to Julian dates in the SQL query to get them to work, like this:

datediff(day,'1/1/1900',logdate) + 2 as julianDate

You'll also see 'ToAODate()' in the code, that's the VB way of doing the same thing. 
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