We have an odd situation where we have jobs showing complete but still have a demand showing in Time Phase. We, the IT department, have been tasked with building a dashboard which shows all jobs marked complete but still have a demand greater than 0. Since there is no true database table that we can pull Time Phase data from, I am looking for a way to calculate this so that we can put together a list of all jobs that meet this criteria. I may just be having a total doofus moment but It is just not coming to me on how to show demand per job dynamically in the BAQ. Anyone have any thoughts?
Hello, have you tried PartDtl table? if i am not mistaken the JM sourcefile records represent demand from job materials. then you can link those on the job tables to find the ones that still show in time phase but the job is closed
3 Likes
Thank you Janae, I’ll check it out.