Posts

Showing posts from July, 2025

3 Ways to Specify Posting Periods in Dynamics 365 Business Central

Image
1. Company-wide posting periods Search for General Ledger Setup and open it. On the General Ledger Setup page, enter the dates in the Allow Posting from and Allow Posting To fields. 📖 Example: If you set: Allow Posting From: 01/07/2025 Allow Posting To: 31/07/2025 Only transactions within July 2025 can be posted. These posting periods apply to the  entire company  and to  all users . 2. User-specific posting periods If you want exceptions for certain users (like accountants who need to post adjustments in earlier periods), you can define posting periods at the user level . Search for User Setup and open it. On the User Setup page, define Allow Posting from and Allow Posting To dates for individual users. These user-specific posting periods override the dates in General Ledger Setup . 📖 Example: If the General Ledger allows posting for July 2025, but you set Allow Posting From: 01/08/2025 for User A, they can’t post in July . 3. Journa...

Understanding the AllowScheduling Property in Business Central Reports

Image
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

🌟 Understanding Report Labels in Business Central: Why and How to Use Them

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 ...

Types of Columns in a Report Dataset in Business Central

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...