Finance | Project Operations, Human Resources, ...

Total amount gets summed even when there is only one record

(0) Share

Report

Posted on by Community Member

Hi. i am a beginner in AX. i have been working on a bug which is related to Fixed asset where some customization have been done. On generating the fixed asset statement report, the total amount for the asset type ( in this case , vehicle ) is getting added twice even when there is only one record () in that asset type. Whereas for Computers, it is working fine. Can anyone help me on finding out whats the issue here?

Thanks in advance.

All responses (6)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Total amount gets summed even when there is only one record

Good Morning AdithyaArvind97,

What is the name of that report?

Do you have the system name or can you share the navigation path to it?

In addition, can you let us know your system version?

What would also be good to know is the country/region for which this system is operated as there are a number of local fixed asset reports available.

Best regards,

Ludwig
Suggested answer

SouravDam 11,723 on at

Like (0)

Report

RE: Total amount gets summed even when there is only one record

Hello AdithyaArvind97,

Please check if there is any acquisition adjustment made for asset VEHC-000009 in the current year or not.

If yes; then also you need to check with the developer to segregate the values based on the transaction date as it looks like (as per your explanation) both current year and previous year acquisition values are showing in one column which is wrong.

For depreciation also; no separate column is maintained which doesn't look good too.

In a nutshell; please discuss with the developer who built this report to understand the logic applied here.

Question is -- why don't you use the standard Fixed asset balances report available in FA module?

This standard one will give you more details compared to what I can see in this customized report.

You can also check for Fixed assets roll forward report if the electronic reporting is already configured for this.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.
Community Member on at

Like (0)

Report

RE: Total amount gets summed even when there is only one record

Hi Sourav,

Thanks for helping out.

Actually, "VEHC" is the asset group inside which we have VEHC-000009 asset. Similarly, "Computers" is the asset group inside which we have assets COMP-000202 and COMP-000203.

For computers, it is displaying the sum of net amounts of COMP-000202 and COMP-000203.

For VEHC, we have only one asset VEHC-000009 for which the net total is 10,000 but for asset group, it adds the amounts another time and then displays it.
Suggested answer

SouravDam 11,723 on at

Like (0)

Report

RE: Total amount gets summed even when there is only one record

Hello AdithyaArvind97,

As I mentioned before; my understanding on this customized report is as per the following.

--- All these "Net" lines are showing the net balance of first 2 lines which are 'Aqu' and 'Dep'.

Let's say; for 1st and 2nd lines; acquisition is showing 10000.00 and 20000.00 and depreciation -274.20 and -548.40 respectively.

The same is also showing as "Net" balance in the 3rd line.

Now; just because this is a customized report; therefore appreciate if you can check with the concerned developer who built this report and he/she will be able to explain you more precisely what was the requirement from the client which is covered in this report; what logic is used and what are the field values mapped to display the values in this report.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.
Community Member on at

Like (0)

Report

RE: Total amount gets summed even when there is only one record

Hi Sourav,

Thanks for the reply.

As i checked in the transactions of the particular fixed asset, there is only one acquisition transaction happened in the previous year . No acquisition has been happened current year which means the net acquisition should be 10,000 only? why is it getting summed again?
Suggested answer

SouravDam 11,723 on at

Like (0)

Report

RE: Total amount gets summed even when there is only one record

Hello AdithyaArvind97,

Even though this is a customized report; I don't see any difference here.

The screenshot what you send, is showing the NET balance in the 3rd line which is showing the net acquisition and depreciation balances from first 2 lines.

And the last column is showing the actual net balance (Acquisition - Depreciation) of that fixed asset.

And for rest of the lines; there is no acquisitions made in the prior year and no depreciation also recorded except the current year's acquisition; therefore it is showing the Net balance accordingly.

Is there any gap in understanding?

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.