With Nav 2013 a new License Model was introduced. Especially the new Limited User License is a bit hard to understand. First of all: full read access is permitted. But … write access is very strong limited. It’s said, that within a write transaction 3 tables are allowed to access, But … it’s not described, how to do that. That is not easy to handle, especially for developers. 😦 But ok. It would be interesting, how the Microsoft Developers themselves handle that limitation.
What does that mean at the end? When writing your own code, always check your list of used tables. A maximum of only 3 tables, you use, might not be listed in “Appendix A”, within your code snippet!
At least there are a couple of tables, that can be used anyway. Following is the original text out from the “Dynamics ERP Perpetual License Guide”.
Limited User licenses for Microsoft Dynamics NAV 2013 provide users full read, but limited write capabilities to all of the licensed solution functionality through any and all modes of access including the Windows Client. The Limited User license is designed to give customers a lower-cost alternative for extending ERP to users who only need to perform the following tasks:
- “Read access” to data contained in the ERP solution through any client accessing the application via the Microsoft Dynamics NAV Application Programming Interface (API) including but not limited to the User Interface Web Services for Microsoft Dynamics NAV
- “Write access” via the Timesheet functionality
- “Write access” through any client accessing the ERP solution via the Microsoft Dynamics NAV API to a maximum of 3 table objects in any range number with the following exceptions:
- limited users are not allowed to write to any of the following tables: General Ledger (table 17), Permission Set (table 2000000004), Permission (table 2000000005) or Access Control (table 2000000053) and
- any table described in Appendix A as “Limited User Included Tables” do not count towards the 3 table objects
APPENDIX A – Limited User Included Tables
The following tables do not count towards the maximum of 3 permitted for Limited Users in Microsoft
Dynamics NAV. Last updated 20 November 2012 (11 tables added)
Table | Table Name | Table | Table Name |
43 | Purch. Comment Line | 5123 | Inter. Log Entry Comment Line |
44 | Sales Comment Line | 5125 | Purch. Comment Line Archive |
51 | User Time Register | 5126 | Sales Comment Line Archive |
97 | Comment Line | 5150 | Integration Page |
309 | No. Series Line | 5151 | Integration Record |
336 | Tracking Specification | 5199 | Attendee |
337 | Reservation Entry | 5648 | FA Allocation Dimension |
355 | Dimension Ledger Entry | 5766 | Warehouse Activity Header |
356 | Journal Line Dimension | 5772 | Registered Whse. Activity Hdr. |
357 | Document Dimension | 5773 | Registered Whse. Activity Line |
358 | Production Document Dimension | 5814 | Inventory Period |
359 | Posted Document Dimension | 6550 | Whse. Item Tracking Line |
361 | G/L Budget Dimension | 7135 | Item Budget Dimension |
389 | Service Contract Dimension | 7310 | Warehouse Journal Batch |
405 | Change Log Entry | 7311 | Warehouse Journal Line |
455 | Approval Line Comment | 7312 | Warehouse Entry |
480 | Dimension Set Entry | 7313 | Warehouse Register |
481 | Dimension Set Tree Node | 7318 | Posted Whse. Receipt Header |
952 | Time Sheet Detail | 7319 | Posted Whse. Receipt Line |
953 | Time Sheet Comment Line | 7320 | Warehouse Shipment Header |
5050 | Contact | 7321 | Warehouse Shipment Line |
5051 | Contact Alt. Address | 7322 | Posted Whse. Shipment Header |
5052 | Contact Alt. Addr. Date Range | 7323 | Posted Whse. Shipment Line |
5054 | Contact Business Relation | 7324 | Whse. Put-away Request |
5061 | Rlshp. Mgt. Comment Line | 7325 | Whse. Pick Request |
5062 | Attachment | 7326 | Whse. Worksheet Line |
5065 | Interaction Log Entry | 7331 | Whse. Internal Put-away Header |
5072 | Campaign Entry | 7332 | Whse. Internal Put-away Line |
5075 | Logged Segment | 7354 | Bin |
5078 | Segment History | 2000000067 | User Default Style Sheet |
5080 | To-do | 2000000068 | Record Link |
5106 | Document Dimension Archive | 2000000073 | User Personalization |
5107 | Sales Header Archive | 2000000075 | User Metadata |
5108 | Sales Line Archive | 2000000080 | Page Data Personalization |
5109 | Purchase Header Archive | 2000000111 | Session Event |
5110 | Purchase Line Archive |
Source: Page 6 and Appendix A in Dynamics ERP Perpetual Licensing Guide.