Kittingstockinproduction

Report KittingStockInProduction

Filename: KittingStockInProduction
Title: Kitting stock in production area
Sample: Unit131

Synopsis

List of products available in production area.

SQL

SELECT
  A.AVIZNO, C.ARTCODE AS MASTERCODE, C.QTY AS KQTY, C.READYQTY,
  A.artcode, B.stockcode, A.qty , A.QTYCF, A.TransitLocation
FROM
  OUTDETAILS A,
  INNER JOIN INVDETAILS B ON
    (b.ID = a.INVOICENO)
    AND (b.STOCKCODE = a.STOCKCODE)
    AND (b.ARTCODE = a.ARTCODE)
  INNER JOIN CGROUP C  ON AND (A.AVIZNO='KG'+CAST(C.ID AS VARCHAR(15)))
WHERE  
   (pickedby<>'')
   AND (A.TransactionType = 'KIT')
   AND (isnull(checkedby, '') = '')
ORDER BY
  A.AVIZNO , C.ARTCODE, A.ARTCODE

Parameters

None.

Accessible in forms

Kitting