I have a model which shows shortages on Production lines.I am able to calculate the shortages and it works wonderfully for the purchased parts. So basically if a MO is short of a Purchased part.. its shows the relevant information about PO which helps. I am getting stuck at the Manufactured parts level. If a MO part is short of Manufactured part..I want qlikview to be able to do a recursive call to the MO file and find the MO details regarding this component which is short.
The Momast is the manufacturing order master file containing order number, top level item number which is FITEM, planner and the scheduled start date. This file relates to MOdata which is the mnf component file. It contains all the components (CITEM) required to make the top level MO item. Which I have related again to MOMAST to get the order details for these components. Hence giving info for two levels down. What I want to achieve is for this to blow down to the bottom. ITEMBL file helps us giving the on hand quantity MOHTQ. POITEM is the purchase order file giving relevant info about the purchase parts identified by LTCOD 'P' or 'M'.
For example, if I choose FItem(Top Level Part) 5002227, it shows components which are short-in red, one component being 200813(lower level). - This is perfect. But if we clear all and select 200813 as the Top Level Part, we see that component 200813 has further component shortages(going to an even lower level).I want to be able to show these without having to clear Top Level Part and selecting 200813.
