Hope this might be helpful:
Let's break down your consolidation process queries in Business Central:
-
Consolidation % in Business Unit:
Yes, the Consolidation % field on the Business Unit card will only consider the given percentage of balances from all G/L Accounts of that Business Unit when consolidating. For example, if a Business Unit is 80% owned, only 80% of its balances will be pulled into the consolidation company.
-
Consolidation - Only New Transactions?
No, that's not entirely correct. When you run the consolidation process, it typically pulls the full G/L balances from the specified period (e.g., month, quarter, year) in the source companies into the consolidation company. It doesn't just look for "new" individual transactions. If you run it multiple times for the same period, it will usually overwrite or add to previous consolidation entries, effectively ensuring the consolidation company reflects the latest full balances from the business units for that period. It's not an incremental update based on new individual postings, but rather a snapshot of the balance as of the consolidation date.
-
Reversing Entries - G/L Register for Bulk Reversal?
Yes, you can use the G/L Register for bulk reversal of consolidation entries. After running a consolidation, a G/L Register entry is created. You can navigate to the G/L Register and use the "Reverse Transaction" action to reverse all entries posted by that specific consolidation run. This is the standard and recommended method for bulk reversal of consolidated entries.
-
Elimination - Both Sales and Purchase Intercompany Transactions?
Yes, for proper consolidation, you should eliminate both sales and purchase related intercompany transactions between the consolidating companies. The goal of elimination is to remove transactions that only exist between entities within the consolidated group, ensuring that the consolidated financial statements reflect transactions with external parties only. If Company A sells to Company B (both consolidated), that internal sale/purchase needs to be eliminated from the consolidated revenue and cost of goods sold.
-
Define Elimination Rules in Business Central?
No, Business Central's standard consolidation module does not have a dedicated feature to define complex "elimination rules" or "elimination journals" automatically. Elimination entries typically need to be manually prepared and posted in the consolidation company using General Journals. You would analyze your intercompany accounts and post adjusting entries to eliminate intercompany balances and transactions (like intercompany sales/purchases, loans, etc.). Some users achieve a semi-automated process using recurring journals or external tools to generate these entries, but there isn't a "rule engine" within standard BC for this.
✅ Mark this answer as verified if it helps you.
