We are running Magento 18.104.22.168 on a Linux CENTOS 7.3 x86_64 standard – host cPanel & WHM 64.0 (build 36); We have been running since December 24th 2016. We are very happy for the most part. Main issues are extension conflicts and slightly unstable Magento upgrades using Softaculous. I have a strange situation involving an order. The order looks normal in the Admin panel except when I go into Order view and view the Invoices. It shows no invoices, status of the order is Processing. Order appears to have been processed normally meaning the Customer received an Order Confirmation email, the payment was process successfully in Authorize.net, payment captured, and the Comments History shows an invoice was created at the time of the order. When I inspect the database using phpMyadmin, I see the invoice record in the sales_flat_invoice table. Do you know why the invoice would exist in the table and not display under Invoices under Sales/Orders?
UPDATE: Upon further inspection, I found that the probable cause for the invoice not being displayed is because the record is missing from the sales_flat_invoice_grid. If that is true, is there a way to repair this in Magento?
UPDATE: Two weeks and no one has replied to this post. Yesterday, I found 5 orders with this condition. Am I the only one experiencing this problem?
The problem is intermittent for me. Since July 25th, out of 81 orders, 7 have this condition. I recently upgraded the Magento 22.214.171.124 and still the problem persist. The only way I can clear the order is to marked it Shipped. The Invoice button on the edit order page does not appear. The invoice to show the order is paid is there, but Magento does not have the record in the Grid so I assume Magento considers it a "Quote" and does not know to treat it as an "Order". Does anyone know of a way to debug this problem by tracing the function that creates the order at checkout?
It appears we are not going to get any help on this blog. I plan to post the same problem on Magento Stack Exchange later today.
Hi there, did you find a solution for this? We are facing the same issue. Invoice is in the database, but not on the grid and we don't see the invoice button or can't generate a pdf invoice. We start seen this issue after we moved to ShipperHQ. But is occasionally we haven't find a pattern.
It occurs mainly for Order status is 'processing' due to the following up of a cancellation of payment and then successful payment in successive transactions.Hence item staus remains cancelled.So no chance of making an invoice.
'Solution not found here still'
I have the same issue in magento 126.96.36.199. Is someone have found a solution or a workaround ?
I need to display the "order invoice" button.