Moving dimension values (5.01)
Lovis
Member Posts: 2
We have this customer, who streamlined their dimension structure. They have a lot (and I mean A LOT) of dimension values that they don't use anymore. But they can not delete these values, since there are records in the Ledger Entry Dimension table with these dimension values on them.
Basically what they want, is to move all the old dimension information to one dimension value code, called OLDDIMVAL or whatever, and then delete the old dimension values.
We do not want to touch the G/L Ledger entries, or otherwise make any changes to the database.
Is there an easy way to do this? I could of course code a report which does this, but I'd rather use standard functionality if there is such a thing available.
What problems should I be aware of?
Is it even legal to do this?
Thanks in advance
/Lovis
Basically what they want, is to move all the old dimension information to one dimension value code, called OLDDIMVAL or whatever, and then delete the old dimension values.
We do not want to touch the G/L Ledger entries, or otherwise make any changes to the database.
Is there an easy way to do this? I could of course code a report which does this, but I'd rather use standard functionality if there is such a thing available.
What problems should I be aware of?
Is it even legal to do this?
Thanks in advance
/Lovis
0
Comments
-
hmm nobody wants to answer this question. :-k0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
