We are trying to export into Excel a report that shows the multiple level of parts that are in the structures on the “Complete Where Used” screen, see example below:
The levels can be complex as one part number can have several layer deep. Is there a standard IFS report that can show this information or would a complex SQL report need to be written? We are on IFS Apps 9, update 16.
Thanks,
Mark
When I need the full structure of an item, I tend to use the Product Structures > Multi Level Structure tab and export directly to Excel. This works find for one part at a time, if you have a large number of them to do, then a query on the manufacturing structures would likely be required.
I don’t think there is a standard report to get what you want from the Complete Where Used.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.