Returnordercontent

Report ReturnOrderContent

• Filename: ReturnOrderContent
• Title: Order with damaged pallets
• Sample: Unit127

Synopsis

List of damaged goods pallets.

SQL

SELECT
  A.*,
  (SELECT TOP 1 X.LOCATION+ '   '+STR(COUNT (X.ID))+' pcs'  
   FROM
     Invdetails X
   WHERE
     (X.COLNO=A.PALNO)
   GROUP BY
     X.LOCATION
   ORDER BY
     COUNT(X.ID) DESC
  ) AS LOCATION
FROM
  RETUROUTDET A
WHERE
  (IDNO=:OrderNo)
ORDER BY
  PALNO ASC

Parameters

• OrderNo returout ID.

Accessible in forms

• Returns