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
- 269 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 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
Combine a Dimension Code Value
rsfairbanks
Member Posts: 107
Hello,
We have 2 dimension 1 code values that are essentially the same, and users are getting confused over which to use. We cannot block one as it prevents the item cost adjust report from running.
Are there any problems if we delete one value, and then rename the other as that one. i.e delete VAL1, then remane VAL2 as VAL1.
Regards
Any comments as to whether the proposed solution would work?
We have 2 dimension 1 code values that are essentially the same, and users are getting confused over which to use. We cannot block one as it prevents the item cost adjust report from running.
Are there any problems if we delete one value, and then rename the other as that one. i.e delete VAL1, then remane VAL2 as VAL1.
Regards
Any comments as to whether the proposed solution would work?
0
Comments
What you can try to do is:
1. Export table 349 Dimension Value
2. Remove the code in the OnDelete Trigger of that table
3. Perform the rename action
4. Restore the table
5. Test the database
This sould be done in a test database first and I give to warranty.
Suc6.
Mark
Thanks for that, but can I not delete the value with DELETE(FALSE) so it does not run the trigger?
Regards
Richard
Please set the right filters or you will be deleting all dimension values.
Greetsz,
Marq