Articlemoves

Report ArticleMoves

• Filename: ArticleMoves
• Title: Moves list for :ArticleCode
• Sample: Unit137

Synopsis

SQL

SELECT
  *  
FROM
  SCANHISTORY A  
WHERE
  (CREATIONDATE BETWEEN :FromDate and :ToDate)
  AND ((:AllMoves=1) or (OpType in (''MOVE'', ''MOVE-FL'', ''TRANSFER'')))
  AND ((ARTCODE=:ArticleID) or (OriginalARTCODE=:ArticleID))

ORDER BY ID DESC

SELECT
  h.*  ,
  L.lName as shLocation,
  L2.lName as shOriginalLocation,
  a.aCode as shArticle,
  a2.aCode as shOriginalArticle,
  U.uLogin as shUsername
FROM
  SCANHISTORY H  
  left join Article A on (H.shArticleFK=A.aID)
  left join Article A2 on (H.shArticleFK=A2.aID)
  left join Location L on (h.shLocationFK=l.lID)
  left join Location L2 on (h.shOriginalLocationFK=l2.lID)
  left join [user] U on (h.shCreatedByFK=U.uID)
WHERE
  (shCreatedOn BETWEEN :FromDate and :ToDate)
  AND ((:AllMoves = 1) or (h.shOperation in ('MOVE', 'MOVE-FL', 'TRANSFER')))
  AND ((h.shArticleFK=:ArticleID) or (h.shOriginalArticleFK=:ArticleID))

ORDER BY shID DESC

Parameters

• ArticleID (integer) Article id.
• ArticleCode (string) Article code
• NotAllMoves integer : 1 for all moves, 0 for just indicated moves.
• FromDate (DateTime) start of period.
• ToDate (DateTime) start of period.

Accessible in forms

• ArticlesGrid
• ArticleStock