Can you grab the id of the person entering a transaction (ie. the logged in user) when that user triggers a flow

I have a process flow in which I'm trying to create a new 6 Month Eval that occurs 6 months after the effective date of the action. Under the Start activity node, I'm able to make the following declairation: revDateSixMo=getDateDME(AddMonth(pfDate(Effect_Date),6)) The result is: empRevDateSixMo(Type=String) = 07/09/2011 It works under the Start node. However, later in the process flow, I check to see if the effective date has been changed and I try to re-calculate the same date in an Ass...

I have a flow that has to create a pa52 transaction record, but when the PA100 tries to run it it bombs because I'm not able to get the field numbers into field 1 and 2. Here is my call _PDL=&_TKN=PA52.1&_EVT=ADD&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=Add&PCT-COMPANY=1&PCT-EMPLOYEE=&PCT-ACTION-CODE=TERM20FINAL&PCT-EFFECT-DATE=&PCT-REASON1=TERM&PCT-UPDATE-BENEFIT=Y&PCT-UPD-ABS-MGMT=N&PCT-NEW-VALUE-1r0=T9&IMMEDIATE-ACTION=N&ORIG-COMPANY=1&ORIG-EMPLOYEE=&ORIG-ACTION-CODE=TERM20FINAL&ORIG-EFFECT-...

Currently all transactions waiting for approval, regardless of the product line, appear in the same (or equivalent) Inbasket. Has anyone found a way to separate the different development areas so that Development Inbasket transactions cannot be viewed and approved while in the User Acceptance Testing or Training data areas The wf01.1 is set to Logan in all product lines, which is shared by all product lines in DEV. Is it possible to replicate the workflow tables in another area other then Logan...

I have a pflow which has a simple node to a work object (which calls a second pflow). Within the second pflow there is a query. Query is name Query9100. Here's the query: PROD=&FILE=REQLINE&FIELD=COMPANY;LINE-NBR;REQ-NUMBER&SELECT=COMPANY=26REQ-NUMBER=&OUT=CSV&DELIM=~ Within the query loop there's a simple assignment node: linenumber = Query9100_LINE_NBR Should ...

I have a pflow which has a simple node to a work object (which calls a second pflow). Within the second pflow there is a query. Query is name Query9100. Here's the query: PROD=&FILE=REQLINE&FIELD=COMPANY;LINE-NBR;REQ-NUMBER&SELECT=COMPANY=26REQ-NUMBER=&OUT=CSV&DELIM=~ Within the query loop there's a simple assignment node: linenumber = Query9100_LINE_NBR Should be simple thing, I believe.Works on all other flows I've worked on but maybe not workobjects... Anyways when the 1st ...

Hi, I am scheduling a flow from another flow using WebRun node. But JobId is mandatory field in the post string. So how will i get job id as they are generated by scheduler while scheduling. regards, Prakash B

We have process flows set up for some MSS actions and when we perform corrections to those actions we have to follow the process flow again.  How are others handling corrections to data that was originally submitted through MSS and subject to process flows  An example is... MSS termination entry sends an e-mail to the HR team.  Once the HR team approves the termination entry submitted by the manager, e-mails are sent to IT, payroll, etc.  When we make a correction, the flow starts over and HR ...

We have a number of Crystal Reports written some time ago that calculate out some data and display them out in report form. A project we are working on is trying to take the logic out and build flows, but we are having issues. So the question came up, can Process Flow invoke Crystal We think that if we change the Crystal Report to spit out data in delimited format, we can then take that and upload it into our systems; but may process flow could invoke and get the results and then work with the ...

Trying to find out if there's a way to mimic or use the Approve and Reject functions within the Processflow inbasket. I want to use the same Approve and Reject functions to approve and reject workunits programatically, but I don't know where in the file structure these functions would be, meaning I know they should be javascript but I don't know exactly where or what the actual functions would be called. Does anyone have any idea Thank you greatly, Thomas

Anyone have a solution with processflow to pull a file from an FTP site...   I don't like that we have some integrations that use different tools and I am researching processflow as the core application for integration.   I am looking to understand the node that could pull a file from an FTP site and hopefully decrypt the file ...   (Might need to use system command to decrypt the file.) Thanks Shane

Hi, Is there any way to retrieve the job Id of a scheduled flow from the flow which is scheduled. regards, Prakash

Hi, I am using webrun node to schedule a flow from another flow. But i need to pass a variable from the flow which is scheduling to the flow which is scheduled. Is there any way to schedule a flow from another flow by passing variables regards, prakash

I am trying to build a transaction node that will update a certain HR11 user field row number after a page down or i also have the FIELD-KEY specified.  Is there a way to use pf to update this

Building a process flow similar to the flow in the tips and tricks section about sending an email about jobs that are in 'Needs Recovery' status. First of all I can't get drill down in GEN from my API builder in PF (all I see is JO, LA, UN) but that isn't as big of deal (at the moment) because I can still pull data using the following query: \\PROD=GEN&FILE=QUEUEDJOB&FIELD=JOBNAME;USERNAME;STATUS;STOPDATE&SELECT=STATUS=34&OUT=CSV&DELIM=~ Now, when I run this I am getting the username in ...

I have been asked to create an audit report using crystal reports and querying the process flow tables, that will show each po approval flow from beginning to end. Has anyone done this before Are there any canned reports provided by lawson that can be leveraged

How do I query null values of a date SELECT BB.COMPANY, BB.LEASE, BB.END_DATE, BB.TERMINATE_DATE, AA.DUE_DATE, MAX(AA.PMT_NBR) FROM  LMPAYDTL AA,  LMLEASE BB WHERE AA.COMPANY = BB.COMPANY AND AA.LEASE = BB.LEASE AND BB.R_STATUS = 1 AND BB.COMPANY =    AND BB.TERMINATE_DATE = '1700-01-01' GROUP BY BB.COMPANY, BB.LEASE, BB.END_DATE, BB.TERMINATE_DATE, AA.DUE_DATE

We have done some testing and find that we can only get about 8-12 threads to process concurrently, the rest of the workunits stay in ready status until an open thread is available.  We changed the max thread pool size to 20, then 50 but had no improvement. We are on an IBM i5, does anyone know how to increase the number of current thread that can be processed by the PFI server I hear that there is a limitation of 8 threads and that this cannot be changed.  I have also heard that the SQL...

Were in the process of implemetning requisition approvals through PF, one of the issues we have encountered is that the Inbasket does not show the multiple distributions in a req line that has been split between accounting units. Accounting will be reviewing req's for correct acct usage and needs to be able to see the multiple distributions on a line. Drilling on the req is not an option as accounting will not know which line has been split and there could be 100 lines in a req. Does someone hav...

Friends, My admins and I took the necesssary steps to updating the iosconfig.xml file to change the MAX query length to be 999999. But now i get some odd behavior in my pflow; what I am doing in the flow is simply pulling all vendors from the lawson table (which has 34k plus records). The query is below. So running the query below in the pflow (with my full server info) returns me the following error ( I have stripped our server and host information but all works good; plug yours in). B...

The production portal inbasket is displaying the workunits from test I checked the pfserv config and it is pointing to production. Any ideas   Thanks JC

We have several process flows that send emails to employees to notify them of various things, especially registration for training. The employee email address is read from HR11.  While these flows were in development and testing we have inadvertantly sent emails to employees that should not have gone out.  We are looking for suggestions to keep these emails from going to employees and instead have them sent to a tester or pre-defined email address.  Ideally, we'd like to have the UAT tester be a...

Hi all, What is the maximum value of the variable type integer in ProcessFlow The reason I asked is because I have an employee number 50745130. In ResourceQuery, if I assign the result to a string varaiable say s_EE, the value is 50745130. But if I assign this to a type integer variable say i_EE, the value is 50745128. I do not have issues with smaller numbers. Below is the Debug window result. Is this an integer limitation in ProcessFlow Thank you, Jude Variables in Process : DesignerTes...

Has anyone successfully written a Java application/Bean, deployed it, and then invoke/call it from the Lawson ProcessFlow Custom Activity Node  The Pflow Admin Guide says we can do this.   I'm just curious to see how many of us out there have done this in Production If you have, what are the challenges in doing this

Hi, I have three actions for a User action, which are Approve, Reject and Esc. Is there any way to display only two actions Approve and Reject in web inbasket and smart office inbasket. This is for lawson M3. Thanks! regards, Prakash B