Business/Reporting Units in Trial Balance Report not working

[aungzwin10]

Version

1.11.16

What browsers are you seeing the problem on?

This problem isn't browser related

What happened?

When filtering the Trial Balance report with business/reporting unit(s), the data never come out.

What should have happened?

The business/reporting unit(s) filter should work as in income statement.

[ehuelsmann]

Are you sure there is data? I see

LedgerSMB/sql/modules/trial_balance.sql

Lines 95 to 111 in 4084f7a

	WITH RECURSIVE bu_tree (id, path) AS (
	SELECT id, id::text AS path
	FROM business_unit
	WHERE parent_id = any(in_business_units)
	UNION
	SELECT bu.id, bu_tree.path || ',' || bu.id
	FROM business_unit bu
	JOIN bu_tree ON bu_tree.id = bu.parent_id
	)
	SELECT ac.transdate, ac.amount_bc, ac.chart_id
	FROM (select * from acc_trans
	where in_business_units = '{}' OR in_business_units IS NULL
	OR EXISTS (
	select 1 from business_unit_ac buac
	join bu_tree on bu_tree.id = buac.bu_id
	where buac.entry_id = acc_trans.entry_id
	)) ac

which is the heart of the data retrieval for this function. you could try running that to see if there is data in the system.