Trying to see the item numbers for all the return orders

Hi…

I am trying to set up a screen or a report where I can see the item number and the RMA number…

Please help.

Hi,

RMA number is stored in purch table of order type returned order (PO).

Select the Purch id from the purch table and then you can fetch purch lines based on purch id.

Pranav…

Thanks Pranav…

But I have no idea what you are talking about…I am a new to AX. All I really want to do is for a given items sold on a sales orders, I want to see is there and RMA issued. No easy way it look like…I can scrool through the Return Orders and see if on the bottom of the screen my number shows up, but that sounds the hard way…

Thanks my friend for trying to help…

Cheers…