Is there an alternative to the JobEntry business object?

Epicor ERP 10
1

I want to make a REST call to update the MfgComment on JobMtl.

I did a trace in a few places and they all use the JobEntry business object.

The huge downside to this is that that BO will download the entire MOM of the job even if you only want to update a single row of JobMtl.

Small jobs, meh, fine. But I looked at one job for a truck we build and it has

  • 1,799 JobMtl rows
  • 485 JobOper rows
  • 110 JobAsmbl rows

So it takes 21-33 seconds to pull all of that info into the update task even though I know the exact JobNum/Asm/MtlSeq that I want. It’s this long whether I use DMT or a REST call.

So, is there a better way? I am a very low-coder, so I wanted to use the BOs, but all I see being used is JobEntry.

2

Have you tried using the get list method and putting your desired record to update in the where clause?

3

No, but I sure will!

4

Actually, try the GetRows method:

image
image478×709 10 KB

5

@jgehling Bam! Works in milliseconds!

Maybe this is obvious to many here, but I found I had to do a where clause on the job and the asm and the mtl in order to get only one record. Meaning, I needed three where clauses. I assumed one would do it.

Anyway, awesome stuff. I :heart: Functions!

image
image959×1050 78.5 KB

1 Like
6

Nice! Glad it worked out for you. Can’t wait till we are on a version with Functions!

7

Yes! It is life-altering! Really, it changes everything.

And I didn’t say this earlier, but thank you so much for the solution.