Set New Table Style as Default in Microsoft Word
I’ve been doing some work recently in Microsoft Word, where I’ve been tidying up some of the formatting. One of the issues was the embedded tables were styled to look the same, but they weren’t actually a using style so any new table added, either had to be a copy of an existing one or formatting manually applied. I formatted the table up as required and applied the format to all of the… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Add Teaching Tooltips on Queries and Report Request Pages
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The twenty-third of the new functionality in the Development section is Add teaching tooltips on queries and report request pages. Teaching tips are used to increase the… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Add a New FieldGroup to an Existing Table
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The twenty-second of the new functionality in the Development section is Add a new FieldGroup to an existing table. One of the highest-voted extensibility gaps in AL is… Continue Reading Ian Grieve’s...
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Receipts and Put-aways in Advanced Warehousing
This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. The first level of the advanced warehousing functionality, is to require both a warehouse receipt and a… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Provide Queries for Users to do Ad Hoc Data Analysis Across Tables
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The twenty-first of the new functionality in the Development section is Provide queries for users to do ad hoc data analysis across tables. Developers can now provide… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Use the AL Language Extension for Linux in Preview
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The twentieth of the new functionality in the Development section is Use the AL Language extension for Linux in preview. To allow developers to choose the environment that… Continue Reading Ian...
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Warehouse Receipts and Put-aways in Advanced Warehousing
This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. We’ve so far taken a look at inventory put-aways and required receipts being processed separately. The… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Show List of Keys While Working on AL Code
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The nineteenth of the new functionality in the Development section is Show list of keys while working on AL code. IntelliSense offers great productivity features. On… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Segment AL Code and Reduce Naming Conflicts with Namespaces
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The eighteenth of the new functionality in the Development section is Segment AL code and reduce naming conflicts with namespaces. AL for Business Central will now support… Continue Reading Ian...
How To Install Microsoft SQL Server 2022: SSIS Configuration For Named Instances
This article is part of the series on How To Install Microsoft SQL Server 2022; I do not claim to be an expert on SQL Server and this series is installing SQL Server in a development/testing/demo environment. If you’re installing SQL into a production environment there will be additional work required to harden the SQL Server and avoid security issues. In the last article, I covered the
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Document Your Extensions With the ALDoc Tool for Partners
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The seventeenth of the new functionality in the Development section is Document your extensions with the ALDoc tool for partners. Business Central has a large and… Continue Reading Ian Grieve’s Article...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Use SecretText Type to Protect Credentials and Sensitive Textual Values From Being Revealed
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The sixteenth of the new functionality in the Development section is Use SecretText type to protect credentials and sensitive textual values from being revealed. With an… Continue Reading Ian Grieve’s...
Warehouse Receipt Preview Posting Error in Warehouse Receipt in Microsoft Dynamics 365 Business Central
When writing this post on warehouse receipts I came across an oddity when previewing the posting of the receipt. If I created a warehouse receipt for an order, I can successfully preview the posting; if I created a new receipt for a second receipt and did a preview of the posting, the preview was successful. However, if I created one receipt with both orders, then I received the following… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Track Source and Build Metadata on Extensions
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The fifteenth of the new functionality in the Development section is Track source and build metadata on extensions. To help track extensions that are created as part of… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Set the Default Folder Location for New AL Projects
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The fourteenth of the new functionality in the Development section is Set the default folder location for new AL projects. The AL Language extension for Microsoft Dynamics… Continue Reading Ian...
How To Install Microsoft SQL Server 2022: Install SQL Server Integration Services
This article is part of the series on How To Install Microsoft SQL Server 2022; I do not claim to be an expert on SQL Server and this series is installing SQL Server in a development/testing/demo environment. If you’re installing SQL into a production environment there will be additional work required to harden the SQL Server and avoid security issues. SQL Server Integration Services (SSIS) is… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Get Smarter Method Signature Recommendations in IntelliSense
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The thirteenth of the new functionality in the Development section is Get smarter method signature recommendations in IntelliSense. One of the most common uses of… Continue Reading Ian Grieve’s Article...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Get IntelliSense for Adding Variables in Visual Studio Code AL Debugger Console
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The twelfth of the new functionality in the Development section is Get IntelliSense for adding variables in Visual Studio Code AL debugger console. Usually when debugging… Continue Reading Ian Grieve’s...
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post Receipt From a Warehouse Receipt Document
This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. With a location enabled for requiring receive, we can now the receipt of goods to the warehouse. There… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Choose Between More Sampling Intervals for Snapshot and In-client Profiling
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The eleventh of the new functionality in the Development section is Choose between more sampling intervals for snapshot and in-client profiling. Some releases ago… Continue Reading Ian Grieve’s Article...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Set New Output Folder Setting for Storing App Files at AL Project Build
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The tenth of the new functionality in the Development section is Set new output folder setting for storing app files at AL project build. By default, when you build AL… Continue Reading Ian Grieve’s...
Features Not Implemented in On-premises Deployments of Microsoft Dynamics 365 Business Central
I stumbled across an article on Microsoft Learn the other day which lists the features of Microsoft Dynamics 365 Business Central which are not implemented in on-premises deployments. These are features which are not only not implemented, but will also not be implemented in future. I’ve included the key part of the list below, but there is additional information at the link I posted above.
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Hover Over Label Variable to See Text String Value
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The ninth of the new functionality in the Development section is Hover over label variable to see text string value. When label variables are used in AL code, only the… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The eighth of the new functionality in the Development section is Get inlay hints in source editor for AL method parameters and return types. Visual Studio Code supports… Continue Reading Ian Grieve’s...
How To Install Microsoft SQL Server 2022: Install SQL Server Analysis Services
This article is part of the series on How To Install Microsoft SQL Server 2022; I do not claim to be an expert on SQL Server and this series is installing SQL Server in a development/testing/demo environment. If you’re installing SQL into a production environment there will be additional work required to harden the SQL Server and avoid security issues. The SQL Server Analysis Services (SSAS)… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Find All References Now Works on Triggers, System Methods, and Trigger Events
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The seventh of the new functionality in the Development section is Find all references now works on triggers, system methods, and trigger events. The CodeLens for Where… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Get the AL Language Extension in Prerelease Versions on Visual Studio Code Marketplace
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The sixth of the new functionality in the Development section is Get the AL Language extension in prerelease versions on Visual Studio Code Marketplace. Prerelease… Continue Reading Ian Grieve’s...
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Receipts
This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. In the last article, I covered receiving items on a PO without a specific receipt requirement; this would… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Easier Management of System Application Permissions
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The fifth of the new functionality in the Development section is Easier management of System Application permissions. A streamlined and organized permissions management… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Responsibility Centers Are Supported for Advance Payments in Czechia
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The of the new functionality in the Country and regional section is Responsibility Centers are supported for Advance Payments in Czechia. This new feature adds support… Continue Reading Ian Grieve’s...
How To Install Microsoft SQL Server 2022: Change SQL Server Reporting Services maxRequestLength Setting
This article is part of the series on How To Install Microsoft SQL Server 2022; I do not claim to be an expert on SQL Server and this series is installing SQL Server in a development/testing/demo environment. If you’re installing SQL into a production environment there will be additional work required to harden the SQL Server and avoid security issues. While I no longer work with Microsoft… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Easily Integrate Generative AI With Your AL Solutions
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The of the new functionality in the Copilot and AI innovation section is Easily integrate generative AI with your AL solutions. Azure OpenAI Service offers powerful,… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Generate a Customer Statement Only With Open Entries
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The twenty-seventh of the new functionality in the Application section is Generate a customer statement only with open entries. Businesses send customer statements to… Continue Reading Ian Grieve’s...
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process a Receipt From the Source Document
This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. In this article, I’m going to take a look at how receipts can be entered via the source document…. Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Receive More Items Than Ordered by Using Inventory Put-away Documents
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The twenty-sixth of the new functionality in the Application section is Receive more items than ordered by using inventory put-away documents. When more goods arrive than… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Print and Scan Barcodes
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The twenty-fifth of the new functionality in the Application section is Print and scan barcodes. Streamline your processes with barcode technology. Enabled for: Users,… Continue Reading Ian Grieve’s...
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Receipts in Basic Warehousing
This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. As I mentioned in this article on the different levels of inventory and warehouse management, warehouse… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Navigate Easier Between Order, Receipt, and Invoice Documents
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The twenty-fourth of the new functionality in the Application section is Navigate easier between order, receipt, and invoice documents. Sales, purchase, and service orders… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Improved Processes for Inventory Counts and Adjustments
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The twenty-third of the new functionality in the Application section is Improved processes for inventory counts and adjustments. Productivity increases when processes are… Continue Reading Ian Grieve’s...
How To Install Microsoft SQL Server 2022: Configure SQL Server Reporting Services
This article is part of the series on How To Install Microsoft SQL Server 2022; I do not claim to be an expert on SQL Server and this series is installing SQL Server in a development/testing/demo environment. If you’re installing SQL into a production environment there will be additional work required to harden the SQL Server and avoid security issues. With SQL Server reporting Services (SSRS)… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Identify and Track Items Easier with Item References
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The twenty-second of the new functionality in the Application section is Identify and track items easier with item references. Streamline inventory management by providing… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Block Item Variants
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The twenty-first of the new functionality in the Application section is Block item variants. Over time, you might have some item variants that you no longer need. Business… Continue Reading Ian...
“You have one or more documents that must be posted before you post document no. 20230803-1 according to your company’s No. Series setup.” Error in Microsoft Dynamics 365 Business Central
When doing some work for a client on the Fixed Assets module, a short time ago, prior to a training session I did a little testing and encountered a problem when creating an acquisition journal: You have one or more documents that must be posted before you post document no. 20230803-1 according to your company’s No. Series setup. I had previously checked the assigned number series and it was… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Add More Columns to Pages for Better Insight
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The nineteenth of the new functionality in the Application section is Add more columns to pages for better insight. Different businesses and users need different… Continue Reading Ian Grieve’s Article...
How To Install Microsoft SQL Server 2022: Install SQL Server Reporting Services
This article is part of the series on How To Install Microsoft SQL Server 2022; I do not claim to be an expert on SQL Server and this series is installing SQL Server in a development/testing/demo environment. If you’re installing SQL into a production environment there will be additional work required to harden the SQL Server and avoid security issues. Once you have the correct version of SQL… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Use Different General Ledger Accounts for Payables, Receivables
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The eighteenth of the new functionality in the Application section is Use different general ledger accounts for payables, receivables. Sometimes businesses want to post… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: More Control Over General Journal Approvals
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The seventeenth of the new functionality in the Application section is More control over general journal approvals. Some transactions require more scrutiny by accounting… Continue Reading Ian Grieve’s...
Error Posting Fixed Asset Write-Down In Microsoft Dynamics 365 Business Central
I was asked to deliver a training workshop to users at a client on the Fixed Assets module. Prior to the session, I logged on and gave te module a quick run through of the areas I would be covering, to make sure that everything worked correctly. I encountered one error when trying to post a write-down; unfortunately I forgot to take a screenshot of the error as it happened, but the error… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Adjust Exchange Rates Easily, Replace the Built-in Batch Job
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The sixteenth of the new functionality in the Application section is Adjust exchange rates easily, replace the built-in batch job. When companies operate in multiple… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Include Only Open Entries on Customer Statements
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The fifteenth of the new functionality in the Application section is Include only open entries on customer statements. Businesses send customer statements to customers in… Continue Reading Ian Grieve’s...