Asset Location Report

ERPNext Accounting
1

Hi,

We constantly move our assets from one location to another as we have lots of tools and machinery. Is there any way to see where all my assets are located and filter it? like we do for stock report with warehouse.

2

Hi @rishabh421

Here is the custom SQL Report;

SELECT
DATE_FORMAT(tabAsset Movement.transaction_date, ‘%%Y-%%m-01’) AS “Date:Date:120”,
tabAsset.asset_name AS “Asset Name:Data:200”,
tabAsset.location AS “Location:Link/Location:150”,
tabAsset.custodian AS “Custodian:Link/Employee:150”,
tabAsset.department AS “Department:Link/Department:150”,
tabAsset Movement Item.source_location AS “Source Location:Link/Location:150”,
tabAsset Movement Item.target_location AS “Target Location:Link/Location:150”,
tabAsset.status AS “Status:Data:120”,
tabAsset Movement Item.from_employee AS “From Employee:Link/Employee:150”,
tabAsset Movement Item.to_employee AS “To Employee:Link/Employee:150”

FROM
tabAsset AS tabAsset

INNER JOIN
tabAsset Movement Item AS tabAsset Movement Item
ON tabAsset.name = tabAsset Movement Item.asset

INNER JOIN
tabAsset Movement AS tabAsset Movement
ON tabAsset Movement Item.parent = tabAsset Movement.name

WHERE
tabAsset.docstatus = 1

ORDER BY
tabAsset Movement.transaction_date DESC