Embarrassed by publishing D365 Financial Statements that do not match the Trial Balance? Do not fear, this simple trick will save you.
Financial Statements are supposed to represent the values in the Trial Balance. When by mistake you add a new account and forget to update your D365 Report Definition in Financial Reporter the report will not match the Trial Balance. Publishing wrong reports can not only be embarrassing but can potentially lead to bad business decisions based on the report.
An easy fix is to create a row to display the out-of-balance amount in BIG RED LETTERS.
-
Income Statement
Create a row for the sum of all the profit and loss accounts.
Set this row’s Print Control to NP (no print)
see exhibit row 10060
Create a row to calculate the variance vs. the Net Income
Label this row OUT OF BALANCE
Set this row’s Print Control to X0 (do not print if zero)
(see exhibit row 10090)
2. Balance Sheet
Create a row for the difference of TOTAL ASSETS minus TOTAL LIABILITIES & EQUITY
Label this row OUT OF BALANCE
Set this row’s Print Control to X0 (do not print if zero)
(see exhibit row 11410)