You’re offline. This is a read only version of the page.
414
HI,
1. There are around 55 units in Navision
2. We have closed each units wise income statement.
3. In group level company we have run the consolidation month wise. Than we closed the income statement.
Consolidated TB values not matching with the standalone TB for respective units how to resolve this issue...?
*This post is locked for comments
Am I right in saying that you are closing your income statement in the consolidated (group) company? If you do, your TB that you compare (group vs individual companies) should NOT include the closing entries (hence will not include the retained earning account). When closing income statement in NAV, even if you tick 'Close by Business Unit Code', the retained earning account is the absolute total, and doesn't have the BU code.
If you want to compare TBs after closing income statement - then you should consolidate data after individual statements are closed, and include closed entries in the consolidation.
Don't know if that helps you but this is just how NAV works
Robertas
Thank you very much Robertas
I'm agree but problem is in one G/L account that is retained earning account. Particularly in this account value are not matching with standalone TB and one thing I was observed here when I'm closing income statement in group level in retained earning account business code getting null after posting the journals
consolidation TB is showing me opening balance amount of each business units. because of this value I'm getting difference in TB please refer the attachment.
Hi Shambhu
Usually discrepancies are caused by the setup of the G/L Accounts in subsidiaries. For example, if a certain G/L Account has the "Consol. Credit Account" defined, but "Consol. Debit Account" blank, then credits will go into one account and debits into a different account. This would make TB difficult to reconcile.
So first things first, you need to review "Consol. Credit Account" and "Consol. Debit Account" fields in COA of the subsidiary.
Robertas
You need to compare the Chart of Accounts for all companies with consolidation companies . Check for difference for ledger accounts.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (