shayota 6/26/2020 1:18:21 PM

taRMDistribution - 'Account Does Not Exist' for a GL that is used as a default [Error Code 1340]

Hi everyone,

I'm working on a .Net C# Application that is designed to create credit memos with distributions that to need to be applied to outstanding invoices each month.

At this point I'm having trouble with the distributions part because of Error # 1340: Account does not exist for Account Number String <ACTNUMST>

The issue I'm having is that the String I'm passing, "12000-00" is our Accounts Receivable GL and that is the default for this type of transaction so I know for a fact that it does exist. Here is what it looks like when I manually create a credit memo and open the distributions tab.

Since I had trouble trying to edit the empty GL, I elected to set CREATEDIST = 0; and just assign the GL's myself.

It even accepts account numbers that are designated as 'Inactive', but for some reason wont accept this highly used default GL#.

Here is the XML I'm feeding and I greatly appreciate any help or advice.

<?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">
  <RMTransactionType>
    <eConnectProcessInfo xsi:nil="true" />
    <taRequesterTrxDisabler_Items xsi:nil="true" />
    <taUpdateCreateCustomerRcd xsi:nil="true" />
    <taCreateCustomerAddress_Items xsi:nil="true" />
    <taRMCommissions_Items xsi:nil="true" />
    <taRMTransactionTaxInsert_Items xsi:nil="true" />
    <taRMDistribution_Items>
      <taRMDistribution>
        <RMDTYPAL>7</RMDTYPAL>
        <DOCNUMBR>100003-GLCR</DOCNUMBR>
        <CUSTNMBR>10500</CUSTNMBR>
        <DISTTYPE>19</DISTTYPE>
        <ACTNUMST>12004-02</ACTNUMST>
        <DEBITAMT>177.75</DEBITAMT>
      </taRMDistribution>
      <taRMDistribution>
        <RMDTYPAL>7</RMDTYPAL>
        <DOCNUMBR>100003-GLCR</DOCNUMBR>
        <CUSTNMBR>10500</CUSTNMBR>
        <DISTTYPE>3</DISTTYPE>
        <ACTNUMST>12000-00</ACTNUMST>
        <CRDTAMNT>177.75</CRDTAMNT>
      </taRMDistribution>
    </taRMDistribution_Items>
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taRMTransaction>
      <RMDTYPAL>7</RMDTYPAL>
      <DOCNUMBR>100003-GLCR</DOCNUMBR>
      <DOCDATE>04/30/2020</DOCDATE>
      <BACHNUMB>91+ CR</BACHNUMB>
      <CUSTNMBR>10500</CUSTNMBR>
      <DOCAMNT>177.75</DOCAMNT>
      <SLSAMNT>177.75</SLSAMNT>
      <DOCDESCR>DTS ON FILE DO SHORTS OVERS</DOCDESCR>
      <ADRSCODE>buckeye</ADRSCODE>
      <CREATEDIST>0</CREATEDIST>
    </taRMTransaction>
    <taMdaUpdate_Items xsi:nil="true" />
  </RMTransactionType>
</eConnect>

 

 

Version: Unknown or N/A, GP 2015
Section: .NET Development, Dynamics GP, eConnect


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3