WIP ISSUE

[ddoracle]

hi,

>

> In wip CUSTOM report,i have this issue..

>

> In the assembly, there are items and subitems - eg, item fan and its

> subitem blade..

> This report has to display those subitems whose onhand qty is 0.

> But the report displays few subitems correctly which has onhand qty 0

> but som of same subitems with onhand qty 0 is not displaying.

> Is there any functional setup missing or can any one provide the

> solution.

> I have attached the query of the custom report.Can anyone help me, why certain items of same type not getting displayed whose onhand qty is 0, while few same type items of onhand qty 0 are getting displayed

> Thanks in Advance



[img]/images/icon_zip.gif[/img] <b>Attachment:</b> WIP QRY.zip <i>( 3505bytes )</i>