Fixed Asset Register

Fixed Asset Register

Hello,

I would like some help with a report that can be used as a fixed asset register:

The columns should be

User (user)
Asset Name (assName)
CI Type (ciType)
Serial Number (sNum)
Service Tag (sTag) (As we use Dell machines)
Invoice Number (iNum)
Purchase Price (purPrice)
Depreciation Period (depPeriod)
Current Value (curValue)

The idea would be that the report should look like this

user        assName      iType      sNum     sTag     iNum   purPrice  depPeriod  curValue
Han SL   Monitor01     Monitor    AA11                   01      200           36               50
Han SL   Monitor02     Monitor    AB12                   01      200           36               50
Han SL   host01          Worksta               5CH7YL   01     1500          36               1000
Yoda      Monitor03     Monitor   AC12                    02      200           36               50    

I would appreciated some help.

Thanks,     
              New to ADManager Plus?

                New to ADSelfService Plus?