Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Adding "Job Filter" to "Analyses by Dimensi
Farukca
Member Posts: 19
Hi,
I must add a "Job Filter" to "Form 554 Analysis by Dimensions".
Job Filter will contain the one or more "No." data of "167 Job" table.
Of course when we select a job no; the entries, or sum of the entries which just belong to this Job record will be seen.
I have tried various ways but I could not do anything. Because all these analysises have been done on the "365 Analysis View Entry" and "366 Analysis View Budget Entry" tables. And in this tables there is no relation with the Job table.
Do you have any idea, then it will be welcome.
Please tell me if you have any idea..
Thanks
I must add a "Job Filter" to "Form 554 Analysis by Dimensions".
Job Filter will contain the one or more "No." data of "167 Job" table.
Of course when we select a job no; the entries, or sum of the entries which just belong to this Job record will be seen.
I have tried various ways but I could not do anything. Because all these analysises have been done on the "365 Analysis View Entry" and "366 Analysis View Budget Entry" tables. And in this tables there is no relation with the Job table.
Do you have any idea, then it will be welcome.
Please tell me if you have any idea..
Thanks
0
Comments
maybe you could do your report another way - based on job entries ?
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
probably you have multiple dimensions.
add new dimension "JobDim" and somehow relate it to jobs.
you should take care about adding new dimension value for JobDim when new job is created, etc.
when copying data in journals (at posting) you should take care that when "Job NO."<>'' you should add dimension value "DimJob"...
and so on...
then standard analysis by dimesnion should somehow work...
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯