• From: Pakistan, Karachi
  • Registered: 10/18/2012
  • Posts: 17

Topic: Sales Order View showing DN and INV of an year old order

Hi Guys,

Something very strange happened, a new sales order is showing invoices and delivery notes linked to it from an order that is an year old.

See image https://ibb.co/n6Z4DQ6

The sales order created in Nov 2020 is showing associated invoices from Aug and Sep 2019. Also a delivery note is associated that is from Aug 2019. All these irrelevant linked documents/transactions belong to another customer they are not even from the same customer.

I was on 2.4.4 and I updated it to the latest 2.4.8 release thinking that it might fix it, but no luck. Does anyone know why this is happening and how to fix this issue?

Post's attachments

sales-order.jpg 56.6 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.
  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,115

Re: Sales Order View showing DN and INV of an year old order

Looks like some primary keys got mangled or indexes are corrupt. Diagnose and fix DB errors in phpMyAdmin or other MySQL client. Also the next auto_increment key may have got jumped.

apmuthu's Website