Business Central Junction 365 Blogs

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

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

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

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

 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