Dashboard Net worth doesn't sum up all assets account

[jinformatique]

I am running Firefly III version 4.6.12

I just started fresh from a new install to record all my assets account for 2018 and put an initial balance. It seems the total of all my assets account is not taking into account. The net worth is based only on one asset account. Same goes for the details on the account graph. You can check on the screenshots. Maybe is it part of the #1040?

[JC5]

I see what's happening. I can't reproduce it.

I created three normal asset accounts with everything on default.

• No balance: empty
• 1 dec: balance of 1000 on 1 dec 2017 (opening balance)
• 1 jan: balance of 1000 on 1 jan 2018 (opening balance)

All accounts are correct, net worth is 2000.

Did you do something with foreign / not-foreign balances?

[jinformatique]

So, I just connected today and the NET WORTH is the amount of all the asset accounts. Good.
I don't have any foreign / not-foreign balances, what is it?

But still in the graphic below, I have 0 for all asset accounts:

[JC5]

Could you run the following query for me? Share the info over email.

Instead of the number XXX, enter one of the account numbers of an asset account that has a balance, but shows 0 in the chart.

select

	`transaction_journals`.`date`,
	`transactions`.`transaction_currency_id`,
	SUM(transactions.amount) AS modified,
	`transactions`.`foreign_currency_id`,
	SUM(transactions.foreign_amount) AS modified_foreign
from
	`transactions`
	left join `transaction_journals` on `transactions`.`transaction_journal_id` = `transaction_journals`.`id`
where
	`transactions`.`account_id` = 'xxxxxxx' and 
	`transactions`.`account_id` is not null and 
	`transaction_journals`.`date` >= '2018-01-01' and 
	`transaction_journals`.`date` <= '2018-02-01' and 
	`transaction_journals`.`deleted_at` is null and 
	`transactions`.`deleted_at` is null 

group by
	`transaction_journals`.`date`,
	`transactions`.`transaction_currency_id`,
	`transactions`.`foreign_currency_id`
order by `transaction_journals`.`date` asc

[Nik-vr]

I use SQLite database. How do I make this query?

[JC5]

Use a program like DB browser for sqlite. This should work in that program. I believe there is an option to run a query:

select

	transaction_journals.date,
	transactions.transaction_currency_id,
	SUM(transactions.amount) AS modified,
	transactions.foreign_currency_id,
	SUM(transactions.foreign_amount) AS modified_foreign
from
	transactions
	left join transaction_journals on transactions.transaction_journal_id = transaction_journals.id
where
	transactions.account_id = 'xxxxxxx' and 
	transactions.account_id is not null and 
	transaction_journals.date >= '2018-01-01' and 
	transaction_journals.date <= '2018-02-01' and 
	transaction_journals.deleted_at is null and 
	transactions.deleted_at is null 

group by	
	transaction_journals.date,
	transactions.transaction_currency_id,
	transactions.foreign_currency_id
order by transaction_journals.date asc

[Nik-vr]

I run the specified query. It returns part of the transactions, not all.

[JC5]

That's no problem, the amounts are summed up. But good news: I think I have found the problem. It will be fixed in the next release.

[Nik-vr]

OK!

[Nik-vr]

I tested your fix. Now the chart works! Thank you!