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
S
Steve Gagneposted
13 days ago
Setting the UseMasterCalendar argument in the function to TRUE resolved the issue. Thank you.
0 Votes
Gabriel Michaudposted
13 days 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
13 days ago
Admin
I would suggest reaching out to the Velixo Help Desk ([email protected]) so that they can examine your Acumatica configuration.
0 Votes
S
Steve Gagneposted
13 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
14 days ago
Yes, all companies are in the same instance of Acumatica.
0 Votes
H
Harry Lewisposted
14 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 13 days ago
Setting the UseMasterCalendar argument in the function to TRUE resolved the issue. Thank you.
0 Votes
Gabriel Michaud posted 13 days 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 13 days ago Admin
I would suggest reaching out to the Velixo Help Desk ([email protected]) so that they can examine your Acumatica configuration.
0 Votes
Steve Gagne posted 13 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 14 days ago
Yes, all companies are in the same instance of Acumatica.
0 Votes
Harry Lewis posted 14 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