Lost Sales Analysis

[miguelitrojop]

Hi is there anyway to generate a report that show the lost sales one has between the PO of the customer and the invoice when we don't have enough to complete the PO?

[TimSchofield]

The following SQL should provide you with a list of order numbers where the whole quantity wasn't invoiced but the line is marked as complete

SELECT orderno FROM salesorderdetails WHERE quantity<>qtyinvoiced AND completed=1;

If this is what you want then it wouldn't be hard to work that SQL up into a report,

Thanks
Tim

[miguelitrojop]

Hi Tim:
Thanks a lot that is exactly what i need.