Ga naar inhoud

Nrwdisabledlocalwithstock

Report NRWDisabledLocalWithStock

  • Filename: NRWDisabledLocalWithStock
  • Title: Norwex Disabled Local Articles With Stock
  • Sample: Unit218

Synopsis

List of Norwex Disabled Local Articles With Stock

SQL

Select
  A.ARTCODE, A.LOCATION, A.STOCKCODE, sum(QTYIN-isnull(QTYOUT, 0)) as QTY
FROM
  Stoctotal A
WHERE
  LEFT(A.ARTCODE, 2)='NW'
  AND ARTCODE LIKE '%.%'
  AND STOCKCODE='75'
  AND QTYIN-isnull(QTYOUT, 0)>0
  AND  A.ARTCODE NOT IN (
      SELECT (CASE WHEN isnull(LINKEDARTCODE2, '')='' then 'NW'+B.ARTCODE+'.'+LINKEDARTCODE1 ELSE 'NW'+B.ARTCODE+'.'+LINKEDARTCODE1+'.'+LINKEDARTCODE2 END) FROM NRW_ARTICLE_GLOBAL B
  )
GROUP BY
  A.ARTCODE, A.LOCATION, A.STOCKCODE

Parameters

None.

Accessible in forms