New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Provide Queries for Users to do Ad Hoc Data Analysis Across Tables

Microsoft Dynamics 365 Business CentralThis 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 queries that end users and data analysts can use to analyze data directly in the client without the need to open the page in Excel or run a report.

Enabled for: Users by admins, makers, or analysts
Public Preview: Sep 2023
General Availability: Oct 2023

Feature Details

Analysis mode was introduced as a public preview feature in 2023 release wave 1 as a new way of interacting with data on list pages. Instead of running reports using different options and filters, users can simply add multiple tabs that represent different tasks or views on the data. For more information about the analysis mode on list pages, visit Analyze list data using data analysis mode.

In this release, Microsoft take this concept even further and make it possible to also analyze data from any query, the same way as you can on a list page. (Learn more at Analyze, group, and pivot data on queries using multiple tabs.)

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Provide Queries for Users to do Ad Hoc Data Analysis Across Tables”

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Use the AL Language Extension for Linux in Preview

Microsoft Dynamics 365 Business CentralThis 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 fits their needs as a platform for developing amazing Business Center extensions, Microsoft are releasing a preview of the AL Language extension for Linux with the Business Central 2023 release wave 2

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: Aug 2023
General Availability: Oct 2023

Feature Details

The AL Language extension for Microsoft Dynamics 365 Business Central now includes a Linux variant.

Just install the extension from https://marketplace.visualstudio.com/items?itemName=ms-dynamics-smb.al in your Visual Studio Code installation on Linux.

Since this is a preview, feedback is particularly welcome, as usual on https://github.com/microsoft/al/issues.

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2
Change Modification Limits for Triggering Flows and Bulk Updates
Support Business Events in Business Central Connector for Power Automate
Enable Specific Virtual Tables When You Connect to Dataverse
Get Control Over How to View Power BI Embedded Content
Availability Overview Helps You Calculate Quantities in Your Warehouse
Configure The Right Level of Handling For Different Warehouse Operations
Do financial Consolidations Across Environments in Multicompany Setups
Edit in Excel on Item Journals and Warehouse Worksheets
Get More Productive While Approving Time Sheets
Get More Productive While Entering Time Sheets
Include Approvals for Intercompany General Journals in Your Workflows
Make Intercompany Transactions Across Business Central Environments
Suggest the Next Step For Sales and Production Orders
Sync Document and Posting Dates for Sales and Purchases
Troubleshoot Shopify Integration Issues
Usability Improves for Warehouse, Inventory, and Tracking
Use Directed Pick and Put-away Suggestions in Basic Warehouse Configurations
Use General Ledger Allocations to Distribute Costs and Revenue More Efficiently
Complete Bank Account Reconciliation Faster With Copilot
Get Marketing Text Suggestions with Copilot
New Design for Report Language and Region Settings
Advance Payment and a Posting Preview of Tax Documents – Czechia
Direct Transfer – Czechia
E-submission of VAT Return in Denmark
Iceland Localization App – Delocalization
Intercompany Posting Cues to the Accountant Role Center – Czechia
New Intrastat – Czechia
Registration and Notification Functionality for Denmark
E-invoicing with NemHandel in Denmark
Supporting More Countries and Regions
Open Visual Studio Code From Web Client to Investigate or Troubleshoot Extensions
Turn Off Data Analysis Mode on Pages and Queries
Turn Off Indexes as a Partner
Use the Built-in Rich Text Editor to Enter Data
Assign More Granular Administration Rights
Improved Update Release Processes
Cancel Cloud Migration Replication Runs
Digital Vouchers
E-documents Core as a Global Solution
Large Companies to Report Payment Times
Modify Texts on the Welcome Banner and Skip Banner Intro State
Set Initial Role Before First Sign-in for a Better First-Run Experience
Enhancements to Excel Add-in
Analyze, Group, and Pivot Data on Queries Using Multiple Tabs
Discover Report and Data Analysis Content Easily
Get Power BI Reports for Reporting and Data Analysis on Finance, Sales, and Inventory
Data Loads Faster in the Server
Faster Application Scenarios
Pages Load Faster in Client
Performance Gain Reducing Locks in the Database
Add Existing Table Fields to Optimize Your Pages
Get to Data Search From Anywhere in Business Central
Distinguish Browser Tabs When Multitasking
Share Readable Deep Links to Pages and Records
Manage User Expectations with Selection Context-Based Actions
Peek at Summarized Data From Editable Fields
Search for Pages and Data in the Mobile App
Use Actions to Navigate or Fix Errors From Inline Validation Dialog
Updates to the Release Plan
Power Pages Support via Business Central Virtual Tables on Dataverse
Synchronize More Fields in Your Integration with Dataverse and Dynamics 365 Sales
Consolidated Power Automate Flow Creation from Business Central Templates
Get List of Companies Using Business Central Connector in Power Automate
Simplified Power Automate Approval Flow Experience
Create Power Automate Flows that Dynamically Support Different Companies
Business Central Virtual Tables Fully Supported on Microsoft Dataverse
Relate Native and Virtual Tables to Expose More Business Central Data in Dataverse
Include Only Open Entries on Customer Statements
Adjust Exchange Rates Easily, Replace the Built-in Batch Job
More Control Over General Journal Approvals
Use Different General Ledger Accounts for Payables, Receivables
Add More Columns to Pages for Better Insight
Availability Overview Helps You Calculate Quantities in Your Warehouse
Block Item Variants
Identify and Track Items Easier with Item References
Improved Processes for Inventory Counts and Adjustments
Navigate Easier Between Order, Receipt, and Invoice Documents
Print and Scan Barcodes
Receive More Items Than Ordered by Using Inventory Put-away Documents
Generate a Customer Statement Only With Open Entries
Responsibility Centers Are Supported for Advance Payments in Czechia
Easier Management of System Application Permissions
Get the AL Language Extension in Prerelease Versions on Visual Studio Code Marketplace
Find All References Now Works on Triggers, System Methods, and Trigger Events
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Hover Over Label Variable to See Text String Value
Set New Output Folder Setting for Storing App Files at AL Project Build
Choose Between More Sampling Intervals for Snapshot and In-client Profiling
Get IntelliSense for Adding Variables in Visual Studio Code AL Debugger Console
Get Smarter Method Signature Recommendations in IntelliSense
Set the Default Folder Location for New AL Projects
Track Source and Build Metadata on Extensions
Use SecretText Type to Protect Credentials and Sensitive Textual Values From Being Revealed
Document Your Extensions With the ALDoc Tool for Partners
Segment AL Code and Reduce Naming Conflicts with Namespaces
Show List of Keys While Working on AL Code
Use the AL Language Extension for Linux in Preview
Provide Queries for Users to do Ad Hoc Data Analysis Across Tables
Add a New FieldGroup to an Existing Table
Add Teaching Tooltips on Queries and Report Request Pages
Get Syntax Highlighting for AL in Azure DevOps
Sell Business Central Apps Through AppSource
AppSource ISV Publishers Can Preview Their AppSource Apps With Select Customers
Extend General Ledger Posting Aggregations
Define multi-worksheet datasets for Excel reports
Include or Exclude Tables From Cloud Migration
Delete Data from Uninstalled Extensions as an Admin
Automatically Update AppSource Apps With Minor Updates
Transfer Environments Between Microsoft Entra Tenants
Control Partner Access Per Environment
Use Drop Shipments for Triangular Intrastat Trade
Start Faster with Refreshed and Enhanced Setup Data
VAT Posting in General Ledger Setup
Demo Tool and Data for Service Scenarios
Analyze, Group, and Pivot Data on Lists
Share a Data Analysis With a Co-worker
Synchronize Multiple Business Central Companies With the Same Dataverse Environment
New Operational Limits on Scheduled Tasks and Web Requests Improve Throughput
Service-to-Service Apps and Device License Users Can Schedule Tasks
Mark Fields as Read-only When Customizing UI
Scan barcodes with Business Central mobile app for iOS and Android
Access Worksheet Pages From Mobile Phones
Use Virtual Tables to Expose More Business Central Data in Dataverse
Reverse a Customer and Vendor Ledger Entry with a Realized Gain or Loss Entry
Use General Ledger Account Revaluation for More Accurate Financial Statements
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Chat with Copilot
Improved Data Upgrade Troubleshooting for Dynamics GP Migration
Retain Permissions When Enabling Cloud Migration
Detect Invalid Cloud Migration Configurations with Proactive Warnings
Multiple VAT Numbers per Customer

In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Warehouse Receipts and Put-aways in Advanced Warehousing

Microsoft Dynamics 365 Business CentralThis 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 next level of warehousing moves out of the basic warehousing which we’ve seen so far, into advanced warehousing by combining receipts with put-aways.

The receipts are the same, but the put-aways are warehousing put-aways rather than the inventory ones we looked at in the earlier article.

This configuration of requiring receipts and put-aways is generally used by larger businesses who require more controls in the warehouse. While in the coming articles, I will just be showing the process using a location, it is commonly used in combination with the use of bins. The only difference between using bins and not, is that in the receipt and put-away process, bins will (generally based on setup) default and be changed if necessary.

In Microsoft Dynamics 365 Business Central, how do I…

In Microsoft Dynamics 365 Business Central, how do I…
In Microsoft Dynamics 365 Business Central, how do I… Sign Up For a Trial
In Microsoft Dynamics 365 Business Central, how do I… Get Access to the Microsoft 365 Admin Center
In Microsoft Dynamics 365 Business Central, how do I… Create a Company
In Microsoft Dynamics 365 Business Central, how do I… Copy a Company
In Microsoft Dynamics 365 Business Central, how do I… Switch Between Companies
In Microsoft Dynamics 365 Business Central, how do I… Create a Sandbox Environment With Cronus
In Microsoft Dynamics 365 Business Central, how do I… Access Dynamics BC Admin Centre
In Microsoft Dynamics 365 Business Central, how do I… Create a Sandbox Environment With a Copy of Production
In Microsoft Dynamics 365 Business Central, how do I… Create a User
In Microsoft Dynamics 365 Business Central, how do I… Add a User In 365 Admin Center
In Microsoft Dynamics 365 Business Central, how do I… Add a User in Dynamics BC
In Microsoft Dynamics 365 Business Central, how do I… Change My Role
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Role Center
In Microsoft Dynamics 365 Business Central, how do I… Create an Advanced Evaluation Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Update Rollout Timeline
In Microsoft Dynamics 365 Business Central, how do I… Change the User Experience in a Company from "Essentials" to "Premium"
In Microsoft Dynamics 365 Business Central (Administration), how do I… Set Update Date
In Microsoft Dynamics 365 Business Central, how do I… Hide the Teaching Tips
In Microsoft Dynamics 365 Business Central (Administration), how do I… Set Update Window
In Microsoft Dynamics 365 Business Central (Administration), how do I… Extend Trial
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Search
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Types of Pages Available
In Microsoft Dynamics 365 Business Central (Administration), how do I… Know Which Keyboard Shortcuts Are Available
In Microsoft Dynamics 365 Business Central (Administration), how do I… Switch Between Companies
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use List Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Advanced Filters on Lists
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Card Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the FactBox
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Action Bar
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Company Badges to Identify Companies or Environments
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Document Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Worksheet Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the On-premise Lifecycle Policy
In Microsoft Dynamics 365 Business Central (Administration), how do I… Start a Free Trial (Updated for the new "customised trial")
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create a Sandbox for a Preview Release
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand General Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Specific Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Tax Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create a Tax Business Posting Group
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create a Tax Product Posting Group
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create the Tax Posting Setup
In Microsoft Dynamics 365 Business Central (Administration), how do I… Add a Company Logo
In Microsoft Dynamics 365 Business Central (Administration), how do I… Share a Saved List View
In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename a Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename an Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete a Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete an Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore a Deleted Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore an Environment to a Point in Time
In Microsoft Dynamics 365 Business Central (Administration), how do I… Refresh an Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore a Deleted Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Approaches to Configuring a New Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… View Two Pages at the Same Time
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Maintain Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand What Data Can Be Deleted
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Master Data Management
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Relationships Between Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create Relationships Between Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Access Business Central
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Master Data Management
Using Extended Texts In Microsoft Dynamics 365 Business Central: What are Extended Texts?
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Personalize a Page
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Remove Personalization from a Page
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Personalize Card Pages
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Understand the Best Way of Customising a Card Page
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Personalize the FactBox
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Personalize the Action Bar
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Understand the Best Way of Personalizing the Action Bar
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Create Customizations for Other Users Using Profiles
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Copy Profile Personalizations to Another Environment
In Microsoft Dynamics 365 Business Central (Customization), how do I… Understand the Difference Between Personalization vs. Design
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand the Chart of Accounts
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand G/L Account Categories and Subcategories
In Microsoft Dynamics 365 Business Central (Financial), how do I… Maintain G/L Account Categories
In Microsoft Dynamics 365 Business Central (Financial), how do I… Create a G/L Account
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand the Types of G/L Account Available
In Microsoft Dynamics 365 Business Central (Financial), how do I… Indent Chart of Accounts
In Microsoft Dynamics 365 Business Central (Finance), how do I… Understand Dimensions
In Microsoft Dynamics 365 Business Central (Financial), how do I… Maintain Dimensions
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Global and Shortcut Dimensions
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Default Dimensions and Priorities
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Default Dimensions
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Dimension Restrictions
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Default Dimension Priorities
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Dimension Combinations
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Dimension Combination Blocks
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Dimension Combination Limits
In Microsoft Dynamics 365 Business Central (Financial), how do I… Remove Dimension Combination
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand General Journal Templates and Batches
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Dimension Sets
In Microsoft Dynamics 365 Business Central (Financial), how do I… Create a General Business Posting Group
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Accounting Periods and Fiscal Years
In Microsoft Dynamics 365 Business Central (Financial), how do I… Create a General Product Posting Groups
In Microsoft Dynamics 365 Business Central (Financial), how do I… Create a New Fiscal Year
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure the General Posting Setup
In Microsoft Dynamics 365 Business Central (Financial), how do I… Manually Create a New Fiscal Year
In Microsoft Dynamics 365 Business Central (Financial), how do I… Close a Period
In Microsoft Dynamics 365 Business Central (Financial), how do I… Allow a User to Post into a Closed Period
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand the Recommended Steps for Closing a Period
In Microsoft Dynamics 365 Business Central (Financial), how do I… Close a Fiscal Year
In Microsoft Dynamics 365 Business Central (Financial), how do I… Close the Income Statement
In Microsoft Dynamics 365 Business Central (Financial), how do I… Stop People Posting to a Closed Fiscal Year
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Why You Can Post to a Closed Year
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Locations
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Setup Inventory for Locations
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create an Inventory Location
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create an Inventory Posting Group
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create the Inventory Posting Setup
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand the Difference Between Inventory and Warehouse Management
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create a Warehouse User
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand the Different Levels of Inventory and Warehouse Management
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Basic Inventory
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Basic Inventory With Shelves
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Basic Inventory With Bins
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Enable Processing of Inventory Using Bins
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Add Bins to a Location
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Stock Using Bins
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create Bins in Bulk
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Bin Contents
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Set Default Bin for Items
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Inventory Put-aways in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Inventory Put-aways
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Put-away from the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Multiple Inventory Put-aways Using a Batch Job
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Put-away in Two Steps by Releasing the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Put-away Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Inventory Picks in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Inventory Picks
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick from the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Multiple Inventory Picks Using a Batch Job
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick in Two Steps by Releasing the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Receipts in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process a Receipt From the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Receipts
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post Receipt From a Warehouse Receipt Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Warehouse Receipts and Put-aways in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Receipts and Put-aways in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post a Receipt From a Warehouse Receipt Document and Post Put-away From a Warehouse Put-away Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand the Warehouse Put-away Worksheet in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Put-aways to Use the Put-away Worksheet in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create a Warehouse Put-away Worksheet Template
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Put-away Stock Using the Warehouse Put-away Worksheet
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Shipments in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process a Shipment from the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Shipments
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post Shipment From a Warehouse Shipment Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Warehouse Picks and Shipments in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Picks and Shipments in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post Pick From a Warehouse Pick Document and Post Shipment From a Warehouse Shipment Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Use the Pick Worksheet for Warehouse Picks
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Prevent Negative Stock Levels
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Consignment Stock at a Customer Location
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Consignment Stock in My Warehouse
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Stock On a Van
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Mass Insert Item Pictures
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Remove a Warehouse/Location from Use
Using Extended Texts In Microsoft Dynamics 365 Business Central: Add Extended Texts to Items
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Create a Vendor Posting Group
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Produce a Goods Received Not Invoiced Report
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Keep Invoiced Purchase Orders
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Understand Dates on Purchase Invoices
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Override VAT on a Purchase Invoice
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Assign Number Series in Purchasing
In Microsoft Dynamics 365 Business Central (Sales), how do I… Create a Customer Posting Group
In Microsoft Dynamics 365 Business Central (Sales), how do I… Produce a Goods Shipped Not Invoiced Report
In Microsoft Dynamics 365 Business Central (Sales), how do I… Keep Shipped Sales Orders
In Microsoft Dynamics 365 Business Central (Sales), how do I… Assign Number Series in Sales
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Understand For What Power Automate can be Used
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Types of Flows Are Available
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Actions Are Available with Power Automate
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Triggers Are Available with Power Automate
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Flow Templates Are Available from Microsoft
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create Environment Variables for the Environment and Company
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create a Flow For a Selected Record
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create a New Cloud Instant Flow
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for when a Business Event Occurs
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… An Alternative to Environment Variables
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for an Approval
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record on Create
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create a New Cloud Flow for Business Central From a Template
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record on Delete
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record on Modification
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record Change
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Understand Business Central Power Automate Actions
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get url V3" Action
In the "For a selected Record V3" Microsoft Dynamics 365 Business Central Trigger in Power Automate, the Record URL is Avalable Without Using "Get url V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Find records V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Find One record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Update Record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Create Record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Delete Record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "List Companies V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Run Action V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get Adaptive Card V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get an Image, File or Document V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Update an Image, File or Document V3" Action
In Microsoft Dynamics 365 Business Central (Development), how do I… How to Upload an Extension

In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I…

In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I…
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Locations
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Setup Inventory for Locations
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create an Inventory Location
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create an Inventory Posting Group
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create the Inventory Posting Setup
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand the Difference Between Inventory and Warehouse Management
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create a Warehouse User
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand the Different Levels of Inventory and Warehouse Management
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Basic Inventory
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Basic Inventory With Shelves
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Basic Inventory With Bins
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Enable Processing of Inventory Using Bins
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Add Bins to a Location
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Stock Using Bins
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create Bins in Bulk
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Bin Contents
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Set Default Bin for Items
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Inventory Put-aways in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Inventory Put-aways
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Put-away from the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Multiple Inventory Put-aways Using a Batch Job
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Put-away in Two Steps by Releasing the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Put-away Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Inventory Picks in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Inventory Picks
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick from the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Multiple Inventory Picks Using a Batch Job
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick in Two Steps by Releasing the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Receipts in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process a Receipt From the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Receipts
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post Receipt From a Warehouse Receipt Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Warehouse Receipts and Put-aways in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Receipts and Put-aways in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post a Receipt From a Warehouse Receipt Document and Post Put-away From a Warehouse Put-away Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand the Warehouse Put-away Worksheet in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Put-aways to Use the Put-away Worksheet in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create a Warehouse Put-away Worksheet Template
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Put-away Stock Using the Warehouse Put-away Worksheet
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Shipments in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process a Shipment from the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Shipments
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post Shipment From a Warehouse Shipment Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Warehouse Picks and Shipments in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Picks and Shipments in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post Pick From a Warehouse Pick Document and Post Shipment From a Warehouse Shipment Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Use the Pick Worksheet for Warehouse Picks
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Prevent Negative Stock Levels
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Consignment Stock at a Customer Location
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Consignment Stock in My Warehouse
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Stock On a Van
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Mass Insert Item Pictures
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Remove a Warehouse/Location from Use

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Show List of Keys While Working on AL Code

Microsoft Dynamics 365 Business CentralThis 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 request, Microsoft have now added support for suggesting available keys when calling methods accepting key parameter. This improves speed and accuracy of coding and thus productivity.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: Aug 2023
General Availability: Oct 2023

Feature Details

AL methods accepting keys, such as SetCurrentKey(), now have IntelliSense listing key parameters that are available. Until now it has only shown the list of fields.

Note that IntelliSense still suggests table fields, in case the developer wants to just perform sorting on specific fields. Keys are only suggested for the first parameter; subsequent parameters just suggest fields.

Example of IntelliSense showing available keys for SetCurrentKey() method

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2
Change Modification Limits for Triggering Flows and Bulk Updates
Support Business Events in Business Central Connector for Power Automate
Enable Specific Virtual Tables When You Connect to Dataverse
Get Control Over How to View Power BI Embedded Content
Availability Overview Helps You Calculate Quantities in Your Warehouse
Configure The Right Level of Handling For Different Warehouse Operations
Do financial Consolidations Across Environments in Multicompany Setups
Edit in Excel on Item Journals and Warehouse Worksheets
Get More Productive While Approving Time Sheets
Get More Productive While Entering Time Sheets
Include Approvals for Intercompany General Journals in Your Workflows
Make Intercompany Transactions Across Business Central Environments
Suggest the Next Step For Sales and Production Orders
Sync Document and Posting Dates for Sales and Purchases
Troubleshoot Shopify Integration Issues
Usability Improves for Warehouse, Inventory, and Tracking
Use Directed Pick and Put-away Suggestions in Basic Warehouse Configurations
Use General Ledger Allocations to Distribute Costs and Revenue More Efficiently
Complete Bank Account Reconciliation Faster With Copilot
Get Marketing Text Suggestions with Copilot
New Design for Report Language and Region Settings
Advance Payment and a Posting Preview of Tax Documents – Czechia
Direct Transfer – Czechia
E-submission of VAT Return in Denmark
Iceland Localization App – Delocalization
Intercompany Posting Cues to the Accountant Role Center – Czechia
New Intrastat – Czechia
Registration and Notification Functionality for Denmark
E-invoicing with NemHandel in Denmark
Supporting More Countries and Regions
Open Visual Studio Code From Web Client to Investigate or Troubleshoot Extensions
Turn Off Data Analysis Mode on Pages and Queries
Turn Off Indexes as a Partner
Use the Built-in Rich Text Editor to Enter Data
Assign More Granular Administration Rights
Improved Update Release Processes
Cancel Cloud Migration Replication Runs
Digital Vouchers
E-documents Core as a Global Solution
Large Companies to Report Payment Times
Modify Texts on the Welcome Banner and Skip Banner Intro State
Set Initial Role Before First Sign-in for a Better First-Run Experience
Enhancements to Excel Add-in
Analyze, Group, and Pivot Data on Queries Using Multiple Tabs
Discover Report and Data Analysis Content Easily
Get Power BI Reports for Reporting and Data Analysis on Finance, Sales, and Inventory
Data Loads Faster in the Server
Faster Application Scenarios
Pages Load Faster in Client
Performance Gain Reducing Locks in the Database
Add Existing Table Fields to Optimize Your Pages
Get to Data Search From Anywhere in Business Central
Distinguish Browser Tabs When Multitasking
Share Readable Deep Links to Pages and Records
Manage User Expectations with Selection Context-Based Actions
Peek at Summarized Data From Editable Fields
Search for Pages and Data in the Mobile App
Use Actions to Navigate or Fix Errors From Inline Validation Dialog
Updates to the Release Plan
Power Pages Support via Business Central Virtual Tables on Dataverse
Synchronize More Fields in Your Integration with Dataverse and Dynamics 365 Sales
Consolidated Power Automate Flow Creation from Business Central Templates
Get List of Companies Using Business Central Connector in Power Automate
Simplified Power Automate Approval Flow Experience
Create Power Automate Flows that Dynamically Support Different Companies
Business Central Virtual Tables Fully Supported on Microsoft Dataverse
Relate Native and Virtual Tables to Expose More Business Central Data in Dataverse
Include Only Open Entries on Customer Statements
Adjust Exchange Rates Easily, Replace the Built-in Batch Job
More Control Over General Journal Approvals
Use Different General Ledger Accounts for Payables, Receivables
Add More Columns to Pages for Better Insight
Availability Overview Helps You Calculate Quantities in Your Warehouse
Block Item Variants
Identify and Track Items Easier with Item References
Improved Processes for Inventory Counts and Adjustments
Navigate Easier Between Order, Receipt, and Invoice Documents
Print and Scan Barcodes
Receive More Items Than Ordered by Using Inventory Put-away Documents
Generate a Customer Statement Only With Open Entries
Responsibility Centers Are Supported for Advance Payments in Czechia
Easier Management of System Application Permissions
Get the AL Language Extension in Prerelease Versions on Visual Studio Code Marketplace
Find All References Now Works on Triggers, System Methods, and Trigger Events
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Hover Over Label Variable to See Text String Value
Set New Output Folder Setting for Storing App Files at AL Project Build
Choose Between More Sampling Intervals for Snapshot and In-client Profiling
Get IntelliSense for Adding Variables in Visual Studio Code AL Debugger Console
Get Smarter Method Signature Recommendations in IntelliSense
Set the Default Folder Location for New AL Projects
Track Source and Build Metadata on Extensions
Use SecretText Type to Protect Credentials and Sensitive Textual Values From Being Revealed
Document Your Extensions With the ALDoc Tool for Partners
Segment AL Code and Reduce Naming Conflicts with Namespaces
Show List of Keys While Working on AL Code
Use the AL Language Extension for Linux in Preview
Provide Queries for Users to do Ad Hoc Data Analysis Across Tables
Add a New FieldGroup to an Existing Table
Add Teaching Tooltips on Queries and Report Request Pages
Get Syntax Highlighting for AL in Azure DevOps
Sell Business Central Apps Through AppSource
AppSource ISV Publishers Can Preview Their AppSource Apps With Select Customers
Extend General Ledger Posting Aggregations
Define multi-worksheet datasets for Excel reports
Include or Exclude Tables From Cloud Migration
Delete Data from Uninstalled Extensions as an Admin
Automatically Update AppSource Apps With Minor Updates
Transfer Environments Between Microsoft Entra Tenants
Control Partner Access Per Environment
Use Drop Shipments for Triangular Intrastat Trade
Start Faster with Refreshed and Enhanced Setup Data
VAT Posting in General Ledger Setup
Demo Tool and Data for Service Scenarios
Analyze, Group, and Pivot Data on Lists
Share a Data Analysis With a Co-worker
Synchronize Multiple Business Central Companies With the Same Dataverse Environment
New Operational Limits on Scheduled Tasks and Web Requests Improve Throughput
Service-to-Service Apps and Device License Users Can Schedule Tasks
Mark Fields as Read-only When Customizing UI
Scan barcodes with Business Central mobile app for iOS and Android
Access Worksheet Pages From Mobile Phones
Use Virtual Tables to Expose More Business Central Data in Dataverse
Reverse a Customer and Vendor Ledger Entry with a Realized Gain or Loss Entry
Use General Ledger Account Revaluation for More Accurate Financial Statements
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Chat with Copilot
Improved Data Upgrade Troubleshooting for Dynamics GP Migration
Retain Permissions When Enabling Cloud Migration
Detect Invalid Cloud Migration Configurations with Proactive Warnings
Multiple VAT Numbers per Customer

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Segment AL Code and Reduce Naming Conflicts with Namespaces

Microsoft Dynamics 365 Business CentralThis 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 namespaces, similar to other code languages. Namespaces provide a way of organizing objects and code in a logical and hierarchical manner. They can be used to help avoid naming conflicts between different extensions, making it easier to maintain and understand extensions, including the relationship between different objects.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: Aug 2023
General Availability: Oct 2023

Feature Details

An AL file can now define a namespace at the top, which will apply to all objects in the code file. A given object can only belong to one namespace, but the same namespace can be used for multiple AL files and objects.

When objects are resolved, the closest scope is used first. Therefore, to resolve to a similarly named object in a dependent extension, the reference must use a fully qualified name. Alternatively, it’s possible to define using directives to include external namespaces and thereby omit fully qualifying names.

Because namespaces are useful for logical segmentation of extensions, the AL Explorer also shows namespaces for objects and allows grouping objects by namespace, making it easier to discover related objects, focus on app subareas, and identify inconsistencies when adding new objects.

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Segment AL Code and Reduce Naming Conflicts with Namespaces”

How To Install Microsoft SQL Server 2022: SSIS Configuration For Named Instances

Microsoft SQL ServerThis 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 installation of SQL Server Integration Services (SSIS); however, if, like me, you are using a named instance of SQL server, the standard installation of SSIS does not result in a working instance of SSIS.

There is a setting which needs to be changed in a configuration file to point SSIS at the working instance of the SQL Server Database Engine.

The file to change is C:\Program Files\Microsoft SQL Server\160\DTS\Binn\MsDtsSrvr.ini where you need to change the ServerName node to include the name of the SQL instance.

MsDtsSrvr.ini

In the, above, example, I have added \Development for the named instance I am using.

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Document Your Extensions With the ALDoc Tool for Partners

Microsoft Dynamics 365 Business CentralThis 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 continuously growing number of ISV apps on AppSource, some of which are being built upon, both by apps from the same publisher, other publishers and resellers (in the form of per-tenant extensions). To aid consuming apps downstream, documentation is a major benefit, but until now it has been a large manual process to create and keep that in sync with app changes, unless the publisher has invested in automation themselves.

Based on the recent investments for generated documentation for the Business Central base, system, and other first-party applications, Microsoft are giving publishers a new ALDoc tool. This allows generating documentation from symbolic and syntactical information, code comments, and overall application structure based on input .app files. Publishers can host the resulting documentation either internally—for example, for R&D usage—or externally for downstream partners.

Generating content based on source code has many advantages such as accuracy, 100 percent reflection of the current codebase, less error-prone documentation, and time savings.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: Aug 2023
General Availability: Oct 2023

Feature Details

It’s Microsoft’s pleasure to announce that with the latest prerelease update of the AL Language extension for Microsoft Dynamics 365 Business Central, Microsoft have included a preview of the ALDoc tool for partners.

The ALDoc tool generates documentation from symbolic and syntactical information, code comments, and overall application structure based on input .app files. You can use it to generate internally or externally facing reference documentation for your solution.

The tool also generates a help site with the reference articles, sorted by the application structure, based on the provided custom template.

Read more about the tool in their docs Generating help with the ALDoc tool.

Also, as usual, Microsoft want to hear what you think. Use AL issues for tool feedback.

Example of ALDoc generated help

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2
Change Modification Limits for Triggering Flows and Bulk Updates
Support Business Events in Business Central Connector for Power Automate
Enable Specific Virtual Tables When You Connect to Dataverse
Get Control Over How to View Power BI Embedded Content
Availability Overview Helps You Calculate Quantities in Your Warehouse
Configure The Right Level of Handling For Different Warehouse Operations
Do financial Consolidations Across Environments in Multicompany Setups
Edit in Excel on Item Journals and Warehouse Worksheets
Get More Productive While Approving Time Sheets
Get More Productive While Entering Time Sheets
Include Approvals for Intercompany General Journals in Your Workflows
Make Intercompany Transactions Across Business Central Environments
Suggest the Next Step For Sales and Production Orders
Sync Document and Posting Dates for Sales and Purchases
Troubleshoot Shopify Integration Issues
Usability Improves for Warehouse, Inventory, and Tracking
Use Directed Pick and Put-away Suggestions in Basic Warehouse Configurations
Use General Ledger Allocations to Distribute Costs and Revenue More Efficiently
Complete Bank Account Reconciliation Faster With Copilot
Get Marketing Text Suggestions with Copilot
New Design for Report Language and Region Settings
Advance Payment and a Posting Preview of Tax Documents – Czechia
Direct Transfer – Czechia
E-submission of VAT Return in Denmark
Iceland Localization App – Delocalization
Intercompany Posting Cues to the Accountant Role Center – Czechia
New Intrastat – Czechia
Registration and Notification Functionality for Denmark
E-invoicing with NemHandel in Denmark
Supporting More Countries and Regions
Open Visual Studio Code From Web Client to Investigate or Troubleshoot Extensions
Turn Off Data Analysis Mode on Pages and Queries
Turn Off Indexes as a Partner
Use the Built-in Rich Text Editor to Enter Data
Assign More Granular Administration Rights
Improved Update Release Processes
Cancel Cloud Migration Replication Runs
Digital Vouchers
E-documents Core as a Global Solution
Large Companies to Report Payment Times
Modify Texts on the Welcome Banner and Skip Banner Intro State
Set Initial Role Before First Sign-in for a Better First-Run Experience
Enhancements to Excel Add-in
Analyze, Group, and Pivot Data on Queries Using Multiple Tabs
Discover Report and Data Analysis Content Easily
Get Power BI Reports for Reporting and Data Analysis on Finance, Sales, and Inventory
Data Loads Faster in the Server
Faster Application Scenarios
Pages Load Faster in Client
Performance Gain Reducing Locks in the Database
Add Existing Table Fields to Optimize Your Pages
Get to Data Search From Anywhere in Business Central
Distinguish Browser Tabs When Multitasking
Share Readable Deep Links to Pages and Records
Manage User Expectations with Selection Context-Based Actions
Peek at Summarized Data From Editable Fields
Search for Pages and Data in the Mobile App
Use Actions to Navigate or Fix Errors From Inline Validation Dialog
Updates to the Release Plan
Power Pages Support via Business Central Virtual Tables on Dataverse
Synchronize More Fields in Your Integration with Dataverse and Dynamics 365 Sales
Consolidated Power Automate Flow Creation from Business Central Templates
Get List of Companies Using Business Central Connector in Power Automate
Simplified Power Automate Approval Flow Experience
Create Power Automate Flows that Dynamically Support Different Companies
Business Central Virtual Tables Fully Supported on Microsoft Dataverse
Relate Native and Virtual Tables to Expose More Business Central Data in Dataverse
Include Only Open Entries on Customer Statements
Adjust Exchange Rates Easily, Replace the Built-in Batch Job
More Control Over General Journal Approvals
Use Different General Ledger Accounts for Payables, Receivables
Add More Columns to Pages for Better Insight
Availability Overview Helps You Calculate Quantities in Your Warehouse
Block Item Variants
Identify and Track Items Easier with Item References
Improved Processes for Inventory Counts and Adjustments
Navigate Easier Between Order, Receipt, and Invoice Documents
Print and Scan Barcodes
Receive More Items Than Ordered by Using Inventory Put-away Documents
Generate a Customer Statement Only With Open Entries
Responsibility Centers Are Supported for Advance Payments in Czechia
Easier Management of System Application Permissions
Get the AL Language Extension in Prerelease Versions on Visual Studio Code Marketplace
Find All References Now Works on Triggers, System Methods, and Trigger Events
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Hover Over Label Variable to See Text String Value
Set New Output Folder Setting for Storing App Files at AL Project Build
Choose Between More Sampling Intervals for Snapshot and In-client Profiling
Get IntelliSense for Adding Variables in Visual Studio Code AL Debugger Console
Get Smarter Method Signature Recommendations in IntelliSense
Set the Default Folder Location for New AL Projects
Track Source and Build Metadata on Extensions
Use SecretText Type to Protect Credentials and Sensitive Textual Values From Being Revealed
Document Your Extensions With the ALDoc Tool for Partners
Segment AL Code and Reduce Naming Conflicts with Namespaces
Show List of Keys While Working on AL Code
Use the AL Language Extension for Linux in Preview
Provide Queries for Users to do Ad Hoc Data Analysis Across Tables
Add a New FieldGroup to an Existing Table
Add Teaching Tooltips on Queries and Report Request Pages
Get Syntax Highlighting for AL in Azure DevOps
Sell Business Central Apps Through AppSource
AppSource ISV Publishers Can Preview Their AppSource Apps With Select Customers
Extend General Ledger Posting Aggregations
Define multi-worksheet datasets for Excel reports
Include or Exclude Tables From Cloud Migration
Delete Data from Uninstalled Extensions as an Admin
Automatically Update AppSource Apps With Minor Updates
Transfer Environments Between Microsoft Entra Tenants
Control Partner Access Per Environment
Use Drop Shipments for Triangular Intrastat Trade
Start Faster with Refreshed and Enhanced Setup Data
VAT Posting in General Ledger Setup
Demo Tool and Data for Service Scenarios
Analyze, Group, and Pivot Data on Lists
Share a Data Analysis With a Co-worker
Synchronize Multiple Business Central Companies With the Same Dataverse Environment
New Operational Limits on Scheduled Tasks and Web Requests Improve Throughput
Service-to-Service Apps and Device License Users Can Schedule Tasks
Mark Fields as Read-only When Customizing UI
Scan barcodes with Business Central mobile app for iOS and Android
Access Worksheet Pages From Mobile Phones
Use Virtual Tables to Expose More Business Central Data in Dataverse
Reverse a Customer and Vendor Ledger Entry with a Realized Gain or Loss Entry
Use General Ledger Account Revaluation for More Accurate Financial Statements
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Chat with Copilot
Improved Data Upgrade Troubleshooting for Dynamics GP Migration
Retain Permissions When Enabling Cloud Migration
Detect Invalid Cloud Migration Configurations with Proactive Warnings
Multiple VAT Numbers per Customer

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Use SecretText Type to Protect Credentials and Sensitive Textual Values From Being Revealed

Microsoft Dynamics 365 Business CentralThis 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 increasing amount of integrations to external systems, it’s not uncommon in AL code to work with secrets such as credentials and other sensitive textual values. Given the need to protect these from being revealed through debugging, the latter has often been blocked through resource exposure policies, at the cost of easy troubleshooting. To support enabling debugging, while protecting credentials and other sensitive textual values from being revealed, Microsoft are introducing a new SecretText type for variables. In addition, some of the common scenarios in the system app will get support for passing in SecretText parameters for credentials—for example, the HttpClient and Isolated Storage types.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: Aug 2023
General Availability: Oct 2023

Feature Details

A new type, SecretText, has been added to protect credentials and other sensitive textual values from being revealed through debugging. The declaration syntax will be similar to the Text data type, with the sole difference that it won’t support constraints on the length.

SecretText will be usable as a:

  • Variable value
  • Return value
  • Parameter value

Its use will be limited to carrying, for example, credentials from the point of creation to the destination method. The destination method must accept a SecretText value.

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Use SecretText Type to Protect Credentials and Sensitive Textual Values From Being Revealed”

Warehouse Receipt Preview Posting Error in Warehouse Receipt in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business CentralWhen 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 error:

Error when preview posting a warehouse receipt which includes two or more orders

The record in table Purch. Rcpt. Header already exists. Identification fields and values: No.='***'

I was able to replicate this error with any warehouse receipt containing two or more receipts. I spent a while investigating before realising that the issue was only with the posting preview; if I actually tried to post the receipt then the posting was successful.

I discussed this with a couple of colleagues and we all agree that it is odd, but it appears to be a designed behaviour. The *** in quotes doesn’t show anywhere on the receipt, it just seems to be a set of characters which it uses as a placeholder and which causes the error.

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Track Source and Build Metadata on Extensions

Microsoft Dynamics 365 Business CentralThis 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 DevOps pipelines, Microsoft are introducing Source and Build properties in the app.json manifest of extensions. This allows easily finding the relevant source repo, commit ID, and build system used to create the extension.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: Aug 2023
General Availability: Oct 2023

Feature Details

The app.json manifest of extensions now contains two new properties, Source and Build. These can be used to track source location and the build context.

For source, the following are supported:

  • repositoryUrl, which is the URL of the repository where the source code of the project can be found.
  • commit, which is an ID of the source code for the current version of the project, that allows getting back to the commit that triggered building the extension.

For build, the following are supported:

  • by, which is useful for tracking the build agent/system that orchestrated the build; for example, AL-Go for GitHub.
  • url, which can be used for the URL to the build system invocation where the build can be found.

You can define these values directly in the app.json, but given the dynamic nature, the usual scenario would be to set these as part of build pipelines via command line parameters for the used alc.exe compiler executable. The values passed here will overwrite any values in the app.json source file.

If using BcContainerHelper, the functions Compile-AppInBcContainer and Compile-AppWithCompilerFolder now take parameters for "SourceRepositoryUrl", "SourceCommit", "BuildBy", and "BuildUrl". These are now being set if you use AL:Go for GitHub to build your extensions.

In this release none of these values are yet surfacing in the Extension Management page, in TAC, or via PowerShell commands like NAV-AppInfo. If you want to read the values, the option is currently to use the BcContainerHelper "Extract-AppFileToFolder", which will allow getting the app.json file with the settings.

Here’s an example of build and source metadata in app.json. This is normally set by the build process and not manually.

Example of build and source metadata in app.json

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2
Change Modification Limits for Triggering Flows and Bulk Updates
Support Business Events in Business Central Connector for Power Automate
Enable Specific Virtual Tables When You Connect to Dataverse
Get Control Over How to View Power BI Embedded Content
Availability Overview Helps You Calculate Quantities in Your Warehouse
Configure The Right Level of Handling For Different Warehouse Operations
Do financial Consolidations Across Environments in Multicompany Setups
Edit in Excel on Item Journals and Warehouse Worksheets
Get More Productive While Approving Time Sheets
Get More Productive While Entering Time Sheets
Include Approvals for Intercompany General Journals in Your Workflows
Make Intercompany Transactions Across Business Central Environments
Suggest the Next Step For Sales and Production Orders
Sync Document and Posting Dates for Sales and Purchases
Troubleshoot Shopify Integration Issues
Usability Improves for Warehouse, Inventory, and Tracking
Use Directed Pick and Put-away Suggestions in Basic Warehouse Configurations
Use General Ledger Allocations to Distribute Costs and Revenue More Efficiently
Complete Bank Account Reconciliation Faster With Copilot
Get Marketing Text Suggestions with Copilot
New Design for Report Language and Region Settings
Advance Payment and a Posting Preview of Tax Documents – Czechia
Direct Transfer – Czechia
E-submission of VAT Return in Denmark
Iceland Localization App – Delocalization
Intercompany Posting Cues to the Accountant Role Center – Czechia
New Intrastat – Czechia
Registration and Notification Functionality for Denmark
E-invoicing with NemHandel in Denmark
Supporting More Countries and Regions
Open Visual Studio Code From Web Client to Investigate or Troubleshoot Extensions
Turn Off Data Analysis Mode on Pages and Queries
Turn Off Indexes as a Partner
Use the Built-in Rich Text Editor to Enter Data
Assign More Granular Administration Rights
Improved Update Release Processes
Cancel Cloud Migration Replication Runs
Digital Vouchers
E-documents Core as a Global Solution
Large Companies to Report Payment Times
Modify Texts on the Welcome Banner and Skip Banner Intro State
Set Initial Role Before First Sign-in for a Better First-Run Experience
Enhancements to Excel Add-in
Analyze, Group, and Pivot Data on Queries Using Multiple Tabs
Discover Report and Data Analysis Content Easily
Get Power BI Reports for Reporting and Data Analysis on Finance, Sales, and Inventory
Data Loads Faster in the Server
Faster Application Scenarios
Pages Load Faster in Client
Performance Gain Reducing Locks in the Database
Add Existing Table Fields to Optimize Your Pages
Get to Data Search From Anywhere in Business Central
Distinguish Browser Tabs When Multitasking
Share Readable Deep Links to Pages and Records
Manage User Expectations with Selection Context-Based Actions
Peek at Summarized Data From Editable Fields
Search for Pages and Data in the Mobile App
Use Actions to Navigate or Fix Errors From Inline Validation Dialog
Updates to the Release Plan
Power Pages Support via Business Central Virtual Tables on Dataverse
Synchronize More Fields in Your Integration with Dataverse and Dynamics 365 Sales
Consolidated Power Automate Flow Creation from Business Central Templates
Get List of Companies Using Business Central Connector in Power Automate
Simplified Power Automate Approval Flow Experience
Create Power Automate Flows that Dynamically Support Different Companies
Business Central Virtual Tables Fully Supported on Microsoft Dataverse
Relate Native and Virtual Tables to Expose More Business Central Data in Dataverse
Include Only Open Entries on Customer Statements
Adjust Exchange Rates Easily, Replace the Built-in Batch Job
More Control Over General Journal Approvals
Use Different General Ledger Accounts for Payables, Receivables
Add More Columns to Pages for Better Insight
Availability Overview Helps You Calculate Quantities in Your Warehouse
Block Item Variants
Identify and Track Items Easier with Item References
Improved Processes for Inventory Counts and Adjustments
Navigate Easier Between Order, Receipt, and Invoice Documents
Print and Scan Barcodes
Receive More Items Than Ordered by Using Inventory Put-away Documents
Generate a Customer Statement Only With Open Entries
Responsibility Centers Are Supported for Advance Payments in Czechia
Easier Management of System Application Permissions
Get the AL Language Extension in Prerelease Versions on Visual Studio Code Marketplace
Find All References Now Works on Triggers, System Methods, and Trigger Events
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Hover Over Label Variable to See Text String Value
Set New Output Folder Setting for Storing App Files at AL Project Build
Choose Between More Sampling Intervals for Snapshot and In-client Profiling
Get IntelliSense for Adding Variables in Visual Studio Code AL Debugger Console
Get Smarter Method Signature Recommendations in IntelliSense
Set the Default Folder Location for New AL Projects
Track Source and Build Metadata on Extensions
Use SecretText Type to Protect Credentials and Sensitive Textual Values From Being Revealed
Document Your Extensions With the ALDoc Tool for Partners
Segment AL Code and Reduce Naming Conflicts with Namespaces
Show List of Keys While Working on AL Code
Use the AL Language Extension for Linux in Preview
Provide Queries for Users to do Ad Hoc Data Analysis Across Tables
Add a New FieldGroup to an Existing Table
Add Teaching Tooltips on Queries and Report Request Pages
Get Syntax Highlighting for AL in Azure DevOps
Sell Business Central Apps Through AppSource
AppSource ISV Publishers Can Preview Their AppSource Apps With Select Customers
Extend General Ledger Posting Aggregations
Define multi-worksheet datasets for Excel reports
Include or Exclude Tables From Cloud Migration
Delete Data from Uninstalled Extensions as an Admin
Automatically Update AppSource Apps With Minor Updates
Transfer Environments Between Microsoft Entra Tenants
Control Partner Access Per Environment
Use Drop Shipments for Triangular Intrastat Trade
Start Faster with Refreshed and Enhanced Setup Data
VAT Posting in General Ledger Setup
Demo Tool and Data for Service Scenarios
Analyze, Group, and Pivot Data on Lists
Share a Data Analysis With a Co-worker
Synchronize Multiple Business Central Companies With the Same Dataverse Environment
New Operational Limits on Scheduled Tasks and Web Requests Improve Throughput
Service-to-Service Apps and Device License Users Can Schedule Tasks
Mark Fields as Read-only When Customizing UI
Scan barcodes with Business Central mobile app for iOS and Android
Access Worksheet Pages From Mobile Phones
Use Virtual Tables to Expose More Business Central Data in Dataverse
Reverse a Customer and Vendor Ledger Entry with a Realized Gain or Loss Entry
Use General Ledger Account Revaluation for More Accurate Financial Statements
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Chat with Copilot
Improved Data Upgrade Troubleshooting for Dynamics GP Migration
Retain Permissions When Enabling Cloud Migration
Detect Invalid Cloud Migration Configurations with Proactive Warnings
Multiple VAT Numbers per Customer