I have run the Product Exception Report and it is showing the Serial qry is not the same as the total qty. But when I check my products, the totals are the same.
This report compares the qty total and the Soldlink on the Prodsn table. As we can see here there is only one line that has a a quantity of one and a blank Soldlink.
If we investigated further we would see that the product 1254 011 5814 Serial number 436601010 was sold on audit 2308267 and then returned again.
A warning note will be added to this report.