Set Field PartPlant fields using Erp.BO.Part.Update

Kinetic ERP
, , ,
1

Hi All,

Just out of interest has anyone else came across issues with using a bpm to set a field on the PartPlant table? (Both Pre and Post)

When using a data directive to set PartPlant.KitTime as ‘123’, it works without issue, but we think we need a BPM so we can apply further logic. This being to add a condition that looks to see if the Part.TypeCode = ‘M’.

We’ve got a pre-processing method and the conditions to check TypeCode field working, but having checked the debug tools, PartPlant.RowMod is not “U” or “A” so we can’t get set field to work on either a Pre or Post method.

Swinging back around to using a data directive which works for us. Does anyone know of a way to link a data directive to a condition based off the part table please?

Thanks as always for all the help! :slight_smile:

2

For your condition on the data directive on PartPlant choose the Number of rows in the designed query is more or equal to 1 option.

In the query, join ttPartPlant to Erp.Part on Company and PartNum, then add a criteria to Part for TypeCode = “M”.

From the true side of your condition, put your set field(s) I think you were wanting to set prep time and kit time?

1 Like
3

Thank you so much Cory!!! Been going around in circles on this one, and what you suggested worked a charm! :slight_smile: