{"id":16233,"date":"2023-04-18T11:03:10","date_gmt":"2023-04-18T11:03:10","guid":{"rendered":"https:\/\/dynamics.folio3.com\/blog\/?p=16233"},"modified":"2023-04-18T11:23:30","modified_gmt":"2023-04-18T11:23:30","slug":"how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions","status":"publish","type":"post","link":"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/","title":{"rendered":"How to insert or modify a record when Business Central doesn\u2019t allow direct permissions\u00a0"},"content":{"rendered":"<p>Every object in Business Central is given various permissions. <strong>Assignable Permissions<\/strong> refers to permission sets that may be applied to objects via the user interface (UI), while <strong>Non-Assignable Permissions<\/strong> refers to permission sets that cannot be applied via the UI.<\/p>\n<p>Permissions on Object<\/p>\n<p>Each object has one of the four sorts of permissions listed below:<\/p>\n<table>\n<tbody>\n<tr>\n<td>Read<\/td>\n<td>R for direct access and r for Indirect access<\/td>\n<\/tr>\n<tr>\n<td>Write<\/td>\n<td>W for direct access and w for Indirect access<\/td>\n<\/tr>\n<tr>\n<td>Modify<\/td>\n<td>M for direct access and m for Indirect access<\/td>\n<\/tr>\n<tr>\n<td>Delete<\/td>\n<td>D for direct access and d for Indirect access<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>You can only read an object if you have given it read-only rights. You cannot add to or change the data of that object if you don&#8217;t have write access.<\/p>\n<p>But what if we only have read permission on the data and want to insert or modify it? Here, I&#8217;ll explain how to add or modify a record when Business Central disallows direct permissions.<\/p>\n<p><strong>Let\u2019s take an example of posted sales shipment<\/strong><\/p>\n<p>Modify Posted Sales Shipment Lines<\/p>\n<p>For instance, we modify some fields of posted sales shipping lines based on certain criteria using the AL code. However we can\u2019t modify the fields using <strong>table.insert()<\/strong> or <strong>table.modify()<\/strong> directly. Because Business Central does not permit write permissions on the &#8220;Sales Shipment Line&#8221; table.<\/p>\n<p>We will create a code unit and provide permission to the table in order to allow permissions on it. In this code block, use the onrun() trigger to insert or modify the record.<\/p>\n<pre><code>codeunit 50120 \"F3 Shipment Line - Edit\"\r\n{\r\n    Permissions = TableData \"Sales Shipment Line\" = rimd; \/\/Full Indirect access\r\n    TableNo = \"Sales Shipment Line\";\r\n    trigger OnRun()\r\n    begin\r\n        SalesShipmentLine := Rec;\r\n        SalesShipmentLine.Modify();\r\n        Rec := SalesShipmentLine;\r\n    end;\r\n    var\r\n        SalesShipmentLine: Record \"Sales Shipment Line\";<\/code> }<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Every object in Business Central is given various permissions. Assignable Permissions refers to permission sets that may be applied to objects via the user interface (UI), while Non-Assignable Permissions refers to permission sets that cannot be applied via the UI. Permissions on Object Each object has one of the four sorts of permissions listed below: [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[],"class_list":["post-16233","post","type-post","status-publish","format-standard","hentry","category-business-central"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to insert or modify a record when Business Central doesn\u2019t allow direct permissions\u00a0<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to insert or modify a record when Business Central doesn\u2019t allow direct permissions\u00a0\" \/>\n<meta property=\"og:description\" content=\"Every object in Business Central is given various permissions. Assignable Permissions refers to permission sets that may be applied to objects via the user interface (UI), while Non-Assignable Permissions refers to permission sets that cannot be applied via the UI. Permissions on Object Each object has one of the four sorts of permissions listed below: [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/\" \/>\n<meta property=\"og:site_name\" content=\"Folio3 Dynamics Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-18T11:03:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-18T11:23:30+00:00\" \/>\n<meta name=\"author\" content=\"Folio3 Microsoft Dynamics Partner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@folio_3\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hira Naeem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/\"},\"author\":{\"name\":\"Folio3 Microsoft Dynamics Partner\",\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/#\/schema\/person\/f7d38b88c941636642e7a9ecf91c20b4\"},\"headline\":\"How to insert or modify a record when Business Central doesn\u2019t allow direct permissions\u00a0\",\"datePublished\":\"2023-04-18T11:03:10+00:00\",\"dateModified\":\"2023-04-18T11:23:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/\"},\"wordCount\":270,\"publisher\":{\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/#organization\"},\"articleSection\":[\"Business Central\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/\",\"url\":\"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/\",\"name\":\"How to insert or modify a record when Business Central doesn\u2019t allow direct permissions\u00a0\",\"isPartOf\":{\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/#website\"},\"datePublished\":\"2023-04-18T11:03:10+00:00\",\"dateModified\":\"2023-04-18T11:23:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\/\/dynamics.folio3.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to insert or modify a record when Business Central doesn\u2019t allow direct permissions\u00a0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/#website\",\"url\":\"https:\/\/dynamics.folio3.com\/blog\/\",\"name\":\"Folio3 Dynamics Blog\",\"description\":\"News, Guides and Info from the world of Microsoft Dynamics\",\"publisher\":{\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dynamics.folio3.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/#organization\",\"name\":\"Folio3\",\"url\":\"https:\/\/dynamics.folio3.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dynamics.folio3.com\/blog\/wp-content\/uploads\/2022\/01\/footer-logo.png\",\"contentUrl\":\"https:\/\/dynamics.folio3.com\/blog\/wp-content\/uploads\/2022\/01\/footer-logo.png\",\"width\":154,\"height\":100,\"caption\":\"Folio3\"},\"image\":{\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/#\/schema\/person\/f7d38b88c941636642e7a9ecf91c20b4\",\"name\":\"Folio3 Microsoft Dynamics Partner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/29f05a21b8db20048e7717694b024bbd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/29f05a21b8db20048e7717694b024bbd?s=96&d=mm&r=g\",\"caption\":\"Folio3 Microsoft Dynamics Partner\"},\"description\":\"Top Microsoft Dynamics partner with 300+ Projects completed worldwide since 2001. Delivering a single point solution tailored to your business needs.\",\"sameAs\":[\"https:\/\/x.com\/folio_3\"],\"url\":\"\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to insert or modify a record when Business Central doesn\u2019t allow direct permissions\u00a0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/","og_locale":"en_US","og_type":"article","og_title":"How to insert or modify a record when Business Central doesn\u2019t allow direct permissions\u00a0","og_description":"Every object in Business Central is given various permissions. Assignable Permissions refers to permission sets that may be applied to objects via the user interface (UI), while Non-Assignable Permissions refers to permission sets that cannot be applied via the UI. Permissions on Object Each object has one of the four sorts of permissions listed below: [&hellip;]","og_url":"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/","og_site_name":"Folio3 Dynamics Blog","article_published_time":"2023-04-18T11:03:10+00:00","article_modified_time":"2023-04-18T11:23:30+00:00","author":"Folio3 Microsoft Dynamics Partner","twitter_card":"summary_large_image","twitter_creator":"@folio_3","twitter_misc":{"Written by":"Hira Naeem","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/#article","isPartOf":{"@id":"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/"},"author":{"name":"Folio3 Microsoft Dynamics Partner","@id":"https:\/\/dynamics.folio3.com\/blog\/#\/schema\/person\/f7d38b88c941636642e7a9ecf91c20b4"},"headline":"How to insert or modify a record when Business Central doesn\u2019t allow direct permissions\u00a0","datePublished":"2023-04-18T11:03:10+00:00","dateModified":"2023-04-18T11:23:30+00:00","mainEntityOfPage":{"@id":"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/"},"wordCount":270,"publisher":{"@id":"https:\/\/dynamics.folio3.com\/blog\/#organization"},"articleSection":["Business Central"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/","url":"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/","name":"How to insert or modify a record when Business Central doesn\u2019t allow direct permissions\u00a0","isPartOf":{"@id":"https:\/\/dynamics.folio3.com\/blog\/#website"},"datePublished":"2023-04-18T11:03:10+00:00","dateModified":"2023-04-18T11:23:30+00:00","breadcrumb":{"@id":"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dynamics.folio3.com\/blog\/how-to-insert-or-modify-a-record-when-business-central-doesnt-allow-direct-permissions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/dynamics.folio3.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to insert or modify a record when Business Central doesn\u2019t allow direct permissions\u00a0"}]},{"@type":"WebSite","@id":"https:\/\/dynamics.folio3.com\/blog\/#website","url":"https:\/\/dynamics.folio3.com\/blog\/","name":"Folio3 Dynamics Blog","description":"News, Guides and Info from the world of Microsoft Dynamics","publisher":{"@id":"https:\/\/dynamics.folio3.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dynamics.folio3.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dynamics.folio3.com\/blog\/#organization","name":"Folio3","url":"https:\/\/dynamics.folio3.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dynamics.folio3.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/dynamics.folio3.com\/blog\/wp-content\/uploads\/2022\/01\/footer-logo.png","contentUrl":"https:\/\/dynamics.folio3.com\/blog\/wp-content\/uploads\/2022\/01\/footer-logo.png","width":154,"height":100,"caption":"Folio3"},"image":{"@id":"https:\/\/dynamics.folio3.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dynamics.folio3.com\/blog\/#\/schema\/person\/f7d38b88c941636642e7a9ecf91c20b4","name":"Folio3 Microsoft Dynamics Partner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dynamics.folio3.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/29f05a21b8db20048e7717694b024bbd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/29f05a21b8db20048e7717694b024bbd?s=96&d=mm&r=g","caption":"Folio3 Microsoft Dynamics Partner"},"description":"Top Microsoft Dynamics partner with 300+ Projects completed worldwide since 2001. Delivering a single point solution tailored to your business needs.","sameAs":["https:\/\/x.com\/folio_3"],"url":""}]}},"_links":{"self":[{"href":"https:\/\/dynamics.folio3.com\/blog\/wp-json\/wp\/v2\/posts\/16233","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dynamics.folio3.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dynamics.folio3.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dynamics.folio3.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dynamics.folio3.com\/blog\/wp-json\/wp\/v2\/comments?post=16233"}],"version-history":[{"count":0,"href":"https:\/\/dynamics.folio3.com\/blog\/wp-json\/wp\/v2\/posts\/16233\/revisions"}],"wp:attachment":[{"href":"https:\/\/dynamics.folio3.com\/blog\/wp-json\/wp\/v2\/media?parent=16233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dynamics.folio3.com\/blog\/wp-json\/wp\/v2\/categories?post=16233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dynamics.folio3.com\/blog\/wp-json\/wp\/v2\/tags?post=16233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}