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
Unusual Error on Consolidation - Import Database.[SOLVED]
TPReggie
Member Posts: 29
Hi All,
I currently have a client testing their Consolidation Company - The Test Database works fine, and all looks good.
When doing the "Import Database" function they are receiving the following error:
The Dimension "Division" is one of their 2 Global Dimensions.
There is no Dimension Value of "2" against this dimension.
So the error message itself makes perfect sense - however I have no idea why they are getting the error in the first place - why the system is looking for, or wanting this value - that makes no sense to me at all.
The settings for the import of the data are as follows:
If any of you have any ideas or suggestions of where I can look it would be much appreciated.
I currently have a client testing their Consolidation Company - The Test Database works fine, and all looks good.
When doing the "Import Database" function they are receiving the following error:
The Dimension "Division" is one of their 2 Global Dimensions.
There is no Dimension Value of "2" against this dimension.
So the error message itself makes perfect sense - however I have no idea why they are getting the error in the first place - why the system is looking for, or wanting this value - that makes no sense to me at all.
The settings for the import of the data are as follows:
If any of you have any ideas or suggestions of where I can look it would be much appreciated.
0
Comments
Just to specify, I have checked the following tables any existing values of "2" against Dimension Code "Division"
G/L Account
G/L Entry
Dimension Value
Dimension Value Combination
Nowhere can I find a value of "2" against the dimension code "Division." All codes against this dimension are numerical, and consist of 4 or 5 figures.
A frustrating error this one
have you checked if the dimension value exists in the target (consolidated company)? Also, is there a stale value (2) in the field "Consolidation Code" in one of the dimension values in the source company? Every dimension value can be translated to a different value for consolidation. The field has no table relation, so any value is possible.
with best regards
Jens
Hi Jens,
Thank you - it was the "Consolidation Code" field that was causing the problem - much appreciated