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)

Suggested answer

Valentin Castravet 31,551 Super User 2025 Season 2 on at

Like (0)

Report

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

hi @valentin, please see

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,390 Most Valuable Professional on at

Like (1)

Report

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 31,551 Super User 2025 Season 2 on at

Like (2)

Report

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,529 Super User 2025 Season 2 on at

Like (0)

Report
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 95,763 Super User 2025 Season 2 on at

Like (1)

Report

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