Skip to main content
Solved

How can I put "Month" as a single parameter in Generic inquiry or Report Designer

  • 9 October 2020
  • 2 replies
  • 1233 views

Forum|alt.badge.img+5

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?

Best answer by porlov

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. 

 

View original
Did this topic help you find an answer to your question?

porlov
Community Manager
  • Community Manager
  • October 9, 2020

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. 

 


Forum|alt.badge.img+5
  • Captain II
  • October 10, 2020
porlov wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings