Run Workflow/Send Email After Batch Job/Periodically?

Question

So I have a SQL query which returns all purchase orders that are over 14 days old, which have still not been signed in Sage from AWRKHISSUI workflow table. 
 What I'd like to do is create a workflow that distributes an email to all of the users in the list periodically, to remind them that the PO is still outstanding. 
 Does anyone know the best way of doing this in X3? Would the best approach be to create a batch job, then a workflow? How would I connect this to the output from the query? 
 Any help is greatly appreciated. 
 Nick

nickdavies07 · Answer

Solved. 
 Created a workflow rule that pulls data from the AWRKHISSUI table. Filtered on header under conditions and grouped by email.

Saq-1 · Answer

I think you went for specific answer 
 To have more flexibility 
 1) custom field in table 2) spe script to code values 3) saiwrkman workflow mixed up with updfld workflow actions 4) batch task to set up saiwrkman timing 
 Custom field gives more granularity to audit.

Sage X3

Run Workflow/Send Email After Batch Job/Periodically?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING