Error Message Creating a Physical Inventory Journal in Microsoft Dynamics 365 Business Central: “Phys. inventory must be equal to ‘Yes’ …”

Microsoft Dynamics 365 Business CentralI helped a client implement Microsoft Dynamics 365 Business Central recently and after training while they were doing UAT, they came to me with an issue when trying to do an adjustment to book stock into the system.

They were just trying to get some stock booked into the system quickly so that they could do some testing of the sales process, so they were trying to do a journal to get the stock in. However, when they entered the item onto the journal they were receiving an error:

Physical Inventory Journal page

Phys inventory must be equal to 'Yes' in Item Journal Line: Journal Template Name=PHYS. INVE. Journal Batch Name=DEFAULT, Line No.=10000. Current value is 'No'.

This error is because they were working in the wrong inventory journal page. They were on the Physical Inventory Journal page which is used by the stock count process and where you do not manually enter the lines, but instead use the Prepare » Calculate Inventory… action to populate the lines.

Instead, they should have been using the Item Journal page which is where you enter any positive and negative adjustments. Once they were directed at the correct page, they were able to get the stock adjustment done and continue testing the sales process.

The “correct” process they should have used, was not doing an adjustment at all, but have someone raise a purchase order and process the receipt for the goods as this is the way that processing would be done post go-live. However, in this instance, they were doing unit testing of a change specific to the despatch of sales orders and the team members from purchasing weren’t available and wanted to avoid delays in testing the sales side.

In Microsoft Dynamics 365 Business Central (Development), how do I… How to Upload an Extension

Microsoft Dynamics 365 Business CentralThis post is part of the In Microsoft Dynamics 365 Business Central (Development), 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.

I’m jumping a little ahead in this series by covering the upload of an extension before covering any development steps, but development isn’t my area as such (I’m a consultant, not a developer) and this came up on a project with a client where the MADIC dynamics development team did the work on creating the extension.

When you have the extension app file, this can be uploaded to your instance of Business Central. This is done from the Extension Management page by clicking the Manage » Upload Extension… action:

Extension Management page with Manage menu open and Upload Extension action highlighted

Continue reading “In Microsoft Dynamics 365 Business Central (Development), how do I… How to Upload an Extension”

In Microsoft Dynamics 365 Business Central (Development), how do I… Series Index

Microsoft Dynamics 365 Business CentralI have recently started working with Microsoft Dynamics 365 Business Central and have decided to blog about it as I learn; I’ve started a In Microsoft Dynamics 365 Business Central, how do I… series which will include everything, but have also decided to break that down into a set of smaller series on specific areas of Dynamics BC.

This is the series index for the Development related posts I will be writing. The series index, below, will automatically update as each post in the series goes live so make sure you bookmark this post so you can see keep up-to-date with my journey into Business Central.

It should be noted that I am a functional consultant and not a developer, so I expect this series will be low on content and only cover some fairly basic aspects of development with Business Central.

Continue reading “In Microsoft Dynamics 365 Business Central (Development), how do I… Series Index”

Jet Reports with Microsoft Dynamics 365 Business Central Book Available

Microsoft Dynamics 365 Business CentralI have a new book available now called Jet Reports with Microsoft Dynamics 365 Business Central; this book is aimed at end-users or consultants looking to use Jet Reports with Microsoft Dynamics 365 Business Central for financial and/or operational reporting.

The book covers the basics of installing and configuring Jet Reports as well as how to design and build reports using the Excel Add-in, before moving on to step-by-step guides on creating six different types of report and closing with a look at the report building tools, Jet Hub and report distribution.

Jet Reports with Microsoft Dynamics 365 Business Central by Ian Grieve

The book is available as an eBook direct from my azurecurve Publishing site (always with a discount of $5, but with an additional discount of 20% until end of April using voucher code EASTER2024) or from Amazon:

The book is structured into these chapters:

  • Chapter 1, Introduction to Jet Reports, introduces Jet Reports and explains what type of reporting for which it can be used.
  • Chapter 2, Implementing Jet Reports, covers the installation of Jet Reports including the Jet Service Tier and Jet Hub.
  • Chapter 3, Configuring Jet Reports, shows how to configure Jet Reports once it has been installed.
  • Chapter 4, Introducing the Excel Add-in, introduces the Excel Add-in and the features available.
  • Chapter 5, Report Structure, shows how reports can be structured to make maintaining them easier.
  • Chapter 6, Using the functions in the Excel Add-in, shows how each of the four Jet Functions can be used.
  • Chapter 7, Creating and using an Options page, covers the creation and use of an options page in reports.
  • Chapter 8, Create a Summary Trial Balance, steps through the creation of a Summary Trial Balance report.
  • Chapter 9, Create a Detailed Trial Balance, shows how to make the Summary TB from the previous chapter into a Detailed report.
  • Chapter 10, Create a Balance Sheet, covers the creation of a formatted Balance Sheet.
  • Chapter 11, Create an Income Statement, covers the creation of an Income Statement and how to make it an intercompany/consolidated version.
  • Chapter 12, Create a Summary Payables Aged Trial Balance, shows how to create a Summary Payables Trial Balance report.
  • Chapter 13, Create a Sales Invoice by Customer Report, covers the creation of an operational report on sales invoices.
  • Chapter 14, Report Creation Tools, introduces the tools which can be used to make creating reports easier.
  • Chapter 15, Using Jet Hub, shows how users can access Jet Reports via web access and without a local install of Jet Reports.
  • Chapter 16, Report Distribution, shows how users can schedule or generate reports into Microsoft Word.

If you buy this or any other ebook from me directly, the coupon code EASTER2024 will get you 20% off (until the end of April 2024).

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Control partner access per environment

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 8th of the new functionality in the Governance and administration section is Control partner access per environment.

Business Central customers with multiple environments are often working with many partners to support each environment. With this feature, customer administrators can now easily and efficiently control partner access to environments. This feature simplifies partner management by allowing administrators to assign partner tenants to each environment.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: –
General Availability: Apr 2024

Feature Details

In 2024 release wave 1, Microsoft are introducing new environment settings in the Business Central admin center that enable internal administrators to control which environments delegated users and multitenant apps from partner tenants can access and administer. Internal administrators can specify the tenant IDs of partners that should be able to access each environment. Delegated users and multitenant apps accessing or administering the environment must belong to an allowlisted tenant. This feature is optional, and if no tenants are allowlisted for an environment, delegated users and multitenant apps will be able to access and administer the environment as they did before. This feature only affects the use of the admin center API by multitenant apps that have been authorized within the admin center

My Opinion

This sounds like a double edged sword; good for users to have the ability to restrict access to environments, but also too easy for something to be set incorrectly and deprive necessary access. However, the same can be said of any security on a system, so I’d say this is a good enhancement. Some of the clients I’ve worked with in the past have had very locked down systems, so they’d like this for witholding access to production while giving access to dev, QA and UAT environments. It could also be useful for companies operating in multiple countries by allowing only the partner for a specific country to access an environment.

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

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: View and Filter Users With Additional User Details

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 7th of the new functionality in the Governance and administration section is view and filter users with additional user details.

Additional user details and technical data helps administrators be more effective when they handle user requests and resolve issues..

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

Feature Details

You can view additional details about users on the Users page by choosing the Show more details action.

Shows new Show more details action in Users page

The Users details page offers multiple views that administrators can filter. For example, an administrator might want to view all users with a Microsoft 365 license, or users who are assigned to the SUPER permission set.

Shows new user details page with extra columns and views

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: View and Filter Users With Additional User Details”

Picking Only Reserved Goods in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Centralvan Labrador Gonzalez, an experienced system engineer, has on his IVAN SINGLETON | A blog about Business Central, Xamarin and Arduino blog recently posted an article on enhancing the picking process within warehouse management so that only reserved goods are included on the pick as it is created.

Unfortunately, this is not something which is available as standard in Business Central; when you create the pick, the whole quantity of goods from the order are included on the shipment and resulting pick.

The way Ivan gets only the reserved items onto the pick is be developing an extension which adds a new button to the Warehouse Shipment (7335) page. Fortunately, in the article he details the step by step to create this customisation, including all of the required code.

Warehouse Shipment page with new action button

The article, including code examples, can be found here and complete code is on GitHub.

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Copy Companies with Dataverse Integration Safely

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 6th of the new functionality in the Governance and administration section is copy companies with Dataverse integration safely.

Administrators in small or medium-sized companies often wear multiple hats and do many different tasks. It’s important that you can efficiently and safely copy companies if you integrate with Dataverse or Dynamics 365 Sales, reducing the risk of data inconsistencies and saving you valuable time. This enhancement streamlines your workflow so you can focus on strategic tasks, driving your business forward.

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

Feature Details

When an administrator copies companies in an environment that has Dataverse or Dynamics 365 Sales integration enabled, Business Central clears the following settings while copying to the target company:

  • Dataverse and Dynamics Connection Settings to ensure that integration correctly re-initiates in the target company.
  • Integration records to ensure that the target company doesn’t point to records that are coupled in the source company.
  • Integration synchronization jobs to stop synchronization background jobs.
  • Integration synchronization errors to clean synchronization errors, it they exist, because they point to errors in source company and would just be considered noise in the target company.

My Opinion

This sounds like a very welcome enhancement as the current process is open to quite a bit of risk. Clearng these settings will help prevent environments syncing incorrectly.

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

Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (Apr-Jun 2024) from MADIC dynamics

MADIC dynamicsEvery month, on the third Tuesday, at MADIC dynamics we will be presenting a Knowledge Hub Webinar on Microsoft Dynamics 365 Business Central and related products; I will be presenting some of the webinars, but other consultants will be getting involved as well, so there will be a variety of presenters through time.

We aim to have the next three monthly Knowledge Hub Webinars scheduled and details of them available. The next three webinars, starting next month, are:

No april-2024 events found.

No may-2024 events found.

No june-2024 events found.

Error Preview or Posting Assembly Order in Microsoft Dynamics 365 Business Central: “Document No. must have a value in Item Journal Line…”

Microsoft Dynamics 365 Business CentralI was doing a project to implement Microsoft Dynamics 365 Business Central with a client recently. When they were doing some UAT they were getting an error when trying to preview or post an assembly order.

I tried the same process on my demo/test environment and did not get the same error as the we were seeing in the client environment. The error they were seeing was this one:

Error message when previewing or posting an assembly order

Document No. must have a value in Item Journal Line: Journal Template Name=, Journal Batch Name=, Line No. =0. It cannot be zero or empty

Continue reading “Error Preview or Posting Assembly Order in Microsoft Dynamics 365 Business Central: “Document No. must have a value in Item Journal Line…””