SALE INVOICE WRONG RECORD

[Folies2013]

HEY,

I got an error when I record and a save the sale invoice 792 / sale order 655
the items FG-RTB-5026
the sale order was 5 boxes but it it recorded 97 boxes .
I try to make credit note of 92 boxes
but an error arise

ERROR Message Report : The credit quantity for the line for FG-RTB-5026( item code) is more than the quantity invoiced. This check is made to ensure that the credit note is not duplicated.

I can access the database but and erase the transaction but I scared that it links to somewhere else.

What is the solution ?

I cannot make a credit note
I try to reverse the transaction in journal entry but It does not allow.
how I delete this sale invoice 792
and record again

what is the step to do?

Thank you for your help
Cheers

[agaluski]

The problem exists with the below code around line 495 in Credit_invoice.php
The code doesn't allow a credit if you over ship (Shipped more than original qty ordered)
If you remove the highlighted line you should be able to create a reversal.

$SQL = "SELECT count(*) FROM salesorderdetails WHERE orderno = '" . $_SESSION['CreditItems'.$identifier]->OrderNo . "'
AND stkcode = '" . $CreditLine->StockID . "'
AND quantity >=" . $CreditLine->QtyDispatched . "
AND qtyinvoiced >=" . $CreditLine->QtyDispatched;

[Folies2013]

thank you for you help