Tips focused on Microsoft Dynamics
Integrating an external dependency can help speed up your development cycle if you are developing an extension for Business Central. In my last task for this Co-op work term, I used an external app as a dependency for one of the Geoson’s projects. Adding An External Dependency There are already a lot of extensions for …
We can use the built-in “Control Addin Object” in AL to use JavaScript and render dynamic HTML onto a page in Business Central. In this post we will create a basic iFrame (a webpage within a Business Central page). File Structure If you want to follow along, add this file structure to your new AL …
Using JavaScript For Business Central Development Read More »
This week I created an automated workflow that emails a report to a user weekly. To do this, I used a ‘Codeunit’ to implement the logic and a ‘Job Queue’ to schedule the task at hand. Although there are built-in workflows in Business Central, I found that writing an AL script. Codeunit For Sending Emails …
One of the reports I worked on this week required me to read data from a Blob field on a Business Central page. A BLOB (Binary Large Object) is a complex data type in Business Central with a variable-length allowing it to store text, bitmaps, or user-defined files with a max size of 2 GB. …
Microsoft 365 Business Central: BLOBS and Data Streams in AL Read More »
A table “record” is a complex data structure I’ve used often when scripting a report or an extension. Creating a record basically gives us an instance of a table within Business Central’s database; rows of the table are stored within this data type based on the current filter or range set on it. Since AL …
Microsoft 365 Business Central: Filtering Data using AL Read More »
Whether you know Bank Payments by ACH, EFT, Data Exchange Definitions, making the file work with your bank is critical. There is huge potential time savings vs manual payment methods. Though the key is avoiding a few stressful weeks to get the ACH file to work. Problem Statement Microsoft Dynamics Business Central comes with several …
Microsoft Dynamics Business Central ACH/EFT editing (Julian Date example) Read More »
This past week I’ve been finishing up a client’s customized sales invoice report. Meetings consisted of getting client feedback on my first report draft. Internal quality control was performed to ensure all requirements for the report were met. I’ve learned quite a bit from creating these extensions, and I thought of sharing my findings on …
All About Reports: An Inside Look Into Report Extensions Read More »
© 2022 Geoson Solutions. All Rights Reserved