Dimension posting error

djswim
Member Posts: 277
Let me just get this out of the way:
](*,) ](*,) ](*,)
Ok, so I'm attempting to receive a PO with one line, qty. of one. Getting the error that I need to select a dimension value for Glob. Dim. 2 Code for Account 13310.
Now, I've set up that account to require a dimension value for that dim. code, BUT, the dimension value is in the line... it's just not getting recognized some how.
I've traced the error to CU11, RunCheck function:
Where the *ELSE* is where the error occurs. Something odd I noticed here is that the "JnlLineDim" variable is uninitialized at this point... that doesn't seem right, right? My next step should be to find where that is supposed to be assigned and figure out why it's not coming over, correct?
Oh: NAV v5 SP1, SQL
](*,) ](*,) ](*,)
Ok, so I'm attempting to receive a PO with one line, qty. of one. Getting the error that I need to select a dimension value for Glob. Dim. 2 Code for Account 13310.
Now, I've set up that account to require a dimension value for that dim. code, BUT, the dimension value is in the line... it's just not getting recognized some how.
I've traced the error to CU11, RunCheck function:
IF NOT DimMgt.CheckJnlLineDimValuePosting(JnlLineDim,TableID,No) THEN IF "Line No." <> 0 THEN ERROR( Text012, TABLECAPTION,"Journal Template Name","Journal Batch Name","Line No.", DimMgt.GetDimValuePostingErr) *ELSE* ERROR(DimMgt.GetDimValuePostingErr);
Where the *ELSE* is where the error occurs. Something odd I noticed here is that the "JnlLineDim" variable is uninitialized at this point... that doesn't seem right, right? My next step should be to find where that is supposed to be assigned and figure out why it's not coming over, correct?
Oh: NAV v5 SP1, SQL
"OMG ALL MY DATA IS GONE"
"Show All..."
"Oh..."
"Show All..."
"Oh..."
0
Answers
-
Here is what ended up being the solution:
Demand brought the inventory negative for the item before the dimension code was assigned to it. Therefore, the automatic cost adjustment is going out to make the associated entry and erroring out because the original transaction didn't have a code, but this one does (and is required to)... we'll have to adjust the historic item ledger and value entries to completely fix this, but for now we can shut off Automatic Cost Adjustment or allow it to go through w/o a dimension. This is solved but I'd still like suggestions on the pros/cons of each of these."OMG ALL MY DATA IS GONE"
"Show All..."
"Oh..."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