Skip to main content


Showing posts with the label Creating Attachments

How to Bulk Upload attachements using AL in Business Central

Problem Statement: Few months ago I wrote a blog on  Generic way of attaching documents . As a feedback to this, questions started coming if there is any chance for bulk uploading attachments like  Import multiple Item Pictures . Lets start. Pre- requisites : Understanding of AL. Microsoft Dynamics Business Central Tenant. Understanding of how compression works in BC. Demonstration: 1. Understanding the Base App Code: In the picture below I have illustrated the important parts needed to understand the Base App Code. In short Upload Zip as Stream > Decompress to Lists > Attach the element of the List. LoadZIP - Item Picture - Code Understanding 2. Writing the Code for the Functionality: To be specific, I have written a code whihc will bulk upload Attachments for Variants of Items. I will be seperating delimiting and recognizing Items and Variants using the format as follows ' VariantNo.[Count per variant]%ItemNo.%[*].[ext] ' Load ZIP - Cu

Generic way of Attaching Documents on any Record of the Page in Microsoft Dynamics Business Central - Template Code

Problem Statement: In Microsoft Business Central, there is a way to attach attachments only on Documents or Master Table records. But, what if this requirement is for other tables such as Opportunities, custom tables, etc. Introduction: I have seen many developers afraid to touch the attachment-related customization as it seems complicated. Well, I have found a solution and here it goes. In this blog, I'm attempting to create a generic template for code that needs to have an attachment feature on any table that you like using AL Code. This means that you simply cannot copy-paste the same code for all the tables but a simple change in variable sub-type will ease your work significantly Pre-requisites: Microsoft Dynamics Business Central VS Code Al Language Extension Source Code: Demonstration: 1. How it works: Document Attachment is a table which stores a few things that help in tracking information rel