Skip to main content

Hello,

      I know “Date to” and “Date From” are more flexible.  But sometimes,  the data are just required in terms of “Month” range. So, to make the user just select 1 time, I am looking for a way to set a single parameter, like Month with data source “Jan, Feb, Mar,,,,” and so on.

      I’ve tried the Fin Period, which, of course, currently set exactly as the Month range.

         However, Fin period of My designed GIs can not be selected by user, it is a text input format, which is not convenient for user to use.

         

        While the some of original Screens can be selected.

          So, can anyone guide me how to do it like the above?

Hey Ray,

If you’re using FinPeriod schema for your parameter then system will pick it up exactly as you have it in the screen of Manage Financial Periods - a text field.

What I can advise here is using schema from the ARInvoice (as example). Just add ARInvoice as table, you may even not join it to any other table in your GI. Then in Parameters use ARInvoice.FinPeriodID schema and you will have it there as the selector.

I hope it helped. 

 

Hey Ray,

If you’re using FinPeriod schema for your parameter then system will pick it up exactly as you have it in the screen of Manage Financial Periods - a text field.

What I can advise here is using schema from the ARInvoice (as example). Just add ARInvoice as table, you may even not join it to any other table in your GI. Then in Parameters use ARInvoice.FinPeriodID schema and you will have it there as the selector.

I hope it helped. 

 

Yes, It works. Thank you

Reply


Terms & ConditionsCookie settings