Business Central Archives - Microsoft Business Intelligence

How to Utilize the Accounts Receivable Administrator Role Center in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central offers a strong ERP solution adapted to streamline financial operations. One of the standout features of 2024 wave1 for collection management is the Accounts Receivable Administrator Role Center. This role center is designed to centralize and simplify collection tasks, such as creating and sending reminders and statements. By leveraging the… Continue reading How to Utilize the Accounts Receivable Administrator Role Center in Microsoft Dynamics 365 Business Central

Dynamics Great Plains vs. Business Central: Why It’s Time to Upgrade

For years, Microsoft Dynamics Great Plains (GP) was the go-to ERP solution for businesses looking for robust accounting and financial management tools. However, as technology evolves and business needs shift, it’s clear that Microsoft Dynamics Business Central has taken the lead as the modern, scalable alternative. If you’re still using GP, it may be time… Continue reading Dynamics Great Plains vs. Business Central: Why It’s Time to Upgrade

Why Business Central is the Smarter Choice for Financial Control and Cost Management

In today’s fast-paced business world, financial control and cost management are at the core of every successful company. Without a clear view of finances, businesses can find themselves overspending, missing financial opportunities, or struggling to compete. Microsoft Dynamics 365 Business Central is a powerful tool that’s helping businesses make smarter financial decisions, save money, and… Continue reading Why Business Central is the Smarter Choice for Financial Control and Cost Management

Why Business Central’s Features Go Beyond Basic Accounting Solutions

When businesses consider upgrading their accounting software, they often look for a solution that manages their finances smoothly, keeps their records accurate, and complies with tax regulations. Microsoft’s Business Central offers all of that—and so much more. But why does Business Central stand out, especially for companies looking for more than just accounting software? Let’s… Continue reading Why Business Central’s Features Go Beyond Basic Accounting Solutions

Top 5 Growing Pains of Small Businesses and How Business Central Solves Them

Growing a small business is an exciting journey, but with growth comes challenges, or what many call “growing pains.” These growing pains can hold businesses back if they’re not addressed properly. Fortunately, tools like Microsoft Dynamics 365 Business Central (BC) can help ease these struggles and set businesses up for long-term success. In this blog… Continue reading Top 5 Growing Pains of Small Businesses and How Business Central Solves Them

Managing Posting Restrictions on Sales/Purchase Document According to various users in MS Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of features. One such feature is the capability to manage posting restrictions on sales and purchase documents according to various users is pivotal for ensuring data integrity and financial control within organizations. Requirement: How can we effectively… Continue reading Managing Posting Restrictions on Sales/Purchase Document According to various users in MS Dynamics 365 Business Central

How to create a QR Code that is the Base64 encoded TLV (Tag, Length, Value) in Dynamics 365 Business Central

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 create a QR Code that is the Base64 encoded TLV (Tag, Length, Value) in Dynamics 365 Business Central. Prerequisites Access to… Continue reading How to create a QR Code that is the Base64 encoded TLV (Tag, Length, Value) in Dynamics 365 Business Central

Cancel Multiple Posted Sales Invoices using Job Queue in MS 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 to Cancel Multiple Posted Sales Invoices in a batch using Job Queue in Business Central. A job queue in Microsoft Dynamics 365… Continue reading Cancel Multiple Posted Sales Invoices using Job Queue in MS Dynamics 365 Business Central using AL Code

Creating a Custom Job Queue to create Sales order from Purchase order in MS 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 to create a custom job queue to create Sales order from Purchase order in Business Central. A job queue in Microsoft Dynamics… Continue reading Creating a Custom Job Queue to create Sales order from Purchase order in MS Dynamics 365 Business Central using AL Code

How to call (invoke) Power Automate Flows on an action via HTTP Request in 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 to call (invoke) Power Automate Flows on an action via HTTP Request in Business Central Using AL Code. Integrating Power Automate Flows… Continue reading How to call (invoke) Power Automate Flows on an action via HTTP Request in Business Central Using AL Code

Archiving Projects (Jobs) in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of features. One such feature is the capability to archive projects (jobs) which can help keep your workspace organized and efficient. With archiving capabilities, users can manage their project data effectively, benefiting from audit trails and version… Continue reading Archiving Projects (Jobs) in Microsoft Dynamics 365 Business Central

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