HowTo #097

How to quickly create an overview of items and their data?

Use Case:

During daily business, there is often the need to gather structured information about items and their data quickly. You might need to compare several items which each other or you might need to consult the same information on a regular basis, such as sold quantities during a certain period, or forecasted requirements during the next couple of months.

Getting the needed information from Business Central can be time-consuming and even tedious, as most of that information is saved in different tables and pages.

Let’s have a look at how this can be done more quickly!

HowTo: Set up and use the Item Overview

01

Open Item Overview Setup.

02

In the page that opens, you can specify filters on a date range, using Business Centrals standard date formulas in the General FastTab.

03

In the Location Filters FastTab, you can select the Locations you would like to filter on. To make the names of the Locations more self-explanatory, you can also change their captions in the Location Filter Caption fields.

04

Once you are happy with all the filters, open Item Overview.

05

The Item Overview gives you plenty more filtering options in the header of the page, such as Item Numbers and Categories.

Extra tip: The filters that are set in the Item Overview Setup will be applied to all Item Overview pages you open.
06

In the bottom section of the page, click on Calculate Item Overview to refresh it with the latest information. This step is necessary every time you use the page to make sure the latest data is displayed.

07

A wide range of data is available, so make sure to browse the options by scrolling to the right and also check for fields that are hidden and can be personalized.

Extra tip: You can also create and save filters using the Filter icon in the top right corner. BC’s Analysis Mode can be used, too, to get an even clearer overview of the displayed data!
Conclusion

Using the Item Overview provides a quick and flexible way to bring together key item information from across Business Central. By defining reusable filters, users can compare items, review quantities and requirements, and access relevant information in one place. As a result, recurring analysis becomes faster and less tedious.

    Feature of the Week

    No ads: A new HowTo for acadon Software every week.

    Wood be nice to have

    You have an idea for a new function or feature?

    Only for acadon customers

    OnRoute App
    Try our new OnRoute app free for 30 days!
    timber tree
    timber tree
    acadon logo
    The acadon AG has 40 years of experience in ERP software for the wood industry. As business optimizers, we develop tailored solutions and strategies for your company.
    © 2024 acadon AG. All rights reserved.

    Request consultation now!

    Webinar registration

    Request free demo now!