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: About the automatic filtering problem after using Page.SetSelectionFilter Method

Hi, Readers.Today I would like to briefly share a question I saw yesterday in the Dynamics 365 Community, Page – Filter Reset – af...

15 hours ago

Dynamics 365 Business Central: Publish without debugging (Ctrl+F5) and Debug without publishing (Ctrl+Shift+F5)

Hi, Readers.Today I would like to share a mini tip about Business Central development, Publish without debugging (Ctrl+F5) and Debug without p...

1 day ago

Cumulative Update Summary for Microsoft Dynamics 365 Business Central(July, 2024)

Cumulative Update (July, 2024) for Microsoft Dynamics 365 Business Central is now released. BC24: Released Updates for Microsoft Dynamics 365 ...

2 days ago

Dynamics 365 Business Central: How to get the full version text in Help & Support via AL (Record daily version information)

Hi, Readers.Today I would like to talk about an interesting topic, how to get the full version text in Help & Support via AL.From the Help...

3 days ago

How to delete Incoming Document Records from Posted Documents in Dynamics 365 Business Central

Hi, Readers.Today I would like to talk about a simple topic, how to delete Incoming Document Records from Posted Documents in Dynamics 365 Bus...

4 days ago

Dynamics 365 Business Central: How to check BaseApp version via AL (Include First-party localization)

Hi, Readers.In Dynamics 365 Business Central: Countries/regions where Microsoft provides the regulatory compliance and other local functionali...

7 days ago

Dynamics 365 Business Central Online: Endpoints for the APIs (V1.0, V2.0, Beta, custom, automation……)

Hi, Readers.Today I would like to briefly summarize the endpoints of the various APIs in Business Central. I sometimes see questions where dat...

8 days ago

Dynamics 365 Business Central: How to delete Comment Lines when combining receipts on a single invoice (Get Receipt Lines)

Hi, Readers.Today I would like to briefly talk about in the Dynamics 365 Community, how to delete Comment Lines when combining receipts o...

9 days ago

Dynamics 365 Business Central: Can we modify/extend the standard Flowfields???

Hi, Readers.As you know, the FlowFields are used extensively in standard codes. This is a very powerful feature in Business Central and NAV.Fl...

10 days ago

Dynamics 365 Business Central: How to copy/flow Links and Notes from Sales order to Warehouse shipment

Hi, Readers.Today I would like to briefly talk about how to copy/flow Links and Notes from Sales order to Warehouse shipment in Business ...

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