diff --git a/erpnext/patches/v15_0/create_asset_depreciation_schedules_from_assets.py b/erpnext/patches/v15_0/create_asset_depreciation_schedules_from_assets.py
index 749225c..9ec7537 100644
--- a/erpnext/patches/v15_0/create_asset_depreciation_schedules_from_assets.py
+++ b/erpnext/patches/v15_0/create_asset_depreciation_schedules_from_assets.py
@@ -62,7 +62,7 @@
 			afb.rate_of_depreciation,
 			afb.expected_value_after_useful_life,
 		)
-		.where((afb.parenttype == "Asset") & (afb.parent == asset_name))
+		.where(afb.parent == asset_name)
 	).run(as_dict=True)
 
 	return records
@@ -75,6 +75,7 @@
 		frappe.qb.from_(ds)
 		.select(ds.name)
 		.where((ds.parent == asset_name) & (ds.finance_book_id == str(fb_row_idx)))
+		.orderby(ds.idx)
 	).run(as_dict=True)
 
 	for idx, depr_schedule in enumerate(depr_schedules, start=1):