Importing OFX statement file in 5.0

[jcm (Jean-Christophe Michel)]

Hi,

I tried to reproduce the ofx import scenario from scenario_account_statement_ofx on demo5.0.tryton.org, with the provided file OFX.txt from account_statement_ofx (I changed only EUR to USD to fit the currency selected on demo).
I get this error alert : “The field “End Balance” on “Account Statement” is required”.

I had the same error here with my bank statement files. I cannot see any line in OFX standard that would provide such value. My conclusion would be that there is a useless validation in the wizard…

[risto3]

We encountered similar problems, but found the following Issue 8879: Total Amount on OFX statement is actually Start / End Balance - Tryton issue tracker which seems not to have advanced much.

OFX seems useless as such for now.
We decided, for example, to prototype a CFONB120 (France) statement importer in order to get over this for our banks.

Cheers,

[jcm (Jean-Christophe Michel)]

Thks Richard for confirming the bug.

@jcm

I had the same error here with my bank statement files. I cannot see any line in OFX standard that would provide such value.

In fact the LEDGERBAL BALAMT value should be the requested value, if examples on ofx website are accurate.

[dave (David Harper)]

@jcm

I get this error alert : “The field “End Balance” on “Account Statement” is required”.

This is because when the statement is created from the OFX file no start and end balance get added to the statement. In the statement journal, if you change the Validation Type to “Number of Lines”, then you should be able to import the OFX file.

@risto3

We encountered similar problems, but found the following Issue 8879: Total Amount on OFX statement is actually Start / End Balance - Tryton issue tracker which seems not to have advanced much.

I have just added review262751002 that hopefully resolves that issue.