How to build a report - tree to consume components along with lot numbers

Hi to all.

I would like to build a report - something like a tree to consume components along with lot numbers. There are several levels of semi-finished products in my production. I thought to exit the Item Ledger Entry table, but I don't really know how to build a loop. I think I need to change the entry type once in production and once in consumption. Do you have any experience how to build such a report where it gives the number of the finished product and its lot number and gets information on consumption at all levels along with the lot number?
Thanks for any suggestions
Sign In or Register to comment.