How to create a financial report for multiple companies with different financial calendars

  • 5 March 2024
  • 2 replies

Userlevel 3

I need to create financial reports for multiple branches, however, one branch has a different financial calendar to the others. The finacial year of this branch starts in November (i.e. for the financial year of 2024, the first period for this branch is 11-2023 on the master financial calendar.

There is the ‘Use Master Financial Calender’ check box in the report designer. How does this work?Would it be that if it is selected and requested, then the periods in the report will be taken from the Master Calendar so for this particular branch, the period would be 03-2024?

And if the master Financial Calendar is not selected, then does the report take the Company Financial Period? In this case for the first period, for this branch the period would be 01-2024 (November)?


Best answer by Laura02 5 March 2024, 12:08

View original

2 replies

Badge +18

Hello Sue,

I expect you are on the right track:  toggling Use master Financial Calendar I think is the likely solution.

I recommend the following test: make a small report with a column set that places the companies in two separate columns with a total.

Print the report with and without checking ‘Use Master Financial Calendar’ and compare the results.


I don’t have a testing area with multiple companies and different fiscal years, and it would take a significant amount of time to build one.  So I am giving you just an idea. I hope this idea helps you!



Userlevel 3

Thank you for your reply. Yes I have managed to set up a scenario to test, and it works as I suspected.


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved