<![CDATA[FrontAccounting forum — Sales Order View showing DN and INV of an year old order]]> https://frontaccounting.com/punbb/viewtopic.php?id=9118 Tue, 15 Dec 2020 16:26:34 +0000 PunBB <![CDATA[Re: Sales Order View showing DN and INV of an year old order]]> https://frontaccounting.com/punbb/viewtopic.php?pid=38743#p38743 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.

]]> Tue, 15 Dec 2020 16:26:34 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=38743#p38743 <![CDATA[Sales Order View showing DN and INV of an year old order]]> https://frontaccounting.com/punbb/viewtopic.php?pid=38737#p38737 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?

]]> Mon, 14 Dec 2020 11:13:34 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=38737#p38737