eConnect Bank Reconciliation - HSalim[MVP] |
16-Oct-07 11:42:26
|
please post your xml document
HS |
 |
| |
eConnect Bank Reconciliation - J |
17-Oct-07 09:41:06
|
EB:
I had the same type of issue with that edit check awhile back and my issue
was it was a bug with that procedure. Support had me download a hot fix for
eConnect and after that I was fine and no longer returned the edit check. I
originally thought it was an MC issue on my part as well but it happened to
me on non-MC transactions so I eventually ruled that out.
I checked my notes and they had me load any version of eConnect on or after
9.0.2.2 - as the fix was in that 9.0.2.2 and since all of the ones after that
I believe are all inclusive I think you will be fine.
Give that a try - hopefully it does the trick for you like it did for me.
JG |
| |
| |
eConnect Bank Reconciliation - O |
17-Oct-07 04:59:00
|
I had the same error. It looks like you only have to create second
distribution, default one is created automatically.
It says in eConnect manual on Bank Rec. : "eConnect automatically creates
the one required distribution."
O.C. |
| |
| |
eConnect Bank Reconciliation - EB |
17-Oct-07 05:05:27
|
This is a multi-part message in MIME format.
------=_NextPart_000_0013_01C8111A.98FA6DF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi HS,
I'm working on eConnect GP 10, so this should be the latest and greatest =
version.
I'll really appreciate any comments, following is the error and the xml =
file.
the Error I recieve once again is:
{Microsoft.Dynamics.GP.eConnect.eConnectException: Sql procedure error =
codes returned:
Error Number =3D 7604 Stored Procedure taBRBankTransactionHeader Error =
Description =3D=20
Originating Debits and Credits do not match (ORDBTAMT <> ORCRDAMT in =
CM20400)
Node Identifier Parameters: taBRBankTransactionHeader =
=20
CMTrxNum =3D 00000000000000000001
CHEKBKID =3D FIRST BANK
---> Microsoft.Dynamics.GP.eConnect.eConnectException: Error Number =3D =
7604 =20
Stored Procedure taBRBankTransactionHeader =20
Error Description =3D Originating Debits and Credits do not match =
(ORDBTAMT <> ORCRDAMT in CM20400)
while the xml file which is passed to eConnect is:
xmlns:xsd=3D\"http://www.w3.org/2001/XMLSchema\">
/eConnect>
Thanks,
Eyal.
Credits do=20
------=_NextPart_000_0013_01C8111A.98FA6DF0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
charset=3Diso-8859-1">
should be=20
the latest and greatest version.</FONT></DIV>
following is=20
the error and the xml file.</FONT></DIV>
is:</FONT></DIV>
size=3D2>{Microsoft.Dynamics.GP.eConnect.eConnectException:=20
Sql procedure error codes returned:<BR>Error Number =3D 7604 =
Stored=20
Procedure taBRBankTransactionHeader Error Description =3D =
Debits and Credits do not match (ORDBTAMT <> ORCRDAMT in=20
CM20400)<BR></FONT></DIV>
taBRBankTransactionHeader =
&=
nbsp; =20
BANK<BR><taBRBankTransactionHeader><BR><Option>1</Option&g=
t;<BR><TRXDATE>17/10/2007=20
12:00:00 AM</TRXDATE><BR><CHEKBKID>FIRST=20
BANK</CHEKBKID><BR><CMTrxNum>00000000000000000001</CMTrxNu=
m><BR><paidtorcvdfrom>eyal</paidtorcvdfrom><BR><DSCRIPT=
N>ddddd</DSCRIPTN><BR><TRXAMNT>100</TRXAMNT><BR><=
BACHNUMB>BR</BACHNUMB><BR><RequesterTrx>1</RequesterTrx=
><BR></taBRBankTransactionHeader>=20
Number =3D=20
7604 <BR>Stored Procedure taBRBankTransactionHeader =
Description =3D Originating Debits and Credits do not match (ORDBTAMT =
<>=20
ORCRDAMT in CM20400)</FONT></DIV>
passed to=20
eConnect is:</STRONG></FONT></DIV>
encoding=3D\"utf-8\"?><BR><eConnect xmlns:xsi=3D\"</FONT><A=20
href=3D"http://www.w3.org/2001/XMLSchema-instance\"><FONT face=3DArial=20
size=3D2>http://www.w3.org/2001/XMLSchema-instance\</FONT></A><FONT =
face=3DArial=20
size=3D2>" xmlns:xsd=3D\"</FONT><A =
href=3D"http://www.w3.org/2001/XMLSchema\"><FONT=20
face=3DArial size=3D2>http://www.w3.org/2001/XMLSchema\</FONT></A><FONT =
face=3DArial=20
size=3D2>"><BR><BRBankTransactionType><eConnectProcessInfo=20
xsi:nil=3D\"true\" /><BR><taRequesterTrxDisabler_Items =
xsi:nil=3D\"true\"=20
/><BR> <taBRBankTransactionDist_Items><BR> <t=
aBRBankTransactionDist><BR> <Option>1</Optio=
n><BR> <ACTNUMST>000-1100-00</ACTNUMST><B=
R> <DEBITAMT>100</DEBITAMT><BR> &=
lt;/taBRBankTransactionDist></FONT></DIV>
size=3D2> <taBRBankTransactionDist><BR> =
;<Option>1</Option><BR> <ACTNUMST>000-=
1101-00</ACTNUMST><BR> <CRDTAMNT>100</CRD=
TAMNT><BR> </taBRBankTransactionDist><BR> </t=
aBRBankTransactionDist_Items><BR><taAnalyticsDistribution_Items=20
xsi:nil=3D\"true\" /></FONT></DIV>
size=3D2> <taBRBankTransactionHeader><BR> <Optio=
n>1</Option><BR> <TRXDATE>17/10/2007=20
12:00:00 AM</TRXDATE><BR> <CHEKBKID>FIRST=20
BANK</CHEKBKID><BR> <CMTrxNum>00000000000000000001=
</CMTrxNum><BR> <paidtorcvdfrom>eyal</paidtorcv=
dfrom><BR> <DSCRIPTN>ddddd</DSCRIPTN><BR> =
<TRXAMNT>100</TRXAMNT><BR> <BACHNUMB>B=
R</BACHNUMB><BR> <RequesterTrx>1</RequesterTrx&=
gt;<BR> </taBRBankTransactionHeader></FONT></DIV>
size=3D2></BRBankTransactionType><BR>/eConnect></FONT></DIV>
href=3D"mailto:HSalim@msn.com"><FONT face=3DArial=20
size=3D2>HSalim@msn.com</FONT></A><FONT face=3DArial size=3D2>> wrote =
in message=20
face=3DArial=20
face=3DArial=20
size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> please post =
your xml=20
document<BR>> HS<BR>> <BR>> "EB" <</FONT><A=20
href=3D"mailto:eyal@etssoftware.net"><FONT face=3DArial=20
size=3D2>eyal@etssoftware.net</FONT></A><FONT face=3DArial size=3D2>> =
wrote in=20
message <BR>> </FONT><A=20
face=3DArial=20
size=3D2>...<BR>>> We are trying to post an eConnect Bank =
Reconciliation (GP=20
10) cheque <BR>>> issuance transaction.<BR>>><BR>>> =
However we=20
reapetedly get the error of "Originating Debits and Credits do =
match" in any scenario of parameters supplying the eConnect.<BR>>> =
We want=20
to have our own distribution for the =
transaction.<BR>>><BR>>> What=20
do we miss ??????<BR>>><BR>>> We recieve the following=20
error:<BR>>><BR>>> Error Number =3D 7604<BR>>> Stored =
Procedure=20
taBRBankTransactionHeader<BR>>> Error Description =3D<BR>>>=20
Originating Debits and Credits do not match (ORDBTAMT <> ORCRDAMT =
in=20
taBRBankTransactionHeader<BR>>> CMTrxNum =3D=20
00000000000000000001<BR>>> CHEKBKID =3D FIRST BANK<BR>>> =
Related Error=20
Code Parameters for Node :=20
taBRBankTransactionHeader<BR>>><BR>>><BR>>>=20
<taBRBankTransactionHeader><BR>>>=20
<Option>1</Option><BR>>> <TRXDATE>16/10/2007 =
12:00:00=20
AM</TRXDATE><BR>>> <CHEKBKID>FIRST=20
BANK</CHEKBKID><BR>>>=20
<CMTrxNum>00000000000000000001</CMTrxNum><BR>>>=20
<paidtorcvdfrom>eyal</paidtorcvdfrom><BR>>>=20
<DSCRIPTN>ddddd</DSCRIPTN><BR>>>=20
<TRXAMNT>200</TRXAMNT><BR>>>=20
<BACHNUMB>BR</BACHNUMB><BR>>>=20
</taBRBankTransactionHeader><BR>>> --->=20
Microsoft.Dynamics.GP.eConnect.eConnectException:<BR>>> Error =
Number =3D=20
7604 Stored Procedure taBRBankTransactionHeader<BR>>> Error=20
Description =3D Originating Debits and Credits do not match<BR>>> =
(ORDBTAMT=20
<> ORCRDAMT in CM20400)<BR>>><BR>>> <BR>>=20
------=_NextPart_000_0013_01C8111A.98FA6DF0-- |
| |
| |
eConnect Bank Reconciliation - EB |
17-Oct-07 05:27:34
|
Thanks O.C,
I really didn't understand what was the meaning in the eConnect help it was
vague to me until I read your comments, any way I droped the first
distribution, the one eConnect supply automatically and then it worked like
magice.
Thanks.
EB. |
| |
| |
eConnect Bank Reconciliation - HSalim[MVP] |
18-Oct-07 12:08:29
|
Glad to see that your problem was resolved, thanks to OC |
| |
| |