Articlecctransactions

Report ArticleCCTransactions

• Filename: ArticleCCTransactions
• Title: Duty Free/Cleared Transactions for :Article.
• Sample: Unit138

Synopsis

Report to see all customs transactions for an article.

SQL

SELECT
  'IN' AS TSIGN,
  INVOICE AS AVIZNO,
  ARTCODE,
  QTY,
  STOCKCODE,
  STOCKCODE AS OriginalSTOCKCODE,
  SUPPLIER,
  PCNAME,
  FILLDATE,
  TransactionType,
  COMMENTS
FROM
  INVDETAILSCC
WHERE
  (ARTCODE=:ArticleID)
UNION
SELECT
  'OUT' AS TSIGN,
  AVIZNO,
  ARTCODE,
  (-1)*QTY AS QTY,
  STOCKCODE, OriginalSTOCKCODE,
  SUPPLIER,
  PCNAME,
  FILLDATE,
  TransactionType,
  COMMENTS
FROM
  OUTDETAILSCC
WHERE
  ARTCODE=:ArticleID
ORDER BY
  TSIGN ASC, FILLDATE DESC

new SQL:

SELECT
  'IN' AS TSIGN,
  I.iCode AS AVIZNO,
  a.aCode as ARTCODE,
  CC.idcQuantity as QTY,
  CC.idcStockCode as STOCKCODE,
  CC.idcStockCode AS OriginalSTOCKCODE,
  C.cName as SUPPLIER,
  U.uLogin as PCNAME,
  CC.idcCreatedOn as FILLDATE,
  cc.idcTransactionType as TransactionType,
  cc.idcComments as  COMMENTS
FROM
  InvDetailCC CC
  inner join inv I ON (CC.idcInvFK=I.iID)
  inner join Article A  ON (CC.idcArticleFK=a.aID)
  inner join Customer C  ON (CC.idcCustomerFK=C.cID)
  inner join [user] U  ON (CC.idcChangedByFK=U.uID)
WHERE
  (a.aID=:ArticleID)
UNION
SELECT
  'OUT' AS TSIGN,
  O.oCode as AVIZNO,
  a.aCode as ARTCODE,
  (-1)*CC.odcQuantity AS QTY,
  CC.odcStockCode as STOCKCODE,
  CC.odcOriginalStockCode as OriginalSTOCKCODE,
  C.cName as SUPPLIER,
  u.ULogin as PCNAME,
  CC.odcCreatedOn as FILLDATE,
  cc.odcTransactionType as TransactionType,
  cc.odcComments as COMMENTS
FROM
  OutOrderDetailCC CC
  inner join OutOrder O ON (CC.odcOutOrderFK=O.oID)
  inner join Article A  ON (CC.odcArticleFK=a.aID)
  inner join Customer C  ON (CC.odcCustomerFK=C.cID)
  inner join [user] U  ON (CC.odcChangedByFK=U.uID)
WHERE
  (a.aID=:ArticleID)
ORDER BY
  TSIGN ASC, FILLDATE DESC

Parameters

• ArticleID ID of article

Accessible in forms

• ArticlesGrid
• ArticleStock