One of my clients wanted 6 approval levels but didn't have 6 approvers in each approval path. That wasn't too difficult to design in ProcessFlow; we simply looked up whether or not an approver was assigned at each level and skipped it when no one was assigned to it.
We had a further challenge when we realized that several approvers were also requesters. We didn't want the requester/approver's requisition to have to be approved at a level below (or by) the requester so we checked first whether a requester was an approver and at what level. We then skipped past that level to the next level up.
We then had to account for those levels we skipped and the authority limits of the approvers.
For example, if a requisition was approved at the first level but there wasn't a 2nd level we had to track the "approved at" level to determine whether or not the requisition needed to go to the 3rd level. If the requisition's value exceeds the level 1 approver but not the level 2 approver it would still go to the level 3 approver since no one was assigned to level 2. If however the requisition fell within the level 1 approver's authority limit then no other approval would be required.
AGS Call to GL40.6
I've mentioned before that you can sometimes get around Lawson's "Click Add Again" messages and here's how when sending an AGS call to GL40.6. Include the PT-XMIT=1 value at the beginning of your AGS statement. This works for both MS Add-Ins and the Transaction node in ProcessFlow.
&FC=Add&PT-XMIT=1&GLC-COMPANY=
&FC=Add&PT-XMIT=1&GLC-COMPANY=
ProcessFlow SQL Query JDBC directory path
Lawson's documentation states to install the SQL Server .jar files to the wrong directory.
The correct directory for these files is $GENDIR/bpm/jar and not $GENDIR/bpm/jars.
Lawson is going to correct their documentation but I wanted to post the correction here as well.
The correct directory for these files is $GENDIR/bpm/jar and not $GENDIR/bpm/jars.
Lawson is going to correct their documentation but I wanted to post the correction here as well.
ProcessFlow Integrator
I'm just getting started with ProcessFlow Integrator and I like what I see so far.
My client uses a custom employee evaluation program run from a SQL Server 2005 database and wanted to get completed evaluations and bring them into Lawson for the merit increases. Each employee receives a score of 1 - 6 which relates to their merit pay increase percentage (a score of 3 nets a 3% raise).
By using the SQL Query node from ProcessFlow we were able to connect to this external database [a big thanks goes out to John Henley, the Lawson Guru, for his help on setting this up] and create a Personnel Action (PA52) for the pay change.
We had a bit of difficulty in that Lawson doesn't seem to support the JDBC driver for SQL Server 2005 so we had to use the SQL Server 2000 driver, but the driver worked with 2005 so we were still able to get the data we needed.
Another nice utility, the CustomActivity node, allowed us to run the Move WorkUnits to History job so we didn't have to set up the Perl script for this function.
My client uses a custom employee evaluation program run from a SQL Server 2005 database and wanted to get completed evaluations and bring them into Lawson for the merit increases. Each employee receives a score of 1 - 6 which relates to their merit pay increase percentage (a score of 3 nets a 3% raise).
By using the SQL Query node from ProcessFlow we were able to connect to this external database [a big thanks goes out to John Henley, the Lawson Guru, for his help on setting this up] and create a Personnel Action (PA52) for the pay change.
We had a bit of difficulty in that Lawson doesn't seem to support the JDBC driver for SQL Server 2005 so we had to use the SQL Server 2000 driver, but the driver worked with 2005 so we were still able to get the data we needed.
Another nice utility, the CustomActivity node, allowed us to run the Move WorkUnits to History job so we didn't have to set up the Perl script for this function.
WF Forms in ProcessFlow 9.x
You know you have to use a WebRun to update the old WF forms in v. 9.x
Here's some of the ones I've used and I thought it would be nice to share them.
The first line is the old WF form, the 2nd line is the WebRun Web Program field value and the 3rd line is the WebRun Post String value.
WF46.1
bpm/queueForm.do
method=Change&workUnit=548&processId=548&activityId=UA22
&displayStatus=8
WF20.1
bpm/workUnitBForm.do
method=Change&workUnit=534&status=4
WF12.4
bpm/xml/userCategoryForm.do
method=Add&id=MZAMBELLI&task=Level5&workCategory=Req Loc&workCategoryValue=10003
WF22.1
bpm/xml/workUnitVariablesForm.do
workUnit=177&variableName=RQH_APPROVAL_VAL&sequenceNumber=12
&variableValue=333&variableType=3&method=Change
See Lawson KB article 556115 (and yes, I list some that Lawson didn't include).
Additional hint: To see the fields available do a method=Inquire on the XML form you're working with.
Here's some of the ones I've used and I thought it would be nice to share them.
The first line is the old WF form, the 2nd line is the WebRun Web Program field value and the 3rd line is the WebRun Post String value.
WF46.1
bpm/queueForm.do
method=Change&workUnit=548&processId=548&activityId=UA22
&displayStatus=8
WF20.1
bpm/workUnitBForm.do
method=Change&workUnit=534&status=4
WF12.4
bpm/xml/userCategoryForm.do
method=Add&id=MZAMBELLI&task=Level5&workCategory=Req Loc&workCategoryValue=10003
WF22.1
bpm/xml/workUnitVariablesForm.do
workUnit=177&variableName=RQH_APPROVAL_VAL&sequenceNumber=12
&variableValue=333&variableType=3&method=Change
See Lawson KB article 556115 (and yes, I list some that Lawson didn't include).
Additional hint: To see the fields available do a method=Inquire on the XML form you're working with.
ProcessFlow AGS call - click Add again!
Have you come across this when you use an AGS call to Add on a form (like GL40.6)? You're asked to click add again but you can't. I found a simple work around that might work for you too.
Instead of using EVT=ADD, change it to EVT=CHG
I won't promise it will work on all forms, but I've used it a couple of times when I've had this come up.
Instead of using EVT=ADD, change it to EVT=CHG
I won't promise it will work on all forms, but I've used it a couple of times when I've had this come up.
Subscribe to:
Posts (Atom)