Loading...

How to design a high performant inventory report in Business Central

How to design a high performant inventory report in Business Central
If we want to answer a simple question in Business Central - “How many items we have in each location?” then there aren’t that many great built in reports available. There is the standard “Items by Location” report that is not that great. It doesn’t offer exporting, doesn’t offer filtering, you can’t see item values etc. So how do we create a better report? To start designing a report the first thing we need to think about is that we need to calculate the inventory for each item in each location by summarizing the Item Ledger Entries.

Published on:

Learn more
Posts on Microsoft Dynamics 365 Business Central Development
Posts on Microsoft Dynamics 365 Business Central Development

Recent content in Posts on Microsoft Dynamics 365 Business Central Development

Share post:

Related posts

Dynamics 365 Business Central: Restore User’s Default Permissions

Hi, Readers.Today I would like to share another mini tip in Business Central, how to restore User’s Default Permissions. As you might kn...

8 hours ago

Dynamics 365 Business Central: How to convert Text to Hexadecimal in AL

Hi, Readers.Today I would like to talk about how to convert Text to Hexadecimal in AL.The hexadecimal number system is a type of number system...

1 day ago

Dynamics 365 Business Central: Regarding the problem that input data cannot be saved (Note, Work Description, etc.)

Hi, Readers.In this post, I would like to share a very strange problem I saw recently, user-entered data cannot be saved in Business Central U...

2 days ago

Dynamics 365 Business Central: How to Copy Existing Customer to New Customer with Power Automate (Copy Customer)

Hi, Readers.Today I would like to talk about how to copy Existing Customer to New Customer with Power Automate. This is a problem I’ve seen in...

3 days ago

Dynamics 365 Business Central: How to set dimension via standard API and Can we do it via Power Automate?

Hi, Readers.Today I would like to briefly talk about how to set dimension via standard API and can we do it in Power Automate?Dimensions are v...

4 days ago

Dynamics 365 Business Central: Copy Comments from Customer to Sales Document – Customization

Hi, Readers.Today I would like to talk about how to copy Comments from Customer to Sales Document. As you might know, you can add extra inform...

7 days ago

Dynamics 365 Business Central: How to quickly get field length from table number and field number

Hi, Readers.Today I would like to share another mini tip about Business Central, how to quickly get field length from table number and field n...

8 days ago

Dynamics 365 Business Central: Set the default publisher when creating a new project

Hi, Readers.Today I would like to share another mini tip about Business Central, how to set the default publisher when creating a new project....

9 days ago

Dynamics 365 Business Central SaaS/Cloud W1 version: How to create an environment with all demo/sample data

If you're trying to create an environment with all demo/sample data in Business Central SaaS/Cloud W1 version, this tutorial will guide you th...

10 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy