Skip to Content
0
Former Member
Feb 22, 2011 at 08:34 AM

Asset Report in BW

243 Views

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