Tryton - Issues

 

Issue8879

Title Total Amount on OFX statement is actually Start / End Balance
Priority bug Status chatting
Superseder Nosy List ced, dave
Type behavior Components account_statement_ofx
Assigned To Keywords
Reviews

Created on 2019-11-29.12:57:53 by dave, last changed by ced.

Messages
msg54287 (view) Author: [hidden] (ced) (Tryton committer) (Tryton translator) Date: 2019-12-05.18:44:11
It seems OK if the computation is simple.
msg53808 (view) Author: [hidden] (dave) Date: 2019-12-03.18:16:02
I was only suggesting using data from the OFX file.

From what I can see the ofx.account.statement.balance (LEDGERBAL aggregate) is the "End Balance" for the account, so I was suggesting possibly using this from the file, and the calculated "Total Amount" (also from the file) to get the "Start Balance".
msg53737 (view) Author: [hidden] (ced) (Tryton committer) (Tryton translator) Date: 2019-11-29.13:39:59
I do not think the starte/end balance is an available information on OFX.
We should fill data only with the content of the file.
msg53735 (view) Author: [hidden] (dave) Date: 2019-11-29.13:36:15
Would it be sensible to add the "Start Balance" / "End Balance" using the ofx.account.statement.balance too?  As you cannot use an Validation Type of Balance with OFX files because the start / end balance are then required fields so the statement cannot be created without them, or is that a separate issue?
msg53734 (view) Author: [hidden] (ced) (Tryton committer) (Tryton translator) Date: 2019-11-29.13:22:59
It looks like OFX does not contain the total amount, so it should be computed.
msg53733 (view) Author: [hidden] (dave) Date: 2019-11-29.12:57:53
When importing an OFX statement, the Total Amount field is populated with the ofx.account.statement.balance.  This value is actually the account balance on the ofx.account.statement.balance_date, and not the sum of the values of the transactions on the statement.

Notes: The ofx.account.statement.balance field is taken from the BALAMT element inside the LEDGERBAL aggregate in the OFX file.  This is not the total of the transactions values as can be seen from the example on page 329 of the ofx spec (https://www.ofx.net/downloads/OFX%202.2.pdf).
History
Date User Action Args
2019-12-05 18:44:11cedsetmessages: + msg54287
2019-12-03 18:16:02davesetmessages: + msg53808
2019-11-29 13:39:59cedsetmessages: + msg53737
2019-11-29 13:36:16davesetmessages: + msg53735
2019-11-29 13:23:00cedsetstatus: unread -> chatting
nosy: + ced
messages: + msg53734
2019-11-29 12:58:17davesettitle: Total Amount on OFX statement is Start / End Balance -> Total Amount on OFX statement is actually Start / End Balance
2019-11-29 12:57:53davecreate

Showing 10 items. Show all history (warning: this could be VERY long)