You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Displaying Accounting Period parameter LOV in expandable hierarchical manner when running FRS Report

The business' FRS report currently has their AccountingPeriod parameter set to only query years, which is causing issues when they're trying to query years with periods that are still in future enterable status.

To potentially solve this, we've attempted to copy the setup (below) of another client's similar report for that AccountingPeriod parameter wherein they have the flexibility to select a year, quarter or period instead by selecting from a hierarchical list they can expand or collapse as needed.

Select members: Prompt for AccountingPeriod
Define Prompts > Choices List: AccountingPeriod

However, copying this setup only displays the member "AccountingPeriod' itself without having the ability to expand to the years, quarters or periods under it.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!