Invalid Account Number
Invalid Account Number
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
- Administrateur
- Posts: 2303
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: Invalid Account Number
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.
There will be your login and password in it so you make sure to remove them.
Re: Invalid Account Number
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]
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
- Administrateur
- Posts: 2303
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: Invalid Account Number
Try to set the Bank ID field to 271972899 instead of 071923954.
Re: Invalid Account Number
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.