Bonjour,
J’ai un message d’erreur lors d’un rapprochement bancaire :
pymysql.err.OperationalError: (1054, « Unknown column ‹ clearance_date › in ‹ field list › »)
J’essaie de rapprocher une transaction bancaire avec 4 factures de ventes gérérée à partir du point de vente:
Voici le détail de l’erreur, pourriez-vous m’aider ?
Je vous remercie.
App Versions
{
"erpnext": "3.36.0",
"frappe": "3.38.0",
"payments": "1.2.1"
}
Route
bank-reconciliation
Traceback
Traceback (most recent call last):
File "apps/frappe/frappe/app.py", line 66, in application
response = frappe.api.handle()
File "apps/frappe/frappe/api.py", line 53, in handle
return _RESTAPIHandler(call, doctype, name).get_response()
File "apps/frappe/frappe/api.py", line 69, in get_response
return self.handle_method()
File "apps/frappe/frappe/api.py", line 79, in handle_method
return frappe.handler.handle()
File "apps/frappe/frappe/handler.py", line 47, in handle
data = execute_cmd(cmd)
File "apps/frappe/frappe/handler.py", line 85, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File "apps/frappe/frappe/__init__.py", line 1638, in call
return fn(*args, **newargs)
File "apps/erpnext/erpnext/accounts/page/bank_reconciliation/bank_reconciliation.py", line 34, in reconcile
bank_reconciliation.reconcile()
File "apps/erpnext/erpnext/accounts/page/bank_reconciliation/bank_reconciliation.py", line 109, in reconcile
self.reconcile_one_transaction_with_multiple_documents()
File "apps/erpnext/erpnext/accounts/page/bank_reconciliation/bank_reconciliation.py", line 158, in reconcile_one_transaction_with_multiple_documents
bank_transaction.save()
File "apps/frappe/frappe/model/document.py", line 322, in save
return self._save(*args, **kwargs)
File "apps/frappe/frappe/model/document.py", line 396, in _save
self.run_post_save_methods()
File "apps/frappe/frappe/model/document.py", line 1158, in run_post_save_methods
self.run_method("on_update_after_submit")
File "apps/frappe/frappe/model/document.py", line 979, in run_method
out = Document.hook(fn)(self, *args, **kwargs)
File "apps/frappe/frappe/model/document.py", line 1348, in composer
return composed(self, method, *args, **kwargs)
File "apps/frappe/frappe/model/document.py", line 1330, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File "apps/frappe/frappe/model/document.py", line 976, in fn
return method_object(*args, **kwargs)
File "apps/erpnext/erpnext/accounts/doctype/bank_transaction/bank_transaction.py", line 43, in on_update_after_submit
self.set_payment_entries_clearance_date()
File "apps/erpnext/erpnext/accounts/doctype/bank_transaction/bank_transaction.py", line 222, in set_payment_entries_clearance_date
self.set_header_clearance_date(payment_entry, clear)
File "apps/erpnext/erpnext/accounts/doctype/bank_transaction/bank_transaction.py", line 228, in set_header_clearance_date
frappe.db.set_value(
File "apps/frappe/frappe/database/database.py", line 923, in set_value
query.run(debug=debug)
File "apps/frappe/frappe/query_builder/utils.py", line 86, in execute_query
return frappe.db.sql(query, params, *args, **kwargs) # nosemgrep
File "apps/frappe/frappe/database/database.py", line 225, in sql
self._cursor.execute(query, values)
File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 1157, in read
first_packet = self.connection._read_packet()
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "env/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "env/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, "Unknown column 'clearance_date' in 'field list'")
Request Data
{
"type": "POST",
"args": {
"bank_transactions": "[{\"name\":\"ACC-BTN-2023-00016\",\"date\":\"2023-06-27\",\"currency\":\"EUR\",\"debit\":0,\"credit\":225.97,\"description\":\"VIR SEPA Sumup Limited | SUMUP PID312537 PAYOUT 270623\",\"allocated_amount\":0,\"unallocated_amount\":225.97,\"bank_account\":\"Crédit coopératif\",\"amount\":225.97,\"link\":\"/app/Form/Bank Transaction/ACC-BTN-2023-00016\",\"vgt_id\":0,\"originalIndex\":1,\"vgtSelected\":true}]",
"documents": "[{\"name\":\"ACC-SINV-2023-00203\",\"creation\":\"2023-06-25 12:03:26.604456\",\"modified\":\"2023-06-25 12:03:28.535112\",\"modified_by\":\"gestionbar@lagaloche.fr\",\"owner\":\"gestionbar@lagaloche.fr\",\"docstatus\":1,\"parent\":null,\"parentfield\":null,\"parenttype\":null,\"idx\":0,\"title\":\"Bar La Galoche\",\"naming_series\":\"ACC-SINV-.YYYY.-\",\"customer\":\"Bar La Galoche\",\"customer_name\":\"Bar La Galoche\",\"tax_id\":null,\"pos_profile\":\"Vente La Galoche\",\"is_pos\":1,\"is_consolidated\":1,\"is_return\":0,\"update_billed_amount_in_sales_order\":0,\"is_down_payment_invoice\":0,\"company\":\"La Galoche\",\"company_tax_id\":null,\"posting_date\":\"2023-06-25\",\"posting_time\":\"12:01:49\",\"set_posting_time\":1,\"due_date\":\"2023-06-25\",\"return_against\":null,\"amended_from\":null,\"down_payment_against\":null,\"project\":null,\"cost_center\":\"Principal - LG\",\"po_no\":\"\",\"po_date\":null,\"customer_address\":null,\"address_display\":null,\"contact_person\":\"Bar La Galoche-1-Bar La Galoche\",\"contact_display\":\"Bar La Galoche\",\"contact_mobile\":\"\",\"contact_email\":\"gestionbar@lagaloche.fr\",\"territory\":\"Tous les Territoires\",\"shipping_address_name\":\"\",\"shipping_address\":null,\"company_address\":null,\"company_address_display\":null,\"currency\":\"EUR\",\"conversion_rate\":1,\"selling_price_list\":\"Vente Standard\",\"price_list_currency\":\"EUR\",\"plc_conversion_rate\":1,\"ignore_pricing_rule\":1,\"set_warehouse\":\"La Galoche - LG\",\"set_target_warehouse\":null,\"update_stock\":1,\"scan_barcode\":null,\"total_billing_amount\":0,\"total_qty\":14,\"base_total\":35.5,\"base_net_total\":35.5,\"total_net_weight\":0,\"total\":35.5,\"net_total\":35.5,\"taxes_and_charges\":null,\"shipping_rule\":null,\"tax_category\":\"\",\"other_charges_calculation\":null,\"base_total_taxes_and_charges\":0,\"total_taxes_and_charges\":0,\"loyalty_points\":0,\"loyalty_amount\":0,\"redeem_loyalty_points\":0,\"loyalty_program\":null,\"loyalty_redemption_account\":null,\"loyalty_redemption_cost_center\":null,\"apply_discount_on\":\"Grand Total\",\"base_discount_amount\":0,\"additional_discount_percentage\":0,\"discount_amount\":0,\"base_grand_total\":35.5,\"base_rounding_adjustment\":0,\"base_rounded_total\":35.5,\"base_in_words\":\"Trente Cinq Euro et Cinquante Centime\",\"grand_total\":35.5,\"rounding_adjustment\":0,\"rounded_total\":35.5,\"in_words\":\"Trente Cinq Euro et Cinquante Centime\",\"total_advance\":0,\"outstanding_amount\":0,\"disable_rounded_total\":0,\"allocate_advances_automatically\":0,\"payment_terms_template\":\"\",\"cash_bank_account\":null,\"base_paid_amount\":35.5,\"unreconciled_amount\":35.5,\"paid_amount\":35.5,\"base_change_amount\":0,\"change_amount\":0,\"account_for_change_amount\":\"5314 - Caisse en devises - LG\",\"write_off_amount\":0,\"base_write_off_amount\":0,\"write_off_outstanding_amount_automatically\":1,\"write_off_account\":\"654 - Pertes sur créances irrécouvrables - LG\",\"write_off_cost_center\":\"Principal - LG\",\"tc_name\":null,\"terms\":null,\"letter_head\":null,\"group_same_items\":0,\"select_print_heading\":null,\"language\":\"fr\",\"inter_company_invoice_reference\":null,\"is_internal_customer\":0,\"represents_company\":null,\"customer_group\":\"Tous les Groupes Client\",\"campaign\":null,\"is_discounted\":0,\"status\":\"Paid\",\"source\":null,\"external_reference\":null,\"debit_to\":\"411 - Clients - LG\",\"party_account_currency\":\"EUR\",\"is_opening\":\"No\",\"c_form_applicable\":null,\"c_form_no\":null,\"unrealized_profit_loss_account\":null,\"remarks\":\"Facture de vente: ACC-SINV-2023-00203 / Client: Bar La Galoche\",\"sales_partner\":null,\"commission_rate\":0,\"total_commission\":0,\"from_date\":null,\"to_date\":null,\"subscription\":null,\"auto_repeat\":null,\"against_income_account\":\"707 - Ventes de marchandises - LG,7569 - Cotisation caisse - LG\",\"_user_tags\":null,\"_comments\":null,\"_assign\":null,\"_liked_by\":null,\"_seen\":\"[\\\"gestionbar@lagaloche.fr\\\"]\",\"_submitted\":\"2023-06-25 12:03:27.356611\",\"_submitted_by\":\"gestionbar@lagaloche.fr\",\"_seal\":\"60552e8d8cc12398d6222c1d379d8eba39e67bb92d573592b2ef1a65bc3f56cf\",\"_draft_name\":null,\"is_debit_note\":0,\"total_billing_hours\":0,\"is_cash_or_non_trade_discount\":0,\"additional_discount_account\":null,\"ignore_default_payment_terms_template\":0,\"amount_eligible_for_commission\":35.5,\"incoterm\":null,\"named_place\":null,\"_printed\":null,\"accounting_journal\":null,\"amount\":35.5,\"party\":\"Bar La Galoche\",\"reference_date\":\"2023-06-25\",\"reference_string\":\"ACC-SINV-2023-00203: Facture de vente: ACC-SINV-2023-00203 / Client: Bar La Galoche\",\"date\":\"2023-06-25\",\"doctype\":\"Sales Invoice\",\"link\":\"/app/Form/Sales Invoice/ACC-SINV-2023-00203\",\"vgt_id\":0,\"originalIndex\":20,\"vgtSelected\":true},{\"name\":\"ACC-SINV-2023-00200\",\"creation\":\"2023-06-24 19:03:46.804146\",\"modified\":\"2023-06-24 19:03:49.066503\",\"modified_by\":\"gestionbar@lagaloche.fr\",\"owner\":\"gestionbar@lagaloche.fr\",\"docstatus\":1,\"parent\":null,\"parentfield\":null,\"parenttype\":null,\"idx\":0,\"title\":\"Bar La Galoche\",\"naming_series\":\"ACC-SINV-.YYYY.-\",\"customer\":\"Bar La Galoche\",\"customer_name\":\"Bar La Galoche\",\"tax_id\":null,\"pos_profile\":\"Vente La Galoche\",\"is_pos\":1,\"is_consolidated\":1,\"is_return\":0,\"update_billed_amount_in_sales_order\":0,\"is_down_payment_invoice\":0,\"company\":\"La Galoche\",\"company_tax_id\":null,\"posting_date\":\"2023-06-24\",\"posting_time\":\"18:58:31\",\"set_posting_time\":1,\"due_date\":\"2023-06-24\",\"return_against\":null,\"amended_from\":null,\"down_payment_against\":null,\"project\":null,\"cost_center\":\"Principal - LG\",\"po_no\":\"\",\"po_date\":null,\"customer_address\":null,\"address_display\":null,\"contact_person\":\"Bar La Galoche-1-Bar La Galoche\",\"contact_display\":\"Bar La Galoche\",\"contact_mobile\":\"\",\"contact_email\":\"gestionbar@lagaloche.fr\",\"territory\":\"Tous les Territoires\",\"shipping_address_name\":\"\",\"shipping_address\":null,\"company_address\":null,\"company_address_display\":null,\"currency\":\"EUR\",\"conversion_rate\":1,\"selling_price_list\":\"Vente Standard\",\"price_list_currency\":\"EUR\",\"plc_conversion_rate\":1,\"ignore_pricing_rule\":1,\"set_warehouse\":\"La Galoche - LG\",\"set_target_warehouse\":null,\"update_stock\":1,\"scan_barcode\":null,\"total_billing_amount\":0,\"total_qty\":22,\"base_total\":46.5,\"base_net_total\":46.5,\"total_net_weight\":0,\"total\":46.5,\"net_total\":46.5,\"taxes_and_charges\":null,\"shipping_rule\":null,\"tax_category\":\"\",\"other_charges_calculation\":null,\"base_total_taxes_and_charges\":0,\"total_taxes_and_charges\":0,\"loyalty_points\":0,\"loyalty_amount\":0,\"redeem_loyalty_points\":0,\"loyalty_program\":null,\"loyalty_redemption_account\":null,\"loyalty_redemption_cost_center\":null,\"apply_discount_on\":\"Grand Total\",\"base_discount_amount\":0,\"additional_discount_percentage\":0,\"discount_amount\":0,\"base_grand_total\":46.5,\"base_rounding_adjustment\":0,\"base_rounded_total\":46.5,\"base_in_words\":\"Quarante Six Euro et Cinquante Centime\",\"grand_total\":46.5,\"rounding_adjustment\":0,\"rounded_total\":46.5,\"in_words\":\"Quarante Six Euro et Cinquante Centime\",\"total_advance\":0,\"outstanding_amount\":0,\"disable_rounded_total\":0,\"allocate_advances_automatically\":0,\"payment_terms_template\":\"\",\"cash_bank_account\":null,\"base_paid_amount\":46.5,\"unreconciled_amount\":46.5,\"paid_amount\":46.5,\"base_change_amount\":0,\"change_amount\":0,\"account_for_change_amount\":\"5314 - Caisse en devises - LG\",\"write_off_amount\":0,\"base_write_off_amount\":0,\"write_off_outstanding_amount_automatically\":1,\"write_off_account\":\"654 - Pertes sur créances irrécouvrables - LG\",\"write_off_cost_center\":\"Principal - LG\",\"tc_name\":null,\"terms\":null,\"letter_head\":null,\"group_same_items\":0,\"select_print_heading\":null,\"language\":\"fr\",\"inter_company_invoice_reference\":null,\"is_internal_customer\":0,\"represents_company\":null,\"customer_group\":\"Tous les Groupes Client\",\"campaign\":null,\"is_discounted\":0,\"status\":\"Paid\",\"source\":null,\"external_reference\":null,\"debit_to\":\"411 - Clients - LG\",\"party_account_currency\":\"EUR\",\"is_opening\":\"No\",\"c_form_applicable\":null,\"c_form_no\":null,\"unrealized_profit_loss_account\":null,\"remarks\":\"Facture de vente: ACC-SINV-2023-00200 / Client: Bar La Galoche\",\"sales_partner\":null,\"commission_rate\":0,\"total_commission\":0,\"from_date\":null,\"to_date\":null,\"subscription\":null,\"auto_repeat\":null,\"against_income_account\":\"707 - Ventes de marchandises - LG,7569 - Cotisation caisse - LG,7713 - Libéralités reçues - LG\",\"_user_tags\":null,\"_comments\":null,\"_assign\":null,\"_liked_by\":null,\"_seen\":\"[\\\"gestionbar@lagaloche.fr\\\"]\",\"_submitted\":\"2023-06-24 19:03:47.838854\",\"_submitted_by\":\"gestionbar@lagaloche.fr\",\"_seal\":\"e3491fae138d76003b60729cdc1986e158cd806e5c2baef9ad5e034ea1e57972\",\"_draft_name\":null,\"is_debit_note\":0,\"total_billing_hours\":0,\"is_cash_or_non_trade_discount\":0,\"additional_discount_account\":null,\"ignore_default_payment_terms_template\":0,\"amount_eligible_for_commission\":46.5,\"incoterm\":null,\"named_place\":null,\"_printed\":null,\"accounting_journal\":null,\"amount\":46.5,\"party\":\"Bar La Galoche\",\"reference_date\":\"2023-06-24\",\"reference_string\":\"ACC-SINV-2023-00200: Facture de vente: ACC-SINV-2023-00200 / Client: Bar La Galoche\",\"date\":\"2023-06-24\",\"doctype\":\"Sales Invoice\",\"link\":\"/app/Form/Sales Invoice/ACC-SINV-2023-00200\",\"vgt_id\":0,\"originalIndex\":21,\"vgtSelected\":true},{\"name\":\"ACC-SINV-2023-00199\",\"creation\":\"2023-06-23 23:23:25.329725\",\"modified\":\"2023-06-23 23:23:27.988957\",\"modified_by\":\"gestionbar@lagaloche.fr\",\"owner\":\"gestionbar@lagaloche.fr\",\"docstatus\":1,\"parent\":null,\"parentfield\":null,\"parenttype\":null,\"idx\":0,\"title\":\"Bar La Galoche\",\"naming_series\":\"ACC-SINV-.YYYY.-\",\"customer\":\"Bar La Galoche\",\"customer_name\":\"Bar La Galoche\",\"tax_id\":null,\"pos_profile\":\"Vente La Galoche\",\"is_pos\":1,\"is_consolidated\":1,\"is_return\":0,\"update_billed_amount_in_sales_order\":0,\"is_down_payment_invoice\":0,\"company\":\"La Galoche\",\"company_tax_id\":null,\"posting_date\":\"2023-06-23\",\"posting_time\":\"23:23:05\",\"set_posting_time\":1,\"due_date\":\"2023-06-23\",\"return_against\":null,\"amended_from\":null,\"down_payment_against\":null,\"project\":null,\"cost_center\":\"Principal - LG\",\"po_no\":\"\",\"po_date\":null,\"customer_address\":null,\"address_display\":null,\"contact_person\":\"Bar La Galoche-1-Bar La Galoche\",\"contact_display\":\"Bar La Galoche\",\"contact_mobile\":\"\",\"contact_email\":\"gestionbar@lagaloche.fr\",\"territory\":\"Tous les Territoires\",\"shipping_address_name\":\"\",\"shipping_address\":null,\"company_address\":null,\"company_address_display\":null,\"currency\":\"EUR\",\"conversion_rate\":1,\"selling_price_list\":\"Vente Standard\",\"price_list_currency\":\"EUR\",\"plc_conversion_rate\":1,\"ignore_pricing_rule\":1,\"set_warehouse\":\"La Galoche - LG\",\"set_target_warehouse\":null,\"update_stock\":1,\"scan_barcode\":null,\"total_billing_amount\":0,\"total_qty\":77,\"base_total\":303,\"base_net_total\":303,\"total_net_weight\":0,\"total\":303,\"net_total\":303,\"taxes_and_charges\":null,\"shipping_rule\":null,\"tax_category\":\"\",\"other_charges_calculation\":null,\"base_total_taxes_and_charges\":0,\"total_taxes_and_charges\":0,\"loyalty_points\":0,\"loyalty_amount\":0,\"redeem_loyalty_points\":0,\"loyalty_program\":null,\"loyalty_redemption_account\":null,\"loyalty_redemption_cost_center\":null,\"apply_discount_on\":\"Grand Total\",\"base_discount_amount\":0,\"additional_discount_percentage\":0,\"discount_amount\":0,\"base_grand_total\":303,\"base_rounding_adjustment\":0,\"base_rounded_total\":303,\"base_in_words\":\"Trois Cent Trois Euro\",\"grand_total\":303,\"rounding_adjustment\":0,\"rounded_total\":303,\"in_words\":\"Trois Cent Trois Euro\",\"total_advance\":0,\"outstanding_amount\":0,\"disable_rounded_total\":0,\"allocate_advances_automatically\":0,\"payment_terms_template\":\"\",\"cash_bank_account\":null,\"base_paid_amount\":303,\"unreconciled_amount\":303,\"paid_amount\":303,\"base_change_amount\":0,\"change_amount\":0,\"account_for_change_amount\":\"5314 - Caisse en devises - LG\",\"write_off_amount\":0,\"base_write_off_amount\":0,\"write_off_outstanding_amount_automatically\":1,\"write_off_account\":\"654 - Pertes sur créances irrécouvrables - LG\",\"write_off_cost_center\":\"Principal - LG\",\"tc_name\":null,\"terms\":null,\"letter_head\":null,\"group_same_items\":0,\"select_print_heading\":null,\"language\":\"fr\",\"inter_company_invoice_reference\":null,\"is_internal_customer\":0,\"represents_company\":null,\"customer_group\":\"Tous les Groupes Client\",\"campaign\":null,\"is_discounted\":0,\"status\":\"Paid\",\"source\":null,\"external_reference\":null,\"debit_to\":\"411 - Clients - LG\",\"party_account_currency\":\"EUR\",\"is_opening\":\"No\",\"c_form_applicable\":null,\"c_form_no\":null,\"unrealized_profit_loss_account\":null,\"remarks\":\"Facture de vente: ACC-SINV-2023-00199 / Client: Bar La Galoche\",\"sales_partner\":null,\"commission_rate\":0,\"total_commission\":0,\"from_date\":null,\"to_date\":null,\"subscription\":null,\"auto_repeat\":null,\"against_income_account\":\"707 - Ventes de marchandises - LG,7569 - Cotisation caisse - LG\",\"_user_tags\":null,\"_comments\":null,\"_assign\":null,\"_liked_by\":null,\"_seen\":\"[\\\"gestionbar@lagaloche.fr\\\"]\",\"_submitted\":\"2023-06-23 23:23:26.892712\",\"_submitted_by\":\"gestionbar@lagaloche.fr\",\"_seal\":\"afa13b66e39635bb876d8e7ee03ca5861a386446fda1fdf1e13539d01a4ea867\",\"_draft_name\":null,\"is_debit_note\":0,\"total_billing_hours\":0,\"is_cash_or_non_trade_discount\":0,\"additional_discount_account\":null,\"ignore_default_payment_terms_template\":0,\"amount_eligible_for_commission\":303,\"incoterm\":null,\"named_place\":null,\"_printed\":null,\"accounting_journal\":null,\"amount\":303,\"party\":\"Bar La Galoche\",\"reference_date\":\"2023-06-23\",\"reference_string\":\"ACC-SINV-2023-00199: Facture de vente: ACC-SINV-2023-00199 / Client: Bar La Galoche\",\"date\":\"2023-06-23\",\"doctype\":\"Sales Invoice\",\"link\":\"/app/Form/Sales Invoice/ACC-SINV-2023-00199\",\"vgt_id\":0,\"originalIndex\":22,\"vgtSelected\":true},{\"name\":\"ACC-SINV-2023-00198\",\"creation\":\"2023-06-23 18:39:39.709307\",\"modified\":\"2023-06-23 18:39:41.693763\",\"modified_by\":\"gestionbar@lagaloche.fr\",\"owner\":\"gestionbar@lagaloche.fr\",\"docstatus\":1,\"parent\":null,\"parentfield\":null,\"parenttype\":null,\"idx\":0,\"title\":\"Bar La Galoche\",\"naming_series\":\"ACC-SINV-.YYYY.-\",\"customer\":\"Bar La Galoche\",\"customer_name\":\"Bar La Galoche\",\"tax_id\":null,\"pos_profile\":\"Vente La Galoche\",\"is_pos\":1,\"is_consolidated\":1,\"is_return\":0,\"update_billed_amount_in_sales_order\":0,\"is_down_payment_invoice\":0,\"company\":\"La Galoche\",\"company_tax_id\":null,\"posting_date\":\"2023-06-23\",\"posting_time\":\"18:35:53\",\"set_posting_time\":1,\"due_date\":\"2023-06-23\",\"return_against\":null,\"amended_from\":null,\"down_payment_against\":null,\"project\":null,\"cost_center\":\"Principal - LG\",\"po_no\":\"\",\"po_date\":null,\"customer_address\":null,\"address_display\":null,\"contact_person\":\"Bar La Galoche-1-Bar La Galoche\",\"contact_display\":\"Bar La Galoche\",\"contact_mobile\":\"\",\"contact_email\":\"gestionbar@lagaloche.fr\",\"territory\":\"Tous les Territoires\",\"shipping_address_name\":\"\",\"shipping_address\":null,\"company_address\":null,\"company_address_display\":null,\"currency\":\"EUR\",\"conversion_rate\":1,\"selling_price_list\":\"Vente Standard\",\"price_list_currency\":\"EUR\",\"plc_conversion_rate\":1,\"ignore_pricing_rule\":1,\"set_warehouse\":\"La Galoche - LG\",\"set_target_warehouse\":null,\"update_stock\":1,\"scan_barcode\":null,\"total_billing_amount\":0,\"total_qty\":16,\"base_total\":19.5,\"base_net_total\":19.5,\"total_net_weight\":0,\"total\":19.5,\"net_total\":19.5,\"taxes_and_charges\":null,\"shipping_rule\":null,\"tax_category\":\"\",\"other_charges_calculation\":null,\"base_total_taxes_and_charges\":0,\"total_taxes_and_charges\":0,\"loyalty_points\":0,\"loyalty_amount\":0,\"redeem_loyalty_points\":0,\"loyalty_program\":null,\"loyalty_redemption_account\":null,\"loyalty_redemption_cost_center\":null,\"apply_discount_on\":\"Grand Total\",\"base_discount_amount\":0,\"additional_discount_percentage\":0,\"discount_amount\":0,\"base_grand_total\":19.5,\"base_rounding_adjustment\":0,\"base_rounded_total\":19.5,\"base_in_words\":\"Dix Neuf Euro et Cinquante Centime\",\"grand_total\":19.5,\"rounding_adjustment\":0,\"rounded_total\":19.5,\"in_words\":\"Dix Neuf Euro et Cinquante Centime\",\"total_advance\":0,\"outstanding_amount\":0,\"disable_rounded_total\":0,\"allocate_advances_automatically\":0,\"payment_terms_template\":\"\",\"cash_bank_account\":null,\"base_paid_amount\":19.5,\"unreconciled_amount\":19.5,\"paid_amount\":19.5,\"base_change_amount\":0,\"change_amount\":0,\"account_for_change_amount\":\"5314 - Caisse en devises - LG\",\"write_off_amount\":0,\"base_write_off_amount\":0,\"write_off_outstanding_amount_automatically\":1,\"write_off_account\":\"654 - Pertes sur créances irrécouvrables - LG\",\"write_off_cost_center\":\"Principal - LG\",\"tc_name\":null,\"terms\":null,\"letter_head\":null,\"group_same_items\":0,\"select_print_heading\":null,\"language\":\"fr\",\"inter_company_invoice_reference\":null,\"is_internal_customer\":0,\"represents_company\":null,\"customer_group\":\"Tous les Groupes Client\",\"campaign\":null,\"is_discounted\":0,\"status\":\"Paid\",\"source\":null,\"external_reference\":null,\"debit_to\":\"411 - Clients - LG\",\"party_account_currency\":\"EUR\",\"is_opening\":\"No\",\"c_form_applicable\":null,\"c_form_no\":null,\"unrealized_profit_loss_account\":null,\"remarks\":\"Facture de vente: ACC-SINV-2023-00198 / Client: Bar La Galoche\",\"sales_partner\":null,\"commission_rate\":0,\"total_commission\":0,\"from_date\":null,\"to_date\":null,\"subscription\":null,\"auto_repeat\":null,\"against_income_account\":\"707 - Ventes de marchandises - LG,7569 - Cotisation caisse - LG,7713 - Libéralités reçues - LG\",\"_user_tags\":null,\"_comments\":null,\"_assign\":null,\"_liked_by\":null,\"_seen\":\"[\\\"gestionbar@lagaloche.fr\\\"]\",\"_submitted\":\"2023-06-23 18:39:40.570523\",\"_submitted_by\":\"gestionbar@lagaloche.fr\",\"_seal\":\"fc5cb04e3d0ed6a633c1e650a0614490ec984cd94ff6309940fb161663365df6\",\"_draft_name\":null,\"is_debit_note\":0,\"total_billing_hours\":0,\"is_cash_or_non_trade_discount\":0,\"additional_discount_account\":null,\"ignore_default_payment_terms_template\":0,\"amount_eligible_for_commission\":19.5,\"incoterm\":null,\"named_place\":null,\"_printed\":null,\"accounting_journal\":null,\"amount\":19.5,\"party\":\"Bar La Galoche\",\"reference_date\":\"2023-06-23\",\"reference_string\":\"ACC-SINV-2023-00198: Facture de vente: ACC-SINV-2023-00198 / Client: Bar La Galoche\",\"date\":\"2023-06-23\",\"doctype\":\"Sales Invoice\",\"link\":\"/app/Form/Sales Invoice/ACC-SINV-2023-00198\",\"vgt_id\":0,\"originalIndex\":23,\"vgtSelected\":true}]"
},
"headers": {},
"error_handlers": {},
"url": "/api/method/erpnext.accounts.page.bank_reconciliation.bank_reconciliation.reconcile"
}
Response Data
{
"exception": "pymysql.err.OperationalError: (1054, \"Unknown column 'clearance_date' in 'field list'\")"
}