diff --git a/erpnext/accounts/general_ledger.py b/erpnext/accounts/general_ledger.py
index 994c7c3..eacb318 100644
--- a/erpnext/accounts/general_ledger.py
+++ b/erpnext/accounts/general_ledger.py
@@ -91,7 +91,7 @@
 		frappe.qb.from_(acc_dimension)
 		.inner_join(dimension_detail)
 		.on(acc_dimension.name == dimension_detail.parent)
-		.select(acc_dimension.name, dimension_detail.offsetting_account)
+		.select(acc_dimension.fieldname, dimension_detail.offsetting_account)
 		.where(
 			(acc_dimension.disabled == 0)
 			& (dimension_detail.company == company)
@@ -100,8 +100,7 @@
 	).run(as_dict=True)
 	accounting_dimensions_to_offset = []
 	for acc_dimension in acc_dimensions:
-		fieldname = acc_dimension.name.lower().replace(" ", "_")
-		values = set([entry.get(fieldname) for entry in gl_map])
+		values = set([entry.get(acc_dimension.fieldname) for entry in gl_map])
 		if len(values) > 1:
 			accounting_dimensions_to_offset.append(acc_dimension)
 	return accounting_dimensions_to_offset