Skip to main content
Solved

open period report for companies in the same tenant

  • Feb 29, 2024 8:17 PM UTC
  • 3 replies
  • 135 views
  • Translate All

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. 

 

View original

3 replies

Forum|alt.badge.img
  • Varsity I
  • Apr 15, 2024 9:32 AM UTC

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.

Translate

Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Apr 15, 2024 10:49 AM UTC

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

Translate

Forum|alt.badge.img
  • Varsity I
  • Answer
  • Apr 15, 2024 9:12 PM UTC

@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. 

 

Translate