query

[Former Member]

Hi,

i jus need a query for rejection details,it should be like

doc num,doc date, item no, item name, ref num, received qty, rejected qty and reason for rejection...

regards,

Vignesh.R

[Former Member]

Hi Vignesh.......

Please refer OIGN and OGN1 table where you get all those details you require.

For more accuracy you can join OWOR table also.......

Regards,

Rahul