Updated: May 4, 2022
This article covers multiple new features and it is sorted by MODULE. Included here is everything from system-wide features that are not specific to a certain area of the ERP System to General Ledger, Banking, Accounts Receivable, Accounts Payable, Inventory, Sales Order Processing, Job Costing, and Manufacturing specific features. Please keep scrolling down for more info...
For help with your Business Central system, please e-mail us at Sales@CBRTechnology.com or call Tel. 855-227-0700.
Version 20 New Features - Released April-May 2022
System-Wide New Features
Multiple Shopify shops connected to the same Business Central
Each shop has its own setup, including a collection of products, locations used to calculate inventory, and prices lists.
Bi-directional synchronization of items/products
Sync images, item variants, barcodes, vendor item numbers, extended texts, and tags.
Export item attributes to Shopify.
Use selected customer price groups and discounts to define prices exported to Shopify.
Decide whether items can be created automatically or to only allow updates to existing products.
Synchronization of inventory levels
Choose some or all of the available locations in Business Central.
Update inventory levels on multiple locations in Shopify.
Bi-directional synchronization of customers
Smart-map customers by phone and email.
Use country-specific templates when creating customers, which helps ensure that tax settings are correct.
Import of Orders from Shopify
Create customers on-the-fly, or use fixed retail customer to keep customer data in Shopify.
Include orders created in other channels, such as Shopify POS or Amazon.
Shipping costs, gift cards, tips, shipping and payment methods, transactions, and risk of fraud.
Receive payout information from Shopify Payments.
Send fulfillment information to Shopify
Include item tracking information.
Log emails using a shared mailbox and Graph API
After setting up a shared mailbox and mail flow rules in Exchange Online and enabling Feature Update: Email logging using the Microsoft Graph API, you can go to the Assisted Setup page and start the Set up email logging guide to setup email logging in Business Central using a shared mailbox and Graph APIs. There are three simple steps in the guide:
Confirm you've set up a shared mailbox and mail flow rules for email logging.
Enter the shared mailbox to use for email logging and validate the connection.
Finish the guide and start logging email interactions between your salespeople and your contacts.
Alternatively, you can use Email Logging page to review and validate your setup and view email logging activities.
Map to Dataverse option sets such as payment terms, freight terms, and shipping agents without code
You can manually map payment terms, freight terms, shipping methods, and shipping agents between Business Central and Microsoft Dataverse.
If you enable the Feature Update: Map to option sets in Dataverse without code feature in Feature Management in Business Central, you will no longer need to do code customizations to synchronize payment terms, shipment methods, and freight terms. The feature update will add integration table mappings for payment terms (PAYMENT TERMS), shipment methods (SHIPMENT METHOD), and shipping agents (SHIPPING AGENT).
Because payment terms, shipment methods, and shipping agents are handled as standard integration table mappings, you can view which payment terms, shipment methods, and shipping agents are coupled using the Coupled in Dataverse column.
You can synchronize payment terms, shipment methods, and shipping agents data by using the Synchronize action, set up or delete coupling by choosing the Coupling, Set up coupling or Delete coupling actions, or do a match-based coupling by choosing the Match-Based Coupling action.
Outlook add-in – add email attachments to Business Central records
The Outlook add-in now offers the option to copy email attachments to the record displayed in the add-in. For example, the add-in will automatically display the contact record that matches the current email sender, from which you can navigate to that customer's latest sales order. Once you have identified the order that the email relates to, the attachments feature can be used to copy files from the current email to that order.
Review and choose some or all of the email attachments to add to the record.
After attaching a file, coworkers can instantly download and view the file from the Attachments FactBox in any of their Business Central clients. Or, they can open the file in OneDrive to share and collaborate with their department.
The feature is available for any records that use the Attachments FactBox, such as a vendor, customer, purchase invoice, or sales order.
Alternatively, purchase invoices can be sent to the incoming documents feature for processing.
Share a file through Microsoft OneDrive - Sharepoint
To share a report from the Report Inbox or to share an attachment to a record, you can now choose the Share action. This action copies the file from Business Central to OneDrive for Business, then displays the file sharing dialog in Business Central with numerous options. At launch, these options include:
Sharing a link to the document with one or more internal or external recipients.
Copying a link to the document, so that you can send it using your preferred application.
Adjusting whether recipients can view or edit the document.
Preventing download of the file.
Specifying the people who can use the link, such as only people in your organization with the link.
Setup Printers for Web Browser, Teams App, and Mobile App
To support your print needs, Business Central offers the following features:
Web client: Mobile appApp for TeamsUniversal PrintUniversal Print is a printer management solution available as a cloud service from Microsoft. With this feature, you can set up your printers in Universal Print, then register them for use in Business Central. This feature requires a Universal print subscription and the Universal Print Integration extension
Email Print: This feature lets you set up email-enabled printers. Business Central then sends print jobs to a printer using the printer's email address. This feature requires email-enabled printers and the Send to Email Printer extension.
Browser printing: Print jobs are handled by the print functionality of the user's browser. If a cloud printer isn't installed and set up, or if an installed printer fails, then the printing will default to the printing options for the browser. The Printer field on the report request page will display (Handled by the browser).
General Ledger & Banking Features
Ability to check posting errors while you work
If your administrator enables Feature: Check documents and journals while you work on the Feature Management page, Business Central will validate the data you enter on documents and journals while you work. If you're just reviewing documents while approving them, this capability may not be of use to you. If that's the case, your admin can turn off the Enable Data Check toggle on the General Ledger Setup page.
Prevent the ability to DELETE a General Ledger Account:
This is an existing capability of Business Central that you can use to track entries that are generated during the posting of specific transactions. The Find Entries feature has been available on most pages that display posted document or document entries, but now it's also available on all Role Centers.
You can easily access the Find Entries feature by using the Ctrl+Alt+Q shortcut key combination anywhere in Business Central.
Pages for posted documents and ledger entries, such as the Posted Sales Invoice or Customer Ledger Entries pages, show the general ledger entries related to a specific document or entry, even without using Find Entries page.
You can define periods during which you allow people to post deferrals for specific users on the G/L Setup page, and for users on the User Setup page by entering dates in the Allow Deferral Posting From and Allow Deferral Posting To fields. This lets people post deferral entries in a future period, even though the Allow Posting From/To fields block other entries.
For deferral templates, you now have an option to specify Beginning of Next Calendar Year as the starting date.
Intercompany Auto-Acceptance of GL Journals
New fields in the Intercompany Setup page mean that you can set up the company for automatic creation of received intercompany transactions from intercompany partners, posted through the intercompany general journal.
In this release wave, we add a new Intercompany Setup page, and we deprecate the older one. The new feature must be enabled in the Feature Management page.
The new Intercompany Setup page has fields to specify where received intercompany journal transactions are created:
Default IC Gen. Jnl. Template
Default IC Gen. Jnl. Batch
The entries are not posted, only created in the journal.
BANKING - PAYMENT RECONCILIATION: The payment reconciliation journal has been improved with the following capabilities:
View fields for debits and credits on the footer of journals.
Preview before posting.
You will find the features in the Payment Reconciliation Journal page
Bank Account Statement
Report on the posted bank reconciliations has been modified so it now shows a more detailed snapshot of the bank information as of the time when the bank reconciliation was posted. New fields, G/L Balance, Outstanding Payments, and Checks, make it easier to validate and audit.
Default Bank Accounts
You can now set default bank accounts for companies, and for individual currencies, by choosing Use as Default for Currency on the Bank Account page.
Create Bank Deposits as Lump Sum
Bank deposits let you maintain a transaction record that contains information that can be applied to outstanding invoices and credit memos.
By using bank deposits, you can easily view all transactions included in a deposit. Bank deposits also make bank reconciliation easier. These advantages make using deposits instead of general journal entries the preferred approach for registering deposits that cover more than one business transaction.
The Bank Deposit page specifies the bank account deposited into, total deposit amount, posting date, document date, dimensions, and currency code, as well as the deposit lines.
Deposit lines contain information about the individual deposited items, such as checks from customers, cash sales revenue, or refunds from vendors. This information includes the document date and number, account type and number, and amount. The total of the amounts on the deposit lines must add up to the total amount of the deposit entered on the deposit header before posting the deposit.
After you enter information about a deposit and add deposit lines, you must post the deposit to update the relevant ledgers, such as the bank ledger, general ledger, or customer ledger. The details about posted bank deposits are stored for future reference and are available on the Posted Bank Deposits page. Alternatively, you can also access the details when you do bank reconciliations.
The Deposit report displays customer and vendor deposits with the original deposit amount, the amount of the deposit that is still open, and the amount applied. The report also shows the total posted deposit amount to reconcile.
Find the bank deposits capabilities under Cash Management on the Business Manager and Accountant Role Centers. You can also use Tell Me to search for the Bank Deposits page.
Accounts Receivable - Accounts Payable
Linking AR and AP, Customer and Vendor Master Records to each other:
You can turn a contact company into a customer or vendor by using the Create as Customer or Create as Vendor actions on the Contact Card page. This link is a prerequisite for seeing the Balance as Vendor field on the Customer page and the Balance as Customer field on the Vendor page.
The Customer Card page offers the Balance as Vendor field, and the Vendor Card page includes the Balance as Customer field for companies that were created or linked to the same contact company.
The Net Customer/Vendor Balances action creates payment journal lines to which the net balances for a customer and vendor are linked.
Demand Forecasting: You can define periods during which you allow people to post deferrals for specific users on the G/L Setup page, and for users on the User Setup page by entering dates in the Allow Deferral Posting From and Allow Deferral Posting To fields. This lets people post deferral entries in a future period, even though the Allow Posting From/To fields block other entries.
For deferral templates, you now have an option to specify Beginning of Next Calendar Year as the starting date.
Default Dimension by LOCATION
Dimensions are values that categorize entries so you can track and analyze them on documents, such as sales orders. For example, dimensions can indicate the department or project an entry came from. That can help people avoid making a mistake and having to enter dimension manually on the transaction level if all goods are coming out of a single location and department.
You can now set default dimensions for a location on the Location Card page by choosing Location, and then Dimensions. The location's default dimensions are copied to journals and documents when you specify the location on a line, but you can delete or change the dimension on the line if needed. You can require that people specify dimensions for specific locations before they can post an entry. You can also include location dimension values in Default Dimension Priorities and Dimension Combinations for combinations of priority and dimension rules.
Sales Order Processing
Release and reopen multiple documents
The status of documents indicates whether they're open, waiting to be approved, have been invoiced for prepayment, or have been released to the next stage of processing. When you finish working on a batch of documents, you can release all or some of them to the next stage in the process or reopen them for further processing, all in one go.
To make it easier to quickly identify documents that are open or released, especially when viewing a list of documents, the Open and Released statuses have different font colors.
When you release or reopen multiple documents, a confirmation will show the number of documents that are selected and the number that remain unchanged.
Sync sales orders both ways in Business Central and Dynamics 365 Sales CRM
You can now synchronize sales orders between Business Central and Dynamics 365 Sales in both directions. For example, if a customer changes their mind about the product or quantity they ordered in Sales, you can automatically process the change to the order in Business Central by archiving the sales document and creating a new one. The same is true for changes in Business Central. For example, when prices, tax amounts, or expected shipment dates change, the changes are automatically synchronized to Sales. That helps keep your sellers up-to-date with the latest changes and the status of quotes and orders.
To enable synchronization of sales orders in both directions, choose the Bidirectional Synch of Sales Orders field on either the Dynamics 365 Connection Setup page or in the Set up a connection to Dynamics 365 Sales assisted setup guide.
The Integration Table Mappings page contains new mappings for the sales order header and lines. When you set up the initial connection for Sales, you can synchronize active orders between Business Central and Sales by using the Full Synchronization or Match-based coupling actions.
Job Costing Module
We've added Sell-to and Ship-to field groups to the Jobs page. Existing jobs will be updated automatically, and these new fields will inherit values from the respective fields in the Bill-to group that was already available.
Additionally, the Your Reference, External Document No., Payment Terms Code, and Payment Method Code fields are added to jobs and will be respected when you create invoices.
Support inventory pick and warehouse pick operations for jobs
The warehouse activity of picking items before they are consumed is performed in different ways, depending on how warehouse management features are configured. The complexity can rank from no warehouse features, through basic warehouse configurations for order-by-order handling in one or more activities, to advanced configurations where all warehouse activities are performed in bulk.
Start by enabling Feature Update: Enable inventory and warehouse pick from Jobs on the Feature Management page.
After you enable the feature, the Create Inventory Pick and Create Warehouse Pick actions are available on the Job Card. To create or register a pick document, use the Put-away/Pick Lines/Movement Lines or Registered Pick Lines actions.
You can use the actions under the following conditions:
The Status of the job is Open.
The Line Type of the job planning line is Budget or Both Budget and Billable.
The Type of the job planning line is Item.
Require Pick is enabled for the related location.
Directed Pick and Put-away is disabled.
Report selection for projects
Use the in-product Search to open the new Report Selection - Job page. The default configuration will use report 1016 Job Quote, but you can change this default behavior. You can also add reports to the Report Selection - Job page if you want to print more than one report per document type, for example.
In this version, you can only specify Job Queue as the value for the Usage field.
You can select the Fixed Quantity option in the Calculation Formula field on production BOM lines, planning components, and production order components to ensure that the consumption of a component is the same.
You can choose from the following values in the Calculation Formula field:
Blank: The quantity is not calculated.
Length: Quantity = Length * Quantity per
Length * Width: Quantity = Length * Width * Quantity per
Length * Width * Depth: Quantity = Length * Width * Height * Quantity per
Weight: Quantity = Weight * Quantity per
Fixed Quantity = Quantity Per
In production order components, when the Calculation Formula field is set to Fixed Quantity, the Expected Quantity field value is always equal to the Quantity Per field. The scrap % that is defined on the same line is ignored. Fixed quantity is respected by the Availability by BOM report that will show the item as the bottleneck if the available quantity is less than the quantity in the Quantity Per Parent field. The Able to Make Parent and Able to Make Top Item fields always have blank values regardless of the available quantity. Fixed quantity is respected by the Standard Cost Calculation process. Lot size for the produced item impacts the cost allocated for one item.
ERRORS Found in the New Version 20:
Error 9011 and Error 9222 when using a custom permission set or a permission group. The default Microsoft Permission Groups and Permission sets will get updated automatically, but if your company uses a custom permission set, the tables 9011 and 9222 have to be added as a READ-ONLY table.
Version 19 New Feature Oct 2020
Microsoft regularly updates the Business Central system. Version 19 was released in October 2021. In this blog, we will keep you up to date as to what new features have been added. You can assume that Microsoft also fixed a number of reported bugs in each release.
Version 19.1 - Released December 2021 1. Admin Tool - Copying Environments from different types i.e. Sandbox, Production 2. The Operations log in the Business Central admin center provides an overview of the admin operations in the relevant Business Central online environments, such as restoring, renaming, installing, and uninstalling apps, exporting databases, and moving environments between different Azure Active Directory (Azure AD) tenants. 3. Restarting an Instance: In some circumstances, as a troubleshooting step, administrators might have to restart a particular Business Central environment to resume its normal operation. In this release wave, we're adding the option to restart an environment in the Business Central admin center. 4. Support for 2D Barcodes: This release wave adds fonts to generate two-dimensional barcodes in Business Central production and sandbox environments. This means that any custom layouts using the fonts will work. Microsoft has licensed the font packages provided by IDAutomation Inc. Microsoft also has added a new AL module to make it easy for developers to encode strings in the different barcode symbologies that the fonts support.
Version 19.2 - Release January 2022 1. Synchronize multiline text fields between Business Central and Dataverse (and Dynamics 365 Sales) 2. AL compiler diagnostic messages include URLs.
For further information or any assistance with your Development Effort in Business Central, please contact our implementation team at Sales@CBRTechnology.com .