#54523 - 08/01/17 03:21 PM
Re: GridView - selecting/filtering data for analysis
[Re: Michael_Arbeau]
|
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
|
Top
|
|
|
|
#54556 - 08/03/17 03:56 PM
Re: GridView - selecting/filtering data for analysis
[Re: Michael_Arbeau]
|
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
|
|
|
|
|
0 registered (),
80
Guests and
3
Spiders online. |
Key:
Admin,
Global Mod,
Mod
|
|
1865 Members
5 Forums
14446 Topics
70591 Posts
Max Online: 432 @ 01/20/25 10:17 PM
|
|
|
|
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
|
|
|
|
|
|