Business Central Junction 365 Blogs

In Dynamics 365 Business Central, users often need reports to run not immediately , but at a scheduled time —for example, after business hours or during low system usage. This is where the AllowScheduling property in AL development comes in handy. In this post, let’s explore what AllowScheduling does, why you should use it, and how to define it in your custom reports. What is AllowScheduling ? The AllowScheduling property allows users to schedule the execution of reports from the report’s request page. When this property is set to true , users see a Schedule option in the report request page.  Schedule Report page will open. Here user can set a detail for execution. Below popup will open. We can check it in the Report Inbox of role center page. Job Queue Entry will be created. Thanks For Reading..!! Regards, Khushbu Rajvi

Report labels are text fields you define in a report to pass static or semi-static text (like titles or captions) into the report layout. These are not coming from the database but are essential for presenting your report in a user-friendly way. Examples include: The title of a report ( e.g., “Sales Invoice” ) A caption for a chart ( e.g., “Monthly Revenue Breakdown” ) Custom static notes in the report layout You can define these labels in your AL report object, and they automatically become available in your report’s layout parameters .  Why Use Labels Instead of Hardcoding Text? Here are the key advantages of using labels: ✅ 1. Multilingual Support Labels are added to the translation file ( .xlf ). This means your text elements can be translated into multiple languages effortlessly. If you hardcode text in variables, these strings don’t appear in translation files and won’t support localization. ✅ 2. Better Report Performance Labels are parameters ...

When defining a dataset for a report in Business Central, you can use the following types of columns: 📄 A field in a table   Add a field directly from the data item’s table. dataitem(Customer; Customer) {     column(CustomerName; Name) { }     column(City; City) { } } Here, Name and City are fields in the Customer table. 📝 A variable   Use a variable declared in report. dataitem(Customer; Customer) {     column(Greeting; GreetingText) { } } var     GreetingText: Text[50]; procedure OnPreDataItem() begin     GreetingText := 'Hello, Customer!'; end; Here, GreetingText is a custom variable added as a column. ➕ An expression   – Use a calculated value or function result. dataitem(SalesLine; "Sales Line") {     column(TotalAmount; "Quantity" * "Unit Price") { } } Here, the column calculates Quantity * Unit Price for each sales line. 🏷️ A caption – Labels or static text not tied to a specific table dataitem(Cu...