Friday, February 3, 2012

Verify Begining Balances in Item As Off F41112


SELECT T1.INITM,
       T1.INLITM,
       T1.INAITM,
       T1.INMCU,
       ((SUM(T1.INCMQT) + SUM(T1.INNQ01) + SUM(T1.INNQ02) + SUM(T1.INNQ03) +
       SUM(T1.INNQ04) + SUM(T1.INNQ05) + SUM(T1.INNQ06) + SUM(T1.INNQ07) +
       SUM(T1.INNQ08) + SUM(T1.INNQ09) + SUM(T1.INNQ10) + SUM(T1.INNQ11) +
       SUM(T1.INNQ12)) / 1000) "11 BALANCE_QTY",
       SUM(T2.INCMQT / 1000) "12 Begining Balance"
  FROM PRODDTA.F41112 T1, PRODDTA.F41112 T2
 WHERE T1.INDCT = 'BF'
   AND T1.INFY = 11
   AND T1.INCTRY = 20
--   AND T1.INMCU = '     3100011'
  -- AND T1.INLITM IN ('F216922', 'F354448')
   AND T1.INITM = T2.INITM
   AND T1.INMCU = T2.INMCU
   AND T1.INDCT = T2.INDCT
   AND T1.INCTRY = T2.INCTRY
   AND T1.INLOCN = T2.INLOCN
   AND T1.INLOTN = T2.INLOTN
   AND T1.INGLPT = T2.INGLPT
   AND T2.INFY = 12
 GROUP BY T1.INITM, T1.INLITM, T1.INAITM, T1.INMCU

HAVING (((SUM(T1.INCMQT) + SUM(T1.INNQ01) + SUM(T1.INNQ02) + SUM(T1.INNQ03) +
       SUM(T1.INNQ04) + SUM(T1.INNQ05) + SUM(T1.INNQ06) + SUM(T1.INNQ07) +
       SUM(T1.INNQ08) + SUM(T1.INNQ09) + SUM(T1.INNQ10) + SUM(T1.INNQ11) +
       SUM(T1.INNQ12)) / 1000))<>
       (SUM(T2.INCMQT / 1000))

No comments:

Post a Comment