Skip to main content
Question

Multiple company financial calendar

  • January 29, 2025
  • 7 replies
  • 101 views

I have query related to having multiple company calendars with varying period start and end dates.  Centralized period management is disabled, multiple calendar support feature is enabled.  It is 2024 R1.

 

There is 1 tenant with 2 companies. Both companies use USD as their base currency and require intercompany transactions and consolidations.

 

Company A follows Jan-Dec. 12 periods but have period type as user defined periods as start date and end dates varies.

 

Period 1: 1/1/2024 - 2/4/2024

Period 2: 2/5/2024 - 3/3/2024

And so on…

Period 9: 9/2/2024 - 9/29/2024

 

Company B follows Sep-Aug 12 periods with period type as Month.

 

Period 1: 9/1/2024 - 9/30/2024

Period 2: 10/1/2024 - 10/31/2024

And so, on

Period 9: 5/1/2025 - 5/31/2025

 

I setup Financial Year as Jan-Dec.  I was able to generate Company Calendar for the first company.  But with Second company, unable to change the start and end dates as it is looking at the existing Master Calendar generated as required for company A.  How can I setup a distinct company financial calendar for company B.

7 replies

  • Acumatica Employee
  • 4 replies
  • January 30, 2025

This can be accomplished by using multiple calendar support (enable on Advanced Financials) 

Multiple Calendar Support

A feature that provides the ability to configure companies having a different end of the financial year within one tenant. For details, see Multiple Calendar Support. You can enable this feature and start using the related functionality at any time. The 

Multiple Calendar Support feature can be enabled if the Centralized Period Management

 feature (under Standard Financials) is disabled.

The system will not allow you to disable the feature if there are companies with different ends of financial years in the system.


  • Author
  • Freshman I
  • 4 replies
  • January 31, 2025

Hi John,

Thank you for taking time and replying to my queries.  Multiple calendar support feature is enabled.   I can setup 2 different calendars company A with Jan-Dec and company B with Sep-Aug, Only if they are following same period i.e., calendar month. 1st to 30 to 31.  Here I can setup Master Financial Calendar Jan-Dec and then have company calendars setup differently i.e., Jan-Dec and Sep-Aug.

 

But actually, company A start, and end dates varies.  It doesn’t match to Master Financial Calendar periods which is following standard month dates 1st to 30th or 31st 

In case of Company A, I specifically need following periods

Period 1: 1/1/2024 - 2/4/2024

Period 2: 2/5/2024 - 3/3/2024

And so on…

Period 9: 9/2/2024 - 9/29/2024

 

As you can notice period start date and end date are not standard calendar days. Whereas in Master Financial Calendar Period 1 is 1/1/2024 - 1/31/2024, and so on.

 

Regards,

Shebaz


  • Acumatica Employee
  • 4 replies
  • January 31, 2025

Shebaz,

On the Master Financial Calendar form, the period start & end date can be modified by enabling User Defined Periods check box.   

There are some limitations including the FY cannot have any transactions posted in order to change the periods.

 

User-Defined Periods

A check box that you select to enable the modification of the periods of the latest year. You can edit the end dates of periods; the system will automatically adjust the start dates of the periods.After you modify the periods and save your changes, if the last period ends on a different date than the financial year does, the system opens the 

Update Financial Year Dialog Box where you can select the method to update the financial year template.If the calendar template has been changed, it will not be possible to generate a calendar for years earlier than the modified year.If the Multiple Calendar Support and Fixed Asset Management

 features are enabled on the Enable/Disable Features (CS100000) form and you modify the periods by selecting this check box, when you save the changes, the system will display a warning message that periods in the fixed assets book do not match the periods in the general ledger. In this case you need to amend the periods on the Book Calendars (FA304000) form by clicking Synchronize FA Calendar with GL on the More menu.


  • Author
  • Freshman I
  • 4 replies
  • February 1, 2025

Agreed, user defined periods on Master Calendar allows to change the start and end dates.  The issue is with company calendar as they use periods setup in Master calendar

 

So, in my case, Master Calendar is defined as Jan-Dec, with standard month dates. 1st  to 30th or 31st.  I also have kept user defined periods on, but I am not changing the start and end dates.

 

For company B Period 1 (Sept) is 09/01/24 – 09/30/24 which is exactly I defined in my Master Financial Calendar.  But For company A, Period 9 is (Sept) but needs different start and end date i.e., 09/02/24 – 09/29/24

 

As said, there is no issue in having FY Jan-Dec for company A and FY Sep-Aug for company B.  The system allows me to generate unique calendar for my companies A and B.

 

The issue is to have a user defined period at Company Financial Calendar.  So, I cannot have user defined periods for company A, as the system doesn’t allow me to change the start-end dates and uses the same period structure as defined in Master Calendar.  


aaghaei
Captain II
Forum|alt.badge.img+10
  • Captain II
  • 1204 replies
  • February 1, 2025

I did a little bit of investigation and it seems you might need small customization to make this work.


  • Author
  • Freshman I
  • 4 replies
  • February 7, 2025

Thank you ​@aaghaei.

Once I am able to customize Company Financial Calendar to allow editing of start/end date, my concern is Financial Period selection on reports, screens, posting and closing function.  All of these reports and functions can be normally run without any further customization.

As I am on multi company environment I need to have consolidated report to show appropriate figures.  We also need Fixed Asset modules to be installed.


aaghaei
Captain II
Forum|alt.badge.img+10
  • Captain II
  • 1204 replies
  • February 8, 2025

@shebaz32 I don’t believe it will be an issue. FinPeriod delector withing the decentralized calendar environment is sensitive to period start/end date defined in the company calendar. I have not come across suach a senario so you won’t no for sure until you work with that in details. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings