BPM to set custom field in SuggPODtl

Epicor ERP 10
,
1

We have been filtering PO Suggestions to only show suggestions that have a job or a requisition number, eliminating stock items. We now are modifying the way we handle stock parts and are going to min/max quantities for reordering, but the min/max will not be on every part.

In an effort to add something to the where clause filter on GetRowsPlant BPM, I added a field to put the max quantity in so the BPM would ignore 0 max quantities. I have tried several different ways of getting the max from the part plant record into the suggestion record but nothing has worked. I have tried both pre and post processing on the Generate BPM and the GetRowsPlant BPM. I really through the post processing on Generate would work.

Does anyone know which BPM I can use to set the UD field so I can add it to the where clause filter?

2

Direct answer: data directive on the POSugg table. It should fire on every row add or update.

Roundabout, but better, answer: I’m not sure I’d ever add a UD field to POSugg, or any other pseudo-temp table associated with MRP. The last thing I want is MRP (which is already a dog) having to also juggle my poorly written BPM’s. I definitely wouldn’t go that route just to pull in some data that is already somewhere else in the system and just needs to be joined to whatever DataView your users are trying to manipulate. Perhaps you can bring in the Part tables via a DataView on the PO Suggestions form.

1 Like