skip to Main Content

I am getting issue on exporting the selected credit memo grid. It is only occurring with the credit memo. Other export is working fine with shipment, invoice, and order.

I am also attaching the error screenshot.
credit memo

2

Answers


  1. You have an SQL query error while exporting the Credit memo data, it happens whenever you something deleted a record in your database.

    Can you please elaborate on more steps:

    -Did you delete some orders associated with the credit memo?
    -Did you delete some invoices of any order?

    Please check and confirm also check the record with entity_id = 1052 in your database table. Run the below query:

    Select * from sales_creditmemo_grid where entity_id = 1052
    Select * from sales_creditmemo_grid where entity_id = 1179
    Select * from sales_creditmemo where entity_id = 1179
    Select * from sales_creditmemo where entity_id = 1052
    
    Login or Signup to reply.
  2. Maybe another way to fix this is if you have added a third-party module that has its own Credit memo Grid within the module to show placed credit memo of each order. This is also conflicting because it is using entity_id from sales_creditmemo_grid as well.

    Error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column ‘entity_id’ in where clause is ambiguous.

    So, you can try in your credit memo collection file and change the method like:

    Replaced this:

    ->addFieldToFilter('entity_id', ['in', $creditmemoIds]);
    

    With this:

    ->addFieldToFilter('main_table.entity_id', ['in' => $creditmemoIds]);
    

    Now all is well! No conflicts!

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search