Ga naar inhoud

Nrwlocalarticleswithoutstock

Report NRWLocalArticlesWithoutStock

  • Filename: NRWLocalArticlesWithoutStock
  • Title: Norwex Local Articles Without Stock
  • Sample: Unit219

Synopsis

List of Norwex Local Articles Without Stock

SQL

SELECT
    A.ARTCODE, sum(QTYIN-isnull(QTYOUT, 0)) as QTY
  FROM
    Stoctotal A
    INNER JOIN NRW_ARTICLE_GLOBAL B ON
     (A.ARTCODE=(CASE WHEN isnull(LINKEDARTCODE2, '')=''
                     THEN 'NW'+B.ARTCODE+'.'+LINKEDARTCODE1
                     ELSE 'NW'+B.ARTCODE+'.'+LINKEDARTCODE1+'.'+LINKEDARTCODE2
                END))
  WHERE (STOCKCODE='75')
Group by
  A.ARTCODE
HAVING
  sum(QTY)=0

Parameters

None.

Accessible in forms