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

 
The selected company is not configured as a company

The selected company is not configured as a company of the current Microsoft Dynamics GP system database.  You must resolve the database configuration to log in to the company.

I was very frustrated to get this message.  Here is script to resolve it.  
Setting up a Business Alert in Dynamics GP
Setting up a Business Alert is very easy.  See the simple steps using the wizard. 
DEX.DIC version is not compatible with executable version

DEX.DIC version 14.00.0084 is not compatible with executable version 14.00.0085.00 was an error I encountered on a recent upgrade
The Account Number (ACTNUMST) does not exist in the Account Index Master Table

Sql procedure error codes returned:

Error Number = 679
Stored Procedure= taGLTransactionLineInsert
Error Description = The Account Number (ACTNUMST) does not exist in the Account Index Master Table
Node Identifier Parameters: taGLTransactionLineInsert
BACHNUMB = CONCUR 0303
JRNENTRY = 3874
CRDTAMNT = 0.00000
DEBITAMT = 80.99000
Related Error Code Parameters for Node : taGLTransactionLineInsert
ACTNUMST = 7600-00

This article discusses the error
Setting the Image property of a Winforms button

Just another of one of those cool pieces of code that takes too long to Google.

This snippet of code will succinctly set the image property of a Winforms button.

The image needs to be in the Images folder under the application
Setting up database mail on SQL 2008 R2
This article will show how to set up database mail on SQL 2008 R2
QuantitytoInvoice is auto populating on save

Hi,

I am saving a sales order that was created at a packing station. It is saving fine but i noticed when there is a packed amount that is 0 in the Quantity it automatically sets the QuantitytoInvoice to the Quantity amount even  if the QtyFullfi is set. Everything is updating and creating fine. all the information is correct headed into the save. I am wondering if anyone has heard of this?

Thanks
eConnect Receivings ITem Detail Entry

Hi All,

 Our client noticed that the screen Receivings ITem Detail Entry is not reflecting the tax amount for the invoice we've created - how can we update this screen within eConnect?

Receivings Item Detail Entry form - not showing Calculated Tax

 

 

XML Used to create this: 

[code]

 <?xml version="1.0" encoding="utf-8"?>
<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <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>RCT1219</POPRCTNM>
        <ITEMNMBR>Laynards x 30</ITEMNMBR>
        <ITEMDESC>Laynards x 30</ITEMDESC>
        <VENDORID>ACETRAVE0001</VENDORID>
        <RCPTLNNM>1</RCPTLNNM>
        <InventoryAccount>000-1100-00</InventoryAccount>
        <UOFM>Each</UOFM>
        <UNITCOST>43.20</UNITCOST>
        <EXTDCOST>43.20</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <QTYSHPPD>1</QTYSHPPD>
        <QTYINVCD>1</QTYINVCD>
        <Purchase_IV_Item_Taxable>3</Purchase_IV_Item_Taxable>
        <Purchase_Item_Tax_Schedu>000-1100-00</Purchase_Item_Tax_Schedu>
        <Purchase_Site_Tax_Schedu>ALL DETAILS    </Purchase_Site_Tax_Schedu>
        <TAXAMNT>8.64</TAXAMNT>
        <LOCNCODE>WAREHOUSE</LOCNCODE>
        <receiptdate>01/02/2016 00:00:00</receiptdate>
        <CURNCYID>Z-US$</CURNCYID>
      </taPopRcptLineInsert>
      <taPopRcptLineInsert>
        <POPTYPE>3</POPTYPE>
        <POPRCTNM>RCT1219</POPRCTNM>
        <ITEMNMBR>A5 Meet the Team invites</ITEMNMBR>
        <ITEMDESC>A5 Meet the Team invites</ITEMDESC>
        <VENDORID>ACETRAVE0001</VENDORID>
        <RCPTLNNM>2</RCPTLNNM>
        <InventoryAccount>000-1100-00</InventoryAccount>
        <UOFM>Each</UOFM>
        <UNITCOST>80.00</UNITCOST>
        <EXTDCOST>80.00</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <QTYSHPPD>1</QTYSHPPD>
        <QTYINVCD>1</QTYINVCD>
        <Purchase_IV_Item_Taxable>3</Purchase_IV_Item_Taxable>
        <Purchase_Item_Tax_Schedu>000-1100-00</Purchase_Item_Tax_Schedu>
        <Purchase_Site_Tax_Schedu>ALL DETAILS    </Purchase_Site_Tax_Schedu>
        <TAXAMNT>16.00</TAXAMNT>
        <LOCNCODE>WAREHOUSE</LOCNCODE>
        <receiptdate>01/02/2016 00:00:00</receiptdate>
        <CURNCYID>Z-US$</CURNCYID>
      </taPopRcptLineInsert>
    </taPopRcptLineInsert_Items>
    <taPopRcptMultiBin_Items xsi:nil="true" />
    <taPopRcptLineTaxInsert_Items>
      <taPopRcptLineTaxInsert>
        <VENDORID>ACETRAVE0001</VENDORID>
        <POPRCTNM>RCT1219</POPRCTNM>
        <TAXDTLID>AUSSTE+PS20N0</TAXDTLID>
        <TAXTYPE>0</TAXTYPE>
        <ACTNUMST>000-1100-00</ACTNUMST>
        <TAXAMNT>8.64</TAXAMNT>
        <TAXPURCH>43.20</TAXPURCH>
        <TOTPURCH>43.20</TOTPURCH>
        <RCPTLNNM>1</RCPTLNNM>
      </taPopRcptLineTaxInsert>
      <taPopRcptLineTaxInsert>
        <VENDORID>ACETRAVE0001</VENDORID>
        <POPRCTNM>RCT1219</POPRCTNM>
        <TAXDTLID>AUSSTE+PS20N0</TAXDTLID>
        <TAXTYPE>0</TAXTYPE>
        <ACTNUMST>000-1100-00</ACTNUMST>
        <TAXAMNT>16.00</TAXAMNT>
        <TAXPURCH>80.00</TAXPURCH>
        <TOTPURCH>80.00</TOTPURCH>
        <RCPTLNNM>2</RCPTLNNM>
      </taPopRcptLineTaxInsert>
    </taPopRcptLineTaxInsert_Items>
    <taPopRctUserDefined xsi:nil="true" />
    <taPopDistribution_Items xsi:nil="true" />
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taPopRcptHdrInsert>
      <POPRCTNM>RCT1219</POPRCTNM>
      <POPTYPE>3</POPTYPE>
      <VNDDOCNM>RCT000111-E</VNDDOCNM>
      <receiptdate>01/02/2016 00:00:00</receiptdate>
      <BACHNUMB>02032016101150</BACHNUMB>
      <VENDORID>ACETRAVE0001</VENDORID>
      <TRDISAMT>0.00</TRDISAMT>
      <TAXAMNT>24.64</TAXAMNT>
      <AUTOCOST>1</AUTOCOST>
      <TAXSCHID>ALL DETAILS    </TAXSCHID>
      <USINGHEADERLEVELTAXES>2</USINGHEADERLEVELTAXES>
      <CURNCYID>Z-US$</CURNCYID>
      <RATEEXPR>0</RATEEXPR>
      <DYSTINCR>0</DYSTINCR>
      <TRXDTDEF>0</TRXDTDEF>
      <RTCLCMTD>0</RTCLCMTD>
    </taPopRcptHdrInsert>
    <taMdaUpdate_Items xsi:nil="true" />
  </POPReceivingsType>
</eConnect>

[/code]

THanks a lot

 

 
Invoice - Adding Project Number to Receivings invoice

Hi again,

 

So we've basically nailed down our issue to adding the Project Number/Cost Centre ID to the invoice that is causing our Distribution Items to be unballanced.  

 When we submit an invoice via eConnect without setting the ProjNum and CostCatID values, the distribution form will balance.  However when we set these (as this is the requirement from the client) the Distribution type changes from PURCH to "Work In Progress" and the sub total is not included on the form

What we really need to happen is the "Work in Progress" to be included in the PAY value - this must be some configuration somewhere but we can't figure this out.
Class_ID not allowing full functioanlity?

Hello

I am trying to determine why I am not able to provide administrative access to a specific user group for password resets.

We have a  SECURITY group (Class ID) called PASSWORDRESET for our helpdesk to simply reset Dynamics GP passwords, generally we copy the access for a new help desk employee from an existing user who has this role or we manually assign the role.

There are a few users in this class ID who can login to reset a users password, the new users created in the past two years do not have the ability to click the "save" button in the User Setup window because the "save" button is greyed out.

I thought perhaps it was something in SQL so I went and verified the following settings:
I have verified that all of the logins within SQL under Server/Security/Logins all have the same access which is true between functional users and the non functional users.

Can anyone think of what may be causing this?

Thank you

Mark

 
consulta

Deseo hacer un addon para gp desde visual estudio, es solo para aprender.

alguien podría indicarme los pasos, o referirme a algún tutorial...

 
I want to make an addon for gp from visual studio , it's just to learn.
someone could tell me the steps , or refer to a tutorial ...


 
Update header-level location code on sales order

Does anyone have any sample code on how to update one piece of information on a sales order header such as the location code?

Thanks!
business alert for new vendor

Hello,

I need to create a business alert for notifying a manager that a new purchase vendor has been added.

Does this alert already exist or if not, how do I use the date as a constant?

 

 

 
VBA and SQL Stored Procedures

Okay -

 I need to modify some Manufacturing Tables using a Push Button on the MO Entry Screen.

 I know exactly what I need to do in SQL (I've written a SQL Stored Procedure that handles the updating and deleting part of the process).

My question is - Using Visual Basic Editor in GP - Can I fire off a SQL Stored Procedure? I would need to pass the MO Number as a parameter to the stored procedure.

 At this point I just need to confirm feasibility - anybody have an opinion?

 Thanks in advance........

 Bron

 
ConnectMethods UpdateEntity return error Root element () not found.

I'm trying to update the LOCNCODE for header and lines in SO transaction, but I get this error "Root element (<eConnect>) not found. Please verify xml document.The current root element is root" 

this is my code:

Dim strDoc As String = oeConnectMethods.GetEntity(connectionString, doc.OuterXml)

strDoc = strDoc.Replace(oldLoc, newLoc) (here I replace <LOCNCODE>MIA-FL</LOCNCODE> for  <LOCNCODE>EGV-IL</LOCNCODE>)

Try 
        oeConnectMethods.UpdateEntity(connectionString, strDoc)
Catch ex As Exception
        Dim strMessage = ex.Message
        Throw New Exception(strMessage)
End Try

this is my strDoc content, there is a <eConnect> element ..so I dont understand why the error :(

- <root>
- <eConnect ACTION="0" Requester_DOCTYPE="Sales_Transaction" DBNAME="NP12" TABLENAME="SOP10100" DATE1="1900-01-01T00:00:00" SOPNUMBE="2175575" SOPTYPE="2">
- <SO_Trans>
  <SOPNUMBE>2175575</SOPNUMBE>
  <SOPTYPE>2</SOPTYPE>
  <ORIGTYPE>0</ORIGTYPE>
  <ORIGNUMB />
  <DOCID>STDORD</DOCID>
  <DOCDATE>2016-03-07T00:00:00</DOCDATE>
  <GLPOSTDT>1900-01-01T00:00:00</GLPOSTDT>
  <QUOTEDAT>1900-01-01T00:00:00</QUOTEDAT>
  <QUOEXPDA>1900-01-01T00:00:00</QUOEXPDA>
  <ORDRDATE>2016-03-07T00:00:00</ORDRDATE>
  <INVODATE>1900-01-01T00:00:00</INVODATE>
  <BACKDATE>1900-01-01T00:00:00</BACKDATE>
  <RETUDATE>1900-01-01T00:00:00</RETUDATE>
  <ReqShipDate>2016-03-07T00:00:00</ReqShipDate>
  <FUFILDAT>2016-03-07T00:00:00</FUFILDAT>
  <ACTLSHIP>2016-03-07T00:00:00</ACTLSHIP>
  <DISCDATE>1900-01-01T00:00:00</DISCDATE>
  <DUEDATE>2016-03-07T00:00:00</DUEDATE>
  <REPTING>0</REPTING>
  <TRXFREQU>0</TRXFREQU>
  <TIMEREPD>0</TIMEREPD>
  <TIMETREP>0</TIMETREP>
  <DYSTINCR>0</DYSTINCR>
  <DTLSTREP>1900-01-01T00:00:00</DTLSTREP>
  <DSTBTCH1 />
  <DSTBTCH2 />
  <USDOCID1>BKORD</USDOCID1>
  <USDOCID2>STDINV</USDOCID2>
  <DISCFRGT>0.00000</DISCFRGT>
  <ORDAVFRT>0.00000</ORDAVFRT>
  <DISCMISC>0.00000</DISCMISC>
  <ORDAVMSC>0.00000</ORDAVMSC>
  <DISAVAMT>0.00000</DISAVAMT>
  <ORDAVAMT>0.00000</ORDAVAMT>
  <DISCRTND>0.00000</DISCRTND>
  <ORDISRTD>0.00000</ORDISRTD>
  <DISTKNAM>0.00000</DISTKNAM>
  <ORDISTKN>0.00000</ORDISTKN>
  <DSCPCTAM>0</DSCPCTAM>
  <DSCDLRAM>0.00000</DSCDLRAM>
  <ORDDLRAT>0.00000</ORDDLRAT>
  <DISAVTKN>0.00000</DISAVTKN>
  <ORDATKN>0.00000</ORDATKN>
  <PYMTRMID>Net 30</PYMTRMID>
  <PRCLEVEL>PP </PRCLEVEL>
  <LOCNCODE>MIA-FL</LOCNCODE>
  <BCHSOURC>Sales Entry</BCHSOURC>
  <BACHNUMB>EGV-IL160888</BACHNUMB>
  <CUSTNMBR>PP1027</CUSTNMBR>
  <CUSTNAME>PP Sales</CUSTNAME>
  <CSTPONBR>8874</CSTPONBR>
  <PROSPECT>0</PROSPECT>
  <MSTRNUMB>164319</MSTRNUMB>
  <PCKSLPNO />
  <PICTICNU />
  <MRKDNAMT>0.00000</MRKDNAMT>
  <ORMRKDAM>0.00000</ORMRKDAM>
  <PRBTADCD>PRIMARY</PRBTADCD>
  <PRSTADCD>PRIMARY</PRSTADCD>
  <CNTCPRSN>PP </CNTCPRSN>
  <ShipToName>test</ShipToName>
  <ADDRESS1>7122 W SASA BLVD</ADDRESS1>
  <ADDRESS2 />
  <ADDRESS3 />
  <CITY>Plastburg </CITY>
  <STATE>FL</STATE>
  <ZIPCODE>33317</ZIPCODE>
  <COUNTRY />
  <PHNUMBR1>885885555500</PHNUMBR1>
  <PHNUMBR2 />
  <PHONE3 />
  <FAXNUMBR />
  <COMAPPTO>0</COMAPPTO>
  <COMMAMNT>0.00000</COMMAMNT>
  <OCOMMAMT>0.00000</OCOMMAMT>
  <CMMSLAMT>0.00000</CMMSLAMT>
  <ORCOSAMT>0.00000</ORCOSAMT>
  <NCOMAMNT>0.00000</NCOMAMNT>
  <ORNCMAMT>0.00000</ORNCMAMT>
  <SHIPMTHD>CPU</SHIPMTHD>
  <TRDISAMT>0.00000</TRDISAMT>
  <ORTDISAM>0.00000</ORTDISAM>
  <TRDISPCT>0</TRDISPCT>
  <SUBTOTAL>750.00000</SUBTOTAL>
  <ORSUBTOT>750.00000</ORSUBTOT>
  <REMSUBTO>750.00000</REMSUBTO>
  <OREMSUBT>750.00000</OREMSUBT>
  <EXTDCOST>0.00000</EXTDCOST>
  <OREXTCST>0.00000</OREXTCST>
  <FRTAMNT>0.00000</FRTAMNT>
  <ORFRTAMT>0.00000</ORFRTAMT>
  <MISCAMNT>0.00000</MISCAMNT>
  <ORMISCAMT>0.00000</ORMISCAMT>
  <TXENGCLD>0</TXENGCLD>
  <TAXEXMT1 />
  <TAXEXMT2 />
  <TXRGNNUM />
  <TAXSCHID>OTHER</TAXSCHID>
  <TXSCHSRC>2</TXSCHSRC>
  <BSIVCTTL>0</BSIVCTTL>
  <FRTSCHID />
  <FRTTXAMT>0.00000</FRTTXAMT>
  <ORFRTTAX>0.00000</ORFRTTAX>
  <FRGTTXBL>1</FRGTTXBL>
  <MSCSCHID />
  <MSCTXAMT>0.00000</MSCTXAMT>
  <ORMSCTAX>0.00000</ORMSCTAX>
  <MISCTXBL>1</MISCTXBL>
  <BKTFRTAM>0.00000</BKTFRTAM>
  <ORBKTFRT>0.00000</ORBKTFRT>
  <BKTMSCAM>0.00000</BKTMSCAM>
  <ORBKTMSC>0.00000</ORBKTMSC>
  <BCKTXAMT>0.00000</BCKTXAMT>
  <OBTAXAMT>0.00000</OBTAXAMT>
  <TXBTXAMT>0.00000</TXBTXAMT>
  <OTAXTAMT>0.00000</OTAXTAMT>
  <TAXAMNT>0.00000</TAXAMNT>
  <ORTAXAMT>0.00000</ORTAXAMT>
  <ECTRX>0</ECTRX>
  <DOCAMNT>750.00000</DOCAMNT>
  <ORDOCAMT>750.00000</ORDOCAMT>
  <PYMTRCVD>0.00000</PYMTRCVD>
  <ORPMTRVD>0.00000</ORPMTRVD>
  <DEPRECVD>0.00000</DEPRECVD>
  <ORDEPRVD>0.00000</ORDEPRVD>
  <CODAMNT>0.00000</CODAMNT>
  <ORCODAMT>0.00000</ORCODAMT>
  <ACCTAMNT>750.00000</ACCTAMNT>
  <ORACTAMT>750.00000</ORACTAMT>
  <SALSTERR>USA</SALSTERR>
  <SLPRSNID />
  <UPSZONE />
  <TIMESPRT>0</TIMESPRT>
  <PSTGSTUS>0</PSTGSTUS>
  <VOIDSTTS>0</VOIDSTTS>
  <ALLOCABY>1</ALLOCABY>
  <NOTEINDX>634782.00000</NOTEINDX>
  <CURNCYID />
  <CURRNIDX>1007</CURRNIDX>
  <RATETPID />
  <EXGTBLID />
  <XCHGRATE>0.0000000</XCHGRATE>
  <DENXRATE>0.0000000</DENXRATE>
  <EXCHDATE>1900-01-01T00:00:00</EXCHDATE>
  <TIME1>1900-01-01T00:00:00</TIME1>
  <RTCLCMTD>0</RTCLCMTD>
  <MCTRXSTT>0</MCTRXSTT>
  <TRXSORCE />
  <COMMNTID />
  <REFRENCE />
  <POSTEDDT>1900-01-01T00:00:00</POSTEDDT>
  <PTDUSRID />
  <USER2ENT />
  <CREATDDT>2016-03-07T00:00:00</CREATDDT>
  <MODIFDT>2016-03-07T00:00:00</MODIFDT>
  <Tax_Date>1900-01-01T00:00:00</Tax_Date>
  <APLYWITH>0</APLYWITH>
  <WITHHAMT>0.00000</WITHHAMT>
  <SHPPGDOC>0</SHPPGDOC>
  <CORRCTN>0</CORRCTN>
  <SIMPLIFD>0</SIMPLIFD>
  <CORRNXST>0</CORRNXST>
  <DOCNCORR />
  <SEQNCORR>0</SEQNCORR>
  <SALEDATE>1900-01-01T00:00:00</SALEDATE>
  <EXCEPTIONALDEMAND>0</EXCEPTIONALDEMAND>
  <Flags>1</Flags>
  <BackoutTradeDisc>0.00000</BackoutTradeDisc>
  <OrigBackoutTradeDisc>0.00000</OrigBackoutTradeDisc>
  <GPSFOINTEGRATIONID />
  <INTEGRATIONSOURCE>0</INTEGRATIONSOURCE>
  <INTEGRATIONID />
  <Commissions />
  <Distribution />
  <Payments />
- <Holds>
  <SOPTYPE>2</SOPTYPE>
  <SOPNUMBE>2175575</SOPNUMBE>
  <PRCHLDID>DEFAULT</PRCHLDID>
  <DELETE1>0</DELETE1>
  <USERID>hdiaz</USERID>
  <HOLDDATE>2016-03-07T00:00:00</HOLDDATE>
  <TIME1>1900-01-01T09:12:20</TIME1>
  <TRXSORCE />
  </Holds>
  <UserDefined />
  <Deposit />
  <Notes />
- <Line>
  <SOPNUMBE>2175575</SOPNUMBE>
  <SOPTYPE>2</SOPTYPE>
  <CMPNTSEQ>0</CMPNTSEQ>
  <LNITMSEQ>1</LNITMSEQ>
  <ITEMNMBR>11GBED50</ITEMNMBR>
  <ITEMDESC>The PPP Mattress</ITEMDESC>
  <NONINVEN>0</NONINVEN>
  <DROPSHIP>0</DROPSHIP>
  <UOFM>EA</UOFM>
  <LOCNCODE>MIA-FL</LOCNCODE>
  <UNITCOST>337.37000</UNITCOST>
  <ORUNTCST>337.37000</ORUNTCST>
  <UNITPRCE>750.00000</UNITPRCE>
  <ORUNTPRC>750.00000</ORUNTPRC>
  <XTNDPRCE>750.00000</XTNDPRCE>
  <OXTNDPRC>750.00000</OXTNDPRC>
  <REMPRICE>750.00000</REMPRICE>
  <OREPRICE>750.00000</OREPRICE>
  <EXTDCOST>337.37000</EXTDCOST>
  <OREXTCST>337.37000</OREXTCST>
  <MRKDNAMT>0.00000</MRKDNAMT>
  <ORMRKDAM>0.00000</ORMRKDAM>
  <MRKDNPCT>0</MRKDNPCT>
  <MRKDNTYP>0</MRKDNTYP>
  <INVINDX>23</INVINDX>
  <CSLSINDX>143</CSLSINDX>
  <SLSINDX>126</SLSINDX>
  <MKDNINDX>139</MKDNINDX>
  <RTNSINDX>23</RTNSINDX>
  <INUSINDX>0</INUSINDX>
  <INSRINDX>0</INSRINDX>
  <DMGDINDX>140</DMGDINDX>
  <ITMTSHID />
  <IVITMTXB>2</IVITMTXB>
  <BKTSLSAM>0.00000</BKTSLSAM>
  <ORBKTSLS>0.00000</ORBKTSLS>
  <TAXAMNT>0.00000</TAXAMNT>
  <ORTAXAMT>0.00000</ORTAXAMT>
  <TXBTXAMT>0.00000</TXBTXAMT>
  <OTAXTAMT>0.00000</OTAXTAMT>
  <BSIVCTTL>0</BSIVCTTL>
  <TRDISAMT>0.00000</TRDISAMT>
  <ORTDISAM>0.00000</ORTDISAM>
  <DISCSALE>0.00000</DISCSALE>
  <ORDAVSLS>0.00000</ORDAVSLS>
  <QUANTITY>1.00000</QUANTITY>
  <ATYALLOC>1.00000</ATYALLOC>
  <QTYINSVC>0.00000</QTYINSVC>
  <QTYINUSE>0.00000</QTYINUSE>
  <QTYDMGED>0.00000</QTYDMGED>
  <QTYRTRND>0.00000</QTYRTRND>
  <QTYONHND>0.00000</QTYONHND>
  <QTYCANCE>0.00000</QTYCANCE>
  <QTYCANOT>0.00000</QTYCANOT>
  <QTYONPO>0.00000</QTYONPO>
  <QTYORDER>0.00000</QTYORDER>
  <QTYPRBAC>0.00000</QTYPRBAC>
  <QTYPRBOO>0.00000</QTYPRBOO>
  <QTYPRINV>0.00000</QTYPRINV>
  <QTYPRORD>0.00000</QTYPRORD>
  <QTYPRVRECVD>0.00000</QTYPRVRECVD>
  <QTYRECVD>0.00000</QTYRECVD>
  <QTYREMAI>1.00000</QTYREMAI>
  <QTYREMBO>0.00000</QTYREMBO>
  <QTYTBAOR>0.00000</QTYTBAOR>
  <QTYTOINV>1.00000</QTYTOINV>
  <QTYTORDR>0.00000</QTYTORDR>
  <QTYFULFI>1.00000</QTYFULFI>
  <QTYSLCTD>1.00000</QTYSLCTD>
  <QTYBSUOM>1.00000</QTYBSUOM>
  <EXTQTYAL>303.00000</EXTQTYAL>
  <EXTQTYSEL>0.00000</EXTQTYSEL>
  <ReqShipDate>2016-03-07T00:00:00</ReqShipDate>
  <FUFILDAT>2016-03-07T00:00:00</FUFILDAT>
  <ACTLSHIP>2016-03-07T00:00:00</ACTLSHIP>
  <SHIPMTHD>FDEG</SHIPMTHD>
  <SALSTERR>USA</SALSTERR>
  <SLPRSNID />
  <PRCLEVEL>PPP </PRCLEVEL>
  <COMMNTID />
  <BRKFLD1>0</BRKFLD1>
  <BRKFLD2>0</BRKFLD2>
  <BRKFLD3>0</BRKFLD3>
  <CURRNIDX>1007</CURRNIDX>
  <TRXSORCE />
  <ORGSEQNM>0</ORGSEQNM>
  <ITEMCODE />
  <PURCHSTAT>1</PURCHSTAT>
  <DECPLQTY>1</DECPLQTY>
  <DECPLCUR>3</DECPLCUR>
  <ODECPLCU>3</ODECPLCU>
  <QTYTOSHP>0.00000</QTYTOSHP>
  <XFRSHDOC>0</XFRSHDOC>
  <EXCEPTIONALDEMAND>0</EXCEPTIONALDEMAND>
  <TAXSCHID>BROWARDFL</TAXSCHID>
  <TXSCHSRC>2</TXSCHSRC>
  <PRSTADCD>PRIMARY</PRSTADCD>
  <ShipToName>test</ShipToName>
  <CNTCPRSN>test</CNTCPRSN>
  <ADDRESS1>test</ADDRESS1>
  <ADDRESS2>test</ADDRESS2>
  <ADDRESS3>test</ADDRESS3>
  <CITY>test</CITY>
  <STATE>test</STATE>
  <ZIPCODE>test</ZIPCODE>
  <COUNTRY>US</COUNTRY>
  <PHONE1 />
  <PHONE2 />
  <PHONE3 />
  <FAXNUMBR />
  <Flags>1</Flags>
  <BackoutTradeDisc>0.00000</BackoutTradeDisc>
  <OrigBackoutTradeDisc>0.00000</OrigBackoutTradeDisc>
  <GPSFOINTEGRATIONID />
  <INTEGRATIONSOURCE>0</INTEGRATIONSOURCE>
  <INTEGRATIONID />
  <CONTNBR />
  <CONTLNSEQNBR>0.00000</CONTLNSEQNBR>
  <CONTSTARTDTE>1900-01-01T00:00:00</CONTSTARTDTE>
  <CONTENDDTE>1900-01-01T00:00:00</CONTENDDTE>
  <CONTITEMNBR />
  <CONTSERIALNBR />
  <LineTax />
  </Line>
  </SO_Trans>
  </eConnect>
  </root>
how to change LOCNCODE after Retrieve a Sales Document with eConnect
how to change <LOCNCODE> for the header and the lines after Retrieve a Sales Document 
this is my sales document

<root>
    <eConnect ACTION="0" Requester_DOCTYPE="Sales_Transaction" DBNAME="NP12" TABLENAME="SOP10100" DATE1="1900-01-01T00:00:00" SOPNUMBE="2175575" SOPTYPE="2">
        <SO_Trans>
            <SOPNUMBE>2175575</SOPNUMBE>
            <SOPTYPE>2</SOPTYPE>
            <ORIGTYPE>0</ORIGTYPE>
            <ORIGNUMB/>
            <DOCID>STDORD</DOCID>
            <DOCDATE>2016-03-07T00:00:00</DOCDATE>
            <GLPOSTDT>1900-01-01T00:00:00</GLPOSTDT>
            <QUOTEDAT>1900-01-01T00:00:00</QUOTEDAT>
            <QUOEXPDA>1900-01-01T00:00:00</QUOEXPDA>
            <ORDRDATE>2016-03-07T00:00:00</ORDRDATE>
            <INVODATE>1900-01-01T00:00:00</INVODATE>
            <BACKDATE>1900-01-01T00:00:00</BACKDATE>
            <RETUDATE>1900-01-01T00:00:00</RETUDATE>
            <ReqShipDate>2016-03-07T00:00:00</ReqShipDate>
            <FUFILDAT>2016-03-07T00:00:00</FUFILDAT>
            <ACTLSHIP>2016-03-07T00:00:00</ACTLSHIP>
            <DISCDATE>1900-01-01T00:00:00</DISCDATE>
            <DUEDATE>2016-03-07T00:00:00</DUEDATE>
            <REPTING>0</REPTING>
            <TRXFREQU>0</TRXFREQU>
            <TIMEREPD>0</TIMEREPD>
            <TIMETREP>0</TIMETREP>
            <DYSTINCR>0</DYSTINCR>
            <DTLSTREP>1900-01-01T00:00:00</DTLSTREP>
            <DSTBTCH1/>
            <DSTBTCH2/>
            <USDOCID1>BKORD</USDOCID1>
            <USDOCID2>STDINV</USDOCID2>
            <DISCFRGT>0.00000</DISCFRGT>
            <ORDAVFRT>0.00000</ORDAVFRT>
            <DISCMISC>0.00000</DISCMISC>
            <ORDAVMSC>0.00000</ORDAVMSC>
            <DISAVAMT>0.00000</DISAVAMT>
            <ORDAVAMT>0.00000</ORDAVAMT>
            <DISCRTND>0.00000</DISCRTND>
            <ORDISRTD>0.00000</ORDISRTD>
            <DISTKNAM>0.00000</DISTKNAM>
            <ORDISTKN>0.00000</ORDISTKN>
            <DSCPCTAM>0</DSCPCTAM>
            <DSCDLRAM>0.00000</DSCDLRAM>
            <ORDDLRAT>0.00000</ORDDLRAT>
            <DISAVTKN>0.00000</DISAVTKN>
            <ORDATKN>0.00000</ORDATKN>
            <PYMTRMID>Net 30</PYMTRMID>
            <PRCLEVEL>PP </PRCLEVEL>
            <LOCNCODE>MIA-FL</LOCNCODE>
            <BCHSOURC>Sales Entry</BCHSOURC>
            <BACHNUMB>EGV-IL160888</BACHNUMB>
            <CUSTNMBR>PP1027</CUSTNMBR>
            <CUSTNAME>PP Sales</CUSTNAME>
            <CSTPONBR>8874</CSTPONBR>
            <PROSPECT>0</PROSPECT>
            <MSTRNUMB>164319</MSTRNUMB>
            <PCKSLPNO/>
            <PICTICNU/>
            <MRKDNAMT>0.00000</MRKDNAMT>
            <ORMRKDAM>0.00000</ORMRKDAM>
            <PRBTADCD>PRIMARY</PRBTADCD>
            <PRSTADCD>PRIMARY</PRSTADCD>
            <CNTCPRSN>PP </CNTCPRSN>
            <ShipToName>test</ShipToName>
            <ADDRESS1>7122 W SASA BLVD</ADDRESS1>
            <ADDRESS2/>
            <ADDRESS3/>
            <CITY>Plastburg </CITY>
            <STATE>FL</STATE>
            <ZIPCODE>33317</ZIPCODE>
            <COUNTRY/>
            <PHNUMBR1>885885555500</PHNUMBR1>
            <PHNUMBR2/>
            <PHONE3/>
            <FAXNUMBR/>
            <COMAPPTO>0</COMAPPTO>
            <COMMAMNT>0.00000</COMMAMNT>
            <OCOMMAMT>0.00000</OCOMMAMT>
            <CMMSLAMT>0.00000</CMMSLAMT>
            <ORCOSAMT>0.00000</ORCOSAMT>
            <NCOMAMNT>0.00000</NCOMAMNT>
            <ORNCMAMT>0.00000</ORNCMAMT>
            <SHIPMTHD>CPU</SHIPMTHD>
            <TRDISAMT>0.00000</TRDISAMT>
            <ORTDISAM>0.00000</ORTDISAM>
            <TRDISPCT>0</TRDISPCT>
            <SUBTOTAL>750.00000</SUBTOTAL>
            <ORSUBTOT>750.00000</ORSUBTOT>
            <REMSUBTO>750.00000</REMSUBTO>
            <OREMSUBT>750.00000</OREMSUBT>
            <EXTDCOST>0.00000</EXTDCOST>
            <OREXTCST>0.00000</OREXTCST>
            <FRTAMNT>0.00000</FRTAMNT>
            <ORFRTAMT>0.00000</ORFRTAMT>
            <MISCAMNT>0.00000</MISCAMNT>
            <ORMISCAMT>0.00000</ORMISCAMT>
            <TXENGCLD>0</TXENGCLD>
            <TAXEXMT1/>
            <TAXEXMT2/>
            <TXRGNNUM/>
            <TAXSCHID>OTHER</TAXSCHID>
            <TXSCHSRC>2</TXSCHSRC>
            <BSIVCTTL>0</BSIVCTTL>
            <FRTSCHID/>
            <FRTTXAMT>0.00000</FRTTXAMT>
            <ORFRTTAX>0.00000</ORFRTTAX>
            <FRGTTXBL>1</FRGTTXBL>
            <MSCSCHID/>
            <MSCTXAMT>0.00000</MSCTXAMT>
            <ORMSCTAX>0.00000</ORMSCTAX>
            <MISCTXBL>1</MISCTXBL>
            <BKTFRTAM>0.00000</BKTFRTAM>
            <ORBKTFRT>0.00000</ORBKTFRT>
            <BKTMSCAM>0.00000</BKTMSCAM>
            <ORBKTMSC>0.00000</ORBKTMSC>
            <BCKTXAMT>0.00000</BCKTXAMT>
            <OBTAXAMT>0.00000</OBTAXAMT>
            <TXBTXAMT>0.00000</TXBTXAMT>
            <OTAXTAMT>0.00000</OTAXTAMT>
            <TAXAMNT>0.00000</TAXAMNT>
            <ORTAXAMT>0.00000</ORTAXAMT>
            <ECTRX>0</ECTRX>
            <DOCAMNT>750.00000</DOCAMNT>
            <ORDOCAMT>750.00000</ORDOCAMT>
            <PYMTRCVD>0.00000</PYMTRCVD>
            <ORPMTRVD>0.00000</ORPMTRVD>
            <DEPRECVD>0.00000</DEPRECVD>
            <ORDEPRVD>0.00000</ORDEPRVD>
            <CODAMNT>0.00000</CODAMNT>
            <ORCODAMT>0.00000</ORCODAMT>
            <ACCTAMNT>750.00000</ACCTAMNT>
            <ORACTAMT>750.00000</ORACTAMT>
            <SALSTERR>USA</SALSTERR>
            <SLPRSNID/>
            <UPSZONE/>
            <TIMESPRT>0</TIMESPRT>
            <PSTGSTUS>0</PSTGSTUS>
            <VOIDSTTS>0</VOIDSTTS>
            <ALLOCABY>1</ALLOCABY>
            <NOTEINDX>634782.00000</NOTEINDX>
            <CURNCYID/>
            <CURRNIDX>1007</CURRNIDX>
            <RATETPID/>
            <EXGTBLID/>
            <XCHGRATE>0.0000000</XCHGRATE>
            <DENXRATE>0.0000000</DENXRATE>
            <EXCHDATE>1900-01-01T00:00:00</EXCHDATE>
            <TIME1>1900-01-01T00:00:00</TIME1>
            <RTCLCMTD>0</RTCLCMTD>
            <MCTRXSTT>0</MCTRXSTT>
            <TRXSORCE/>
            <COMMNTID/>
            <REFRENCE/>
            <POSTEDDT>1900-01-01T00:00:00</POSTEDDT>
            <PTDUSRID/>
            <USER2ENT/>
            <CREATDDT>2016-03-07T00:00:00</CREATDDT>
            <MODIFDT>2016-03-07T00:00:00</MODIFDT>
            <Tax_Date>1900-01-01T00:00:00</Tax_Date>
            <APLYWITH>0</APLYWITH>
            <WITHHAMT>0.00000</WITHHAMT>
            <SHPPGDOC>0</SHPPGDOC>
            <CORRCTN>0</CORRCTN>
            <SIMPLIFD>0</SIMPLIFD>
            <CORRNXST>0</CORRNXST>
            <DOCNCORR/>
            <SEQNCORR>0</SEQNCORR>
            <SALEDATE>1900-01-01T00:00:00</SALEDATE>
            <EXCEPTIONALDEMAND>0</EXCEPTIONALDEMAND>
            <Flags>1</Flags>
            <BackoutTradeDisc>0.00000</BackoutTradeDisc>
            <OrigBackoutTradeDisc>0.00000</OrigBackoutTradeDisc>
            <GPSFOINTEGRATIONID/>
            <INTEGRATIONSOURCE>0</INTEGRATIONSOURCE>
            <INTEGRATIONID/>
            <Commissions/>
            <Distribution/>
            <Payments/>
            <Holds>
                <SOPTYPE>2</SOPTYPE>
                <SOPNUMBE>2175575</SOPNUMBE>
                <PRCHLDID>DEFAULT</PRCHLDID>
                <DELETE1>0</DELETE1>
                <USERID>hdiaz</USERID>
                <HOLDDATE>2016-03-07T00:00:00</HOLDDATE>
                <TIME1>1900-01-01T09:12:20</TIME1>
                <TRXSORCE/>
            </Holds>
            <UserDefined/>
            <Deposit/>
            <Notes/>
            <Line>
                <SOPNUMBE>2175575</SOPNUMBE>
                <SOPTYPE>2</SOPTYPE>
                <CMPNTSEQ>0</CMPNTSEQ>
                <LNITMSEQ>1</LNITMSEQ>
                <ITEMNMBR>11GBED50</ITEMNMBR>
                <ITEMDESC>The PPP Mattress</ITEMDESC>
                <NONINVEN>0</NONINVEN>
                <DROPSHIP>0</DROPSHIP>
                <UOFM>EA</UOFM>
                <LOCNCODE>MIA-FL</LOCNCODE>
                <UNITCOST>337.37000</UNITCOST>
                <ORUNTCST>337.37000</ORUNTCST>
                <UNITPRCE>750.00000</UNITPRCE>
                <ORUNTPRC>750.00000</ORUNTPRC>
                <XTNDPRCE>750.00000</XTNDPRCE>
                <OXTNDPRC>750.00000</OXTNDPRC>
                <REMPRICE>750.00000</REMPRICE>
                <OREPRICE>750.00000</OREPRICE>
                <EXTDCOST>337.37000</EXTDCOST>
                <OREXTCST>337.37000</OREXTCST>
                <MRKDNAMT>0.00000</MRKDNAMT>
                <ORMRKDAM>0.00000</ORMRKDAM>
                <MRKDNPCT>0</MRKDNPCT>
                <MRKDNTYP>0</MRKDNTYP>
                <INVINDX>23</INVINDX>
                <CSLSINDX>143</CSLSINDX>
                <SLSINDX>126</SLSINDX>
                <MKDNINDX>139</MKDNINDX>
                <RTNSINDX>23</RTNSINDX>
                <INUSINDX>0</INUSINDX>
                <INSRINDX>0</INSRINDX>
                <DMGDINDX>140</DMGDINDX>
                <ITMTSHID/>
                <IVITMTXB>2</IVITMTXB>
                <BKTSLSAM>0.00000</BKTSLSAM>
                <ORBKTSLS>0.00000</ORBKTSLS>
                <TAXAMNT>0.00000</TAXAMNT>
                <ORTAXAMT>0.00000</ORTAXAMT>
                <TXBTXAMT>0.00000</TXBTXAMT>
                <OTAXTAMT>0.00000</OTAXTAMT>
                <BSIVCTTL>0</BSIVCTTL>
                <TRDISAMT>0.00000</TRDISAMT>
                <ORTDISAM>0.00000</ORTDISAM>
                <DISCSALE>0.00000</DISCSALE>
                <ORDAVSLS>0.00000</ORDAVSLS>
                <QUANTITY>1.00000</QUANTITY>
                <ATYALLOC>1.00000</ATYALLOC>
                <QTYINSVC>0.00000</QTYINSVC>
                <QTYINUSE>0.00000</QTYINUSE>
                <QTYDMGED>0.00000</QTYDMGED>
                <QTYRTRND>0.00000</QTYRTRND>
                <QTYONHND>0.00000</QTYONHND>
                <QTYCANCE>0.00000</QTYCANCE>
                <QTYCANOT>0.00000</QTYCANOT>
                <QTYONPO>0.00000</QTYONPO>
                <QTYORDER>0.00000</QTYORDER>
                <QTYPRBAC>0.00000</QTYPRBAC>
                <QTYPRBOO>0.00000</QTYPRBOO>
                <QTYPRINV>0.00000</QTYPRINV>
                <QTYPRORD>0.00000</QTYPRORD>
                <QTYPRVRECVD>0.00000</QTYPRVRECVD>
                <QTYRECVD>0.00000</QTYRECVD>
                <QTYREMAI>1.00000</QTYREMAI>
                <QTYREMBO>0.00000</QTYREMBO>
                <QTYTBAOR>0.00000</QTYTBAOR>
                <QTYTOINV>1.00000</QTYTOINV>
                <QTYTORDR>0.00000</QTYTORDR>
                <QTYFULFI>1.00000</QTYFULFI>
                <QTYSLCTD>1.00000</QTYSLCTD>
                <QTYBSUOM>1.00000</QTYBSUOM>
                <EXTQTYAL>303.00000</EXTQTYAL>
                <EXTQTYSEL>0.00000</EXTQTYSEL>
                <ReqShipDate>2016-03-07T00:00:00</ReqShipDate>
                <FUFILDAT>2016-03-07T00:00:00</FUFILDAT>
                <ACTLSHIP>2016-03-07T00:00:00</ACTLSHIP>
                <SHIPMTHD>FDEG</SHIPMTHD>
                <SALSTERR>USA</SALSTERR>
                <SLPRSNID/>
                <PRCLEVEL>PPP </PRCLEVEL>
                <COMMNTID/>
                <BRKFLD1>0</BRKFLD1>
                <BRKFLD2>0</BRKFLD2>
                <BRKFLD3>0</BRKFLD3>
                <CURRNIDX>1007</CURRNIDX>
                <TRXSORCE/>
                <ORGSEQNM>0</ORGSEQNM>
                <ITEMCODE/>
                <PURCHSTAT>1</PURCHSTAT>
                <DECPLQTY>1</DECPLQTY>
                <DECPLCUR>3</DECPLCUR>
                <ODECPLCU>3</ODECPLCU>
                <QTYTOSHP>0.00000</QTYTOSHP>
                <XFRSHDOC>0</XFRSHDOC>
                <EXCEPTIONALDEMAND>0</EXCEPTIONALDEMAND>
                <TAXSCHID>BROWARDFL</TAXSCHID>
                <TXSCHSRC>2</TXSCHSRC>
                <PRSTADCD>PRIMARY</PRSTADCD>
                <ShipToName>test</ShipToName>
                <CNTCPRSN>test</CNTCPRSN>
                <ADDRESS1>test</ADDRESS1>
                <ADDRESS2>test</ADDRESS2>
                <ADDRESS3>test</ADDRESS3>
                <CITY>test</CITY>
                <STATE>test</STATE>
                <ZIPCODE>test</ZIPCODE>
                <COUNTRY>US</COUNTRY>
                <PHONE1/>
                <PHONE2/>
                <PHONE3/>
                <FAXNUMBR/>
                <Flags>1</Flags>
                <BackoutTradeDisc>0.00000</BackoutTradeDisc>
                <OrigBackoutTradeDisc>0.00000</OrigBackoutTradeDisc>
                <GPSFOINTEGRATIONID/>
                <INTEGRATIONSOURCE>0</INTEGRATIONSOURCE>
                <INTEGRATIONID/>
                <CONTNBR/>
                <CONTLNSEQNBR>0.00000</CONTLNSEQNBR>
                <CONTSTARTDTE>1900-01-01T00:00:00</CONTSTARTDTE>
                <CONTENDDTE>1900-01-01T00:00:00</CONTENDDTE>
                <CONTITEMNBR/>
                <CONTSERIALNBR/>
                <LineTax/>
            </Line>
        </SO_Trans>
    </eConnect>
</root>
web services import tracking numbers

Hello

 We are working on having our vendors send us ups/fedex tracking information and updating I know it is a sop function just wondering if there was any sample code to be had

 

thanks

Vic
Accessing the following fields for an salesItem.

Hello,

 I am attempting to create a SalesItem using c# and the Dynamic Web Service. I have achieved a small amount of success inserting a bare bones inventory item. However, I now need to add more SalesItem detail to create a valid entry.  So far I am unable to find object attributes to set the following fields which are viewable from the Item Maintenance Options screen.

Category:

      Product Cat

      Version

      Taxability

      Sales Category

     Prod Portfolio

     Deferrals

 

   Any ideas where I can gain access to these attributes using the Dynamics Service reference, appropriate objects etc..

 

  Thanks Stephen

 

   

 

 
Accessing PriceGroup

Hello,

I am having trouble finding the correct attribute to set the price group (eConnect element PriceGroup) on a salesitem.

I do not see anything remotely resembling this field in the schema or the c# reference.cs  class generated from the GP Dynamics Web Service end  point.

Any pointers to the correct attribute and associated object appreciated.

 Thanks Stephen

 

 
Primary Key Violation PKPA01901

I am using eConnect to insert a POReceipt and get error " Primary Key Violation on costraint 'PKPA01901'. Cannot insert duplicate into object 'dbo.PA01901'

 

Please help.
Business Alerts - reports
 I have a business alert set up in Purchasing for when a new vendor is added.  The email alert is working, but where does the report go?  I cannot locate it in or out of GP.
Serial Number Allocated on Screen but not in database

I have a serial number that shows to be allocated when I do a serial number inquiry. Yet, the Inventory Serial & Lot Number Work file does not include any serial numbers for the part number in questions and the Item Qty Master file shows the Qty on Hand to be 6, and Qty Alloc to be 0.

What script can I run to unallocated this serial number?

 Any help would be greatly appreciated as we are trying to add this serial number to an invoice.

 

Thank you in advance! 

 
Web Services GetVendorByKey, Hexadecimal value 0x06 is an invalid character.

I am developing an Intranet site that utilizes GP Web Services to manage Vendor information (among other things). Today I noticed that the GetVendorByKey method was failing for one of our Vendors.

We have tested quite a few Vendors, and this is the first time that this error has occurred.

I'll provide some context and cover what steps I have already taken here...

 Visual Studio throws a...

 

1.System.ServiceModel.FaultException<System.ServiceModel.ExceptionDetail>

 

With a message of...

 

1.{"The application encountered an unhandled system exception.  Contact your system administrator for details."}

 

I've seen this message a few times before and previously used the Dynamics GP Exception Management Console to actually view the message. However, when I attempted to view the System Exceptions I received a 'Cannot Access the Exception Service' error from the console.

Following the 3rd solution on this guide, I was able to view the errors in SQL Management Studio. I removed the logs that contained 'invalid chars' using the below SQL query.

 

1.delete from DYNAMICS..WSExceptionLog
2.where ExceptionMessage like '%invalid character%'

 

Heading back into the Dynamics Exceptions Console I can now see an error.

 

Business object not found.
 
at Microsoft.Dynamics.Common.BusinessService.GetByKey(Key key, Context context, Type[] types)

 

The Request XML is (Vendor Id 00490 is the problem Vendor)...

 

<?xml version="1.0"?>
<RequestObjects>
    <Id>OO490</Id>
  </VendorKey>
    <OrganizationKey xsi:type="CompanyKey">
      <Id>1</Id>
    </OrganizationKey>
    <CultureName />
    <CurrencyType>Transactional</CurrencyType>
    <RoleKey>
      <Id xmlns="http://schemas.microsoft.com/dynamics/security/2006/01">e18b321a-9548-48fb-b75a-dee0a618ddaa</Id>
    </RoleKey>
  </Context>
  <string>Microsoft.Dynamics.GP.Vendor</string>

After a few more random attempts to retrieve the Vendor object via Web Services, I received the same error from the Exceptions Console and decided to look at the error in SQL Management Studio. Here, I found an Exception Message of...

 

'', hexadecimal value 0x06, is an invalid character.

 

Apparently this character is ACK, or acknowledgment. Never heard of this before.

I assumed that somewhere in the PM00200 table, there was an invalid 'ACK' character so wrote a quick C# script to check each column in the row for 0x06 characters. Nothing came up.

 I also checked the VendorMaintenance Card in GP and all options/address fields for weird characters and didn't find anything.

 

Now that you're up to speed...

I'm still assuming that there is an invalid character in some Vendor-related table that GP Web Services is tripping over, but other than that I don't have a clue.

It may have something to do with the fact that I can only see one 'Business Object Not Found' error in the Error Management Console while every subsequent error apparently contains 'invalid characters'.

Any suggestions?
web service extension

Hi

Our developer wrote a web service extension , I put the dll in \Program Files\Microsoft Dynamics\GPWebServices and I edited the BusinessObjectsFile.config

file to include the xml he gave me. then I restarted the dynamics gp web service host service and the econnect integration service.

 

Is that all I need to do to get it to work??

 

thanks

Vic
GP Custoization
How do I switch the UDF2 text field on the vendor options window to a drop down control with Yes or No options. I have not been able to delete the original bound field, and even though I created the drop down control with the Yes and No options I have not been able to bind the control to the data field.
RadDock sorting

I have a task that inserts a tabbed document into a RadDock control. I needed a routine that would re-sort the tabs for me.

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 | Anchored Marriage
3