Returnmovinglist

Report ReturnMovingList

• Filename: ReturnMovingList
• Title: Return order moving list
• Sample: Unit135 (Form135)

Synopsis

Print a returned goods moving list

SQL

Master Master list

SELECT
  A.*,
  B.NAME2,
  isnull( A.SUGESTEDLOCATIONRET , 'x') AS XLOCATION,
  isnull(Y.sqwpk, 'X') AS MySQ
FROM
  INVDETAILS A  
  LEFT JOIN Location Y ON (isnull( SUGESTEDLOCATIONRET , 'x')=Y.LOCATION)
  INNER JOIN ARTICLE B ON (A.ARTCODE=B.NAME)
WHERE
  (A.INVOICE=:INVOICE)
ORDER BY
  MySQ, A.ARTCODE ASC

SuggestedLocation : suggested location(s) for an item, master-detail with master list.

SELECT
  A.LOCATION,
  A.StockCode,
  SUM(QTY) AS QTY
FROM
  SUGESTED_STOCK_LIST A
WHERE
  (A.ARTCODE = :Artcode)
  AND (A.STOCKCODE = :StockCode)
  AND left(LOCATION, 1) IN ('M', 'H')
GROUP BY
  A.LOCATION, A.StockCode, LocationLevelPriority
HAVING
  SUM(QTY)>0
ORDER BY
  LocationLevelPriority ASC, A.LOCATION asc

Parameters

• Invoice The ID of an invoice.

Accessible in forms

1. Returns