You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Duplicate lines in Fixed Asset Depreciation report

Incorrect Answer
85
Views
2
Comments
edited Feb 17, 2023 2:28PM in Reporting and Analytics for ERP 2 comments

I've created a simple analysis that pulls the depreciation details from the application and presents it in an overview.

Here is the analysis XML:

There's an issue where some (not all) assets show a duplicate line if they are completely depreciated.

Here is an example of two assets where this issue occurs:

We only want to see the rows where Beginning/Ending NBV is not both zero. Though there is also other rows where this is the case, which we want to keep (they are not duplicated).

Here is an asset that should behave in the same way, but does not show the duplication:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!