BAQ Grid with Svc

[LizaAleman (Lizbeth Aleman)]

The PoSuggestion gird requested that 5 columns be added, 2 for customer and 3 for part.

Perform a baq, and add a column to see how it filled but it sends it empty.

This is the configuration of the Svc and the BAQ

[gpayne (Greg Payne)]

@LizaAleman I would do this the same way as the link below using GetRowsPlant.
Part should work like that, but you have an inner join to JobProd and I think even buy direct material will be an outer join to JobMtl on jobNum, AsmSeq and MtlSeq.

If the material is not buy direct then it is doable, but more complex to match the suggestion to the job material(s)

Application Studio Help!

@Pgilbert I was just going to tell you how this worked in classic and hope it worked the same, but I took the opportunity to do the process in Kinetic since I had not before and it was very close to classic. I added a field called volume_c to the SugPODtl table and then regenerated the data model. Reopened Epicor and the field showed in the data section @jwphillips showed above and was available to add to the grid in application studio. I added a NetVolume to the top part in my list and reopene…

[LizaAleman (Lizbeth Aleman)]

I joined the JobProd tab because they want to see the customer information, I couldn’t find another way to bring me the customer information

[gpayne (Greg Payne)]

do you have data in suggestions for all job material? If not that needs to be an outer join. You can also possibly have multiple JobProd records.

[LizaAleman (Lizbeth Aleman)]

SugPoDetail has the JobNum field, with that I link SugPoDetail and JobProd