DynDeveloper.com

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.

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>

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.