FA extraction to display cost and accum dep by gl code combination
I am interested to extract data showing the costs and accum dep by gl code combination.
purpose: to reconcile data in FA against GL
I tried using the data from FA_AEL_GL_V and linked to gl_code_combinations however this table does not capture information on Accum Dep when assets are manually entered into FA module with Accum Dep amount as the Accum Dep does not transfer to GL.
Information required;
1. Code combination by segment
2. amount (cost and accum dep)
I know the seeded report "General Ledger Reserve Report" has the information but this report is too complicated to be re-customised.