Defaulting the JobOpDtl.ResourceID field

Rowley150 · January 3, 2018, 11:12am

Epicor version 9.05.701

I’m looking to default the JobOpDtl.ResourceID field to “unassigned” every time an operation is added, the only condition i need is only do this when the field is blank.

Here is some ABL i have written but it doesn’t seem to work:

For each ttJobOpDtl no-lock.
If ttJobOpDtl.ResourceID = ? Then Do:
/* Set the ResourceID field of the added row to the “unassigned” expression */
Assign ttJobOpDtl.ResourceID = “Unassigned”.
End.
End.

I have applied this ABL to a Data Directive using the JobOpDtl table in the Standard tab.

This code needs to work when:

a job is added through job entry manually.
when MRP is ran and unfirmed jobs are created through their too.

Any help would be much appreciated.

markdamen · January 3, 2018, 12:17pm

On the Data Directive, my understand is this:

Standard Fires after the row is committed to DB. Used for email alert, logging etc. Too late to make any changes to tt Table

In-Trans Fires before the row is committed to DB. Use this one to make changes to the tt

Regards
Mark

Rowley150 · January 3, 2018, 12:21pm

Hi Mark,
i’ve tried In-Transaction, but no change.

markdamen · January 3, 2018, 1:05pm

I’m not really familiar with ABL, hopefully somebody else jumps in to help. Only thing I would try is

If ttJobOpDtl.ResourceID = ‘’ Then Do:

The change being single quotes for the test, rather than ?

kalbee · January 3, 2018, 1:46pm

What I would do instead is create a Method Directive under JobEntry.Update that has a criteria stating that ""There is at least one added row in the ttJobOpDtlTable. Then try utilizing the following code:

Find First ttJobOpDtl Where ttJobOpDtl.RowMod = ‘A’ or ttJobOpDtl.RowMod = ‘U’ no-lock.

If Available ttJobOpDtl then do: Assign ttJobOpDtl.ResourceID = “Unassigned”.

End.

Rowley150 · January 3, 2018, 2:06pm

Hi Kevin,

I tried this as per screenshots - but still no joy.
I wasn’t 100% sure on how to write the condition, so i thought well if i can get something going for no conditions that would be a good start, but nothing.

kalbee · January 3, 2018, 2:11pm

Sorry about that, I should have clarified that it should be in the Pre-Processing! As far as I’m aware, you can only update the temporary tables in the Pre and Base processing. (I also stray away from using Base-Processing as this is when the Epicor process is active for the function and it’s better to perform user functions before or after it)

Rowley150 · January 3, 2018, 2:21pm

Changing it to Pre-processing didn’t really work, when i added an op its just greyed the fields out and left them blank.

kalbee · January 3, 2018, 3:01pm

Alright, got it figured out! Head back to what you were doing originally in Data Directives, but utilize the In-Transaction instead of Standard. And then try out the following code again with the condition set to “There is at least one added row in the ttJobOpDtl table”.

Find First ttJobOpDtl Where ttJobOpDtl.RowMod = ‘A’ or ttJobOpDtl.RowMod = ‘U’ no-lock.

If Available ttJobOpDtl then do: Assign ttJobOpDtl.ResourceID = “Unassigned”.

End.

Rowley150 · January 3, 2018, 3:22pm

Hi Kevin,
I think it works - the only bit im not sure about is i need it to be only applied where the resourceID field is blank.
So if its normally filled with data, to leave it be…which maybe just another condition?

I’ll test some data and report back.

Thank you.

Rowley150 · January 3, 2018, 3:26pm

so this is when the BPM isn’t enabled:

and this is when it is enabled:

So, its certainly getting closer, it just requires a further condition either in the ABL or directly in the BPM to only apply it when the field is null/blank.

Rowley150 · January 3, 2018, 3:42pm

A bit more testing, but i think this is it.

markdamen · January 3, 2018, 3:46pm

Just do a condition block in the BPM.