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
