I am working on a Post Processing BPM to update data Cross Company for a Forecast scenario.
I have it setup just fine to Insert new records and Update existing records on the Post Process BPM. The issue I am having is with the Delete. I am trying to delete records if there are no existing forecasts for that date. When I run the Trace for Delete, I do not see a trigger on RowMod, so I do not see that as an option, but I do see the following:
How do I get hold of that verification in the C# code?
Set a pre-processing directive that checks for a deleted row, then enable post-processing. Then in post-processing, check if it was enabled by pre-processing and do your work.
Jason,
Thanks for the reply. I think that is where I am struggling with the Forecast piece. In most scenarios you can use RowMod to identify, but this one you cannot. So, I am trying to figure out how to identify if it is deleted?
Thanks, I should have noticed that. But another question. How do you transfer a flag from Pre to Post?
Its a widget in Pre-Processing called “Enable Post-Processing”.
In Post Processing, there is a condition for “Enabled from Pre-Processing”.
Ok, I will give this a shot. Thanks.
Jason,
Sorry for the bother and maybe I am making this a bit too complex. But I have 3 scenarios on this: Insert, Update, and Delete.
I have the Insert and Update working in a current Post Processing. How would I separate those to stay running from the Delete portion?
Do the same logic for the Insert/Update as for the delete. The only difference would be that you would change your Pre-Processing condition to “There is at least one changed row in the specified table”
Ok, So, I think there is a problem with this approach after all. When I delete a Forecast for a Part it appears that a Post-Process Method won’t even execute. I am going to need to try a bit of a different approach.
That seems unlikely. Care to share some screenshots of your setup?
Jason,
I have modified how I am going to do this, but just note that it is some work with the Sum of Qty and Sum of UnitPrice on the new approach.
The new approach is to do it in a PreProcessing after all. I think it is going to be better this way as it does connect with the deleted line more accurately.
Thank you for helping.
Ah. The “Deleted” line won’t exist in Post-Processing because it is done deleting it.