Problem With Dimensions When Posting BOM Journal

Jonathan2708
Member Posts: 552
Hi,
I'm trying to post a BOM journal but it fails to post during the 'Adjusting value entries...' posting phase with the error 'Select Dimension Value Code 60 for the Dimension Code COSTCENTRE for Item RM01020'. Item RM01020 is a component item for some of the finished items I'm making. It's item card does have a default dimension for COSTCENTRE of 60 with the Value Posting field set to 'Same Code'. However I have ensured that every BOM journal line has the COSTCENTRE 60 set on the journal line (and has the corresponding child record in the 'Journal Line Dimension' table) so I'm at a loss as to why it refuses to post.
Any help appreciated, I'm using NAV 5.0SP1 on SQL Server 2005 (no customisations in this area).
Jonathan
I'm trying to post a BOM journal but it fails to post during the 'Adjusting value entries...' posting phase with the error 'Select Dimension Value Code 60 for the Dimension Code COSTCENTRE for Item RM01020'. Item RM01020 is a component item for some of the finished items I'm making. It's item card does have a default dimension for COSTCENTRE of 60 with the Value Posting field set to 'Same Code'. However I have ensured that every BOM journal line has the COSTCENTRE 60 set on the journal line (and has the corresponding child record in the 'Journal Line Dimension' table) so I'm at a loss as to why it refuses to post.
Any help appreciated, I'm using NAV 5.0SP1 on SQL Server 2005 (no customisations in this area).
Jonathan
0
Comments
-
Have you checked in the dimensions line subtable ?
You might see for your item that COSTCENTRE 60 exists on the BOM Line, but if you select line > Dimensions you will see the journal dimension lines table. Check if the same values exists here and if they do reenter them.0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions