Issue:

The Reports "Budget Statement" and any variations of it do not have all the required prompts, and don't return expense detail

Solution:

In the report, Press Edit in the upper right corner, putting the report in edit mode.

In the upper right area of the screen, click button under the Data section, shown below, and shows edit if you hover your mouse over it.


The screen that comes up is the Query Panel, in the upper left section, ensure that expense detail is selected, then click the view query script button, which is the one furthest to the right, shown below


Select the Use custom query script button, as shown below


Scroll to the bottom of the code, and look for the section shown below. An easy way to find this code, is to press the Ctrl and F keys at the same time, to open the search function for your browser, and paste in this: @Prompt('Enter accounting activity effective date beginning (mm/dd/yyyy)


Once you have found the code, remove the / from both areas of the (mm/dd/yyyy) for the @Prompt('Enter accounting activity effective date beginning (mm/dd/yyyy)

Instead of:

@Prompt('Enter accounting activity effective date beginning (mm/dd/yyyy)

It should read as

@Prompt('Enter accounting activity effective date beginning (mmddyyyy)

Do not do this for the date ending section

the end result should look like this:

 @Prompt('Enter accounting activity effective date beginning (mmddyyyy)','D',,mono ,free) AND @Prompt('Enter accounting activity effective date ending (mm/dd/yyyy)','D',,mono ,free)

Then press save in the bottom right of the screen

select revenue detail and repeat the same process by pressing the view query script button again and making the same edit.


Once you have fixed both areas, press apply changes and close and don't forget to save the report once you are finished.