Small and medium business | Business Central, N...

Consolidated financial reports:

(0) Share

Report

Posted on by MOHAMMAD TAHA IMTIAZ

427

I have two companies and one for consolidation.

I have done all setups ,consolidated l trial balance 4 showing data of both companies but in financial report showing data only in one company.

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

KasparsSemjonovs 4,685 Super User 2025 Season 2 on at

Like (0)

Report

RE: Consolidated financial reports:

if You see the amounts from both companies in Chart of Account, then You should see the amounts also in Financial reports. Might recheck the filters for lines/columns - for dimension values or other

Was this reply helpful? Yes No
MOHAMMAD TAHA IMTIAZ 427 on at

Like (0)

Report

RE: Consolidated financial reports:

Yes I can see balance of both companies in chart of account.

Was this reply helpful? Yes No
KasparsSemjonovs 4,685 Super User 2025 Season 2 on at

Like (0)

Report

RE: Consolidated financial reports:

Then maybe You can add a screenshot of You Financial Report lines ?

Was this reply helpful? Yes No
MOHAMMAD TAHA IMTIAZ 427 on at

Like (0)

Report

RE: Consolidated financial reports:

Was this reply helpful? Yes No
MOHAMMAD TAHA IMTIAZ 427 on at

Like (0)

Report

RE: Consolidated financial reports:

In consolidated trial both companies showing.

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,685 Super User 2025 Season 2 on at

Like (0)

Report

RE: Consolidated financial reports:

Check "General Ledger Entries" and filter by the "Business Unit Code" and see if any of the entries has the A or B code attached.

Financial Reports are based on General Ledger Entries, so You can try to add the same filters to the page and see/recheck the results.

In the Financial Report list You can see if You are using Analysis View. If it is used, open the list, and check if the used View is updated.

Was this reply helpful? Yes No
MOHAMMAD TAHA IMTIAZ 427 on at

Like (0)

Report

RE: Consolidated financial reports:

Yes in ledger entries both business units are showing .

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,685 Super User 2025 Season 2 on at

Like (0)

Report

RE: Consolidated financial reports:

If theres only 2 business units, You can try to change the filters, in 1st column Business unit leave "A"

and in second Business Unit change to "<>A"

Retested in my consolidated company and it should work, but if You have some customizations, who knows what has gone wrong.

When looking at the results, You can click in a cell where should be values, and You can check the filters and if system finds any entries. Maybe You have run a closing, and zeroed all company A transactions ?

Was this reply helpful? Yes No
KasparsSemjonovs 4,685 Super User 2025 Season 2 on at

Like (0)

Report

RE: Consolidated financial reports:

also recheck if the lines F100, F200 don't have some specific filters attached

Was this reply helpful? Yes No
Suggested answer

Dallefeld 197 User Group Leader on at

Like (0)

Report

RE: Consolidated financial reports:

Are your Business Units actually the letters A and B? If not, then you need to put the actual Business Unit values in the column definition. Also, it might be helpful to show some general ledger entries with the business unit dimensions in a screenshot for better assistance here.

Was this reply helpful? Yes No