taRMApply issue when adding a discount
Hello everyone,
First, I want to thank you in advance for you help with resolving this issue.
Our company wants to apply cash to open invoices via eConnect. I am able to successful create these transaction, however, when they try to apply a discount, I am getting an error that I have not passed in actindex or the actnumst to the transaction. These two fields are not available in the taRMApply document, so I thought maybe I needed to add a taGLTransaction to the eConnect as well, but this did not fix my issue. I am going to post the error message I get as well as the eConnect xml document I submit in hope that someone will have an idea on what I might be missing.
Econnect xml document:
<?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”>
-<RMApplyType>
<eConnectProcessInfo xsi:nil=”true”/>
<taRequesterTrxDisabler_Items xsi:nil=”true”/>
<taAnalyticsDistribution_Items xsi:nil=”true”/>
-<taRMApply>
<APTODCNM>101235186</APTODCNM>
<APFRDCNM>PYMNT0234704 </APFRDCNM>
<APPTOAMT>2300.53</APPTOAMT>
<APFRDCTY>9</APFRDCTY>
<APTODCTY>1</APTODCTY>
<DISTKNAM>37.00</DISTKNAM>
<APPLYDATE>7/1/2017</APPLYDATE>
<GLPOSTDT>7/1/2017</GLPOSTDT>
</taRMApply>
</RMApplyType>
-<GLTransactionType>
<eConnectProcessInfo xsi:nil=”true”/>
<taRequesterTrxDisabler_Items xsi:nil=”true”/>
-<taGLTransactionLineInsert_Items>
-<taGLTransactionLineInsert>
<BACHNUMB>Integrator</BACHNUMB>
<JRNENTRY>911160</JRNENTRY>
<ACTINDX>286</ACTINDX>
<CRDTAMNT>37.00</CRDTAMNT>
<DEBITAMT>0</DEBITAMT>
<ACTNUMST>12000-10-00</ACTNUMST>
</taGLTransactionLineInsert>
-<taGLTransactionLineInsert>
<BACHNUMB>Integrator</BACHNUMB>
<JRNENTRY>911160</JRNENTRY>
<ACTINDX>45</ACTINDX>
<CRDTAMNT>0</CRDTAMNT>
<DEBITAMT>37.00</DEBITAMT>
<ACTNUMST>33010-10-20</ACTNUMST>
</taGLTransactionLineInsert>
</taGLTransactionLineInsert_Items>
<taAnalyticsDistribution_Items xsi:nil=”true”/>
-<taGLTransactionHeaderInsert>
<BACHNUMB>Integrator</BACHNUMB>
<JRNENTRY>911160</JRNENTRY>
<REFRENCE>Integrator Apply Cash process</REFRENCE>
<TRXDATE>7/1/2017</TRXDATE>
<TRXTYPE>0</TRXTYPE>
</taGLTransactionHeaderInsert>
<taMdaUpdate_Items xsi:nil=”true”/>
</GLTransactionType>
</eConnect>
Error Received
Sql procedure error codes returned:
Error Number = 683 Stored Procedure= taGLTransactionLineInsert Error Description = You have not passed an ACTINDX (ACTINDX) or an Account String (ACTNUMST) Node Identifier Parameters: taGLTransactionLineInsert Related Error Code Parameters for Node : taGLTransactionLineInsert ACTINDX = Note: This parameter was not passed in, no value for the parameter will be returned.
ACTNUMST = Note: This parameter was not passed in, no value for the parameter will be returned.
Error Number = 5470 Stored Procedure= taRMApply Error Description = Could not create GL transaction line Node Identifier Parameters: taRMApply APFRDCTY = 9
APFRDCNM = PYMNT0234704
APTODCTY = 1
APTODCNM = 101235186
<taRMApply>
<APTODCNM>101235186</APTODCNM>
<APFRDCNM>PYMNT0234704 </APFRDCNM>
<APPTOAMT>2300.53</APPTOAMT>
<APFRDCTY>9</APFRDCTY>
<APTODCTY>1</APTODCTY>
<DISTKNAM>37.00</DISTKNAM>
<APPLYDATE>7/1/2017</APPLYDATE>
<GLPOSTDT>7/1/2017</GLPOSTDT>
</taRMApply>
Sql procedure error codes returned:
Error Number = 683 Stored Procedure= taGLTransactionLineInsert Error Description = You have not passed an ACTINDX (ACTINDX) or an Account String (ACTNUMST) Node Identifier Parameters: taGLTransactionLineInsert Related Error Code Parameters for Node : taGLTransactionLineInsert ACTINDX = Note: This parameter was not passed in, no value for the parameter will be returned.
ACTNUMST = Note: This parameter was not passed in, no value for the parameter will be returned.
Error Number = 5470 Stored Procedure= taRMApply Error Description = Could not create GL transaction line Node Identifier Parameters: taRMApply APFRDCTY = 9
APFRDCNM = PYMNT0234704
APTODCTY = 1
APTODCNM = 101235186
<taRMApply>
<APTODCNM>101235186</APTODCNM>
<APFRDCNM>PYMNT0234704 </APFRDCNM>
<APPTOAMT>2300.53</APPTOAMT>
<APFRDCTY>9</APFRDCTY>
<APTODCTY>1</APTODCTY>
<DISTKNAM>37.00</DISTKNAM>
<APPLYDATE>7/1/2017</APPLYDATE>
<GLPOSTDT>7/1/2017</GLPOSTDT>
</taRMApply>
Thanks again for your help,
Bill
First, I want to thank you in advance for you help with resolving this issue.
Our company wants to apply cash to open invoices via eConnect. I am able to successful create these transaction, however, when they try to apply a discount, I am getting an error that I have not passed in actindex or the actnumst to the transaction. These two fields are not available in the taRMApply document, so I thought maybe I needed to add a taGLTransaction to the eConnect as well, but this did not fix my issue. I am going to post the error message I get as well as the eConnect xml document I submit in hope that someone will have an idea on what I might be missing.
Econnect xml document:
<?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”>
-<RMApplyType>
<eConnectProcessInfo xsi:nil=”true”/>
<taRequesterTrxDisabler_Items xsi:nil=”true”/>
<taAnalyticsDistribution_Items xsi:nil=”true”/>
-<taRMApply>
<APTODCNM>101235186</APTODCNM>
<APFRDCNM>PYMNT0234704 </APFRDCNM>
<APPTOAMT>2300.53</APPTOAMT>
<APFRDCTY>9</APFRDCTY>
<APTODCTY>1</APTODCTY>
<DISTKNAM>37.00</DISTKNAM>
<APPLYDATE>7/1/2017</APPLYDATE>
<GLPOSTDT>7/1/2017</GLPOSTDT>
</taRMApply>
</RMApplyType>
-<GLTransactionType>
<eConnectProcessInfo xsi:nil=”true”/>
<taRequesterTrxDisabler_Items xsi:nil=”true”/>
-<taGLTransactionLineInsert_Items>
-<taGLTransactionLineInsert>
<BACHNUMB>Integrator</BACHNUMB>
<JRNENTRY>911160</JRNENTRY>
<ACTINDX>286</ACTINDX>
<CRDTAMNT>37.00</CRDTAMNT>
<DEBITAMT>0</DEBITAMT>
<ACTNUMST>12000-10-00</ACTNUMST>
</taGLTransactionLineInsert>
-<taGLTransactionLineInsert>
<BACHNUMB>Integrator</BACHNUMB>
<JRNENTRY>911160</JRNENTRY>
<ACTINDX>45</ACTINDX>
<CRDTAMNT>0</CRDTAMNT>
<DEBITAMT>37.00</DEBITAMT>
<ACTNUMST>33010-10-20</ACTNUMST>
</taGLTransactionLineInsert>
</taGLTransactionLineInsert_Items>
<taAnalyticsDistribution_Items xsi:nil=”true”/>
-<taGLTransactionHeaderInsert>
<BACHNUMB>Integrator</BACHNUMB>
<JRNENTRY>911160</JRNENTRY>
<REFRENCE>Integrator Apply Cash process</REFRENCE>
<TRXDATE>7/1/2017</TRXDATE>
<TRXTYPE>0</TRXTYPE>
</taGLTransactionHeaderInsert>
<taMdaUpdate_Items xsi:nil=”true”/>
</GLTransactionType>
</eConnect>
Error Received
Sql procedure error codes returned:
Error Number = 683 Stored Procedure= taGLTransactionLineInsert Error Description = You have not passed an ACTINDX (ACTINDX) or an Account String (ACTNUMST) Node Identifier Parameters: taGLTransactionLineInsert Related Error Code Parameters for Node : taGLTransactionLineInsert ACTINDX = Note: This parameter was not passed in, no value for the parameter will be returned.
ACTNUMST = Note: This parameter was not passed in, no value for the parameter will be returned.
Error Number = 5470 Stored Procedure= taRMApply Error Description = Could not create GL transaction line Node Identifier Parameters: taRMApply APFRDCTY = 9
APFRDCNM = PYMNT0234704
APTODCTY = 1
APTODCNM = 101235186
<taRMApply>
<APTODCNM>101235186</APTODCNM>
<APFRDCNM>PYMNT0234704 </APFRDCNM>
<APPTOAMT>2300.53</APPTOAMT>
<APFRDCTY>9</APFRDCTY>
<APTODCTY>1</APTODCTY>
<DISTKNAM>37.00</DISTKNAM>
<APPLYDATE>7/1/2017</APPLYDATE>
<GLPOSTDT>7/1/2017</GLPOSTDT>
</taRMApply>
Sql procedure error codes returned:
Error Number = 683 Stored Procedure= taGLTransactionLineInsert Error Description = You have not passed an ACTINDX (ACTINDX) or an Account String (ACTNUMST) Node Identifier Parameters: taGLTransactionLineInsert Related Error Code Parameters for Node : taGLTransactionLineInsert ACTINDX = Note: This parameter was not passed in, no value for the parameter will be returned.
ACTNUMST = Note: This parameter was not passed in, no value for the parameter will be returned.
Error Number = 5470 Stored Procedure= taRMApply Error Description = Could not create GL transaction line Node Identifier Parameters: taRMApply APFRDCTY = 9
APFRDCNM = PYMNT0234704
APTODCTY = 1
APTODCNM = 101235186
<taRMApply>
<APTODCNM>101235186</APTODCNM>
<APFRDCNM>PYMNT0234704 </APFRDCNM>
<APPTOAMT>2300.53</APPTOAMT>
<APFRDCTY>9</APFRDCTY>
<APTODCTY>1</APTODCTY>
<DISTKNAM>37.00</DISTKNAM>
<APPLYDATE>7/1/2017</APPLYDATE>
<GLPOSTDT>7/1/2017</GLPOSTDT>
</taRMApply>
Thanks again for your help,
Bill