Statement import in OFX format: Final balance required

Support User
1

Hi,

I am importing a statement in OFX format as usually and it fails poping me up an error saying a value is required for the field “final balance”.

The exact error message in french is:

Une valeur est requise pour le champ « Solde final » sur l'enregistrement « 00 » de « Relevé comptable »

Logs are clean.

What has changed since the last successful import:

  • I started a new fiscal year but the previous one is still to be closed.
  • I updated from 7.2 to 7.4.

I tried opening a previous OFX that I know was correctly imported and it gives the same error. It contains the final balance as my last OFX does too.

Any idea?

2

What changed is OFX balance not always at the statement end date (#13982) · Issues · Tryton / Tryton · GitLab
So it looks like your bank put in the OFX a balance that has not the same date as the end date of the statement.
In such case you can not request that the statement journal validate the balance.

3

That’s it, thanks!

So LCL (french) is one of those banks that set a balance date slighty different (12h in my case) from the statement end date.

What I did to make Tryton import it is hack the balance date in the OFX file: set the date <DTASOF> within the <LEDGERBAL> tag to the same as <DTEND>.

4

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.