Job Closing Function Help

Kinetic ERP
,
1

I need a hand getting this function to work.
Background: We warranty our equipment for 1 year after shipment. There is a BPM that creates a warranty job when the original job ships. There is also a BPM that launches every night using the SysTask table as a trigger to close all of the warranty jobs that are over a year old. Come to find out that the BPM to close the jobs doesn’t run through the entire BO so PartDtl table doesn’t get cleared out, nothing gets written to the change log, etc. But it does check the JobHead.JobClosed and JobHead.JobComplete.

I want to move this to a scheduled function but I can’t get it to work.
I’ve used Jose’s Kinetic Trace Utility to find the methods and recreate them both with widgets and code.
When I run it from Postman the function passes, but it doesn’t actually close the job.
Generating a curl request on the CloseJob method and running that from Postman works fine.

This is the code I have so far. The only input I have for the function is the Job Number (iJobNum).

Erp.Tablesets.JobClosingTableset JobTS = new Erp.Tablesets.JobClosingTableset();

try
{
    this.CallService<Erp.Contracts.JobClosingSvcContract> 
    (boJob => 
        {
            bool f = false;
            string b = "";
            DateTime now = DateTime.Now;
            
            JobTS = boJob.SelectJobByJobNum (iJobNum);          
            //boJob.SelectJobByJobNum (iJobNum);
            boJob.EnableSerialMatching (ref JobTS, out f);
            var JobRow = JobTS.JobClosing[0];
                JobRow.Company = "Giggity";
                JobRow.JobComplete = true;
                JobRow.JobCompletionDate = now;
                JobRow.JobClosed = true;
                JobRow.ClosedDate = now;
            boJob.OnChangeJobClosed (ref JobTS);
            boJob.PreCloseJob (ref JobTS, out f);
            boJob.CloseJob (ref JobTS, out b);

        }
    );  
}
catch 
{
    output = "Dohh!";
}
2

Hi Christian,

At first glance it looks like you’ve missed setting your RowMod on your JobRow variable. Try setting that to “U”.

Thanks,

Nathan

3

Nathan, every time I try setting RowMod it fails!

edit - it is the CloseJob method that is failing. Setting RowMod does not fail. If I comment out the boJob.CloseJob line goes through, but obviously doesn’t close the job.

4

Is it giving you an error message?

5

nope, just the “Dohh!” output.

I just got it to work though. I had to add in all of the fields except the UD ones. It must be looking for something like PartNumber or somethis else. I’ll comment them out one by one and see where the problem is and update this post for anybody who runs into it in the future.
This was one of those things where you bang your head on a wall then finally ask for help and figure it out 5 minutes later.
I appreciate the assist.

6

I know the feeling! Unfortunately, I’ve just rebuilt my laptop so didn’t have an environment to test anything in. Glad to hear you got it working.

7

You may need to send the unchanged table and the changed table in the call to validate that something is changing. Using Buffer copy or something like that.

this is for order but same concepts to apply

BPM Creates Sales Order And Fails To Update Header Order Amounts - Kinetic ERP - Epicor User Help Forum

8

The problem was that the completed qty did not match the production qty. There is a flag in job closing called QuantityContinue that is a required value. If QuantityContinue = 1 then it allows the quantities not to match.
Here’s the finished goods if anybody else ever needs it.

Erp.Tablesets.JobClosingTableset JobTS = new Erp.Tablesets.JobClosingTableset();
try
{
    this.CallService<Erp.Contracts.JobClosingSvcContract> 
    (boJob => 
        {
            bool f = false;
            string b = "";
            DateTime now = DateTime.Now;
            
            JobTS = boJob.SelectJobByJobNum (iJobNum);          
            boJob.EnableSerialMatching (ref JobTS, out f);
           
            var JobRow = JobTS.JobClosing[0];
              JobRow.Company = "**";
              JobRow.JobClosed = true;
              JobRow.ClosedDate = now;
              JobRow.JobComplete = true;
              JobRow.JobCompletionDate = now;
              JobRow.JobNum = iJobNum;
              JobRow.ProdQty = 1;
              JobRow.CompleteQty = JobRow.ProdQty;
              JobRow.QuantityContinue = 1;
              JobRow.RowMod = "U";

            boJob.OnChangeJobClosed (ref JobTS);
            boJob.PreCloseJob (ref JobTS, out f);
            boJob.CloseJob (ref JobTS, out b);
            
        }
    );  
}
catch 
{
    output = "Dohh!";
}
1 Like