Small and medium business | Business Central, N...

Financial Report not producing desired results

(1) Share

Report

Posted on by CU29101917-0

Im creating a report in BC that uses a calender year format.

Example:

The amount 627,288 is equally divided in 4 time periods of Jan-March, April-June, Jul-Sep and Oct-Dec. This amount is $153,567.

However, when I create the same report in BC, I am getting a different amount for each time period.

I am trying to figure out why BC is producing different amount for each time period?

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Valentin Castravet 32,800 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

What formulas do you have under your report column definition?

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
CU29101917-0 76 on at

Like (0)

Report
Copy link

Link copied!

hi @valentin, please see

Was this reply helpful? Yes No
Gerardo Rentería Ga... 27,611 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi

I hope this can help you: Column definitions in Financial Reporting - Business Central | Microsoft Learn

Best

GR

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,800 Super User 2026 Season 2 on at

Like (2)

Report
Copy link

Link copied!

Your Comparison Period Formula looks correct. Do you have accounting periods set up? Also, what values do you have in the Column Type field in both the row and column definitions? If the report isn’t working, one of these two settings is likely incorrect.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Ramesh Kumar 7,566 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
I recommend clicking 'Show All Lines' to see if you can identify the lines causing the variance.

Another option to check is whether there’s a different calendar created besides the base one.

Also, review the accounting period

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,857 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi, Please check if Accounting Periods is set? If not, "FY" will have no effect.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No