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.
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.
also recheck if the lines F100, F200 don't have some specific filters attached
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 ?
Yes in ledger entries both business units are showing .
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.
In consolidated trial both companies showing.
Then maybe You can add a screenshot of You Financial Report lines ?
Yes I can see balance of both companies in chart of account.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156