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 LIABILITES & EQUITY
Label this row OUT OF BALANCE
Set this row;s Print Control to X0 (do not print if zero)
(see exhibit row 11410)
You have successfully created Financial Reporter reports that will warn you in BIG RED LETTERS if there is an out of balance, and not print the if the out of balance is zero.
Comments