Skip to Content
0
Jun 15, 2011 at 08:50 AM

Query Check

99 Views

Dear Experts..

Here I create a query for Total Sales Report within date range with BOM details.

SELECT T0.[DocNum], T1.[ItemCode], T1.[Dscription],T1.[Quantity], T1.[Price], T2.[Code], T4.[ItemName], T2.[Quantity] FROM OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry, ITT1 T2 INNER JOIN OITT T3 ON T2.Father = T3.Code INNER JOIN OITM T4 ON T2.Code = T4.ItemCode WHERE T1.ITEMCODE = T2.FATHER AND T0.DOCDATE >=[%0] AND T0.DOCDATE <=[%1]

BOM level goes upto 2 to 3 level, but in this I acn able to get only first level report.

i.e. BOM Code = ABCD

Component = A,B,C,D

Sub Component = A1,B1,C1, D1

In above report I can only able to get first level BOM report instead I need full BOM report by sales within date range like Parent Code, Component, Sub Component.

Plz let me know needful changes in Report.

Thanks in Advance,

Regards,

Ravi