You’re offline. This is a read only version of the page.
2,622
Error Number = 7604 Stored Procedure= taBRBankTransactionHeader Error Description = Originating Debits and Credits do not match (ORDBTAMT <> ORCRDAMT in CM20400)
*This post is locked for comments
]-[! vikas as per rob described i think we can try this method.may be it will work for u .....
in the Transaction Distribution section replace this line of code section
<taBRBankTransactionDist>
<Option>1</Option>
<ACTNUMST>000-1110-00</ACTNUMST>
<CRDTAMNT>123</CRDTAMNT>
</taBRBankTransactionDist>
with
<taBRBankTransactionDist>
<Option>1</Option>
<ACTNUMST>000-1110-00</ACTNUMST>
<DEBITAMT>123</DEBITAMT>
</taBRBankTransactionDist>
the econneect maintain credit amount with header itself so you don't have to bother about that
just update your XML with this
//----------------------------------------------------------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="utf-8"?>
<eConnect xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:xsd="www.w3.org/.../XMLSchema">
<BRBankTransactionType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taBRBankTransactionDist_Items>
<taBRBankTransactionDist>
<Option>1</Option>
<ACTNUMST>000-1110-00</ACTNUMST>
<DEBITAMT>123</DEBITAMT>
</taBRBankTransactionDist>
</taBRBankTransactionDist_Items>
<taAnalyticsDistribution_Items xsi:nil="true" />
<taBRBankTransactionHeader>
<Option>1</Option>
<TRXDATE>1/2/15</TRXDATE>
<CHEKBKID>PAYROLL</CHEKBKID>
<CMTrxNum>11640</CMTrxNum>
<paidtorcvdfrom>vineetSharma</paidtorcvdfrom>
<DSCRIPTN>testing 124</DSCRIPTN>
<TRXAMNT>123</TRXAMNT>
<BACHNUMB>VKBRBAT32253</BACHNUMB>
</taBRBankTransactionHeader>
</BRBankTransactionType>
</eConnect>
//--------------------------------------------------------------------------------------------------------------------------------------------
and i think it must work for you Vikas ....
Thanks rob .... :)
Hi Rob,
I have tried with the modified XML. but still having same exception. should i need to add one more element or field in XML "CMTrxType" for defining the Transaction Type .
Hi Vikas,
Thanks for this, please find below a modified version of the XML that should work for you:
<?xml version="1.0" encoding="utf-8"?>
<eConnect xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:xsd="www.w3.org/.../XMLSchema">
<BRBankTransactionType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taBRBankTransactionDist_Items>
<taBRBankTransactionDist>
<Option>1</Option>
<ACTNUMST>000-1110-00</ACTNUMST>
<CRDTAMNT>123</CRDTAMNT>
</taBRBankTransactionDist>
</taBRBankTransactionDist_Items>
<taAnalyticsDistribution_Items xsi:nil="true" />
<taBRBankTransactionHeader>
<Option>1</Option>
<TRXDATE>1/2/17</TRXDATE>
<CHEKBKID>PAYROLL</CHEKBKID>
<CMTrxNum>11657</CMTrxNum>
<paidtorcvdfrom>vineetSharma</paidtorcvdfrom>
<DSCRIPTN>testing 124</DSCRIPTN>
<TRXAMNT>123</TRXAMNT>
<BACHNUMB>VKBRBAT50483</BACHNUMB>
</taBRBankTransactionHeader>
</BRBankTransactionType>
</eConnect>
The reason that it was failing when the header was provided is that the header inserts in the debit/credit side of the entry; depending on the option and transaction type provided in the schema:
The distributions will not have matching debits and credits. eConnect automatically creates the one required distribution. eConnect sets the type of the default distribution (DefaultDist) based on the values specified by the Option and transaction type (CMTrxNum) elements of the <taBRBankTransactionHeader> XML node. The following table shows the default distribution type for the valid combinations of Option and CMTrxType values:
Option CMTrxType DefaultDist
1 3 Credit
1 4 Credit
1 5 Debit
1 6 Credit
So when you setup the XML you only need to provide the debit or credit side, depending on the Option/CMTrxType being used.
Please let me know if you would like any additional information on this issue.
Regards
Rob
Hi Rob,
Here is my XML schema. please correct me . if there is any thing wrong.
<?xml version="1.0" encoding="utf-8"?>
<eConnect xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:xsd="www.w3.org/.../XMLSchema">
<BRBankTransactionType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taBRBankTransactionDist_Items>
<taBRBankTransactionDist>
<Option>1</Option>
<ACTNUMST>000-1110-00</ACTNUMST>
<DEBITAMT>123</DEBITAMT>
</taBRBankTransactionDist>
<taBRBankTransactionDist>
<Option>1</Option>
<ACTNUMST>000-1110-00</ACTNUMST>
<CRDTAMNT>123</CRDTAMNT>
</taBRBankTransactionDist>
</taBRBankTransactionDist_Items>
<taAnalyticsDistribution_Items xsi:nil="true" />
<taBRBankTransactionHeader>
<Option>1</Option>
<TRXDATE>1/2/12</TRXDATE>
<CHEKBKID>PAYROLL</CHEKBKID>
<CMTrxNum>11640</CMTrxNum>
<paidtorcvdfrom>vineetSharma</paidtorcvdfrom>
<DSCRIPTN>testing 124</DSCRIPTN>
<TRXAMNT>123</TRXAMNT>
<BACHNUMB>VKBRBAT50483</BACHNUMB>
</taBRBankTransactionHeader>
</BRBankTransactionType>
</eConnect>
Once i remove the Header Section from the XML. it will Successfully integrate the lines.
Hi Vikas,
Thanks for raising this with us. Can you paste in a copy of the XML schema that you are using to import the transactions; we will need to review this to determine why the distributions are unbalanced.
Regards
Rob
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (