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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Account Schedules - Dimension Code Caption & Lookup
Ms10Key
Member Posts: 13
Morning all!
In NAV 2009 SP1 and R2 RTC, the "Edit - Account Schedule" Page does not display the Dimension Code. It displays a generic label "Dimension 1 Totaling", "Dimension 2 Totaling", etc. It does not say "Department Dimension", etc. as does the Classic Client. Also, there is not a lookup to the Dimension Code Values. Users must manually enter the Dimension Value. MBS is to be correcting this in v7. However, I cannot imagine that many users are not as upset as ours. Being relatively new to SP1, we are not looking to upgrade at this time. Curious to know if anyone has a work around for this?
](*,)
In NAV 2009 SP1 and R2 RTC, the "Edit - Account Schedule" Page does not display the Dimension Code. It displays a generic label "Dimension 1 Totaling", "Dimension 2 Totaling", etc. It does not say "Department Dimension", etc. as does the Classic Client. Also, there is not a lookup to the Dimension Code Values. Users must manually enter the Dimension Value. MBS is to be correcting this in v7. However, I cannot imagine that many users are not as upset as ours. Being relatively new to SP1, we are not looking to upgrade at this time. Curious to know if anyone has a work around for this?
](*,)
0
Comments
GlobalDimension1
TableRelation
"Dimension Value".Code WHERE (Global Dimension No.=CONST(1))
CaptionClass
'1,1,1'
Then on the OnAction trigger of the Show Matrix button it applies the filter with the following code:
IF GlobalDimension1 <> '' THEN
SETRANGE("Dimension 1 Filter",GlobalDimension1);
This way it presets the filters on the Acc. Schedule Overview Matrix. I could not figure out to fix the matrix so it would be possible to select the dimensions from a dropdown directly in the matrix page. But with the workaround it is at least possible from the overview page.