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
- 305 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
Code mandatory on Inventory Adjmt. Account
Fommo
Member Posts: 138
Hello
I have a customer that requires to have a certain dimension on all G/L accounts for analysis. This means they have "Code mandatory" on Inventory Adjmt. Account as well.
Firstly, is it OK to have this requirement on such an account?
Secondly, they get a problem when finalizing production orders. They get a message "Select a dimension Value Code for the Dimension Code XXX for G/L Account <Inventory Adjmt. Account>". Why?
They have "Automatic Cost Posting" set to TRUE in Inventory setup.
The dimension value is set on production order header, as well as in the dimension value table for the production line.
I have implemented KB2557542 as it seemed to describe the problem, but there is no change.
I have debugged the code and found out that the problem starts in Ledger Entry Dimension where there should be a line for the Value Entry post matching the Inventory Adjmt. Account line. I tried to manually add such a line with the correct dimension value, and then it was posted as it should.
Does anyone know what could be the problem? I've spent a lot of time on this now. ](*,)
/Fommo
I have a customer that requires to have a certain dimension on all G/L accounts for analysis. This means they have "Code mandatory" on Inventory Adjmt. Account as well.
Firstly, is it OK to have this requirement on such an account?
Secondly, they get a problem when finalizing production orders. They get a message "Select a dimension Value Code for the Dimension Code XXX for G/L Account <Inventory Adjmt. Account>". Why?
They have "Automatic Cost Posting" set to TRUE in Inventory setup.
The dimension value is set on production order header, as well as in the dimension value table for the production line.
I have implemented KB2557542 as it seemed to describe the problem, but there is no change.
I have debugged the code and found out that the problem starts in Ledger Entry Dimension where there should be a line for the Value Entry post matching the Inventory Adjmt. Account line. I tried to manually add such a line with the correct dimension value, and then it was posted as it should.
Does anyone know what could be the problem? I've spent a lot of time on this now. ](*,)
/Fommo
0
Answers
What I can see they have no customizations around this.
What I can see they have no customizations around this.
It depends. It is not, IMO, because you break quite a lot of automatic postings this way. For example, payment discount posting won't be possible, also no exchange rate adjustments, and so on. Inventory Adjustments is also one of these victims.
The reason behind this behaviour is that some "indirect" postings don't inherit the dimensions from the source postings. Which can be quite a mess, though.
I would say it's the same issue. You would need to step through the calls to find the link where the dimension is not forwarded.
with best regards
Jens
Then it's like I already suspected. I will discuss the matter with the customer. :-k