Are the numbers real? D365 Financial Reporter out of balance trick.

By - September 25, 2021

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.

  1. 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)

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.
This blog was originally posted on 365financearchitect.com

Receive Posts by Email

Subscribe and receive notifications of new posts by email.