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

Question

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?

icon

Best answer by porlov 9 October 2020, 10:41

View original

porlov · Accepted Answer

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

ray20 · Answer

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 advisehere 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

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

2 replies

Reply

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded