Am trying to build a simple Saved Search that will allow me to view the APPROVED hours worked on a project (by project task) through a specific date (e.g. the last day of the previous month).
No built in search seems to provide this information. There are a couple of built in reports that provide some of the information but are not nearly as usable as a saved search.
Therefore, this assignment is proving to be harder than anticipated.
My many searches of SuiteAnswers & the Community have yielded no advice. My search of SuiteIdeas displays nothing that would lead me to believe that my goal cannot be achieved.
Any suggestions would be greatly appreciated.
Here is what I've tried so far:
Starting with the PLANNING view saved search from the Project Planning form SCHEDULE subtab, I added a column for ACTUAL WORK. That gives me the actual hours charged to each Project Task.
However the column shows ALL hours charged, OPEN, SUBMITTED and APPROVED. We would like to display only APPROVED hours.
The saved search also displays all hours input through the moment that the saved search was run. We would like to display only hours through a certain date, for example, the last day of any given month.
Therefore, I then added two filters. These seem to be the most logical filters but I cannot be sure that they are correct. And neither of them seem to work.
1) Transaction: Approval Status
2) Transaction: As-of Date
The field help for both fields is not much help. It states:
Help for this specific field is coming soon. For now, click Help to open the help center and search for a related topic.
Using either filter seems to result in no data being displayed whatsoever.
It sure seems like this is a basic saved search that any project-based organization would use regularly. My guess is that I am just doing something wrong.
Thanks in advance for any advice.