Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
How to change old Dimension Codes to new in all rel. tables?
Aravindh_Navision
Member Posts: 258
Hi Friends,
Version: NAV 2009 SP1
We have a requirement to change the old dimension value to new in G/L Entry and other related tables.
Currently, below 10, 20.. 100 are the dimension codes.
Current requirement is, instead of the above 10 Dimension codes, we are minimizing it to 3. Means the above 10 Dimension Codes are combined and grouped in to 3 dimension codes.
Say,
The dimension codes should be changed in all related tables.
Can anyone tell me how to do?
Thanks in advance,
Aarvi.
Version: NAV 2009 SP1
We have a requirement to change the old dimension value to new in G/L Entry and other related tables.
Currently, below 10, 20.. 100 are the dimension codes.
10 - DimA 20 - DimB 30 - DimC 40 - DimD 50 - DimE 60 - DimF 70 - DimG 80 - DimH 90 - DimI 100 - DimJ
Current requirement is, instead of the above 10 Dimension codes, we are minimizing it to 3. Means the above 10 Dimension Codes are combined and grouped in to 3 dimension codes.
Say,
10 - DimA [New Dimension Code Dim1] 20 - DimB [New Dimension Code Dim2] 30 - DimC [New Dimension Code Dim3] 40 - DimD [New Dimension Code Dim2] 50 - DimE [New Dimension Code Dim3] 60 - DimF [New Dimension Code Dim1] 70 - DimG [New Dimension Code Dim3] 80 - DimH [New Dimension Code Dim3] 90 - DimI [New Dimension Code Dim1] 100 - DimJ [New Dimension Code Dim2]
The dimension codes should be changed in all related tables.
Can anyone tell me how to do?
Thanks in advance,
Aarvi.
0
Comments
For posted entries, only option is to reverse post and post corrections. Or use totalling in dimension value structure, create new dims and historic and new transactions will work in reporting. You may need to rename existing dims to get the sub totalling to work.
Neil