tag:blogger.com,1999:blog-321374832012-02-07T16:12:25.338-05:00Lawson ProcessFlow and Design Studio tips and tricksConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comBlogger59125tag:blogger.com,1999:blog-32137483.post-20777005328805407942012-01-03T09:32:00.002-05:002012-01-03T09:37:49.720-05:002012-01-03T09:37:49.720-05:00

A client recently mentioned to a group of users that they set their approval escalations to 48 hours and had to live with work escalating over the weekend because there was nothing you could do about the hard coded 48 hours.I stopped him after the meeting and told him that of course you could do something about it - use a variable instead of a number in the UserAction node. The variable could be

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com1tag:blogger.com,1999:blog-32137483.post-51487647748207105052011-02-07T06:14:00.002-05:002011-02-07T06:24:31.820-05:002011-02-07T06:24:31.820-05:00

Because the system sends the "Inquire Complete" message back before it actually finishes refreshing the field values displayed (even if it's only a split second) I encountered another issue. I was using the end date from the new record to calculate a salary percentage to display in another field on my form. Since I was picking up the end date from the previous record this calculation was wrong (

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-80567462972857428662011-01-11T10:09:00.002-05:002011-01-11T10:29:34.305-05:002011-01-11T10:29:34.305-05:00

I had a need recently to suppress data a entry field on a form which had records that went beyond the first page. What I tried to do first was to check the conditions for when the field should be suppressed after an inquire (or page down) was done. The down side was that Lawson sends the "Inquiry Complete" before it actually refreshes the page being displayed so my field was suppressed based upon

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-14671639084316410872010-08-24T05:10:00.002-04:002010-08-24T05:20:54.406-04:002010-08-24T05:20:54.406-04:00

In an earlier post I discussed the possibility of making the Inbasket display more user friendly for Requisition Line Approvals. I was thinking this through for my current client (since this is the method they have chosen) when I realized something.You can set the requisition to approve by line but you don't actually have to push each line to its own WorkUnit. I know it's a radical idea but since

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-41697337359034700722010-06-30T11:25:00.000-04:002010-06-30T11:26:08.541-04:002010-06-30T11:26:08.541-04:00

If you're getting one of those annoying DME connection errors with user lawson when running your flow on the server but it works just fine within PF Designer then I have a possible solution for you (I just discovered this for a client).If the DME has a SELECT statement with an Escape character (%3D for the = character) then replace it with the normal character.Replace SELECT=STATUS%3D1 with

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-74998467856747342932010-04-05T08:43:00.002-04:002010-04-05T08:54:15.898-04:002010-04-05T08:54:15.898-04:00

I've been asked several times recently why ProcessFlow isn't triggering so wanted to give some ProcessFlow 101 things to check:Does the application form WF01 have the LOGAN value in the Collarborative Commerce Productline field? If not, ProcessFlow won't trigger.Have you enabled all three of the ProcessFlow Administration Service forms?Service Definition - Service Criteria Level Definition -

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-49186188157361027782009-10-05T08:16:00.004-04:002009-10-19T17:28:06.923-04:002009-10-19T17:28:06.923-04:00

My latest client is only my third to decide to approve requisitions through ProcessFlow by line instead of by header. While I like the concept, I don't like all of the WorkUnits (one for the requisition header and then one for each line to be approved).I only had last week to work with them on developing this flow so I didn't get to test a theory that I'd like to put in place for this process - a

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-28830904493355716182009-07-22T14:59:00.002-04:002009-07-22T15:31:21.516-04:002009-07-22T15:31:21.516-04:00

I often need to parse data within ProcessFlow or Design Studio and thought I'd share some quick tips on parsing text using JavaScript.If I have a variable called mytext with the value of "David's Blog" and only want to use part of the value I can parse it.mytext.substring(0,4) would return "David"Substring returns the text between two points so to get the value substring starts at the 1st

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com1tag:blogger.com,1999:blog-32137483.post-76793961850075575152009-07-08T20:19:00.002-04:002009-07-08T20:31:27.014-04:002009-07-08T20:31:27.014-04:00

Recently on John Henley's Lawson Guru Forum another contributor suggested assigning UserAction approvals to the User rather than to the Task. Normally the User Level Work Inbasket is used with HRUserAction approvals so why not assign non-HR approvals to Users as well?The only real objection I have to this is that when a user leaves then the flow file would have to be updated rather than updating

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-32929139381640080382009-03-22T08:37:00.002-04:002009-03-22T08:54:48.627-04:002009-03-22T08:54:48.627-04:00

Ash Gajjar contacted me recently with an interesting question. Could he get the URL for an attachment from a requisition and add that to the purchase order created from that requisition? Of course, I assured him. Now came the matter of how.I offered Ash a solution with two methods of achieving that solution - use Design Studio when the PO was released to perform a DME on the PO Line Source Record

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-29366968263106794452009-03-18T04:35:00.004-04:002009-03-18T05:16:22.180-04:002009-03-18T05:16:22.180-04:00

Recently a client asked how to use ProcessFlow Integrator to add new users into Lawson Security from their active directory. I gave them two simple choices - we could use the SQL Query (which would require a JDBC connection to their database) or we could use the DataIterator to read a text file they created from their AD.They decided the DataIterator would fit their business requirements and are

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-67469280659321480562009-01-28T02:34:00.003-05:002009-01-28T02:47:46.367-05:002009-01-28T02:47:46.367-05:00

My previous solution example was based upon pressing a button in the form's header and detecting which line(s) had been selected within the detail section. My client decided to add the button to the detail section (so it would appear on each line) and came up with this method of identifying which line's button was clicked:if (id != "push2") return true{Invoice = lawForm.getDataValue("APD-INVOICE"

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-91238566046586428442009-01-15T19:00:00.003-05:002009-01-15T19:08:34.218-05:002009-01-15T19:08:34.218-05:00

Do you need to determine the line you're working on based upon the user selecting it in the Line FC? Here's a simple method I used with AP95.2 to pass variables to ImageNow to display an invoice. I had to repeat this for each line of the form.This is using the field ID's.if (lawForm.getElementValue("_f36r0") =="X") // Line 1{Vendor = lawForm.getElementValue("_f39r0")Invoice =

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com3tag:blogger.com,1999:blog-32137483.post-75459232377081279932008-12-29T05:42:00.003-05:002008-12-29T05:57:26.951-05:002008-12-29T05:57:26.951-05:00

In a previous posting I mentioned modifying the pflow.js file in order to add a custom JavaScript function for use within your flow (http://consultdavidw.blogspot.com/2007/07/processflow-custom-functions.html) but with ProcessFlow Designer 9.x you can now add a JavaScript Function within your flow.Within the Assign node properties, click the Add JavaScript button and the JavaScript Expression

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-25623594812581770022008-12-29T05:12:00.004-05:002008-12-29T05:25:54.251-05:002008-12-29T05:25:54.251-05:00

Just in case you, like another one of my clients, wants to use this ProcessFlow Service to notify the Agreement Administrator that the PO's released against a Vendor Agreement have exceeded the notification percent on the PO25 setup form - you will need to make sure that ProcessFlow Administration (menu.do) has the Form and Form Field Definitions defined for the PO25.1 form.For some reason, like

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-2273199804380039122008-12-21T07:17:00.002-05:002008-12-21T07:26:23.059-05:002008-12-21T07:26:23.059-05:00

I don't usually post LBI tips but my latest client had an issue with User/Group Rights on a report that bothered me. We set up the Elements, Structures and Rights correctly but when we tried to access the report we got an error saying no rights existed for the user.What we found (with help from Lawson support) was that the Start Date for the Right had to pre-date the oldest historical instance

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-5912822100032312222008-11-24T12:32:00.004-05:002008-11-24T12:39:09.251-05:002008-11-24T12:39:09.251-05:00

I was surprised that I hadn't done an Invoice Approval Flow in LSF9 until now and so didn't know about a potential problem. The WorkUnit created for the Invoice Approval wouldn't update beyond "Ready to Progess" until I added the AP26.1 & J-AP26.1 Form & Field Definitions.This problem existed in 8.03 but the AP30.2 & J-AP30.2 definitions resolved that issue. Apparently in ProcessFlow 9 you have

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-71681713848198688472008-11-06T04:59:00.002-05:002008-11-06T05:11:57.928-05:002008-11-06T05:11:57.928-05:00

I have been asked how I learned JavaScript for use within Design Studio (and with some limitations within ProcessFlow) and I admit I steal a lot of code from other people. I do have a JavaScript for Dummies book but my main source for JavaScript help is http://www.w3schools.com/js/Lawson does provide some examples in the Design Studio Reference Guide but not usually for what I need to do. For

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-14335521603189364742008-11-06T04:30:00.002-05:002008-11-06T04:51:56.711-05:002008-11-06T04:51:56.711-05:00

I recently received an email from a new ProcessFlow user asking how to get an AGS call to work to update PA42 with the correct status for a job requisition approval flow. She sent me her current AGS call and I compared it to one I knew worked. The only thing missing was the &FROM-WORKFLOW=Y section.I get questions like this from time to time about why an AGS call from ProcessFlow (or Design

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-50194582871387763072008-10-20T11:10:00.002-04:002008-10-20T11:11:58.278-04:002008-10-20T11:11:58.278-04:00

I recently presented a webinar "ProcessFlow Administration - Extreme Makeover, Lawson Edition" and you can view this by following the link below. You will have to register, but it's free.https://www1.gotomeeting.com/register/632831061

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com1tag:blogger.com,1999:blog-32137483.post-85832950471883025332008-09-04T13:07:00.002-04:002008-09-04T13:12:40.920-04:002008-09-04T13:12:40.920-04:00

A question was posted on John Henley's LawsonGuru ProcessFlow Forum related to using the HR Supervisor structure to automate the setting up the the users, tasks and filtering in ProcessFlow administration.I did this for a client recently so posted a reply on how to update the LSF9 WF forms related to these settings. Here are the values to use in the WebRun nodes for updating each of the

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com2tag:blogger.com,1999:blog-32137483.post-7501410741931596302008-07-16T07:26:00.004-04:002008-07-16T15:19:15.437-04:002008-07-16T15:19:15.437-04:00

A client wanted to customize their AR09-Customer Group Address form so that they could add the AR10-Customer record at the same time. To do this we needed to add ten fields from AR10 onto the AR09 form.Adding ten textbox fields to AR09 and then including an AGS call to add the AR10 record (after the AR09 Add button was clicked) wasn't too difficult. I didn't need to store those values, just

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-45567787179967331632008-07-02T18:14:00.009-04:002008-07-02T18:22:55.830-04:002008-07-02T18:22:55.830-04:00

My client has an external system for their merit reviews and is passing a delimited file to Lawson for ProcessFlow to add the PA26 record and to kick off a Merit Personnel Action for the merit pay change.The file looks something like this:Record Type|Company|Employee|Scheduled Review Date|Actual Review Date|Review Score|Merit Increase Percent|SupervisorA|100|53059|20080601|20080701|3|3.5|90006I'm

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-9044264619844820952008-05-07T16:51:00.002-04:002008-05-07T16:56:08.065-04:002008-05-07T16:56:08.065-04:00

If your network security is tight then you may get a "Permission Denied" error when trying to view a display exec file in your ProcessFlow Inbasket. We were able to resolve this for a couple of clients by adding the Lawson Server URL to the Trusted Sites in Internet Explorer and by checking the "Allow active content to run in files on My Computer" box on the Tools - Advanced Tab.

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0tag:blogger.com,1999:blog-32137483.post-24129631285689405692008-05-06T09:24:00.004-04:002008-12-11T06:37:29.643-05:002008-12-11T06:37:29.643-05:00

Do you want to add or delete messages within the Inbasket display for your WorkUnit?I personally don't like the System added Mailmsg messages that are created for Personnel Actions and wanted to figure out how to delete them so the user would know that if a message existed that it was added by another user.Use a WebRun like this to Add or Delete UPDTACTION=A to add a message UPDTACTION=D to

ConsultDavidWhttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com0