New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Easier to Create Opening Balances for Item Tracked Inventory

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

The seventeenth of the new functionality in the Application section is Easier to create opening balances for item tracked inventory.

Businesses can easily move the inventory they track with serial and batch numbers into Business Central.

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

Feature Details

As the flow of goods in today’s supply chain becomes more complex, keeping track of items is increasingly important for businesses. For example, monitoring an item’s transaction flow is a legal requirement in the medical and chemical supply industries. Other businesses might want to monitor products with warranties or expiration dates for customer service reasons.

In this release wave, we’ve simplified the first steps, such as creating opening balances for items where item tracking is required. Because you can choose different warehouse configurations, there are two new options:

  • You can enable specific batches on the Item Journal page to let people enter serial, lot, and package data directly on journal lines.
  • For locations where the Directed Put-away and Pick toggle is turned on, you can use the Warehouse Physical Inventory Journal page to make all item tracking fields available. The fields that are available now include the Warranty Date and Expiration Date fields.

Item journal

  1. Search for the Item Journals page, and then choose the related link.

  2. Choose the Name field to open a list of item journal batches.

  3. Choose New to create a new batch, and then turn on the Item Tracking on Lines toggle.

    Item Journal Batch
  4. Choose OK to select the batch you created.

  5. Fill in the fields on the item journal line as necessary. Notice that the Lot No., Serial No., Expiration Date, Warranty Date, and Package No. fields are available (if the feature is enabled).

  6. Choose the Post action to adjust inventory.

Item Journal

note Note

Business Central does a few minor validations when you enter or import data. A more comprehensive check happens when you post or transfer data from journal lines to the Item Tracking Window. The latter happens automatically when you open the Item Tracking Window from the item journal line or if you choose the Update Item Tracking Lines action.

Warehouse physical inventory journal for locations where directed pick and put-away is turned on

  1. Search for the Warehouse Physical Inventory Journal page, and then choose the related link.
  2. Fill in the fields on the item journal line as necessary. Notice that the Lot No., Serial No., Expiration Date, Warranty Date, and Package No. fields are available (if the feature is enabled).
  3. Choose the Register action to make the inventory adjustments. Remember that you’ll need to synchronize the adjusted warehouse entries with the related item ledger entries. To learn more, go to synchronize the adjusted warehouse entries.
Warehouse Physical Inventory Journal

For bulk import, you can use configuration packages to import data to the journals.

You can’t use Edit in Excel to create journal lines with tracking information.

My Opinion

This seems like a good addition which will be useful when implementing Dynamics BC. Data take-on is usually both quite complex and time consuming; this looks like it should make taking on items a little easier by allowing you to include tracking data.

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1
Use Business Events To Notify And Trigger External Systems
Get Started With More Sample Power Automate Templates And Power Apps
New Approval Workflow Experience With Power Automate Templates
Support Dynamic Environment And Company In Power Platform Connector
Remove Modification Limits For Triggering Flows
Use Power Automate To Post Adaptive Card Or Link To Business Central Record
Adjust Exchange Rates Easily, Replace The Built-In Batch Job
Use Different General Ledger Accounts For Payables, Receivables
Avoid Document Number Errors When You Post Item Journals
Company Hub Now Lets Admins Add User-Specific Settings
Define Content Of Created Warehouse Documents With Filters
Intercompany Posting Setup Supports More Transaction Types And Streamlines Flows
Preview Item Journals Before Posting
Review General Ledger Accounts Faster
Set Up And Sync Master Data Across Companies
Ship And Receive Non-Inventory Items On Warehouse Documents
Shopify Connector Becomes Extensible
Shopify Connector Becomes Extensible
Synchronize Returns, Refunds From Shopify
Undo Transfer Shipments
Swedish Localization Delivered As Extension
Supporting More Countries And Regions
AL Explorer And AL Home In Visual Studio Code AL Extension
Attach AL Debugger To Active Session Or Next Session
Improved Compiler Resource Handling And Faster Code Analyzers
Optimized Runtime Package Generation For Sharing
Provide Title And Custom Actions To Error Dialogs
Control Database Locking Behaviour
AL-Go For Github – Modern Devops For Partners
ISVs Can Organize A Preview For Their Appsource Apps
Experience Improved App Management Settings
Get An Improved Cloud Migration Status Overview
Include Or Exclude Tables From Cloud Migration
Transfer Environments Between Azure Ad Tenants
Non-Deductible, Partly Deductible Vat Expands Functionality
Audit File Export Eases Saf-T Compliance
Easily Find And Install Payroll Apps From Within Business Central
Modern Tooltips Are Easy To Read And Understand
Refresh Of Content To Support Modern Tooltip UI
Experience Enhanced Adaptive Cards In Teams
Configure Security Controls For Teams Cards
Add Existing Table Fields To Optimize Your Pages
Drag And Drop Files Onto The File Upload Dialog
Access Actions And Navigation Menu Efficiently With Keyboard
Get More Productivity Out Of An Optimized Action Bar On All App Pages
Get Unblocked Using Actionable Error Messages In Select Application Areas
Tailor Action Bar To Fit Your Needs On Document Lines
Copy And Paste Readable Hyperlinks
Removed Functionality
Add More Columns to Pages for Better Insight
Catalog Items Use Standard Number Series, Can Include in Blanket Sales Orders
Demo Tool and Data for Warehouse and Inventory Scenarios
Easier to Create Opening Balances for Item Tracked Inventory
Post multiple transfer orders at the same time
Set Default Dimensions on Locations, Inventory Documents and Journals
Usability Improves for Transfer Order: Select Multiple Items, Mandatory Fields
Usability Improves for Warehouse, Inventory and Tracking Areas
Use Advanced Warehouse Functionality With Minimal Complexity
Use Statistical Accounts to Collect Data for Financial Reports
Save Time With Automatic Account Codes (Sweden and Finland Only)
Country/Regional Expansion – Andorra
Define Regional Settings Per Report Using a Region Property
Extensions That Fail Pre-Upgrade Validation Get More Detailed Error Insights
Delegated Admin’s Job Queue Entries Are Run by User
Manage User Permissions Using Security Groups
Analyze, Group, and Pivot Data on List Pages Using Multiple Tabs
Allow Application and Tenant Databases to Differ in Collation
Business Central server runs on .NET 6
New telemetry events and data
Performance – OData calls are now faster
Improved Alignment of Headers in Statistics Pages

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Leave a Reply

Your email address will not be published. Required fields are marked *