Can anyone assist with this error? I receive the error "Error! Financial period 'mm-yyyy' does not exist in the company 'COMPANY'" with the ACCOUNTENDINGBALANCE formula. I have ten companies in the same file and this error appears in only two of the companies. This error starts in the same month in both of these two companies and works fine in the months prior. I recently added these two companies to this file, having gone live with them on 3/1/25. The other eight companies went live in two tranches in 2024.
0 Votes
6 Comments
Sorted by
Recent
Past
Popular
Recent
S
Steve Gagneposted
1 day ago
Setting the UseMasterCalendar argument in the function to TRUE resolved the issue. Thank you.
0 Votes
Gabriel Michaudposted
1 day ago
Admin
Steve,
The ACCOUNTENDINGBALANCE and other formulas have a UseMasterCalendar argument. By default, this argument is FALSE, meaning we calculate the balance based on each of the included company's financial calendar. You have one company that doesn't have a 07-2024 period, and it's causing the calculation to fail.
Here are the possible solutions:
1. Create this financial period in the companies that don't have it
-or-
2. Exclude this company from the report you're running as of 07-2024
-or-
3. Just set the UseMasterCalendar argument in the function to TRUE -- given that you have the same calendar across all your companies that will essentially be equivalent.
0 Votes
H
Harry Lewisposted
1 day ago
Admin
I would suggest reaching out to the Velixo Help Desk (support@velixo.com) so that they can examine your Acumatica configuration.
0 Votes
S
Steve Gagneposted
2 days ago
Sorry, read your response quickly and didn't answer your question fully. I am getting the error starting in 07-2024. All periods are Locked through 04-2024. 05-2024 is Closed. Periods are Open from 06-2024 on. Because all ten companies are in the same instance of Acumatica, they all use the same Calendar. Only the two new companies are showing this error starting in 07-2024. The other eight companies are pulling in amounts for 07-2024 and later periods no problem.
0 Votes
S
Steve Gagneposted
2 days ago
Yes, all companies are in the same instance of Acumatica.
0 Votes
H
Harry Lewisposted
2 days ago
Admin
Hi Steve -
If you log in to your ERP instance, navigate to the Master Financial Calendar, and select the specific company, does it show that period as open?
0 Votes
Can anyone assist with this error? I receive the error "Error! Financial period 'mm-yyyy' does not exist in the company 'COMPANY'" with the ACCOUNTENDINGBALANCE formula. I have ten companies in the same file and this error appears in only two of the companies. This error starts in the same month in both of these two companies and works fine in the months prior. I recently added these two companies to this file, having gone live with them on 3/1/25. The other eight companies went live in two tranches in 2024.
0 Votes
6 Comments
Steve Gagne posted 1 day ago
Setting the UseMasterCalendar argument in the function to TRUE resolved the issue. Thank you.
0 Votes
Gabriel Michaud posted 1 day ago Admin
Steve,
The ACCOUNTENDINGBALANCE and other formulas have a UseMasterCalendar argument. By default, this argument is FALSE, meaning we calculate the balance based on each of the included company's financial calendar. You have one company that doesn't have a 07-2024 period, and it's causing the calculation to fail.
Here are the possible solutions:
1. Create this financial period in the companies that don't have it
-or-
2. Exclude this company from the report you're running as of 07-2024
-or-
3. Just set the UseMasterCalendar argument in the function to TRUE -- given that you have the same calendar across all your companies that will essentially be equivalent.
0 Votes
Harry Lewis posted 1 day ago Admin
I would suggest reaching out to the Velixo Help Desk (support@velixo.com) so that they can examine your Acumatica configuration.
0 Votes
Steve Gagne posted 2 days ago
Sorry, read your response quickly and didn't answer your question fully. I am getting the error starting in 07-2024. All periods are Locked through 04-2024. 05-2024 is Closed. Periods are Open from 06-2024 on. Because all ten companies are in the same instance of Acumatica, they all use the same Calendar. Only the two new companies are showing this error starting in 07-2024. The other eight companies are pulling in amounts for 07-2024 and later periods no problem.
0 Votes
Steve Gagne posted 2 days ago
Yes, all companies are in the same instance of Acumatica.
0 Votes
Harry Lewis posted 2 days ago Admin
Hi Steve -
If you log in to your ERP instance, navigate to the Master Financial Calendar, and select the specific company, does it show that period as open?
0 Votes
Login or Sign up to post a comment