Error message when you use eConnect in Microsoft Dynamics GP together with a bank transaction in Analytical Accounting: "Error Number = 9469 Stored Procedure taAnalyticsDistribution

SYMPTOMS

When you use eConnect in Microsoft Dynamics GP, you receive the following error message:

Error Number = 9469 Stored Procedure taAnalyticsDistribution Error Description = Cannot find a distribution amount based on input value.

This problem occurs if the following conditions are true:

• You are using eConnect together with a bank transaction in Analytical Accounting in Microsoft Dynamics GP.
• You use the DistSequence element in the taAnalyticsDistribution node when you process a bank transaction.

CAUSE

This problem occurs because the taBRBankTransactionDist node does not have a distribution sequence. Bank transactions are posted as soon as they are entered. Therefore, you cannot use the DistSequence value in the taAnalyticsDistribution node.

RESOLUTION

<eConnect>
  <BRBankTransactionType>
    <taBRBankTransactionDist_Items>
      <taBRBankTransactionDist>
        <Option>1</Option>
        <ACTNUMST>000-1103-00</ACTNUMST>
        <DEBITAMT>31.72</DEBITAMT>
        <CRDTAMNT>0</CRDTAMNT>
        <DistRef>Dist Ref 2</DistRef>
      </taBRBankTransactionDist>
    </taBRBankTransactionDist_Items>
  <taAnalyticsDistribution_Items>
    <taAnalyticsDistribution>
        <DOCNMBR>MIKE0008</DOCNMBR>
        <DOCTYPE>3</DOCTYPE>
        <NOTETEXT>This is an AA test</NOTETEXT>
        <DistRef>New Schema Type for AA</DistRef>
        <AMOUNT>31.72</AMOUNT>
        <aaTrxDim>CCTR</aaTrxDim>
        <aaTrxDimCode>CC01</aaTrxDimCode>
      </taAnalyticsDistribution>
      <taAnalyticsDistribution>
        <DOCNMBR>MIKE0008</DOCNMBR>
        <DOCTYPE>3</DOCTYPE>
        <NOTETEXT>This is an AA test</NOTETEXT>
        <DistRef>New Schema Type for AA</DistRef>
        <AMOUNT>31.72</AMOUNT>
        <aaTrxDim>CCTR</aaTrxDim>
        <aaTrxDimCode>CC01</aaTrxDimCode>
      </taAnalyticsDistribution>
    </taAnalyticsDistribution_Items>
    <taBRBankTransactionHeader>
      <Option>1</Option>
      <CMTrxType>3</CMTrxType>
      <TRXDATE>4/14/2007</TRXDATE>
      <CHEKBKID>FLEX BENEFITS</CHEKBKID>
      <CMTrxNum>MIKE0008</CMTrxNum>
      <paidtorcvdfrom>Paid To</paidtorcvdfrom>
      <DSCRIPTN>Description</DSCRIPTN>
      <TRXAMNT>31.72</TRXAMNT>
      <USERID>sa</USERID>
      <DistRef>Dist Ref 1</DistRef>
    </taBRBankTransactionHeader>
  </BRBankTransactionType>		
</eConnect>