Updating PO Release Promise Date When Updating PO Header Promise Date

Kinetic ERP
,
1

Afternoon all!

I have a BPM that is checking if my purchase order has been confirmed and if there is no value in the Promise Date field of the POHeader. If both are true, then it updates the header Promise Date to match the header Due Date, as well as all releases’ Promise Dates to match all releases’ Due Dates.

Now, the first part works, and updates the header as such, but I cannot get the PORel.PromiseDate to update. I’ve looked through the console to see what else could get called, but it really just looks like it calls the main PO.Update BO when it saves a release as well as the header. Anybody have some insight here?

Method Directive and Console window are below :

image
image1726×1345 345 KB

image
image1179×1536 154 KB

2

While it does use the POUpdate to update PORel, my guess would be that it isn’t updating PORel because you’re not sending in any PORel records to be updated.

Your test is running when you are updating POHeader (confirming it) and is working with the dataset that has been passed in. No PORel has been passed in so it doesn’t do anything with those.

1 Like
3

Okay, so I need to figure out how to populate all the Releases in the dataset as well before the Update occurs, and then, change the values there in order to actually update the releases’ promise dates!

I’m not sure if there is a good way to do that with widgets instead of code…

4

Hopefully someone here can help you with widgets as I would go with a custom code block.

Custom code block would involve setting a variable to your PONum and Due Date using widgets from POHeader then in the block doing something like:

foreach (var PORelRow in (from PORelRow in Db.PORel where PORelRow.PONum==PONum select PORelRow))
{
PORelRow["PromiseDt"] = DueDate;
}
Db.Validate();

Hopefully someone can give you the widgets or the code aims you in the right direction.

2 Likes
5

Minimal effort would be to use the before update method and put your condition and set the header promise date. This will make the “Update release lines” prompt show up.

Other suggestion would be to after the po tableset in the post processing using a getbyid getting the PO.DueDate then using a updateext the PORel rows with the promise date.

Or call a function to do similar

I am sure others will have their opinion also.
I think the reason why it is not working is that the update method does not allow multi-dirtyrow uppdating of the PORel table. A discussion on it here Updating Custom Date Field on Purchase Order Release

1 Like
6

I did not see the CheckBeforeUpdate method! So many little spots to check, thank you!

1 Like