Directive to populate UD field based on criteria

Kinetic ERP
,
1

Hi all,

We have created a UD date field within JobHead which we are looking to use an in-transaction data directive to populate the field with todays date minus the production prep buffer days stored against the Part

image
image990×668 21 KB

I’ve created a Set Field rule, and can see there is a ‘AddInterval()’ function, but struggling to see how I’d then bring in the Part.ProductionPrepBuffer to this expression when the only available data within this directive is from ttJobHead, as expected.

image
image2463×812 44.7 KB

I was wondering if anyone has achieved something similar when looking at two different tables to use within the same expression, or if I need to be looking at the Set by Query option instead?

image
image1212×592 18.9 KB

Thanks alot in advance!! :smiley:

2

You won’t be able to populate a field from a different table through Set Field widget.

Set by Query would also won’t work in your case.

I remember doing something similar earlier, Update Table by Query should get you started.
Assign relation between this two table.

image
image1425×727 53.5 KB

Display following fields:

image
image970×413 11.3 KB

Under configured settings:
Hit on Bind Automatically and you will see Company,Plant,PartNum binded to Part Plant fields:

image
image991×634 22.7 KB

Also, I don’t have any field to test this but on your custom field where you want to populate, add the expression as:
image

Feel free to post any screenshot if you get stuck!

2 Likes
3

Wow!! :star2: Honestly thank you SO much for this and all the detailed steps too!! Really appreciate it!!! :smile:

I’ve set up the Update Table section, and is it now I need to bring in a Set Field to enter the expression please?

image
image978×720 19.4 KB

4

This expression should update your custom field at ttJobHead upon save. Why do you need Set Field widget?

Can you show your configured settings?

1 Like
5

Ahh sorry, I’m not sure where to enter the expression. So thought maybe I’d need to bring in a Set Field widget. Would it be using Execute Custom Code instead please?

6

You should be able to add it here:

image
image1404×642 183 KB

BpmFunc.AddInterval(BpmFunc.Today(),TimeSpan.FromDays(-queryRow.PartPlant_PrepTime))

Once expression is added, just hit ok, save the BPM, enable it and test it out.

1 Like
7

Sorry!! Please ignore me ha! I’m in the browser and couldn’t see the drop-down arrow! :sweat_smile:

image
image952×603 19.4 KB

1 Like
8

Thank you so much! This has been really helpful :smile:

I think there’s an issue with it not liking PrepTime being an integer trying to subtract from a Date field :thinking:

image
image1376×1081 22.9 KB

9

Wasn’t this the requirement?

10

It certainly was! Thank you for help in getting me to this point. I believe the issue lies with what we are trying to achieve, we will need to reassess due to the data type mismatch.

1 Like
11

Just thought to share the code/expression we have to work around the DateTime/Int error if it helps anyone trying to do something similar :slight_smile:

DateTime.Today.AddDays(-queryRow.PartPlant_PrepTime)

Turns out the criteria has changed and we now need to figure out how to replace Today with JobHead.PlannedKitDate within this expression, so it reads Planned Kit Date-PrepTime so still a bit of a work in progress.

12 
BpmFunc.AddInterval(ttJobHeadRow.PlannedKitDate,TimeSpan.FromDays(-queryRow.PartPlant_PrepTime))

This should help !?

1 Like
13

This worked perfectly!! Thank you SO much!! :smile: :confetti_ball:

Just out of interest, if its possible please, do you know how we could bring in a WeekDay() function to this expression so that it excludes weekends when doing the calculation?