5
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?
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
Thank you, but which of these reports summarizes the total of a main asset with all its 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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,532
Super User 2024 Season 2
#2
Martin Dráb
228,501
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (