search

ledgersmb / LedgerSMB

Double-entry accounting & ERP for the web
https://ledgersmb.org
Other
429 stars 151 forks source link

Business/Reporting Units in Trial Balance Report not working #8381

Open aungzwin10 opened 3 months ago

aungzwin10 commented 3 months ago

Version

1.11.16

What browsers are you seeing the problem on?

This problem isn't browser related

What happened?

Screenshot 2024-08-22 at 5 45 52 PM

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 commented 1 month ago

Are you sure there is data? I see

https://github.com/ledgersmb/LedgerSMB/blob/4084f7aaea2af81de3caa2c07735b503d165fe1e/sql/modules/trial_balance.sql#L95-L111

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.