{"id":15560,"date":"2022-09-22T10:27:11","date_gmt":"2022-09-22T10:27:11","guid":{"rendered":"https:\/\/dynamics.folio3.com\/blog\/?p=15560"},"modified":"2022-10-04T07:03:54","modified_gmt":"2022-10-04T07:03:54","slug":"get-attachment-document-from-business-central-using-a-l","status":"publish","type":"post","link":"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/","title":{"rendered":"Get Attachment Document from Business Central using A\/L"},"content":{"rendered":"

In Business Central there are two ways to attach documents (pdf, txt and more) to respective sales order, purchase order or Posted Sales Invoice and more.<\/span>
\n<\/span><\/p>\n

    \n
  1. Incoming Document<\/span><\/li>\n
  2. Attachments<\/span><\/li>\n<\/ol>\n

    Introduction to Incoming Document:<\/h2>\n

    Snapshot for Incoming Document for Posted Sales Invoice Page:<\/p>\n

    \"\"<\/p>\n

    We can view already attached incoming document using View Incoming Document Option as highlighted in above snapshot. The Documents which are going to be attached using Incoming Document Option would be accessed using <\/span>Incoming Document (130)<\/b> and <\/span>Incoming Document Attachment <\/b>Table. We will discuss how we can access documents using AL later.<\/span><\/p>\n

    Introduction to Attachments:<\/b><\/h2>\n

    Snapshot for Attachments for Posted Sales Invoice Page:<\/p>\n

    \"\"<\/p>\n

    \"\"<\/p>\n

    We can view already attached attachments using Attachments Option as highlighted in above snapshot. The Documents which are going to be attached using Attachments Option would be accessed using <\/span>Document Attachment (1173)<\/b> Table.\u00a0<\/span><\/p>\n

    <\/b>Get Incoming Document for Posted Sales Invoice using AL:<\/b><\/p>\n

    In this tutorial we will be storing document content in the form of base64 string as a final output.<\/span>
    \n<\/span>
    \n<\/span>1) First step will be to define required variables, we will be using following variables for fetching Document.<\/span><\/p>\n


    \n<\/span>-> Incoming Document Attachment (Type : Record) for fetching document for specific posted invoice.<\/span>
    \n<\/span>-> Temp Blob (Type : Codeunit) for creating and managing OutStream and InStream Objects.<\/span>
    \n<\/span>-> InStream object<\/span>
    \n<\/span>-> Base64 Convert for converting InStream to base64 String.<\/span><\/p>\n

    \"\"<\/p>\n

    2) Second step is to set range on Incoming Document Attachment table for fetching specific invoice.<\/span><\/p>\n

    \"\"<\/p>\n

    3) Third step to apply FindFirst function on Incoming Document Attachment table.<\/span> \"\"<\/p>\n

    4) Actual content of document is placed in \u201cContent\u201d field of Incoming Document Attachment table which is a FlowField so for that we will have to use CalcField function after filtering the record using SetRange and FindFirst and then store it in Temp Blob.<\/span><\/p>\n

    \"\"<\/p>\n

    5)Then create InStream using tempBlob<\/span>
    \n<\/span><\/p>\n

    \"\"<\/p>\n

    6) Finally we need to convert that InSream to Base64 String for that we will use Base64 Convert.<\/span>
    \n<\/span><\/p>\n

    \"\"<\/p>\n

    Full Code Snippet for fetching Document from Incoming Document Attachment Table and converting it into Base64 String.\u00a0<\/span>
    \n<\/span><\/p>\n

    \"\"<\/p>\n

    Get Attachment for Posted Sales Invoice using AL:<\/b><\/h2>\n

    In this tutorial we will be storing document content in the form of base64 string as a final output.<\/span>
    \n<\/span>
    \n<\/span>1) First step will be define required variables, we will be using following variables for fetching Document.<\/span><\/p>\n


    \n<\/span>-> Document Attachment (Type : Record) for fetching document for specific posted invoice.<\/span>
    \n<\/span>-> Temp Blob (Type : Codeunit) for creating and managing OutStream and InStream Objects.<\/span>
    \n<\/span>-> OutStream object<\/span>
    \n<\/span>-> InStream object<\/span>
    \n<\/span>-> Base64 Convert for converting InStream to base64 String.<\/span>
    \n<\/span><\/p>\n

    \"\"<\/p>\n

    2) Second step is to set range on Document Attachment table for fetching specific invoice.<\/span><\/p>\n

    \"\"<\/p>\n

    3) Third step to apply FindFirst function on Document Attachment table.<\/span>
    \n<\/span><\/p>\n

    \"\"<\/p>\n

    4) Actual content of document can be accessed using \u201cDocument Reference ID\u201d which is a media type field in Document Attachment table. Initially we will create empty OutStream using tempBlob ad then write content of actual document on OutStream using export function as follow.<\/span>
    \n<\/span><\/p>\n

    \"\"<\/p>\n

    5) Then create InStream using same tempBlob object.<\/span><\/p>\n

    \"\"<\/p>\n

    6) Finally convert that InStream to base64 String using Base64 Convert.<\/span><\/p>\n

    \"\"<\/p>\n

    Full Code Snippet for fetching Document from Document Attachment Table and converting it into Base64 String.<\/span><\/p>\n

    \"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

    In Business Central there are two ways to attach documents (pdf, txt and more) to respective sales order, purchase order or Posted Sales Invoice and more. Incoming Document Attachments Introduction to Incoming Document: Snapshot for Incoming Document for Posted Sales Invoice Page: We can view already attached incoming document using View Incoming Document Option as […]<\/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-15560","post","type-post","status-publish","format-standard","hentry","category-business-central"],"yoast_head":"\nGet Attachment Document from Business Central using A\/L<\/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\/get-attachment-document-from-business-central-using-a-l\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Get Attachment Document from Business Central using A\/L\" \/>\n<meta property=\"og:description\" content=\"In Business Central there are two ways to attach documents (pdf, txt and more) to respective sales order, purchase order or Posted Sales Invoice and more. Incoming Document Attachments Introduction to Incoming Document: Snapshot for Incoming Document for Posted Sales Invoice Page: We can view already attached incoming document using View Incoming Document Option as […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/\" \/>\n<meta property=\"og:site_name\" content=\"Folio3 Dynamics Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-22T10:27:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T07:03:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dynamics.folio3.com\/blog\/wp-content\/uploads\/2022\/09\/01-unnamed.png\" \/>\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=\"Khabab Mahboob Butt\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/\"},\"author\":{\"name\":\"Folio3 Microsoft Dynamics Partner\",\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/#\/schema\/person\/f7d38b88c941636642e7a9ecf91c20b4\"},\"headline\":\"Get Attachment Document from Business Central using A\/L\",\"datePublished\":\"2022-09-22T10:27:11+00:00\",\"dateModified\":\"2022-10-04T07:03:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/\"},\"wordCount\":528,\"publisher\":{\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dynamics.folio3.com\/blog\/wp-content\/uploads\/2022\/09\/01-unnamed.png\",\"articleSection\":[\"Business Central\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/\",\"url\":\"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/\",\"name\":\"Get Attachment Document from Business Central using A\/L\",\"isPartOf\":{\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dynamics.folio3.com\/blog\/wp-content\/uploads\/2022\/09\/01-unnamed.png\",\"datePublished\":\"2022-09-22T10:27:11+00:00\",\"dateModified\":\"2022-10-04T07:03:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/#primaryimage\",\"url\":\"https:\/\/dynamics.folio3.com\/blog\/wp-content\/uploads\/2022\/09\/01-unnamed.png\",\"contentUrl\":\"https:\/\/dynamics.folio3.com\/blog\/wp-content\/uploads\/2022\/09\/01-unnamed.png\",\"width\":512,\"height\":258},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\/\/dynamics.folio3.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Get Attachment Document from Business Central using A\/L\"}]},{\"@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":"Get Attachment Document from Business Central using A\/L","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\/get-attachment-document-from-business-central-using-a-l\/","og_locale":"en_US","og_type":"article","og_title":"Get Attachment Document from Business Central using A\/L","og_description":"In Business Central there are two ways to attach documents (pdf, txt and more) to respective sales order, purchase order or Posted Sales Invoice and more. Incoming Document Attachments Introduction to Incoming Document: Snapshot for Incoming Document for Posted Sales Invoice Page: We can view already attached incoming document using View Incoming Document Option as […]","og_url":"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/","og_site_name":"Folio3 Dynamics Blog","article_published_time":"2022-09-22T10:27:11+00:00","article_modified_time":"2022-10-04T07:03:54+00:00","og_image":[{"url":"https:\/\/dynamics.folio3.com\/blog\/wp-content\/uploads\/2022\/09\/01-unnamed.png","type":"","width":"","height":""}],"author":"Folio3 Microsoft Dynamics Partner","twitter_card":"summary_large_image","twitter_creator":"@folio_3","twitter_misc":{"Written by":"Khabab Mahboob Butt","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/#article","isPartOf":{"@id":"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/"},"author":{"name":"Folio3 Microsoft Dynamics Partner","@id":"https:\/\/dynamics.folio3.com\/blog\/#\/schema\/person\/f7d38b88c941636642e7a9ecf91c20b4"},"headline":"Get Attachment Document from Business Central using A\/L","datePublished":"2022-09-22T10:27:11+00:00","dateModified":"2022-10-04T07:03:54+00:00","mainEntityOfPage":{"@id":"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/"},"wordCount":528,"publisher":{"@id":"https:\/\/dynamics.folio3.com\/blog\/#organization"},"image":{"@id":"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/#primaryimage"},"thumbnailUrl":"https:\/\/dynamics.folio3.com\/blog\/wp-content\/uploads\/2022\/09\/01-unnamed.png","articleSection":["Business Central"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/","url":"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/","name":"Get Attachment Document from Business Central using A\/L","isPartOf":{"@id":"https:\/\/dynamics.folio3.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/#primaryimage"},"image":{"@id":"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/#primaryimage"},"thumbnailUrl":"https:\/\/dynamics.folio3.com\/blog\/wp-content\/uploads\/2022\/09\/01-unnamed.png","datePublished":"2022-09-22T10:27:11+00:00","dateModified":"2022-10-04T07:03:54+00:00","breadcrumb":{"@id":"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/#primaryimage","url":"https:\/\/dynamics.folio3.com\/blog\/wp-content\/uploads\/2022\/09\/01-unnamed.png","contentUrl":"https:\/\/dynamics.folio3.com\/blog\/wp-content\/uploads\/2022\/09\/01-unnamed.png","width":512,"height":258},{"@type":"BreadcrumbList","@id":"https:\/\/dynamics.folio3.com\/blog\/get-attachment-document-from-business-central-using-a-l\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/dynamics.folio3.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Get Attachment Document from Business Central using A\/L"}]},{"@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\/15560","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=15560"}],"version-history":[{"count":0,"href":"https:\/\/dynamics.folio3.com\/blog\/wp-json\/wp\/v2\/posts\/15560\/revisions"}],"wp:attachment":[{"href":"https:\/\/dynamics.folio3.com\/blog\/wp-json\/wp\/v2\/media?parent=15560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dynamics.folio3.com\/blog\/wp-json\/wp\/v2\/categories?post=15560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dynamics.folio3.com\/blog\/wp-json\/wp\/v2\/tags?post=15560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}