Bitta Sheets · Part 8 · 2:21 · YouTube
Business Central Consolidation: Review, Post, Reverse
What this video covers
Review a Business Central consolidation in a live workbook, post its eliminations with a preview first, and reverse them.
The six workbook tabs and Review changes, Post from the workbook or the Consolidation Posting Log, Block Posting On Exceptions, Preview Changes and Apply Changes, G/L Register and G/L Entries, Reverse Register, the Audit Trail, and the next period.
Transcript
The eliminations are reviewed. Now they go into the general ledger, and sometimes they need to come back out. Here's how to review a consolidation in its workbook, post the eliminations, and reverse them.
Review in the workbook. Post with a preview first. Reverse with Business Central's Reverse Register. The workbook has six tabs: companies, account mapping,
trial balances, eliminations, the consolidated statements, and an audit trail. Columns with a pencil write back to Business Central, and nothing is written until you review the changes and apply them.
Posting starts here, or from the Posting Log. While exceptions are open, it shows why it won't post. On the Posting Log, Post Eliminations gives the same answer: the intercompany mismatches block the posting.
The difference sits on the intercompany difference account, so you can post now and correct it later. Clear Block Posting On Exceptions on the card. Post Eliminations simulates first.
Preview Changes lists every line before anything is written. Apply Changes posts into the consolidation company only, through its consolidation journal batch, once per period. The log shows the document and its G/L register.
G/L Register and G/L Entries open what was posted: seven lines on the last day of the period. To take a posting back, run Business Central's Reverse Register on that register. It posts the correcting entries.
The Posting Log shows it reversed, and the period can be posted again. The Audit Trail keeps every change, with who made it and when: the block switched off and on, and every refused and simulated posting. When the period is done, Next period moves the workbook on.
Or open the consolidation for the next period from the wizard. Post once the review is clean and the period is final. Until then, review and simulate as often as you like. Next: financial reports by period.
More Bitta Sheets videos
All videos
1:18OverviewEdit Business Central Tables Live in a Spreadsheet
2:08Part 1Edit Business Central Data in an Excel-Style Sheet
3:08Part 2Business Central Bulk Update Without Export and Import
2:50Part 3Business Central Budget in a Spreadsheet, Written Back Live
2:35Part 4Business Central Budget Entry by Department
2:56Part 5Business Central Consolidation: Companies and Account Mapping