Skip to main content
Answer

open period report for companies in the same tenant

  • February 29, 2024
  • 3 replies
  • 93 views

Forum|alt.badge.img

Hi There,

We have many companies in the same tenant with different financial year ends. Just wondering if there’s a report to view the current opening period/close period for all the companies. Just wanted to double check if all the periods are closed across all the companies at month end. Thank you. 

Best answer by johnh3

@Laura02 Thanks for chiming in, I had a play last night and found that a relatively simple Generic Inquiry (to the extent of my skill level) could be made using the single table with no joins: 

PX.Objects.GL.FinPeriods.OrganizationFinPeriodStatus

See below for my Results Grid, hope it helps you. 

 

3 replies

Forum|alt.badge.img
  • Jr Varsity III
  • April 15, 2024

How did you go with this, epan? I’m looking for something similar as we also have 60 odd entities that I’d like to check for open modules for a given period.


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • April 15, 2024

Hello,

Please add your Idea in the Ideas section of this community.  I think it’s a great idea to have a GI screen or a report that shows by period - which companies are open/closed for each module, or by company - which periods are open/closed for each module.

When I de-activate Centralized Period Management feature, no related Inquiry or Report showing the period status across companies appears. I think the only way within Standard Acumatica is using Manage Financial Periods screen to cycle through the companies at the top.

Laura


Forum|alt.badge.img
  • Jr Varsity III
  • Answer
  • April 15, 2024

@Laura02 Thanks for chiming in, I had a play last night and found that a relatively simple Generic Inquiry (to the extent of my skill level) could be made using the single table with no joins: 

PX.Objects.GL.FinPeriods.OrganizationFinPeriodStatus

See below for my Results Grid, hope it helps you.