Need to display Master Parent of Child item from Bill of Material

Hi All,

I have custom report where i need to display the master parent of particular LITM from F3002.Can anyone help me in writing the logic or in finding out the business functions which display the parent of child item .
Any help is appreciated.

Hi

If you have the component item number and you want to display it's parent, one way is to table IO to F3002 passing in the component item (IXLITM) and the component branch (IXCMCU) in order to return the parent item (IXKITL).

With the correct business view, you could also use the sort order and level breaks in your report, to help you to output IXKITL at the desired point in your report.

You will also need to consider if a component item is on multiple BOMs.

Hope this helps
Aidy

Hi Jyothi,
Do you really suppose that your issue a CNC/Tech issue.
I ask it, because this is the Tech/CNC forum and THERE IS a DEVELOPERS forum on JDEList.
Sorry, it wasn't a help.
Regards,
Zoltán

you're kidding ... right?

If you look at the table layout . . . CPIL is the component/child item, KITL is the parent . . .

Hi Larry

KITL appears in F3002, but CPIL doesn't, it does in F3111 though.

Does this change in version 9? I'm still on 8.11 SP1 for the time being.

In F3002, LITM is the component 2nd Item Number, KITL is the parent.