Dynamics 365 Business Central: Retrieve Linked Sales Order Data in Assembly Orders Using AL Code

Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to get linked Sales order’s data in Assembly Order. This customization can be used for businesses that deal with complex assembly processes and… Continue reading Dynamics 365 Business Central: Retrieve Linked Sales Order Data in Assembly Orders Using AL Code

Dynamics 365 Business Central

Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to link Dimensions to a custom table and its Pages in D365 Business Central. Prerequisites Access to a Microsoft Dynamics 365 Business Central… Continue reading Dynamics 365 Business Central

How to use SecretText Data type in Business Central

Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to set the shipment date as blank when creating a new sales order in Business Central. This customization can be particularly useful when… Continue reading How to use SecretText Data type in Business Central

Dynamics 365 Business Central: Item Variant Block Functionality

Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of features. One such feature that can significantly enhance your process is the Block your item variant which is not in use. Requirement: How can we Specify and restrict to use old or not in use variant during… Continue reading Dynamics 365 Business Central: Item Variant Block Functionality

Unlocking Data Agility: Leveraging Databricks to Interface with Dynamics 365 Business Central’s Complex API

Say hello to Databricks, a dynamic platform merging the power of Apache Spark with collaborative workspaces allowing flexibility to use multiple programming languages (Python, Scala, SQL) within a single environment. This versatility surpasses the constraints of predefined transformations in pipelines, allowing for more intricate and customized data transformations. Data Pipeline Hiccups: The ‘Content-Type’ Snag Let’s… Continue reading Unlocking Data Agility: Leveraging Databricks to Interface with Dynamics 365 Business Central’s Complex API

Integration of Business Central APIs and Web Services with OAuth

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to connect Business Central APIs and Web Service with OAuth. Microsoft Dynamics 365 Business Central, offers a set of powerful APIs and… Continue reading Integration of Business Central APIs and Web Services with OAuth

Identify Posted Purchase Receipt and Invoices Against Purchase Order

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of features. One such feature that can significantly enhance your process is to identify posted purchase receipts and invoices against order. Prerequisites: Verify that the organization has valid licenses for Microsoft Dynamics 365 Business Central. Required Business… Continue reading Identify Posted Purchase Receipt and Invoices Against Purchase Order

Auto create Item In Business Central While Entering Item Description In Sales Line

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of features. One such feature that can significantly enhance your sales process is the ability to auto-create items in Business Central when entering item descriptions on sales lines. Requirement: How can we create item while entering item… Continue reading Auto create Item In Business Central While Entering Item Description In Sales Line

How to Create Progress Indicator in Business Central using AL Code

If you want to know how to create a progress indicator in Business Central using AL Code, look no further. This blog will teach you how. A progress indicator is a useful feature that lets the user know how much of a long-running process has been completed and how much is left. A progress indicator… Continue reading How to Create Progress Indicator in Business Central using AL Code

Make fields Non-editable in Business Central

If you want to make fields non editable in Business Central on a master page or on a transaction page, you depend on developers, but now it is possible and for a functional consultant, this feature is very useful. Prerequisites: Generally, we use the Personalize option to hide the fields or move the fields from… Continue reading Make fields Non-editable in Business Central

Allow Selecting Multiple Customer/Vendor Posting Group in Business Central

At the time of transaction, the user can change Customer posting Group OR Vendor posting Group if needed as per the Accounting Expect. Lets see how we can allow selecting multiple posting groups in Business Central. Requirement: If  we are purchasing the material OR sale the material to Vendor/Customer, and Purchasing or Providing Service to… Continue reading Allow Selecting Multiple Customer/Vendor Posting Group in Business Central

Set Shipment Date Blank When Creating A New Sales Order In Business Central Using AL Code

Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to set the shipment date as blank when creating a new sales order in Business Central. This customization can be particularly useful when you want… Continue reading Set Shipment Date Blank When Creating A New Sales Order In Business Central Using AL Code

Creating Custom Email Subject in Dynamics 365 Business Central using AL Code

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is the ability to dynamically create a custom email subject in Dynamics 365 Business Central using AL code for different document types, when… Continue reading Creating Custom Email Subject in Dynamics 365 Business Central using AL Code

How to insert new balances for Vendors and Customers in a new company in Business Central

Requirement: We had a requirement to import the balances of the Customers and Vendors in a fresh instance.  Issues: The master data wasn’t imported in the system. No direct way to post the opening balances in the system. While posting the balances there was an error related to the General Journal posting. Solution: Master data… Continue reading How to insert new balances for Vendors and Customers in a new company in Business Central

Business Central latest updates 2022 release Wave 1

Here are some interesting new updates in the latest release for Business Central Blocking deletion of G/L accounts This new feature is going to be introduced to help avoid accidental deletion of general ledger (G/L) accounts, this release wave adds an extra check. An extra safeguard against accidental deletion of G/L accounts even in the… Continue reading Business Central latest updates 2022 release Wave 1

Latest Updates in Business Central V 18.3

Description This blog will describe the updates on Business Central 18.3. Below is the list of the major updates available in Dynamics 365 Business Central. Document Objective G/L Entry Dimension Correction. Inventory Documents. Item Availability by Lot No. Variant codes on production orders in Business Central. In this blog we are going to discuss some… Continue reading Latest Updates in Business Central V 18.3

Schema Update Mode in AL code for Dynamics 365 Business Central

Description:  This blog will describe the significance of the Schema Update Mode and why it is used in Business Central. We were facing some issues while working on the table extensions and realized that we could not change the data type or the size of the custom fields we described in the extension once published.… Continue reading Schema Update Mode in AL code for Dynamics 365 Business Central

How to set-up Jet Reports in Business Central – Part 2

In the previous blog we learnt how to make a connection between Business Central and Jet reports. Jet Reports are fast and flexible financial reporting solution that helps to eliminate the errors in traditional reporting available OOTB in the Business Central system. In this blog you will learn how to build a Jet Report in… Continue reading How to set-up Jet Reports in Business Central – Part 2

How to set-up Jet Reports in Business Central – Part 1

Overview on Jet Reports: Jet Reports are fast and flexible financial reporting solution that helps to eliminate the errors in traditional reporting available out of the box in the Business Central system. Jet Reports allows to get the latest information from the database. Jet Reports integrates into excel allowing us to get the real-time data… Continue reading How to set-up Jet Reports in Business Central – Part 1

Working with the Analysis view in Business Central

What is Analysis view? There are 2 global dimensions which help to analyze the data in the whole Business Central system. The Analysis view is used to set multiple dimensions to use with the Account Schedules. The global dimensions are available in the account schedule, so we can run our reports/income statement and we can… Continue reading Working with the Analysis view in Business Central

Page Inspection in Business Central

As the name suggests Page is any page of the Business Central and Inspection means careful examination of something. Hence, Page Inspection means closer examination of the Business Central Page. Page inspection allows you to get the details about a particular page you are on. It provides insight into the page design and elements that comprise the page along with the… Continue reading Page Inspection in Business Central