Reading this post, it looks like you can schedule a BPM to run.
I’m stuck. I have a SysAgentSched.Update / In-Transaction BPM built as shown in their post.
The post above stops at “Executing Custom Code”. So I either need help writing custom code to uncheck a UD field in the VendPart table or add something else so my other BPM it will fire.
Ideally, UD Field box gets checked when new record is created in Supplier Part List when Effective Date is not todays date. (Done with another BPM already)
Scheduled BPM checks all Supplier Part Records where Effective Date = Today and the checkbox is true.
Then it can simply uncheck the box and an existing working BPM will fire.
DMT on a schedule is my next move to fire by other BPM if I cannot solve it in the system.
@kylepbsps - I’m glad my previous post could help. @DaveOlender is right - the newer versions that allow you schedule a function provide an alternate route - although I’d argue that using the schedule to trigger something is the same no matter how you do it
As for you’re issue - I’d write the BPM so it work’s directly when you interact with the record - in order to test the code without having to trigger something that runs in the background that you cannot see. Get the code working in the UI as a BPM, and then move that code to the scheduled BPM or Function.
I guess the issue i’m having is that someone will enter the new record but the values shouldn’t take effect until a later date. I don’t want my BPM to run until the day its effective. By storing a checkbox value, I can hopefully clear that value when the date arrives, and by clearing the value will trigger the 2nd BPM.
Checking once a day was the best I could come up with for scheduling. I’ll check out 10.2.7 and see if that “schedule function” exists in my license.
You have to start by allowing yourself permissions: Bring over the 3 Function Security Groups (Ok I brought over all 3 - you will want to research the abilities and limitations of each group and select just the appropriate security group - of coarse
I’m thinking Supplier Price List which access’s VendPart table rely’s on information from Part first. I’ll try to query part, then VendPart, or store my custom field in the Part Table, so I can retrieve it easier.
I recently scheduled a BPM using a Updateable BAQ and “exporting” it. I found this solution on another thread from people much smarter than I. The reason I gravitated towards this solution was to avoid a BPM being fired unnecessarily every time a task is run.
Add tables and configure the results to show the records you want modified.
Click Updatable Checkbox on General tab.
Go to Update > Update Processing. Check the Advanced BPM Update only and click the BPM Directives Configuration Button