Skip to main content

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 related to the attachment
Document Attachment Table Fields

The main unique thing that works for all the different tables is the TableID, Line No and No. fields.
Along with this, the document is attached through a stream inside a Media DataType.

There are 2 important functions
1. SaveAttachment2 : This function takes a few parameters RecRef for origin Table ID, FileName to
store the file name, Blob which will be imported a Stream in Document Reference ID Media type field,
Recs.No which will store the unique record for which the attachment is attached.
This function when the line has no attachment attached to it. This is done by checking if the field
Document Reference ID has no value.
SaveAttachment2


2. Export2: This function exports the attached BLOB to a file. This is done if the Document
Reference ID field has any value.
Export2

This is both functions are complimentary of each other and are trigger on FileName field DrillDown
DrillDown to Attach OR Export


2. Things that you need to change:
Either you are using the Generic Attachment Template code first time or mulitple times in the same project, you need to find //Change the Table Name Here----OLISTER and //Change the Page Name Here----OLISTER comment and replace your table name. Also, you will need to manage with the PageName and IDs. Read through README.TXT in the project.
README.TXT



3. Custom Attachments for multiple tables:
In the above case, I have created the code for the Opportunity Card page. I will repeat the same for Item Card Page.
Prior to Items Card Page
Make a copy of all the 3 Pages and change their names and Ids.

After adding a new set of pages for different tables

Change the Table Nos on the comment line //Change the Table Name Here----OLISTER and
//Change the Page Name Here----OLISTER
After changing Table Names
After changing Page Names
After changing Part Page Names

4. Output:
Finally, I got this.
Opportunities Attachment
Items Attachment

Conclusion:

Thus, we are successful in creating a generic code template for attachments.

Hope this helps!

Comments

Anik said…
What about the Temp Blob Codeunit. As it is not there in standard BC 14.0
Hi Anik,
TempBlob Codeunit in BC15.0 is the same as TempBlob Table in BC14.0.
You will need to upgrade your app to make it compatible with BC15.0.
Refer by Blog on this https://www.olisterr.tech/2019/12/Per-Tenant-Code-Upgrade-for-Business-Central-version15.html

For BC14.0 you can use TempBlob Table though.

Thanks.
Olister Rumao
Unknown said…
Thank you, it was very helpful!!

Popular posts from this blog

Understanding and How to use APIs Business Central - 2

Introduction:
In my last blog post (Business Central API -1 ) on Creating API in Business Central, we discussed all the commonly used properties of the page, query, and controls like field and data-item. In today's blog, we will be diving deeply into the validation of the data passed through the API endpoint, how it enters into the source tables and is manipulated to be inserted/modified into single or multiple tables.
Also, I will be demonstrating how APIs are to be used.

Pre-requisites:
Microsoft Dynamics Business Central (SaaS)VS Code(https://code.visualstudio.com/download)AL Language Extension(https://tinyurl.com/yyvzxwkb)API V1 from Business Central On-Premise DVD
Books & References:
API V1 from Business Central On-Premise DVDAPI(V1.0) for Business Central (Click Here)API(Beta) for Business Central (Click Here)
Theory:
Understanding API in Business Central 1. BINDSUBSCRIPTIONS: Use to trigger IntegrationEvent for the Codeunit stated in parameters whenever the function calling BI…

Creating APIs in Business Central - 1

Introduction:
While writing a blog on Automated Testing in Business Central, I was going through sample apps provided by Microsoft and realized that the complexity is nowhere close to what examples Microsoft has provided on docs.microsoft.com. In this blog, I will try to explain how APIs work and how to be creative with the implementation. Also, an API which were in beta are finally out with version V1.0 in the April 2019 release let's see some important key things from development aspects.
This blog is going to be theoretical one kindly bear with me.


Pre-requisites:
Microsoft Dynamics Business Central (SaaS)VS Code(https://code.visualstudio.com/download)AL Language Extension(https://tinyurl.com/yyvzxwkb)API V1 from Business Central On-Premise DVD
Books & References:
API V1 from Business Central On-Premise DVDAPI(V1.0) for Business Central (Click Here)API(Beta) for Business Central (Click Here)
Solution:

Key Requirements:
API source table must have an Id(GUID) field per record for m…

Enum Object in Business Central - How to create and how to extend!

Introduction:
Since the dawn of Business Central Era (2nd April 2018 - Today), there are many new data types introduced by Microsoft.
One such data type is Enum(Enumeration). Essentially, what enumeration is having a single select value with multiple options at a given time!
Well, I know what your thinking what about the 'Option' data type.
Anyways, enough of talking let's just dive in!

Disclaimer:The knowledge in this blog is true and complete to the best of authors and publishers knowledge. The author and publisher disclaim any liability in connection with the use of this information.
Pre-requisites:
Microsoft Dynamics Business Central (SaaS or On-Premise)
VS code with AL Language extension

Code:
1. Enum as an Object:
Just like Tables and Pages, Enum behaves like an Object.
Note that Extensible means that the Enum Object can be extended in another module. By default, this property is set to TRUE.



Enums and Enum Extensions behave differently. They follow a different number se…