Retrieve Ending Balances of asset cost, accumulated depreciation, impairment reserve until the selec

Summary

Issue - When referred to the Asset Balances Register report category total values there's an imbalance with the amounts in the developed OTBI .

Content

Hi all,

I have a requirement to retrieve ending balances of cost, accumulated depreciation, impairment reserve by asset Major Category wise.

For that I have developed an OTBI report using the "Fixed Assets - Assets Balances Real Time"  subject area with the below columns;

1. Asset Book
2. Segment 1 (Major Category)
3. Ending Balance
4. Impairments
5. Depreciation
6. Asset Calendar Period Name (Time)

The issue is that when referred to the Asset Balances Register report category total values there's an imbalance with the amounts in the developed OTBI .​