cancel
Showing results for 
Search instead for 
Did you mean: 

Need Date Selection Criteria

Former Member
0 Kudos

Hii, Experts.

I need one help I am having one query in which i want 'from date' and 'to date'

Here is my query please help me

-------------

SELECT T1.Code as 'Raw Material',

            (select sum(T2.Quantity) from IGE1 T2 where T1.Code  = T2.ItemCode ) as 'issue' ,

T0.[Code] 'Finished Goods',

(select sum(T3.Quantity)  from IGN1 T3 where T0.Code  = T3.ItemCode ) 'Receipt' ,

 

    ( isnull ((select sum(T2.Quantity) from IGE1 T2 where T1.Code  = T2.ItemCode ),0)-

isnull ( (select sum(T3.Quantity)  from IGN1 T3  where T0.Code  = T3.ItemCode ),0 )

    

)

            as ' Closing'

             FROM OITT T0  INNER JOIN ITT1 T1 ON T0.[Code] = T1.[Father]

-----------------------

Thank you in advance

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hii,

I want date which should applicable for both received or issued .

whatever the date range i ll give it should take data from both table within that date range only .

Thank you.

Former Member
0 Kudos

Please help me ...

Thank you

Neelima

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please advice date requirement from received or issued table.

Thank you.