I am using Adobe Commerce ver. 2.4.6-p1 and we are getting error while print pdf of credit memo. It is returning error.
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT main_table.*, sales_alias.tj_salestax_sync_date FROM sales_creditmemo_grid AS main_table LEFT JOIN sales_creditmemo AS sales_alias ON main_table.entity_id = sales_alias.entity_id WHERE (((entity_id IN('1'))))
Steps to Reproduce
Go to Credit memo grid
Select a credit memo from checkbox and select 'PDF Credit Memo'
An error will occur
Expected Result
Go to Credit memo grid
Select a credit memo from checkbox and select 'PDF Credit Memo'
It should open PDF for credit memo
Actual Result
Go to Credit memo grid
Select a credit memo from checkbox and select 'PDF Credit Memo'
It returns an error.
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT main_table.*, sales_alias.tj_salestax_sync_date FROM sales_creditmemo_grid AS main_table LEFT JOIN sales_creditmemo AS sales_alias ON main_table.entity_id = sales_alias.entity_id WHERE (((entity_id IN('1'))))
Prerequisites
I am using Adobe Commerce ver. 2.4.6-p1 and we are getting error while print pdf of credit memo. It is returning error. SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT
main_table
.*,sales_alias
.tj_salestax_sync_date
FROMsales_creditmemo_grid
ASmain_table
LEFT JOINsales_creditmemo
ASsales_alias
ON main_table.entity_id = sales_alias.entity_id WHERE (((entity_id
IN('1'))))Steps to Reproduce
Expected Result
Actual Result
main_table
.*,sales_alias
.tj_salestax_sync_date
FROMsales_creditmemo_grid
ASmain_table
LEFT JOINsales_creditmemo
ASsales_alias
ON main_table.entity_id = sales_alias.entity_id WHERE (((entity_id
IN('1'))))Versions
This is our Version Adobe Commerce ver. 2.4.6-p1