Share a formula to get the current FinPeriod to be used in Generic inquiry

A possibly simpler formula

= CStr(Year( Today() )) + PadLeft(CStr(Month( Today() )), 2, '0')

These formulas assume that MasterFinPeriod was setup to match calendar periods. 

If using user defined periods or any other financial calendar that doesn’t match, formulas won’t work.

Why not just Cross join MasterFinPeriod in your GI and find the required period for whatever date is needed? 

@RoyceLithgo 
Yes, you are right. Our method has obvious limitations.
Can you give more details on your method?  Can you give us a simple example?

Hi @ray20 - were you able to find a solution for your issue? Thank you!

 @vkumar @joshmagalich27 
Hi Folks, just to update.  @RoyceLithgo is right. we can join “FinPeriod” table to get the current or any period we want.
“PX.Objects.GL.FinPeriods.TableDefinition.FinPeriod”

Note: this table has multiple finperiods splitted by organization/company. So in order to avoide duplicated data, we have to carefully make the join condition like below:
 

Then we can use the Finperiod table, to get the period we want.
Below is to get the last period leveraging the “Start date” definitions of the period.

ray20 wrote:

 @vkumar @joshmagalich27 
Hi Folks, just to update.  @RoyceLithgo is right. we can join “FinPeriod” table to get the current or any period we want.
“PX.Objects.GL.FinPeriods.TableDefinition.FinPeriod”

Note: this table has multiple finperiods splitted by organization/company. So in order to avoide duplicated data, we have to carefully make the join condition like below:
 

 

Then we can use the Finperiod table, to get the period we want.
Below is to get the last period leveraging the “Start date” definitions of the period.

 

Thanks for posting this but it’s not quite the way i do it. For finding the correct period, you want StartDate <= [ReportDate] and FinDate >= [ReportDate]. [ReportDate] being a parameter in this GI.

Here’s an example usage:

I then used MasterFinPeriod in the joins for other table relations. Depending on your needs you could also do Inner join to MasterFinPeriod if you want to filter each row of the Left table.

Shorter version:

=Concat(CStr(Year(Now())),PadLeft(CStr(Month(Now())),2,'0'))