DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In

Archives

 

Today's little slice of joy comes installing an eConnect/VSTools application onto a Windows 7 machine. There's not much documented on what's needed, so here's the errors and how I got past them.

We have a combination of GP 10, VS Tools, eConnect, Enterprise Library 4.1, and Windows 7. It all worked fine on the server, but the workstation went through a series of errors

Error 1: 

Rattliff.fll: the type initializer for 'Microsoft.Dexterity.applications.root' threw and exception.InnerException: Specified argument was out fo the range of valid values.

Parameter name: productID

Error 2:

Ratliff.dll: Could not load file or assembly 'file:///c:\Program Files\Microsoft Dynamics\GP\Addins\Ratliff.dll or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded

Error 3:

The current build operation (build key Build Key[Microsoft.Practices.EnterpriseLibrary.Data.Database, RATL]) failed: The type initializer for 'Microsoft.Practices.EnterpriseLibrary.Data.Database' threw an exception. (Strategy type ConfiguredObjectStrategy, index 2)The type initializer for 'Microsoft.Practices.EnterpriseLibrary.Data.Database' threw an exception.

When I start debugging, the cmd window opens and it appears to be integrating the new customer into GP10 TWO - but I do not see the new customer created in GP?  I have setup the econnect, loaded all of the programs and tools per the instructions and ran the sample - but there is no indication that it failed yet it did?  The Fabrikam sample is a fresh copy as well..

Could the problem be due to running the VBexpress version of VS2010?  Any advise would be greatly Appreciated[:)]

Is it really not possible to create an XML document with multiple transaction types?  My process creates cash transactions with distributions as well as checking to see if the applicable account for deferred revenue has or has not been created.  XML is below.  Each transaction type works fine alone, but not in a single document. 

 <?xml version="1.0" encoding="utf-8"?>
<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <RMCashReceiptsType>
    <eConnectProcessInfo xsi:nil="true" />
    <taRequesterTrxDisabler_Items xsi:nil="true" />
    <taUpdateCreateCustomerRcd xsi:nil="true" />
    <taCreateCustomerAddress_Items xsi:nil="true" />
    <taRMDistribution_Items>
      <taRMDistribution>
        <RMDTYPAL>9</RMDTYPAL>
        <DOCNUMBR>PYMT0000000217</DOCNUMBR>
        <CUSTNMBR>BAMA BCS 2010</CUSTNMBR>
        <DISTTYPE>1</DISTTYPE>
        <ACTNUMST>03-1013-99</ACTNUMST>
        <DEBITAMT>1402501.10</DEBITAMT>
      </taRMDistribution>
      <taRMDistribution>
        <RMDTYPAL>9</RMDTYPAL>
        <DOCNUMBR>PYMT0000000217</DOCNUMBR>
        <CUSTNMBR>BAMA BCS 2010</CUSTNMBR>
        <SEQNUMBR>1</SEQNUMBR>
        <DISTTYPE>3</DISTTYPE>
        <DSTINDX>1</DSTINDX>
        <ACTNUMST>03-2201-01</ACTNUMST>
        <CRDTAMNT>1402501.10</CRDTAMNT>
      </taRMDistribution>
    </taRMDistribution_Items>
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taRMCashReceiptInsert>
      <CUSTNMBR>BAMA BCS 2010</CUSTNMBR>
      <DOCNUMBR>PYMT0000000217</DOCNUMBR>
      <DOCDATE>12/17/2009 12:00:00 AM</DOCDATE>
      <ORTRXAMT>1402501.10</ORTRXAMT>
      <GLPOSTDT>12/17/2009 12:00:00 AM</GLPOSTDT>
      <BACHNUMB>ECONNECT</BACHNUMB>
      <CSHRCTYP>0</CSHRCTYP>
      <CHEKBKID>ASSOCIATED BANK</CHEKBKID>
      <TRXDSCRN>econnect</TRXDSCRN>
      <CREATEDIST>0</CREATEDIST>
    </taRMCashReceiptInsert>
  </RMCashReceiptsType>
  <GLAccountType>
    <eConnectProcessInfo xsi:nil="true" />
    <taRequesterTrxDisabler_Items xsi:nil="true" />
    <taUpdateCreateAccountRcd>
      <ACTNUMST>03-2201-01</ACTNUMST>
      <ACTALIAS>BAMA BCS 2010 DR</ACTALIAS>
      <ACTDESCR>BAMA BCS 2010 Deferred Revenue</ACTDESCR>
      <PSTNGTYP>1</PSTNGTYP>
      <CATEGORY>Other Current Liabilities</CATEGORY>
      <TPCLBLNC>1</TPCLBLNC>
      <FXDORVAR>1</FXDORVAR>
    </taUpdateCreateAccountRcd>
    <taCreateVariableAllocationAccountRcd_Items xsi:nil="true" />
    <taCreateFixedAllocationAccountRcd_Items xsi:nil="true" />
  </GLAccountType>
  <PAAccountsSetupType>
    <eConnectProcessInfo xsi:nil="true" />
    <taRequesterTrxDisabler_Items xsi:nil="true" />
    <taPAAccountsSetup_Items>
      <taPAAccountsSetup>
        <PAsfid>34</PAsfid>
        <PArecordid>BAMA BCS 2010  </PArecordid>
        <PAaccttype>35</PAaccttype>
        <PAAccount>03-2201-01</PAAccount>
      </taPAAccountsSetup>
    </taPAAccountsSetup_Items>
  </PAAccountsSetupType>
</eConnect>

 Hello, I see in the eConnect help file there is a RMApply schema.  Has anyone used this?  If so, please provide feedback.

Also, I don't see a PMApply in the help file.  Does anyone know if there is a PMApply?  I find it hard to believe MS would only do a RM and not a PM apply schema.

Thanks.

G

Sometimes the stuff I code can be best described as arcane. Or obtuse. Even better: stuff not many people care about. That's OK, I like it.

Todays topic involves getting the CMRECNUM field from the CM Transaction Entry form in Dynamics GP 10. You can't see the field on the form, only the 'Document Number' (00000000000000005 in the image below); and Document Number is not unique.

 


This piece of VS Tools code will get that value for you.