Report question, merge assets and contract details
hi
i recently ran into the problem where i wanted to see all my sim card, and their contract details
when running an asset report i can get the contract name and contract vendor listed but not the contract expiry date
when running a contract report i can get the contract name, vendor and the start and end date but not the actual asset it is covering
i am not a sql wizz so have no idea how to do a custom sql query to achieve this but IMHO this should be part of either the contract reports or asset reports.
it would make live so much easier
i know that i could put the conract expiry date in the expiry column of the assets but this would mean additional data input which is fine if you have 10 or 20 entries but not if you have hundreds
is there anyone else who had this problem and was able to solve it?
many thanks
elbutre
i recently ran into the problem where i wanted to see all my sim card, and their contract details
when running an asset report i can get the contract name and contract vendor listed but not the contract expiry date
when running a contract report i can get the contract name, vendor and the start and end date but not the actual asset it is covering
i am not a sql wizz so have no idea how to do a custom sql query to achieve this but IMHO this should be part of either the contract reports or asset reports.
it would make live so much easier
i know that i could put the conract expiry date in the expiry column of the assets but this would mean additional data input which is fine if you have 10 or 20 entries but not if you have hundreds
is there anyone else who had this problem and was able to solve it?
many thanks
elbutre