Emptylocations

Report EmptyLocations

• Filename: EmptyLocations
• Title: Empty locations
• Sample: Unit172 (Form172)

Synopsis

List of empty locations.

SQL

SELECT
  *
FROM
  LOCATION
WHERE
  left(location, 1) in (:LocationList)
  AND location not in (
    SELECT
      location
    FROM
      STOCTOTAL
    WHERE
      LEFT(location, 1) in (:LocationList)
    GROUP BY
      artcode, location
    HAVING
     SUM(QTYIN-ISNULL(QTYOUT, 0))>0
  )
ORDER BY
  location

(Rework using WITH and LEFT JOIN ?)

Parameters

• LocationList : macro to be inserted in IN.

Accessible in forms

1. StockReports