feat: add patch
(cherry picked from commit fc65a3d9895c8ba9de957da820ed6b59c6c1bcbd)
# Conflicts:
# erpnext/patches.txt
diff --git a/erpnext/patches.txt b/erpnext/patches.txt
index 5a8f8ef..5f95e13 100644
--- a/erpnext/patches.txt
+++ b/erpnext/patches.txt
@@ -324,6 +324,7 @@
execute:frappe.delete_doc_if_exists('Workspace', 'ERPNext Integrations Settings')
erpnext.patches.v14_0.set_payroll_cost_centers
erpnext.patches.v13_0.agriculture_deprecation_warning
+<<<<<<< HEAD
erpnext.patches.v13_0.hospitality_deprecation_warning
erpnext.patches.v13_0.update_exchange_rate_settings
erpnext.patches.v13_0.update_asset_quantity_field
@@ -342,3 +343,6 @@
erpnext.patches.v13_0.update_sane_transfer_against
erpnext.patches.v12_0.add_company_link_to_einvoice_settings
erpnext.patches.v14_0.migrate_cost_center_allocations
+=======
+erpnext.patches.v13_0.set_billed_amount_in_returned_dn
+>>>>>>> fc65a3d989 (feat: add patch)
diff --git a/erpnext/patches/v13_0/set_billed_amount_in_returned_dn.py b/erpnext/patches/v13_0/set_billed_amount_in_returned_dn.py
new file mode 100644
index 0000000..1f86c76
--- /dev/null
+++ b/erpnext/patches/v13_0/set_billed_amount_in_returned_dn.py
@@ -0,0 +1,22 @@
+# Copyright (c) 2022, Frappe and Contributors
+# License: GNU General Public License v3. See license.txt
+
+import frappe
+
+from erpnext.stock.doctype.delivery_note.delivery_note import update_billed_amount_based_on_so
+
+
+def execute():
+ dn_item = frappe.qb.DocType('Delivery Note Item')
+
+ so_detail_list = (frappe.qb.from_(dn_item)
+ .select(dn_item.so_detail)
+ .where(
+ (dn_item.so_detail.notnull()) &
+ (dn_item.so_detail != '') &
+ (dn_item.docstatus == 1) &
+ (dn_item.returned_qty > 0)
+ )).run()
+
+ for so_detail in so_detail_list:
+ update_billed_amount_based_on_so(so_detail[0], False)
\ No newline at end of file