Update Make To Stock Qty in BAQ

Epicor ERP 10
,
1

Hello, I want to update the Make To Stock qty (Job Entry) in BAQ and set JobProd.ProdQty as the updatable field in the BAQ. In a test run, Update returned:

Query returned 1 row(s).
Updatable query action fulfilled and reported no error.

But Qty was not updated.

In DMT, the column is MakeToStockQty. If this is not in JobProd, I’m looking for the table needed for this update. Thanks.

2

From the updatable BAQ, I can change JobHead.ProdQty and the job total quantity is updated in the Job Entry panel. When I did the same with JobProd.ProdQty, the BAQ Update returns no error but the Quantity in “Make To Stock” tab from the Job Entry panel did not get updated.

3

Were you able to figure this out? I’m creating a similar BAQ, but mine does return an error when I updated (index is out of bounds). The JobHead.ProdQty updates but then the Job Prod and Job Part quantity fields do not.

4

Here is a snipit of what I use that does update in my job update BAQ

Erp.Tablesets.JobEntryTableset ds = new Erp.Tablesets.JobEntryTableset();

      ds = job.GetByID(jh.JobNum);

      if(ds.JobProd[0].MakeToStockQty  != Convert.ToDecimal(ttr.Calculated_MakeToStockQty))
      {
        ds.JobProd[0].MakeToStockQty  = Convert.ToDecimal(ttr.Calculated_MakeToStockQty);
        ds.JobProd[0].RowMod = "U";
        job.Update(ref ds);
      }
5

UpdateQtyWidgetBPM.pdf (73.6 KB)

Here is a solution for anyone in the cloud, this gets added in the uBAQ “Update”>“Update Processing”>“BPM Directives Configuration”
It is added as a pre-processing step to the update method