Author: Ian Grieve

Ian is a Microsoft Dynamics GP certified consultant specialising in the delivery of Microsoft Dynamics GP projects and currently the Lead ERP Consultant for ISC Software Ltd., a Microsoft Partner, VAR and ISV in England. Ian has worked with Microsoft Dynamics GP since 2003 and, over the nine years since, has dealt with all aspects of the product life-cycle from presales, to implementation, to technical and functional training, to post go-live support and subsequent upgrades and process reviews. In his spare time, Ian runs the azurecurve | Ramblings of a Dynamics GP Consultant blog dedicated to Microsoft Dynamics GP and related products.

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Define Default Location for Project or Project Phase

Ian Grieve3 minute read0 comment

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 5th of the new functionality in the Application section is define default location for project or project phase.

Reduce the time you spend on data entry and focus more on core tasks by specifying a default location and bin for projects on the Project Card page. When you create project tasks, project planning lines, and project journal lines for the project, the default location and bin are automatically assigned. Stay flexible with the ability to change the location code and bin on tasks and lines if needed.

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

Feature Details

Specify a default Location Code and Bin Code on the Project and Project Task Lines Subform pages. Similar to production order processes, these default values simplify data entry on project tasks, project planning lines, and project journal lines.

Location and Bin in Project

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Define Default Location for Project or Project Phase”

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Define a Service Invoice Posting Policy for Various Users

Ian Grieve3 minute read0 comment

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 4th of the new functionality in the Application section is define a service invoice posting policy for various users.

Companies often have unique processes for invoices and shipments. For example, processes can vary from one person posting everything on a service order to multiple employees, each working with their own pages. A setting on the User Setup page lets you specify how each user can process service invoices.

Enabled for: Users by admins, makers, or analysts
Public Preview: Mar 2024
General Availability: Apr 2024

Feature Details

You can use posting policies to restrict users from posting service invoices, or require them to post invoices together with the related service shipment. To specify a posting policy, on the User Setup page, choose one of the following options in the Service Invoice Posting Policy field:

  • Allowed (Default): Keep the current behavior, where you can choose the posting option, such as Ship, Invoice, and Ship and Invoice.
  • Prohibited: Prevent people from posting invoices. Business Central shows a confirmation dialog that provides only the Ship option.
  • Mandatory: Let people post invoices along with service shipments. Business Central shows a confirmation dialog with the Ship and Invoice option.
Service Invoice Posting Policy

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Define a Service Invoice Posting Policy for Various Users”

In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Stock On a Van

Ian Grieve5 minute read0 comment

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.

While I was writing the articles on consignment stock being held by the customer in their warehouse or in your own warehouse, I have dealt with several clients who hold stock on vans.

One example, I worked with a housing association who had operatives driving vans going to do housing maintenance with stock in the van to use for the jobs.

If I was doing this in Business central, I would, as with consignment in the customers own warehouse, create a new location identified as a van; I’ve seen a few variations of location names, from van registration places, operative names and initials, but the one that seems to work best is simply issuing each van with a numeric or colour identifier. The problem with using something like a name or registration plate, is that people leave and vans get replaced. An identifier based on the operative is particularly tricky; what if he changes vans, even if only for one day while his usual van is replaced.

Separate locations can be defined with an Inventory Posting Group and related Inventory Posting Setup which allow you to account for van stock in a different G/L account than the warehouse, if you so choose.

In addition, I’d suggest configuring these van locations with only basic inventory and no warehouse configuration (they’re too small to require anything other than the basics).

Stock would be transferred to the vans using the Item Reclassification Journal; this would be done for general stock on the van as well as items for specific jobs (such as a sink or boiler).

Consumption would depend on the way in which the stock had been consumed:

  • Used for work to the customers benefit – a sales order line could be raised for the quantity of stock used. For example, fitting a new sink.
  • Consumed for a non-rechargeable repair (like some repairs by a housing association) where the customer is not responsible for the cost of the good, or where the items used are classed as an incidental (such as some sand for cement) which might be subsumed into the cost of the overall work; this stock could be removed from the van by way of a negative adjustment on an Item Journal.

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 (Administration), how do I… Add Branding to Business Central by Setting a Theme
Word Template Mail Merge in Business Central: What is it?
Word Template Mail Merge in Business Central: Create Word Template for Mail Merge
Word Template Mail Merge in Business Central: Create Mail Merge from Business Central Entity
Word Template Mail Merge in Business Central: Create Mail Merge from Business Central Using a Word Template
Word Template Mail Merge in Business Central: Create Mail Merge from a Business Central Entity using a Word Template
Word Template Mail Merge in Business Central: Send Email Using a Word Template
Word Template Mail Merge in Business Central: Send Email Using a Word Template as an Attachment
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
Using Extended Texts In Microsoft Dynamics 365 Business Central: Add Extended Texts to Stockkeepping Units
Using Extended Texts In Microsoft Dynamics 365 Business Central: Enable Item Extended Texts to be Added to Transactions Automatically
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
Using Extended Texts In Microsoft Dynamics 365 Business Central: Create a Purchasing Transaction with Manually Added Extended Texts
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
Using Extended Texts In Microsoft Dynamics 365 Business Central: Create a Sales Transaction with Manually Added Extended Texts
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 2024 Wave 1: Use Deferral Codes in Purchase and Sales Journals

Ian Grieve3 minute read0 comment

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 Application section is Use deferral codes in purchase and sales journals.

Entering sales and purchase journals is sometimes associated with data entry for transactions that require deferrals. The process of entering data is smoother because you can specify a deferral code on sales and purchase journals, without having to create a general journal.

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

Feature Details

You can set a deferral code on sales and purchase journal lines, which allows you to post deferral transactions while you work in these journals. Deferral works the same way on sales and purchase journals as it does for general journals. To learn more about deferrals, go to Defer Revenue and Expenses.

Note that sales and purchase journals validate the source code. The validation requires that the source code for sales and sales journals, and purchase and purchase journals respectively, aren’t identical when you’re using deferrals. If it’s set up to be identical, you can work around this limitation by creating a template and batch that uses another source code.

Purchase journal with the new Deferral Code field

My Opinion

I’ve not had a need to delve too much into deferrals yet, but it is surprising that you couldn’t already use deferral codes on sales and purchase journals. It’s good to know that the functionality is coming.

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: Usability Improves for Service and Projects

Ian Grieve2 minute read0 comment

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 2nd of the new functionality in the Application section is usability improves for service and projects.

Productivity increases when processes are easy, so Microsoft have improved the usability of several areas within project and service management. For example, you can save a step by automatically releasing source documents, and in several places data is easier to access and digest.

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

Feature Details

Based on feedback from their customers, Microsoft have made it easier to complete several business processes in service management and accounting.

The PowerBI and Project Details FactBoxes are available on the Project List page, so you can access project details from the list. The Power BI content that’s currently available isn’t changed.

Project Details

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Usability Improves for Service and Projects”

Working with Power Automate: Create an Environment Variable

Ian Grieve2 minute read0 comment

Power AutomateThis article is part of the Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC.

The last article of this series introduced environment variables which are used to store keys and parameters for flows within a solution.

To create a new environment variable, open your solution and click New » More » Environment variable:

Power Automate portal showing the expanded menu for creating a new environment variable

Continue reading “Working with Power Automate: Create an Environment Variable”

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Archive Projects

Ian Grieve3 minute read0 comment

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 Application section is archive projects.

Projects often change and evolve during their lifecycle. The archiving capability gives you control over your project data through audit trails and version control.

Enabled for: Users by admins, makers, or analysts
Public Preview: Mar 2024
General Availability: Apr 2024

Feature Details

Archiving capabilities for projects are similar to the functionality you might already be familiar with from the sales and purchase areas. You can set up projects to archive automatically, so that you don’t need to think about it. With automatic archiving, Business Central creates a new version of the archived document when people do the following:

  • Change the status of a document, or delete it.
  • Print, download, or send a document by email.
  • Post an invoice.

You’re in full control of archiving. The following table describes the options you can choose when you set up automatic archiving on the Project Setup page.

Project Setup

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Archive Projects”

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Improve Approval Processes via Power Automate

Ian Grieve3 minute read0 comment

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 Adapt faster with Power Platform section is improve approval processes via Power Automate.

Approving documents or data changes in a modern company must be straightforward. Microsoft listen to feedback and continue to improve this area, making sure this experience matches business users’ expectations.

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

Feature Details

In previous releases, Microsoft introduced several new approval templates and a simplified experience based on Power Automate. With this wave, Microsoft improve this area by introducing several new changes:

  • The Approval User Setup page has been updated and exposed to Power Automate. Approvers don’t need to be defined manually on the Power
  • Automate side anymore, but the flow execution takes the relevant approver directly from Business Central.
  • The system passes information about user actions in Power Automate back to Business Central where the respective events are properly logged.
  • More templates are enabled for Power Automate approval integration.

Microsoft welcome your feedback on these improvements as they continue to innovate.

My Opinion

Approvals in Power Automate was one of the areas of which I have been most critical as it seemed to lack a lot of the functionality I would expect. The first two of the improvements look to be good enhancements, especially the second one of logging statuses back into Business Central.

The first one will vary in usefulness depending on the complexity of the approval workflow as the standard Approval User Setup page in Business Central only has very little flexibility.

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

In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Consignment Stock in My Warehouse

Ian Grieve4 minute read0 comment

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.

In the previous article of this series, I discussed a process we helped a client setup for the process of consignment stock, whereby our client had a customer who held stock in their own warehouse, but only purchased it when they sold it on to their own customers.

That’s actually fairly straightforward to do using additional sites and a simple basic warehouse configuration. what about if the consignment stock was still held at the customers warehouse where they still had responsibility for managing the stock, including receiving, put-away, pick and shipment?

Well, the process will vary somewhat depending on the requirements of the consignment location.

In most cases, the consignment location is likely to be a section of the warehouse; if large enough, bins could be required to allow for efficient management of goods.

I would still recommend creating this section of the warehouse as a separate location within Business Central, as it gives you control over the financial aspects of the inventory as well as the physical, which simply using bins would not accomplish.

When ordering goods, which you know to be to refill the consignment location, the consignment location could be selected on the purchase order, thereby receiving goods directly to it. If goods are being generally ordered and need moving to the consignment location after receipt, then an Item Reclassification Journal can be used to move goods to the consignment location.

If the consignment location was particularly large, you might enable advanced warehouse functionality on the location such as receipts, put-aways, picks, shipments or any combination thereof to best manage the warehouse processes.

Sales orders would be raised against the consignment location as discussed in the previous article.

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 (Administration), how do I… Add Branding to Business Central by Setting a Theme
Word Template Mail Merge in Business Central: What is it?
Word Template Mail Merge in Business Central: Create Word Template for Mail Merge
Word Template Mail Merge in Business Central: Create Mail Merge from Business Central Entity
Word Template Mail Merge in Business Central: Create Mail Merge from Business Central Using a Word Template
Word Template Mail Merge in Business Central: Create Mail Merge from a Business Central Entity using a Word Template
Word Template Mail Merge in Business Central: Send Email Using a Word Template
Word Template Mail Merge in Business Central: Send Email Using a Word Template as an Attachment
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
Using Extended Texts In Microsoft Dynamics 365 Business Central: Add Extended Texts to Stockkeepping Units
Using Extended Texts In Microsoft Dynamics 365 Business Central: Enable Item Extended Texts to be Added to Transactions Automatically
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
Using Extended Texts In Microsoft Dynamics 365 Business Central: Create a Purchasing Transaction with Manually Added Extended Texts
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
Using Extended Texts In Microsoft Dynamics 365 Business Central: Create a Sales Transaction with Manually Added Extended Texts
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

SQL Query on Matomo Database to Calculate the Number of Visits to Each Page

Ian Grieve3 minute read0 comment

Useful WebsitesI’ve been using for just short of four years now and have been pretty happy with it.

I generally consume the data it holds via the eweb portal, but I was wanting to extract some data to manipulate recently, in a way that the web portal didn’t allow, so I did a little poking around the database to work out the syntax needed to query the database directly in mySQL.

The below query returns all pages for the specified date range (the first two highlighted variables at the top), sorted in descending order of number of visits; the third parameter is the id of the site for which you want the data:

/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
SET @StartDate = '2023-01-01';
SET @EndDate = '2023-12-31';

SET @SiteID = 1;

SELECT
	name
	,COUNT(name) AS COUNT
FROM
	matomo_log_visit
LEFT JOIN
	matomo_log_link_visit_action
		ON
			matomo_log_visit.idvisit = matomo_log_link_visit_action.idvisit
LEFT JOIN
	matomo_log_action
		ON
			matomo_log_action.idaction = matomo_log_link_visit_action.idaction_name
WHERE
	matomo_log_visit.idsite = @SiteID
AND
	type = 4
AND
	matomo_log_link_visit_action.server_time >= @StartDate
AND
	matomo_log_link_visit_action.server_time <= @EndDate
GROUP BY
	NAME
ORDER BY
	COUNT(NAME) DESC;