stecorp
16th December 2013, 06:43
I am trying to create a session to get all the top level items for a low level item. Each low level item is linked to multiple items.
eg.,
Top level item - 40
2nd level - 30
3rd level - 20
4th level - 10
Main purpose of the session is to calculate the required inventory of child parts in level 30 (Purchase items) based on the demand forecast in Top level item.
Any logic or method would be a great help.
Get all the top level items for a particular child part and the total quantity to produce the top level items.
I can find the top level item by using the Item Planning "Order Phase Number", but my problem is if the single item is linked to multiple items in sub levels.
eg.,
Top level item - 40
2nd level - 30
3rd level - 20
4th level - 10
Main purpose of the session is to calculate the required inventory of child parts in level 30 (Purchase items) based on the demand forecast in Top level item.
Any logic or method would be a great help.
Get all the top level items for a particular child part and the total quantity to produce the top level items.
I can find the top level item by using the Item Planning "Order Phase Number", but my problem is if the single item is linked to multiple items in sub levels.