Invalid Account Number

[jbonini]

Hello: I am using iCompta on the iPad. I am trying to connect to my bank via OFX services. It appears to log-in, however I receive an error from the server "Invalid Account Number [XXXXXXXXXX]". I checked the account number several times and called my bank to verify I'm inputting it correctly. They say that I am. Any thoughts on how to fix this? It is a checking account (ACCTTYPE=CHECKING), which is set in the account setup screen. I am at a loss. Anyone have any ideas? I appreciate any thoughts. Thanks.

[Angeman]

Can you click on the details button in the alert that appears and copy/paste the error message ?
There will be your login and password in it so you make sure to remove them.

[jbonini]

Thank you for responding. Following is the information you asked for (I filled in X's for the username, password and account info):

Server
https://ofxdi.diginsite.com/cmr/cmr.ofx

Request
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20110822
<USERID>XXXXXX
<USERPASS>XXXXXXXXXXX
<LANGUAGE>ENG
<FI>
<ORG>DI
<FID>271972899
</FI>
<APPID>QWIN
<APPVER>1500
</SONRQ>
</SIGNONMSGSRQV1>
<BANKMSGSRQV1>
<STMTTRNRQ>
<TRNUID>859ABDD3-20A7-48F5-8452-1467B62AC336
<STMTRQ>
<BANKACCTFROM>
<BANKID>071923954
<ACCTID>XXXXXXXXXX
<ACCTTYPE>CHECKING
</BANKACCTFROM>
<INCTRAN>
<DTSTART>19700101
<INCLUDE>Y
</INCTRAN>
</STMTRQ>
</STMTTRNRQ>
</BANKMSGSRQV1>
</OFX>

Response
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><DTSERVER>20110822123338.040[-7:PDT]<LANGUAGE>ENG<FI><ORG>DI<FID>271972899</FI></SONRS></SIGNONMSGSRSV1><BANKMSGSRSV1><STMTTRNRS><TRNUID>859ABDD3-20A7-48F5-8452-1467B62AC336<STATUS><CODE>2003<SEVERITY>ERROR<MESSAGE>Invalid Account Number [XXXXXXXXXX]</STATUS></STMTTRNRS></BANKMSGSRSV1></OFX>

Accounts
SAVINGS XXXXXXXXXX [271972899]
CHECKING XXXXXXXXXX [271972899]
CHECKING XXXXXXXXXX [271972899]

[Angeman]

Try to set the Bank ID field to 271972899 instead of 071923954.

[jbonini]

Perfect. That works. I thought I had tried everything before writing--I should have figured that out. Thanks for writing. One last item. I note that transactions come in with the "payee" field and the "memo" filed reversed. I know that problem is on my bank's side and not an issue with your software. However, is there a way to perhaps have an option to reverse those fields on import? Just curios. Thanks again.

[Angeman]

Yes, I will add this option in V3.