forums.lyricapps.com

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.

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.

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]

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

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.

Yes, I will add this option in V3.