Cause:
The System will not allow you to save Sales return if the quantity or lot number returned does not match invoice. System shows the following error ‘Invalid Quantity, Total Sales return qty exceeds the invoice quantity’ or ‘Full return mismatch in number of lines in invoice trace and Sales return detail, please ensure the detail lines are matching’.
Sometimes, the user enters an item and quantity and lot on that base invoice was pulled but in invoice it was scheme product so 2 lines entered 40+10 due to which it was giving error if the users try to split in the same manner.
Remedies:
Split of item quantity functionality does not exist in the Sales return(return) screen. Hence users should ensure that the quantity entered manually in Sales returns should be the same as in the invoice before finishing the transaction. Also users need to ensure that the lot numbers should be the same as in the invoice.