Data protectiong on G/L Entries in current versions?

clarasdk
Member Posts: 46
Some days ago, I had a discussion with a colleague about the modification of G/L lines.
We both were of the opinion that in Dynamics NAV, at least in older versions, it was not possible to change G/L data directly via the table view (to ensure the financial integrity of the data). But when we tried in our NAV 2015 solution we could change things like description, Sales (LCY) etc.
Is this something that have come via one of the newer versions of Dynamics NAV? Or are we just remembering the locking in older version wrong?
We both were of the opinion that in Dynamics NAV, at least in older versions, it was not possible to change G/L data directly via the table view (to ensure the financial integrity of the data). But when we tried in our NAV 2015 solution we could change things like description, Sales (LCY) etc.
Is this something that have come via one of the newer versions of Dynamics NAV? Or are we just remembering the locking in older version wrong?
0
Comments
-
First can you clarify which table you are talking about? You mention "G/L Entries" but then also mention the field "Sales (LCY)". Which is not part of that table.
The method for protecting the ledger tables has not changed in the new versions. It is controlled by the license. Are you sure you are not using a Partner license or a license that contains the Solution Developer granule? As you would need either of those to directly modify these tables from NAV.There are no bugs - only undocumented features.0 -
Sorry took the example from the customer ledger entry table, but the same apply to the G/L table.
Actually I think the customer license has the solution developer granule, I was just not aware that this made it possible for anybody to open the table and do changes (providing they have the modify rights) on the G/L table.
Will see if I can find a customer without the developer granule to test the difference.0 -
The solution developer granule is what controls this. But even with that granule the user still needs the direct modify right on the tabledata. So you might review your user permissions. Especially who you have assigned to the SUPER role.There are no bugs - only undocumented features.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