Small and medium business | Business Central, N...

Report to show total of Main Asset and Components

(0) Share

Report

Posted on by esgmaximus

So I know that if you select "Main Asset Statistics" from an asset card you can get an acquisition cost summary of the Main and Component assets. But is there a report where you could run several Main asset numbers and get the acquisition cost sum of each of them with all their components? So sum total per family so to speak?

All responses (3)

Answers (0)

Suggested answer

DAnny3211 9,272 Super User 2024 Season 1 on at

Like (0)

Report

RE: Report to show total of Main Asset and Components

hi

it is possible to create a report in Dynamics NAV (now called Dynamics 365 Business Central) that can give you the acquisition cost sum of each Main asset and its components.

Here are the general steps to achieve this:

Create a new report in the Microsoft Dynamics NAV Development Environment.

Define the report's dataset by adding the necessary tables and fields. For example, you could use the Asset table to retrieve the Main asset and its Component assets, and the Value Entry table to retrieve the acquisition cost for each asset.

Write a codeunit that calculates the sum total of the acquisition cost for each Main asset and its components. You can use the Sum function in the C/AL language to calculate the total acquisition cost.

In the report's layout, create a table that displays the Main asset numbers and their corresponding acquisition cost totals.

Optionally, you can add filters to the report to enable the user to filter the report results by specific Main asset numbers or other criteria.

Once you have created the report, you can run it to get the acquisition cost sum of each Main asset and its components. The report will display the total acquisition cost for each Main asset, including the cost of its components.

Note that the specific steps to create this report may vary depending on the version of Dynamics NAV that you are using, as well as any customization or modifications that have been made to your system.

DAniele
esgmaximus 5 on at

Like (0)

Report

RE: Report to show total of Main Asset and Components

Thank you, but which of these reports summarizes the total of a main asset with all its components?
Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (0)

Report

RE: Report to show total of Main Asset and Components

Hi, I'm not sure if it's the same in NAV, the following is the standard Fixed Assets Reports and Analytics, hope it helps.

https://learn.microsoft.com/en-us/dynamics365/business-central/fa-reports

Customization may be required if the standard does not meet the needs.

Hope this helps.

Thanks.

ZHU