Link Child Job to Parent Job Mtl Detail Screen

[LBARKER (Lawson Barker)]

Hello All,

What I’m trying to do is display the child Job that is linked to a Material in the parent Job

I’ve created a BAQ that links the JobMtl to JobProd on JobNum = TargetJobNum and MtlSeq = TargetMtlSeq and AssemblySeq = TargetAssemblySeq

I added three Parameters JobNum, Assembly Seq and Mtl Seq
The BAQ works fine and shows the data required

I’ve done Dynamic data quires linked to a button before but in this case, I want it to do the query when you navigate to the Job Details>Materials>Detail screen (No Buttons)

Any help would be greatly appreciated - or pointers to another post that I may have missed while trying to find a solution

Version: 10.2.400.13

[LBARKER (Lawson Barker)]

Ok, after a bit more searching I found a couple of handy posts and I’ve got a BAQ Data View working

BAQ Dataview Example Video

Here’s an example video of how to do a BAQ dataview. BAQ Dataviews are a great way to view related data onto a screen in Epicor. If you can link the data on the screen to the data you want to display in a BAQ you can display it. They are faster and more flexible than FKVs or embedded dashboards. [Epicor BAQ DataView] and the code. public void CreateOrderLineOnHandBAQDV() { orderLineOnHandBAQDV = new BAQDataView("OrderLineOnHand"); oTrans.Add("OrderLineOnHandBAQDV",orderL…

BAQ Data View

I have created a BAQ Data View that I would like to be able to subscribe to a text box in my Dashboard. This is just a free form text box that when a customer ID is entered into it the BAQ Data View will subscribe to it and reset the DataView. @josecgomez helped me with the Data View. //Customer - Customer Data View private void CreateCustomerBAQView() { GS_Customer_DataView = new BAQDataView("GS_Customer_DataView"); oTrans.Add("GS_Customer_DataView", GS_Customer_DataView); var CustID = …

[Gil_V (Gil Violette)]

Why not just indent the job on the method? Then you will have one job with two levels, the parent and the child. Same job number means they will be linked together! Plus, the child and parent will have a coordinated schedule.

[LBARKER (Lawson Barker)]

Sometimes the Production Planner only wants to release part of a Job, so he creates a Material and links another Job to it, if there was a way to engineer and release a subassembly that would be great… I haven’t found a way to do that yet

[Gil_V (Gil Violette)]

Talk to your production planner about why they feel the need to do that.

There is a very easy way to have the jobs be created already indented, or leave them separate. It’s a one or the other proposition based upon part/method settings.