Dear All,
I need a help in Developing a BW report, required the functional logic for the same,
The report format will be as follows
1. Asset
Asset Class / Opening balance / Additions / Retirement / Closing Balance
Debit bal Credit Bal
2. Accumulated Depreciation
AssetClass / Opening Balance / Additions / Retirement / Closing Balance
Credit Bal Debit Bal
This i can get from GL balances table , but the same has to be mapped using Asset Module , when i checked the tables i stuck up in matching the GL debit and credit with respect to Accumulated Depreciation.
I used Transaction Types, to differentiate Debit and credit for Accumulated depreciation , but i was not able to match the GL balance.
Can somebody throw some light on the above requirement.
thanks and regards