Posts

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

Accidentally Removed All SUPER Users in Business Central Production – What Next?

One of my colleagues recently faced a critical issue in the Microsoft Dynamics 365 Business Central (BC) Production environment: Scenario: The admin user accidentally deleted their own permission sets . No other user had SUPER or equivalent permissions to restore access. This effectively locked out the tenant from performing any privileged action in Production. This kind of situation is highly risky , especially when no fallback access or admin recovery users are available. Recommended Action: Raise a Support Request (SR) with Microsoft Since no internal access was possible, the only feasible and secure route was to: How to raised SR Escalate Support Issues to Microsoft   How Microsoft Helped: Microsoft made internal changes in the backend, after which admin access to the Production environment was restored successfully. Thanks For Reading...!! Regards Khushbu Rajvi

Setting Up and Handling Sales Prepayments in D365 Business Central

Image
Prepayments in Business Central let you invoice and post advance payments on sales or purchase orders before the final invoice. This is useful when you require deposits before production or delivery. First of all, we have to set up Sales & Receivables Open Sales & Receivables Setup using the Tell Me 🔍 feature. Under the Number Series section: Make sure Posted Prepmt. Inv. Nos. is the same as Posted Invoice Nos. And Posted Prepmt. Cr. Memo Nos. matches Posted Credit Memo Nos. This ensures that your prepayment invoices and credit memos follow the same numbering as regular sales documents. Configuring sales prepayment accounts in the General Posting Setup Read:  Ways to handle prepayment    Go to General Posting Setup , find the line for DOMESTIC and RETAIL , and set the Sales Prepayments Account to the correct G/L account. Set Up Prepayment Percentages for Customers and Items Once the core sales prepayment settings are configured, the next step is...

Common Ways to Handle Prepayments in Accounting in D365 Business central

When a customer pays you before you deliver goods or services — that's called a prepayment. You haven’t earned the money yet because the sale isn't complete. So, where do you put this money in your accounts? That’s where Customer Prepayment Accounts come in. 💡 Two Common Ways to Handle Prepayments in Accounting: 1. Prepayments as a Liability (most common) Why? Because the money received doesn’t belong to you yet. You owe the customer a product or service. Example in Chart of Accounts: You create a Liability Account like “Customer Prepayments.” What Happens in BC: When you deliver the product/service, Business Central automatically moves the prepayment amount from the liability account to the Revenue Account. 🔁 This is the default and standard accounting practice in many industries. 2. Prepayments as Prepaid Revenue (used in service companies) Why? In professional services (like consulting), some companies record prepayments directly in the income statement as a special kind o...

🚫 Is It Possible to Block Shipments for Unpaid Prepayments in Business Central?

Image
 Yes — and it’s a smart move to ensure you're not shipping goods before receiving required deposits. You can block the shipment or invoicing of sales orders until the required prepayment is fully paid. This ensures financial control and reduces risk with customers who have poor payment histories. Here’s how to enable it: 🔹 Navigate to: Sales & Receivables Setup > General FastTab 🔹 Action: Enable the Check Prepayment when Posting checkbox. 📌 What does this do? When enabled, you cannot post shipments or invoices for any sales order that still has an unpaid prepayment amount. Thanks For Reading...!! Regards, Khushbu Rajvi