how to generate Fixed assets listing using Query generator?

[Former Member]

Hi

I'm new to query generator. I'm currently using v9.0 and would like to generate a fixed asset listing for the company and it's monthly depreciation amount

Pls advise. thanks!

Regards,

Claudia

[former_member212181 · Accepted solution]

Hi,

Have you tried "Asset Depreciation Forecast Report"??

Thanks

Unnikrishnan

[Former Member · Accepted solution]

Hi Unnikrishnan

Thanks! is there a report for the entire FA listing?

Claudia

[former_member212181 · Accepted solution]

Hi Claudia,

For that you can use query.

SELECT * FROM OITM T0 WHERE T0.[ItemType] ='F'

Please make necessary changes in Select area.

Thanks

Unnikrishnan

[former_member212181 · Accepted solution]

Hi,

Please try below query

SELECT T0.ItemCode, T0.ItemName

  , case T0.AsstStatus

  when 'A' then 'Active'

  when 'N' then 'New'

  when 'I' then 'Inactive'

  Else 'Others' end [Asset Status]

  , T0.AssetClass, T0.AssetGroup, T0.DeprGroup

  , T0.InventryNo, T0.AssetSerNo

  , T1.Location, T0.CapDate

FROM OITM T0

  Left Outer JOIN OLCT T1 ON T0.Location = T1.Code

WHERE T0.ItemType ='F'

Thanks

Unnikrishnan

Message was edited by: Unnikrishnan Balan