Adding Field to End Labor Activity that Shows Remaining Quantity

Kinetic ERP
1

I am pretty new to Application Studio and am looking for the simplest approach to accomplish the following:

So I am adding three read-only text boxes to the End Labor Activity application that populates with the following information as reference for the user:

  1. Total operation prod quantity
  2. Quantity completed on the operation
  3. Quantity remaining on the operation

So far, I have done the following:

  1. created a BAQ that supplies the information and added it as a data view
  2. Added the three text boxes, set them as read-only, and set their epbinding to .

Where I am hung up is getting the text boxes to populate with the necessary values from my BAQ. From my research, it sounds like there are a few different ways handle this, but I have not had much luck getting them to work yet. Honestly, the options have been overwhelming, especially when they involve tools I have zero experience with (BPMs), and I am looking for a little hand holding here.

Any help pointing me in the right direction would be greatly appreciated! Even if it’s pointers on what training material I should spend more time with to help myself.

Thanks!

2

You should be able to trigger the BAQ to run after the needed fields are entered via an event.

3

Trigger your baq event off the column changed event of the operation field.

1 Like
4

Ok! I will try creating an event…

Type: DataTable
Hook: Column Changed
Target: LaborDtl
Columns: OprSeq

I am assuming I will need to specify a ‘where’ condition under execution options which returns the baq values that correspond to the specified oprseq value?

5

Its ReportQty not LaborDtl

image
image1743×698 66.4 KB

You can set parameters in your BAQ and retrieve it that way. Or else set up the parent/child on your dataview.

6

So here is what I see, including the three: text fields I have added.

image
image1555×779 64.7 KB

This is the ‘where’ condition I am rolling with: JobOper_JobNum = ?{LaborDtl.JobNum} AND JobOper_OprSeq =?{LaborDtl.OprSeq}

So if I understand correctly, I can eliminate that condition if I configure the parent child relationship between the two dataviews in the same fashion?

7

Oh you’re in end activity not report qty, that’s why our binding is different. Yeah I would probably just do it with parameters in your BAQ. You can map the parameter values in the kinetic-baq widget in the get event. But yeah it should also be possible if you go into your dataview and add the parent relationship there.

8

So “End Activity” application opens with the operation seq already specified, which is based the operation I have selected from the Queue in MES. Does that fact change how I should be configuring the event?

My event didnt appear to work :frowning:

image
image1543×568 27.4 KB

9

Yeah if the operation is already there, you should be able to do after form on load or something like that so it pulls it in right away.

1 Like