Delete demand link by BPM

Epicor ERP 10
1

I created a persistent method using JobEntry BO to delete a demand link for Job Entry by changing the RowMod to D and executing the Update. The JobProd table is deleted however the ProdQty in JobHead keeps the qty. If I delete the demand manually the JobHead.ProdQty changes to zero, has anyone faced that problem or am I missing something?

PS. the only method that is triggered when deleting is the update.

image
image.png1047Ă—306 18.8 KB

image
image.png979Ă—741 35.2 KB

image
image.png1009Ă—726 30.3 KB

2

What does your code look like? Are you invoking the BO?

3

Yes I’m invoking the BO, this is the code (I hard coded the Job Num for testing):

Erp.Contracts.JobEntrySvcContract hJob = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.JobEntrySvcContract>(Db);
Erp.Tablesets.JobEntryTableset jobDataSet = new Erp.Tablesets.JobEntryTableset();
if (hJob != null)
{

 jobDataSet = hJob.GetByID("2025");
 
 var jobProdRow = (from row in jobDataSet.JobProd
                   where row.Company == Session.CompanyID && row.JobNum == "2025"
                   select row).FirstOrDefault();
 if (jobProdRow != null)
 {
      jobProdRow.RowMod = "D"; //  Deleting the make to stock demand link 
      hJob.Update(ref jobDataSet);
 }

}
hJob = null;

4

Not sure if this will make a difference or not, but instead of using RowMod=“D”
Try setting the RowState

jobProdRow.SetRowState(IceRowState.Deleted);
1 Like
5

Have you tried updating the jobprod quantity yourself on the jobhead table add setting its rowmod to u in the same dataset?

(I’m on mobile so haven’t checked if it is in fact a field in the jobhead table)

6

It would also be in the JobAssembly table and the Material Labor, Costs etc calculations would be off. Updating the field in the DB wouldn’t fix those things in my experience.

7

It would be passed through the business logic so wouldn’t that take care of things? Having said that I assumed that deleting the demand link would have done the same.

8

Ah yeah, however I don’t believe that that field is updatable (directly) in Jobhead (I may be wrong)

9

Probably not, if the above code is mimicking what’s happening in the trace then I’ll just shrug

10

Thank you @josecgomez and @Ben_Bowtell, setting the rowstate did the trick.

Thanks again!