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

Sales analysis report - Current period

(5) Share

Report

Posted on by Frida_Admotion

387

in Hi!

In my column in a sales analysis report I have set up this, and it worked very well when I set it up in January. I set the Matrix Option view by Year.

Now when I use this columns, the first column still shows CP as January. (We have a broken fiscal year starting 1 sept, so this shows Period 1 to 5 right now. The posting dates should be 2-09-01..25-03-31 by now..)

Can someone give me a clue about what is happening here?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Ramesh Kumar 7,555 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Did you check accounting period start date and end date. Also I hope below link can help check the date formula.

https://yzhums.com/43809/

Thanks

Ramesh

If this helped you, please check the box Does this answer your question?

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 16,154 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Yes i am agree with Ramesh Kumar that there is a Date Issue.

You can check the Accounting Period as well as check the Working Date Format in My Settings.

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

Like (1)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Column definitions in Financial Reporting - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,350 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hope this help as well:https://learn.microsoft.com/en-us/dynamics365/business-central/bi-how-create-analysis-views-reports

Was this reply helpful? Yes No