In this part I will describe the new possibility to attach any URL to any record in database. This can be very usefull for connecting the word of documents with data in ERP. There are tools for managing these links through C/AL code (see previous part, the rec.ADDLINK command etc.)
How it is working
At first, there is new shortcut on the toolbar (Clip).
Through this shortcut, any user can open form, where you can enter the URL you want (HTTP, Sharepoint, local filesystem, network filesystem, anything you want). From same form you can open attached URL. Count of the atached links is not limited, length of URL can be max. 1000 chars.
For example, you can add scanned Invoice to your purchase order and when the order is posted, the attached links will be copied to Posted Invoice. All users can easilly find and open the document without searching through folders with thousends of files. User can recognize that on actual record are some links in status bar, where is new flag “LINK” near the “FILTER” flag.
What is behind
For saving the links new virtual table is used (2000000068 – Record Link).
As you can see, links are numbered and related to the record through RecordID. Long URLs are splited into 4 fields, with possibility to enter 250 chars of description. The type and BLOB is not used yet, in my opinion the type “Note” and the BLOB “Note” is prepared for version 5.1 for the Work-flow notes. The links can be added, deleted and copied through C/AL commands.
That’s all. It is easy but smart solution. I know that many partners used similar way for attaching the documents, but this solution is much better, because you do not need any change in C/AL code and you can attach the document to any record without customization.
Next part will be about possibility to export any form into Word or Excel and possibility to create templates for this export.