frappe / erpnext

Free and Open Source Enterprise Resource Planning (ERP)
https://erpnext.com
GNU General Public License v3.0
21.96k stars 7.36k forks source link

fix: patch (backport #44191) #44288

Closed mergify[bot] closed 10 hours ago

mergify[bot] commented 10 hours ago

Patch failing while migrating from v13 to v14


 File "/home/frappe/frappe-bench/apps/erpnext/erpnext/patches/v13_0/item_reposting_for_incorrect_sl_and_gl.py", line 61, in execute
    update_entries_after(
      doctypes_to_reload = [('setup', 'company'), ('stock', 'repost_item_valuation'), ('stock', 'stock_entry_detail'), ('stock', 'purchase_receipt_item'), ('stock', 'delivery_note_item'), ('stock', 'packed_item'), ('accounts', 'sales_invoice_item'), ('accounts', 'purchase_invoice_item'), ('buying', 'purchase_receipt_item_supplied'), ('subcontracting', 'subcontracting_receipt_item'), ('subcontracting', 'subcontracting_receipt_supplied_item')]
      module = 'subcontracting'
      doctype = 'subcontracting_receipt_supplied_item'
      reposting_project_deployed_on = datetime.datetime(2024, 11, 12, 9, 24, 36)
      posting_date = datetime.date(2024, 11, 12)
      posting_time = datetime.time(9, 24, 36)
      company_list = ['Arjuna']
      data = [{'name': 'MAT-SLE-2024-53213', 'item_code': 'Bird', 'warehouse': 'Bahan Baku - ARJ', 'voucher_type': 'Purchase Receipt', 'voucher_no': 'MAT-PRE-2024-00613', 'posting_date': datetime.date(2024, 11, 11), 'posting_time': datetime.timedelta(seconds=19246), 'company': 'Arjuna'}, {'name': 'MAT-SLE-2024-53223', 'item_code': 'BUMBU MARINASI GEPREKIN', 'warehouse': 'Bahan Penolong - ARJ', 'voucher_type': 'Stock Entry', 'voucher_no': 'MAT-STE-2024-02525', 'posting_date': datetime.date(2024, 11, 11), 'posting_time': datetime.timedelta(seconds=19625), 'company': 'Arjuna'}, {'name': 'MAT-SLE-2024-53221', 'item_code': 'Bird', 'warehouse': 'Bahan Baku - ARJ', 'voucher_type': 'Purchase Receipt', 'voucher_no': 'MAT-PRE-2024-00618', 'posting_date': datetime.date(2024, 11, 11), 'posting_time': datetime.timedelta(seconds=19797), 'company': 'Arjuna'}, {'name': 'MAT-SLE-2024-53228', 'item_code': 'Bird', 'warehouse': 'Bahan Baku - ARJ', 'voucher_type': 'Stock Entry', 'voucher_no': 'MAT-STE-2024-02527', 'pos...
      total_sle = 60
      i = 0
      d = {'name': 'MAT-SLE-2024-53213', 'item_code': 'Bird', 'warehouse': 'Bahan Baku - ARJ', 'voucher_type': 'Purchase Receipt', 'voucher_no': 'MAT-PRE-2024-00613', 'posting_date': datetime.date(2024, 11, 11), 'posting_time': datetime.timedelta(seconds=19246), 'company': 'Arjuna'}
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/stock/stock_ledger.py", line 359, in __init__
    self.build()
      self = <erpnext.stock.stock_ledger.update_entries_after object at 0x7fc6e0422890>
      args = {'item_code': 'Bird', 'warehouse': 'Bahan Baku - ARJ', 'posting_date': datetime.date(2024, 11, 11), 'posting_time': datetime.timedelta(seconds=19246), 'voucher_type': 'Purchase Receipt', 'voucher_no': 'MAT-PRE-2024-00613', 'sle_id': 'MAT-SLE-2024-53213'}
      allow_zero_rate = False
      allow_negative_stock = True
      via_landed_cost_voucher = False
      verbose = 1
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/stock/stock_ledger.py", line 407, in build
    self.process_sle_against_current_timestamp()
      self = <erpnext.stock.stock_ledger.update_entries_after object at 0x7fc6e0422890>
      future_sle_exists = <function future_sle_exists at 0x7fc6e00bbbe0>
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/stock/stock_ledger.py", line 428, in process_sle_against_current_timestamp
    sl_entries = self.get_sle_against_current_voucher()
      self = <erpnext.stock.stock_ledger.update_entries_after object at 0x7fc6e0422890>
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/stock/stock_ledger.py", line 435, in get_sle_against_current_voucher
    return frappe.db.sql(
      self = <erpnext.stock.stock_ledger.update_entries_after object at 0x7fc6e0422890>
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 244, in sql
    self._cursor.execute(query, values)
      self = <frappe.database.mariadb.database.MariaDBDatabase object at 0x7fc6e1538070>
      query = 'select\n\t\t\t\t*, posting_datetime as "timestamp"\n\t\t\tfrom\n\t\t\t\t`tabStock Ledger Entry`\n\t\t\twhere\n\t\t\t\titem_code = %(item_code)s\n\t\t\t\tand warehouse = %(warehouse)s\n\t\t\t\tand is_cancelled = 0\n\t\t\t\tand (\n\t\t\t\t\tposting_datetime = %(posting_datetime)s\n\t\t\t\t)\n\t\t\t\tand creation = %(creation)s\n\t\t\torder by\n\t\t\t\tcreation ASC\n\t\t\tfor update'

      conn = <pymysql.connections.Connection object at 0x7fc6e08df040>
builtins.KeyError: 'creation'
```<hr>This is an automatic backport of pull request #44191 done by [Mergify](https://mergify.com).
rohitwaghchaure commented 10 hours ago

@mergifyio backport version-14

mergify[bot] commented 10 hours ago

backport version-14

✅ Backports have been created

* [#44289 fix: patch (backport #44191) (backport #44288)](https://github.com/frappe/erpnext/pull/44289) has been created for branch `version-14`