Topic Options
#54520 - 08/01/17 01:54 PM GridView - selecting/filtering data for analysis
Michael_Arbeau Offline
Adagio Buff

Registered: 12/09/10
Posts: 63
Loc: Sidney, BC Canada
We are new at GridView and would like use it to analyze data from our Job Cost Module. We are trying to build some filters that will enable us extract data from Jobs, Phases and Categories for specific time frames, i.e. find out what the cost is for a Job-Phase-Category from a specified start date to a specified end date. How do we go about doing that?

Thanks!

Top
#54523 - 08/01/17 03:21 PM Re: GridView - selecting/filtering data for analysis [Re: Michael_Arbeau]
Brian Stief Offline
Waterloo Guy

Registered: 04/04/06
Posts: 1733
Loc: Waterloo, Ontario, Canada
Hi Michael,

Using Gridview to analyze JC data is an excellent choice. But there is a lot of options to consider. We have created a number of views that for client Job Sites but you might start first with your Adagio Consultant because they might be closer to your data and your requirements than feedback from an open forum.

But since you asked, you should use the prompt view trick where the date prompt range is carried as a variable to all views in your workspace. You would use a job index view, that can (when column linked) quickly select the costs (filtered for just costs) for selected job(s) summarized by J-P-C, with options for reporting details at the summary level or by selected detail drill downs.

And then you get to link back to the open PO's (in summary and detail) that have been committed against the costs incurred against the estimates for J-P-C, with filter options for open or closed or all jobs, for each project manager. This assumes that you are using Purchase Orders with Job Costing because every site should be.

And probably add a view for the billings details to show jobs with incurred costs that are behind in billings.

We normally would be doing this using our simple cost strategy for configuring Job Costing, and then calculating WIP and Deferred revenue with separate views, with options to export the resultant into GL J/E flat files to import your WIP and Deferred JE's in GL for your month end financial reporting. We use the simple costing method for all job cost sites because nothing is more annoying that seeing a "revenue recognized" entry in the GL and having to refer back to some hard copy report for the details of the entry that is not date sensitive. Equally important is the ability to see the details in the GL that tie into JC Gridview reporting.

That's where we would start.

Best,
Brian
_________________________
Brian Stief,CPA,CA
Stief Group www.stiefgroup.com
Link2 Systems www.link2systems.com
800.540.3164

Top
#54537 - 08/02/17 08:53 AM Re: GridView - selecting/filtering data for analysis [Re: Brian Stief]
Michael_Arbeau Offline
Adagio Buff

Registered: 12/09/10
Posts: 63
Loc: Sidney, BC Canada
Hi Brian,

Thank you for the suggestion about the prompt view trick. We will try it out.

Have a great day!

Top
#54539 - 08/02/17 09:02 AM Re: GridView - selecting/filtering data for analysis [Re: Michael_Arbeau]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11518
Loc: Vancouver, BC Canada
Hi, Michael,

As you're new to GV, something else you might want to check out is the Client Portal on our website. There's an Online Training section that has previously recorded online webinars for GV that you can start and stop at your leisure. There are also some short Show-Me-How videos for things like Creating a View, Filters, Calculated Columns and Linking that you might find helpful.
_________________________
Regards,
Softrak Tech Support

Top
#54554 - 08/03/17 03:24 PM Re: GridView - selecting/filtering data for analysis [Re: Softrak Support]
Michael_Arbeau Offline
Adagio Buff

Registered: 12/09/10
Posts: 63
Loc: Sidney, BC Canada
Hi All,

We were able to extract all the data for Job Cost and now we're having issues specifying a start and end date. The filter we use is this:

AND(
{JobPhCat}
,
{Trx Date}
,
DATESTART("Enter Start Date")
,
DATEEND("Enter End Date")
,
{Document}
,
{Amount}
)

Brian Stief mentioned the date prompt range in his response the other day and using a job index view to select costs.

The filter we put in is not returning any data.

Top
#54555 - 08/03/17 03:55 PM Re: GridView - selecting/filtering data for analysis [Re: Michael_Arbeau]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4505
Loc: Wynnewood, PA
Filters evaluate expressions, separated by commas if there are multiple expressions, and a record is displayed only if the result of all the expressions are true. You are a asking it to evaluate fields not expressions.

If this is not clear you need more assistance than this forum can provide.

Steve

Top
#54556 - 08/03/17 03:56 PM Re: GridView - selecting/filtering data for analysis [Re: Michael_Arbeau]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hello Michael,

You need to review the manual and videos mentioned by Tech Support, or engage the services of an Adagio Consultant to get you started in writing Filters.

I'm sorry, but what you posted shows that you do not understand how to structure a Filter.
_________________________
Andrew Bates

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 80 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14446 Topics
70591 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30