MADIC dynamics Knowledge Hub Webinars: Reporting with Business Central

MADIC dynamicsIn our most recent webinar here at MADIC dynamics, we took a look at Reporting with Business Central.

If you want to catch up on this webinar, you can do so here.

  1. Introduction
  2. List Pages
  3. Standard Reports
  4. Financial Accounting
  5. Jet Reports
  6. Jet Analytics
  7. Power BI
  8. 3rd Party BI
  9. Conclusion

Introduction ^

In this webinar we took an introductory look at the reporting tools which come with Microsoft Dynamics 365 Business Central as standard, such as list pages, standard reports and financial reporting, as well as then taking a look at the commonly used third-party reporting tools which include Jet Reports and Power BI.

Continue reading “MADIC dynamics Knowledge Hub Webinars: Reporting with Business Central”

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Handle Multiple File Uploads and File Drop Zones

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 1.

The 1st of the new functionality in the Development section is handle multiple file uploads and file drop zones.

The ability for AL developers to handle multiple file uploads and designate different page parts as file drop zones in Business Central provides greater flexibility and usability. This enhancement benefits developers working on applications or customizations that require multifile upload functionality and adds value to organizations by improving productivity and the user experience.

Enabled for: Users, automatically
Public Preview: Mar 2024
General Availability: Apr 2024

Feature Details

Developers can handle multiple file uploads and designate different page parts as file drop zones.

This improvement empowers AL developers to create more flexible and user-friendly interfaces within Business Central. Designating specific page parts as file drop zones lets people upload multiple files at the same time, which improves efficiency.

This feature is particularly valuable for developers working on applications or customizations that require users to upload multiple files simultaneously. By allowing users to drag and drop files onto designated page parts, developers can streamline the file upload process and simplify data entry.

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Handle Multiple File Uploads and File Drop Zones”

MADIC dynamics Knowledge Hub Webinars: Series Index

MADIC dynamicsAt MADIC dynamics we have started running a series of Knowledge Hub Webinarswebinars on Microsoft Dynamics 365 Business Central and related products. I will be trying to follow up each webinar with a writeup of the topics covered, linking to the webinar recording.

I’ve decided to add these webinars into a series so that they are easy for people to find details of the previous webinars, when they’re reading about the most recent.

Continue reading “MADIC dynamics Knowledge Hub Webinars: Series Index”

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Install UK Localization as an App

error Important

The planned-features for this release wave have been updated and this feature appears to have been removed.

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 1.

The 3rd of the new functionality in the Country and regional section is install UK localization as an app.

The new and upgraded localized version for the United Kingdom is delivered as an extension.

By removing country-based customizations in the base app, delocalization can help organizations save time and money during implementation. This can be especially beneficial for organizations that operate in multiple countries or regions with different regulatory requirements because they can easily build PTEs and connect those environments. Delocalization can also help organizations get ISV solutions without limitations.

Enabled for: Users, automatically
Public Preview: –
General Availability: Aug 2024

Feature Details

The localized version for the UK is now delivered as a set of extensions on top of the W1 base app. The solution offers a data upgrade, making it easy to move from the previous localization to the new extension. This release is a step toward full delocalization so that ISVs can release their apps to a broader market.

My Opinion

This sounds, on the surface, like it might be a positive, but also that there could be a lot of extra overhead and complexity. I worry about the phrase “set of extensions”.

Click to show/hide the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 Series Index

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1
Use Virtual Tables to Expose More Business Central Data in Dataverse
Improve Approval Processes via Power Automate
Add Table and Field Mappings for Existing Integration Tables
Find a Matching Record in a Power Automate Flow
Archive Projects
Usability Improves for Service and Projects
Use Deferral Codes in Purchase and Sales Journals
Define a Service Invoice Posting Policy for Various Users
Define Default Location for Project or Project Phase
Block Item, Item Variant or Service Item from Use in Service Management transactions
Connect Business Central With Shopify B2B
Set Up Financial Consolidation Runs More Efficiently
Simpler Shopify Connection
Use General Ledger Account Revaluation for More Accurate Financial Statements
Get More Productive While Entering Time Sheets
Create Projects That You Can Invoice to Multiple Customers
Assemble to Project
Invoice a Customer for Multiple Projects
Use New Excel Layouts for 35 Selected Reports
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Manage Work Orders in Field Service, Invoice Them in Business Central
Manage Document Attachments in Service Items and Documents
Export and Import Multiline Text Using Configuration Packages
Correct Errors in Service Invoices
Prevent Editing Number Series on Service Documents and Cards
Be More Productive When Approving Time Sheets
Inventory Package Numbers Work Like Item Tracking Dimensions
Assign Salesperson to Customer Ship-to Addresses
View Incoming Documents in Archived Quotes and Orders
Specify Dimensions on Posted Entries Applications With Realized Gains or Losses
Allow Lines with Amounts of Zero on Recurring General Journals
Automate the Reminders Process in Collections
See Improved Usability for Warehouse and Inventory
Ensure Accurate Inventory Valuation by Controlling Cost Adjustment
Use a New Role Center for Collection Management
Manage Subscription Billing and Revenue and Expense Recognition
Enable Sustainability Features for Integrations with APIs
Install Field Service Integration with Business Central from AppSource
Introduce Power Automate Copilot Integration with Business Central
Map e-Documents to Purchase Order Lines with Copilot
Create Sales Lines Easily with Copilot
Extend Copilot Using Richer Development Tools
Get to Insights Faster with Copilot-Generated Analysis Tabs
Complete Bank Account Reconciliation Faster With Copilot
Create Product Information Faster with Copilot
Learn More About Fields with Copilot
Chat with Copilot
Simplify collections with Copilot for Finance and Business Central
Automate Tests for your Copilot Extensions with the Business Central Test Toolkit
Automate IRS 1099 Form Submission in US
Enable Additional Countries and Regions
Install UK Localization as an App
Process Czech Bank Statements, Payment Orders More Productively
Improvement of Czech Localization Reports
Report Explorer has Additional Outputs in the Czech Version
Improved Updates of ARES Data in the Czech Version
Allow More Extendability of Advance Payments in the Czech Version
Print QR Codes on Sales Invoices in the Czech Version
Use Excel Layouts for Czech Reports
Handle Multiple File Uploads and File Drop Zones
Debug the System Application
Remove Friction When Working with External App Dependencies
Use In-client Page Scripting Tool for Acceptance Testing
Use AL-controlled Barcode Scanning For All Scenarios
Write flexible and performant code with NumberSequences
Use the OData V4 IN Operator in Web Service Queries
Define Extension Objects in Same App as Their Base Object
Use Cookies in HTTP Calls From Business Central
Define Tooltips on Table Fields
Use Linked Environment in Dataverse Integration
Audit Business Central Operations in Microsoft Purview
Encrypt Data At-Rest with Customer-Managed Encryption Key
Allow Customers to Consent to Microsoft Support Accessing Their Data
Link Business Central Environments to Power Platform Environments
Copy Companies with Dataverse Integration Safely
View and Filter Users With Additional User Details
Control partner access per environment
Analyze Telemetry Events Across Browser and Server for a Session or User
Use Premium License to Sign In to Environment with Essentials Licenses
Experience the New Embedded AppSource Marketplace Page
Migrate Record Links and Notes with Cloud Migration Tooling
See VAT Date in Posting Previews
Automate Country of Origin Listed for Item Tracking Code in Intrastat Reporting
Achieve Sustainable Compliance with Business Central
Discover Report and Data Analysis Content Easily
Use Drag and Drop to Attach Multiple Files
Use Actions to Navigate and Highlight or Fix Platform-Generated Errors
Share Error Details to Get Help from Another User
Access Worksheet Pages from Mobile Phones
Boost Productivity With the Modern Action Bar
Enhancements to the User Experience

Document Number on Payment Journal Not Incrementing in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business CentralI had a moment during a client training session recently where I was showing them through the payment journal for doing a purchase ledger payment run and ran into a problem with the process whereby all of the lines were getting the same document number assigned. Obviously this is bad, as each vendor payment requires a unique document number.

It took me a couple of minutes to realise that when I’d talked them through the Suggest Vendor Payments function, I had missed the last field. This field is New Doc. No.per Line and needs to be toggled on for each payment line to receive a unique document number:

Suggest Vendor Payments page New Doc No. per Line option not marked

I don’t know why this is an option is off by default on a new system, as you will always want every line to have a unique number, but at least it will be remembered for future payments runs which are processed. Once the option was toggled on and the suggest function complete, all of the payment lines had a unique number and the payment run could be completed.