Information about bug
getting error while trying to open:
Traceback with variables (most recent call last):
File "apps/frappe/frappe/utils/background_jobs.py", line 224, in execute_job
retval = method(**kwargs)
site = 'postgres'
method = <bound method GSTR1Beta._generate_gstr1 of <GSTR1Beta: doctype=GSTR-1 Beta GSTR-1 Beta>>
event = None
job_name = 'india_compliance.gst_india.doctype.gstr_1_beta.gstr_1_beta.GSTR1Beta._generate_gstr1'
kwargs = {}
user = 'Administrator'
is_async = True
retry = 0
retval = None
method_name = 'india_compliance.gst_india.doctype.gstr_1_beta.gstr_1_beta.GSTR1Beta._generate_gstr1'
before_job_task = 'frappe.monitor.start'
File "apps/india_compliance/india_compliance/gst_india/doctype/gstr_1_beta/gstr_1_beta.py", line 162, in _generate_gstr1
raise e
self = <GSTR1Beta: doctype=GSTR-1 Beta GSTR-1 Beta>
filters = {'company': 'Test Company-3344', 'company_gstin': '27AABCT1296R1ZN', 'month_or_quarter': 'October', 'year': '2025', 'filing_preference': 'Monthly'}
File "apps/india_compliance/india_compliance/gst_india/doctype/gstr_1_beta/gstr_1_beta.py", line 151, in _generate_gstr1
self.gstr1_log.generate_gstr1_data(filters, callback=self.on_generate)
self = <GSTR1Beta: doctype=GSTR-1 Beta GSTR-1 Beta>
filters = {'company': 'Test Company-3344', 'company_gstin': '27AABCT1296R1ZN', 'month_or_quarter': 'October', 'year': '2025', 'filing_preference': 'Monthly'}
File "apps/india_compliance/india_compliance/gst_india/doctype/gst_return_log/generate_gstr_1.py", line 607, in generate_gstr1_data
return self.generate_only_books_data(data, filters, callback)
self = <GSTReturnLog: doctype=GST Return Log GSTR1-102025-27AABCT1296R1ZN>
filters = {'company': 'Test Company-3344', 'company_gstin': '27AABCT1296R1ZN', 'month_or_quarter': 'October', 'year': '2025', 'filing_preference': 'Monthly'}
callback = <bound method GSTR1Beta.on_generate of <GSTR1Beta: doctype=GSTR-1 Beta GSTR-1 Beta>>
data = {}
settings = <GSTSettings: doctype=GST Settings GST Settings>
File "apps/india_compliance/india_compliance/gst_india/doctype/gst_return_log/generate_gstr_1.py", line 672, in generate_only_books_data
books_data = self.get_books_gstr1_data(filters, aggregate=True)
self = <GSTReturnLog: doctype=GST Return Log GSTR1-102025-27AABCT1296R1ZN>
data = {}
filters = {'company': 'Test Company-3344', 'company_gstin': '27AABCT1296R1ZN', 'month_or_quarter': 'October', 'year': '2025', 'filing_preference': 'Monthly'}
callback = <bound method GSTR1Beta.on_generate of <GSTR1Beta: doctype=GSTR-1 Beta GSTR-1 Beta>>
status = 'Not Filed'
File "apps/india_compliance/india_compliance/gst_india/doctype/gst_return_log/generate_gstr_1.py", line 727, in get_books_gstr1_data
books_data = GSTR1BooksData(_filters).prepare_mapped_data()
self = <GSTReturnLog: doctype=GST Return Log GSTR1-102025-27AABCT1296R1ZN>
filters = {'company': 'Test Company-3344', 'company_gstin': '27AABCT1296R1ZN', 'month_or_quarter': 'October', 'year': '2025', 'filing_preference': 'Monthly'}
aggregate = True
get_gstr_1_from_and_to_date = <function get_gstr_1_from_and_to_date at 0x72b398ca1c60>
data_field = 'books'
from_date = datetime.date(2025, 10, 1)
to_date = datetime.date(2025, 10, 31)
_filters = {'from_date': datetime.date(2025, 10, 1), 'to_date': datetime.date(2025, 10, 31), 'filing_preference': 'Monthly', 'company': 'Test Company-3344', 'company_gstin': '27AABCT1296R1ZN', 'month_or_quarter': 'October', 'year': '2025', 'type_of_business': 'Adjustment'}
File "apps/india_compliance/india_compliance/gst_india/utils/gstr_1/gstr_1_json_map.py", line 2444, in prepare_mapped_data
GSTR1_Category.TXP.value: self.prepare_advances_adjusted_data(),
self = <india_compliance.gst_india.utils.gstr_1.gstr_1_json_map.GSTR1BooksData object at 0x72b393760370>
prepared_data = {}
_class = <india_compliance.gst_india.utils.gstr_1.gstr_1_data.GSTR1Invoices object at 0x72b392d08250>
data = []
data_for_hsn = defaultdict(<function GSTR1BooksData.get_structured_data.. at 0x72b392d07400>, {})
data_for_invoice_no_key = ********
data_for_nil_exempt = defaultdict(<function GSTR1BooksData.get_structured_data.. at 0x72b392d072e0>, {})
data_for_b2cs = defaultdict(<function GSTR1BooksData.get_structured_data.. at 0x72b392d07370>, {})
File "apps/india_compliance/india_compliance/gst_india/utils/gstr_1/gstr_1_json_map.py", line 2525, in prepare_advances_adjusted_data
return self.prepare_advances_received_or_adjusted_data("Adjustment")
self = <india_compliance.gst_india.utils.gstr_1.gstr_1_json_map.GSTR1BooksData object at 0x72b393760370>
File "apps/india_compliance/india_compliance/gst_india/utils/gstr_1/gstr_1_json_map.py", line 2555, in prepare_advances_received_or_adjusted_data
data = query.run(as_dict=True)
self = <india_compliance.gst_india.utils.gstr_1.gstr_1_json_map.GSTR1BooksData object at 0x72b393760370>
type_of_business = 'Adjustment'
advances_data = {}
gst_accounts = {'cgst_account': 'Output Tax CGST - TC-3', 'sgst_account': 'Output Tax SGST - TC-3', 'igst_account': 'Output Tax IGST - TC-3', 'cess_account': None, 'cess_non_advol_account': None}
_class = <india_compliance.gst_india.report.gstr_1.gstr_1.GSTR11A11BData object at 0x72b392d09cc0>
query = SELECT "tabPayment Entry"."place_of_supply",SUM(CASE WHEN "tabGL Entry"."account"<>IFNULL(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "tax_amount",SUM(CASE WHEN "tabGL Entry"."account"=IFNULL(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "cess_amount","tabPayment Entry Reference"."allocated_amount" "taxable_value","tabPayment Entry"."name","tabPayment Entry"."party","tabPayment Entry"."posting_date","tabPayment Entry"."company_gstin","tabPayment Entry Reference"."reference_name" FROM "tabGL Entry" JOIN "tabPayment Entry" ON "tabPayment Entry"."name"="tabGL Entry"."voucher_no" JOIN "tabPayment Entry Reference" ON "tabPayment Entry Reference"."name"="tabGL Entry"."voucher_detail_no" WHERE "tabGL Entry"."is_cancelled"=0 AND "tabGL Entry"."voucher_type"='Payment Entry' AND "tabGL Entry"."company"='Test Company-3344' AND "tabGL Entry"."account" IN ('Output Tax CGST - TC-3','Output Tax SGST - TC-3','Output Tax IGST - TC-3') AND "tabGL Entry"."pos...
fields = (<pypika.terms.Field object at 0x72b392d1fcd0>, <pypika.terms.Field object at 0x72b392d1d810>, <pypika.terms.Field object at 0x72b392d1e8c0>, <pypika.terms.Field object at 0x72b392d1e770>, <pypika.terms.Field object at 0x72b392d1e620>)
multipler = -1
File "apps/frappe/frappe/query_builder/utils.py", line 87, in execute_query
result = frappe.db.sql(query, params, *args, **kwargs) # nosemgrep
query = 'SELECT "tabPayment Entry"."place_of_supply",SUM(CASE WHEN "tabGL Entry"."account"<>IFNULL(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "tax_amount",SUM(CASE WHEN "tabGL Entry"."account"=IFNULL(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "cess_amount","tabPayment Entry Reference"."allocated_amount" "taxable_value","tabPayment Entry"."name","tabPayment Entry"."party","tabPayment Entry"."posting_date","tabPayment Entry"."company_gstin","tabPayment Entry Reference"."reference_name" FROM "tabGL Entry" JOIN "tabPayment Entry" ON "tabPayment Entry"."name"="tabGL Entry"."voucher_no" JOIN "tabPayment Entry Reference" ON "tabPayment Entry Reference"."name"="tabGL Entry"."voucher_detail_no" WHERE "tabGL Entry"."is_cancelled"=0 AND "tabGL Entry"."voucher_type"=%(param1)s AND "tabGL Entry"."company"=%(param2)s AND "tabGL Entry"."account" IN (%(param3)s,%(param4)s,%(param5)s) AND "tabGL Entry"."posting_date" BETWEEN '2025-10-01' AND '2025-10-31...
args = ()
kwargs = {'as_dict': True}
child_queries = []
params = {'param1': 'Payment Entry', 'param2': 'Test Company-3344', 'param3': 'Output Tax CGST - TC-3', 'param4': 'Output Tax SGST - TC-3', 'param5': 'Output Tax IGST - TC-3', 'param6': '27AABCT1296R1ZN'}
execute_child_queries = <function patch_query_execute..execute_child_queries at 0x72b393688280>
prepare_query = <function patch_query_execute..prepare_query at 0x72b3936884c0>
File "apps/frappe/frappe/database/postgres/database.py", line 326, in sql
return super().sql(modify_query(query), modify_values(values), *args, **kwargs)
self = <frappe.database.postgres.database.PostgresDatabase object at 0x72b393862f50>
query = 'SELECT "tabPayment Entry"."place_of_supply",SUM(CASE WHEN "tabGL Entry"."account"<>IFNULL(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "tax_amount",SUM(CASE WHEN "tabGL Entry"."account"=IFNULL(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "cess_amount","tabPayment Entry Reference"."allocated_amount" "taxable_value","tabPayment Entry"."name","tabPayment Entry"."party","tabPayment Entry"."posting_date","tabPayment Entry"."company_gstin","tabPayment Entry Reference"."reference_name" FROM "tabGL Entry" JOIN "tabPayment Entry" ON "tabPayment Entry"."name"="tabGL Entry"."voucher_no" JOIN "tabPayment Entry Reference" ON "tabPayment Entry Reference"."name"="tabGL Entry"."voucher_detail_no" WHERE "tabGL Entry"."is_cancelled"=0 AND "tabGL Entry"."voucher_type"=%(param1)s AND "tabGL Entry"."company"=%(param2)s AND "tabGL Entry"."account" IN (%(param3)s,%(param4)s,%(param5)s) AND "tabGL Entry"."posting_date" BETWEEN '2025-10-01' AND '2025-10-31...
values = {'param1': 'Payment Entry', 'param2': 'Test Company-3344', 'param3': 'Output Tax CGST - TC-3', 'param4': 'Output Tax SGST - TC-3', 'param5': 'Output Tax IGST - TC-3', 'param6': '27AABCT1296R1ZN'}
args = ()
kwargs = {'as_dict': True}
class = <class 'frappe.database.postgres.database.PostgresDatabase'>
File "apps/frappe/frappe/database/database.py", line 236, in sql
self._cursor.execute(query, values)
self = <frappe.database.postgres.database.PostgresDatabase object at 0x72b393862f50>
query = 'SELECT "tabPayment Entry"."place_of_supply",SUM(CASE WHEN "tabGL Entry"."account"<>coalesce(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "tax_amount",SUM(CASE WHEN "tabGL Entry"."account"=coalesce(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "cess_amount","tabPayment Entry Reference"."allocated_amount" "taxable_value","tabPayment Entry"."name","tabPayment Entry"."party","tabPayment Entry"."posting_date","tabPayment Entry"."company_gstin","tabPayment Entry Reference"."reference_name" FROM "tabGL Entry" JOIN "tabPayment Entry" ON "tabPayment Entry"."name"="tabGL Entry"."voucher_no" JOIN "tabPayment Entry Reference" ON "tabPayment Entry Reference"."name"="tabGL Entry"."voucher_detail_no" WHERE "tabGL Entry"."is_cancelled"= '0' AND "tabGL Entry"."voucher_type"=%(param1)s AND "tabGL Entry"."company"=%(param2)s AND "tabGL Entry"."account" IN (%(param3)s,%(param4)s,%(param5)s) AND "tabGL Entry"."posting_date" BETWEEN '2025-10-01' AND '20...
values = {'param1': 'Payment Entry', 'param2': 'Test Company-3344', 'param3': 'Output Tax CGST - TC-3', 'param4': 'Output Tax SGST - TC-3', 'param5': 'Output Tax IGST - TC-3', 'param6': '27AABCT1296R1ZN'}
as_dict = True
as_list = 0
debug = False
ignore_ddl = 0
auto_commit = 0
update = None
explain = False
run = True
pluck = False
as_iterator = False
trace_id = None
psycopg2.errors.GroupingError: column "tabPayment Entry.place_of_supply" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT "tabPayment Entry"."place_of_supply",SUM(CASE WHEN "t...
^
Version
frappe 15.72.4 pre-prod
erpnext 15.65.1 pre-prod
payments 0.0.1 version-15
assets 0.0.1 pre-prod
sales_commission 0.0.1 pre-prod
projects 0.0.1 pre-prod
india_compliance 15.18.1 pre-prod
erpnext_india 0.0.1 pre-prod
erpnext_crm 0.0.1 pre-prod
hrms 15.39.0 pre-prod
Relevant log output / Stack trace / Full Error Message.
Code of Conduct
Information about bug
getting error while trying to open:
Traceback with variables (most recent call last):
File "apps/frappe/frappe/utils/background_jobs.py", line 224, in execute_job
retval = method(**kwargs)
site = 'postgres'
method = <bound method GSTR1Beta._generate_gstr1 of <GSTR1Beta: doctype=GSTR-1 Beta GSTR-1 Beta>>
event = None
job_name = 'india_compliance.gst_india.doctype.gstr_1_beta.gstr_1_beta.GSTR1Beta._generate_gstr1'
kwargs = {}
user = 'Administrator'
is_async = True
retry = 0
retval = None
method_name = 'india_compliance.gst_india.doctype.gstr_1_beta.gstr_1_beta.GSTR1Beta._generate_gstr1'
before_job_task = 'frappe.monitor.start'
File "apps/india_compliance/india_compliance/gst_india/doctype/gstr_1_beta/gstr_1_beta.py", line 162, in _generate_gstr1
raise e
self = <GSTR1Beta: doctype=GSTR-1 Beta GSTR-1 Beta>
filters = {'company': 'Test Company-3344', 'company_gstin': '27AABCT1296R1ZN', 'month_or_quarter': 'October', 'year': '2025', 'filing_preference': 'Monthly'}
File "apps/india_compliance/india_compliance/gst_india/doctype/gstr_1_beta/gstr_1_beta.py", line 151, in _generate_gstr1
self.gstr1_log.generate_gstr1_data(filters, callback=self.on_generate)
self = <GSTR1Beta: doctype=GSTR-1 Beta GSTR-1 Beta>
filters = {'company': 'Test Company-3344', 'company_gstin': '27AABCT1296R1ZN', 'month_or_quarter': 'October', 'year': '2025', 'filing_preference': 'Monthly'}
File "apps/india_compliance/india_compliance/gst_india/doctype/gst_return_log/generate_gstr_1.py", line 607, in generate_gstr1_data
return self.generate_only_books_data(data, filters, callback)
self = <GSTReturnLog: doctype=GST Return Log GSTR1-102025-27AABCT1296R1ZN>
filters = {'company': 'Test Company-3344', 'company_gstin': '27AABCT1296R1ZN', 'month_or_quarter': 'October', 'year': '2025', 'filing_preference': 'Monthly'}
callback = <bound method GSTR1Beta.on_generate of <GSTR1Beta: doctype=GSTR-1 Beta GSTR-1 Beta>>
data = {}
settings = <GSTSettings: doctype=GST Settings GST Settings>
File "apps/india_compliance/india_compliance/gst_india/doctype/gst_return_log/generate_gstr_1.py", line 672, in generate_only_books_data
books_data = self.get_books_gstr1_data(filters, aggregate=True)
self = <GSTReturnLog: doctype=GST Return Log GSTR1-102025-27AABCT1296R1ZN>
data = {}
filters = {'company': 'Test Company-3344', 'company_gstin': '27AABCT1296R1ZN', 'month_or_quarter': 'October', 'year': '2025', 'filing_preference': 'Monthly'}
callback = <bound method GSTR1Beta.on_generate of <GSTR1Beta: doctype=GSTR-1 Beta GSTR-1 Beta>>
status = 'Not Filed'
File "apps/india_compliance/india_compliance/gst_india/doctype/gst_return_log/generate_gstr_1.py", line 727, in get_books_gstr1_data
books_data = GSTR1BooksData(_filters).prepare_mapped_data()
self = <GSTReturnLog: doctype=GST Return Log GSTR1-102025-27AABCT1296R1ZN>
filters = {'company': 'Test Company-3344', 'company_gstin': '27AABCT1296R1ZN', 'month_or_quarter': 'October', 'year': '2025', 'filing_preference': 'Monthly'}
aggregate = True
get_gstr_1_from_and_to_date = <function get_gstr_1_from_and_to_date at 0x72b398ca1c60>
data_field = 'books'
from_date = datetime.date(2025, 10, 1)
to_date = datetime.date(2025, 10, 31)
_filters = {'from_date': datetime.date(2025, 10, 1), 'to_date': datetime.date(2025, 10, 31), 'filing_preference': 'Monthly', 'company': 'Test Company-3344', 'company_gstin': '27AABCT1296R1ZN', 'month_or_quarter': 'October', 'year': '2025', 'type_of_business': 'Adjustment'}
File "apps/india_compliance/india_compliance/gst_india/utils/gstr_1/gstr_1_json_map.py", line 2444, in prepare_mapped_data
GSTR1_Category.TXP.value: self.prepare_advances_adjusted_data(),
self = <india_compliance.gst_india.utils.gstr_1.gstr_1_json_map.GSTR1BooksData object at 0x72b393760370>
prepared_data = {}
_class = <india_compliance.gst_india.utils.gstr_1.gstr_1_data.GSTR1Invoices object at 0x72b392d08250>
data = []
data_for_hsn = defaultdict(<function GSTR1BooksData.get_structured_data.. at 0x72b392d07400>, {})
data_for_invoice_no_key = ********
data_for_nil_exempt = defaultdict(<function GSTR1BooksData.get_structured_data.. at 0x72b392d072e0>, {})
data_for_b2cs = defaultdict(<function GSTR1BooksData.get_structured_data.. at 0x72b392d07370>, {})
File "apps/india_compliance/india_compliance/gst_india/utils/gstr_1/gstr_1_json_map.py", line 2525, in prepare_advances_adjusted_data
return self.prepare_advances_received_or_adjusted_data("Adjustment")
self = <india_compliance.gst_india.utils.gstr_1.gstr_1_json_map.GSTR1BooksData object at 0x72b393760370>
File "apps/india_compliance/india_compliance/gst_india/utils/gstr_1/gstr_1_json_map.py", line 2555, in prepare_advances_received_or_adjusted_data
data = query.run(as_dict=True)
self = <india_compliance.gst_india.utils.gstr_1.gstr_1_json_map.GSTR1BooksData object at 0x72b393760370>
type_of_business = 'Adjustment'
advances_data = {}
gst_accounts = {'cgst_account': 'Output Tax CGST - TC-3', 'sgst_account': 'Output Tax SGST - TC-3', 'igst_account': 'Output Tax IGST - TC-3', 'cess_account': None, 'cess_non_advol_account': None}
_class = <india_compliance.gst_india.report.gstr_1.gstr_1.GSTR11A11BData object at 0x72b392d09cc0>
query = SELECT "tabPayment Entry"."place_of_supply",SUM(CASE WHEN "tabGL Entry"."account"<>IFNULL(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "tax_amount",SUM(CASE WHEN "tabGL Entry"."account"=IFNULL(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "cess_amount","tabPayment Entry Reference"."allocated_amount" "taxable_value","tabPayment Entry"."name","tabPayment Entry"."party","tabPayment Entry"."posting_date","tabPayment Entry"."company_gstin","tabPayment Entry Reference"."reference_name" FROM "tabGL Entry" JOIN "tabPayment Entry" ON "tabPayment Entry"."name"="tabGL Entry"."voucher_no" JOIN "tabPayment Entry Reference" ON "tabPayment Entry Reference"."name"="tabGL Entry"."voucher_detail_no" WHERE "tabGL Entry"."is_cancelled"=0 AND "tabGL Entry"."voucher_type"='Payment Entry' AND "tabGL Entry"."company"='Test Company-3344' AND "tabGL Entry"."account" IN ('Output Tax CGST - TC-3','Output Tax SGST - TC-3','Output Tax IGST - TC-3') AND "tabGL Entry"."pos...
fields = (<pypika.terms.Field object at 0x72b392d1fcd0>, <pypika.terms.Field object at 0x72b392d1d810>, <pypika.terms.Field object at 0x72b392d1e8c0>, <pypika.terms.Field object at 0x72b392d1e770>, <pypika.terms.Field object at 0x72b392d1e620>)
multipler = -1
File "apps/frappe/frappe/query_builder/utils.py", line 87, in execute_query
result = frappe.db.sql(query, params, *args, **kwargs) # nosemgrep
query = 'SELECT "tabPayment Entry"."place_of_supply",SUM(CASE WHEN "tabGL Entry"."account"<>IFNULL(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "tax_amount",SUM(CASE WHEN "tabGL Entry"."account"=IFNULL(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "cess_amount","tabPayment Entry Reference"."allocated_amount" "taxable_value","tabPayment Entry"."name","tabPayment Entry"."party","tabPayment Entry"."posting_date","tabPayment Entry"."company_gstin","tabPayment Entry Reference"."reference_name" FROM "tabGL Entry" JOIN "tabPayment Entry" ON "tabPayment Entry"."name"="tabGL Entry"."voucher_no" JOIN "tabPayment Entry Reference" ON "tabPayment Entry Reference"."name"="tabGL Entry"."voucher_detail_no" WHERE "tabGL Entry"."is_cancelled"=0 AND "tabGL Entry"."voucher_type"=%(param1)s AND "tabGL Entry"."company"=%(param2)s AND "tabGL Entry"."account" IN (%(param3)s,%(param4)s,%(param5)s) AND "tabGL Entry"."posting_date" BETWEEN '2025-10-01' AND '2025-10-31...
args = ()
kwargs = {'as_dict': True}
child_queries = []
params = {'param1': 'Payment Entry', 'param2': 'Test Company-3344', 'param3': 'Output Tax CGST - TC-3', 'param4': 'Output Tax SGST - TC-3', 'param5': 'Output Tax IGST - TC-3', 'param6': '27AABCT1296R1ZN'}
execute_child_queries = <function patch_query_execute..execute_child_queries at 0x72b393688280>
prepare_query = <function patch_query_execute..prepare_query at 0x72b3936884c0>
File "apps/frappe/frappe/database/postgres/database.py", line 326, in sql
return super().sql(modify_query(query), modify_values(values), *args, **kwargs)
self = <frappe.database.postgres.database.PostgresDatabase object at 0x72b393862f50>
query = 'SELECT "tabPayment Entry"."place_of_supply",SUM(CASE WHEN "tabGL Entry"."account"<>IFNULL(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "tax_amount",SUM(CASE WHEN "tabGL Entry"."account"=IFNULL(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "cess_amount","tabPayment Entry Reference"."allocated_amount" "taxable_value","tabPayment Entry"."name","tabPayment Entry"."party","tabPayment Entry"."posting_date","tabPayment Entry"."company_gstin","tabPayment Entry Reference"."reference_name" FROM "tabGL Entry" JOIN "tabPayment Entry" ON "tabPayment Entry"."name"="tabGL Entry"."voucher_no" JOIN "tabPayment Entry Reference" ON "tabPayment Entry Reference"."name"="tabGL Entry"."voucher_detail_no" WHERE "tabGL Entry"."is_cancelled"=0 AND "tabGL Entry"."voucher_type"=%(param1)s AND "tabGL Entry"."company"=%(param2)s AND "tabGL Entry"."account" IN (%(param3)s,%(param4)s,%(param5)s) AND "tabGL Entry"."posting_date" BETWEEN '2025-10-01' AND '2025-10-31...
values = {'param1': 'Payment Entry', 'param2': 'Test Company-3344', 'param3': 'Output Tax CGST - TC-3', 'param4': 'Output Tax SGST - TC-3', 'param5': 'Output Tax IGST - TC-3', 'param6': '27AABCT1296R1ZN'}
args = ()
kwargs = {'as_dict': True}
class = <class 'frappe.database.postgres.database.PostgresDatabase'>
File "apps/frappe/frappe/database/database.py", line 236, in sql
self._cursor.execute(query, values)
self = <frappe.database.postgres.database.PostgresDatabase object at 0x72b393862f50>
query = 'SELECT "tabPayment Entry"."place_of_supply",SUM(CASE WHEN "tabGL Entry"."account"<>coalesce(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "tax_amount",SUM(CASE WHEN "tabGL Entry"."account"=coalesce(NULL,'') THEN "tabGL Entry"."debit_in_account_currency" ELSE 0 END) "cess_amount","tabPayment Entry Reference"."allocated_amount" "taxable_value","tabPayment Entry"."name","tabPayment Entry"."party","tabPayment Entry"."posting_date","tabPayment Entry"."company_gstin","tabPayment Entry Reference"."reference_name" FROM "tabGL Entry" JOIN "tabPayment Entry" ON "tabPayment Entry"."name"="tabGL Entry"."voucher_no" JOIN "tabPayment Entry Reference" ON "tabPayment Entry Reference"."name"="tabGL Entry"."voucher_detail_no" WHERE "tabGL Entry"."is_cancelled"= '0' AND "tabGL Entry"."voucher_type"=%(param1)s AND "tabGL Entry"."company"=%(param2)s AND "tabGL Entry"."account" IN (%(param3)s,%(param4)s,%(param5)s) AND "tabGL Entry"."posting_date" BETWEEN '2025-10-01' AND '20...
values = {'param1': 'Payment Entry', 'param2': 'Test Company-3344', 'param3': 'Output Tax CGST - TC-3', 'param4': 'Output Tax SGST - TC-3', 'param5': 'Output Tax IGST - TC-3', 'param6': '27AABCT1296R1ZN'}
as_dict = True
as_list = 0
debug = False
ignore_ddl = 0
auto_commit = 0
update = None
explain = False
run = True
pluck = False
as_iterator = False
trace_id = None
psycopg2.errors.GroupingError: column "tabPayment Entry.place_of_supply" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT "tabPayment Entry"."place_of_supply",SUM(CASE WHEN "t...
^
Version
frappe 15.72.4 pre-prod
erpnext 15.65.1 pre-prod
payments 0.0.1 version-15
assets 0.0.1 pre-prod
sales_commission 0.0.1 pre-prod
projects 0.0.1 pre-prod
india_compliance 15.18.1 pre-prod
erpnext_india 0.0.1 pre-prod
erpnext_crm 0.0.1 pre-prod
hrms 15.39.0 pre-prod
Relevant log output / Stack trace / Full Error Message.
Code of Conduct