I have a process flow that is running a SQL query and the output from that query is the run group out of GLTRANSREL.  I update the run group in my GL165 job through the LWSNTXN node, using that run group, and then the job is submitted via the WebRun Node.  But when I update the job using the output from the query (which is in a string) - the run group in the job parameters is being padded to the right with '' instead of spaces so GL165 ends up not finding the run group.  I've tried everything...

Good Afternoon all,   My hospital moved from Lawson 9 to Lawson 10 late last year and we are having conversations with Infor about moving to Cloudsuite.  Some of the things they have shown our materials and accounting staff revolve around using IPA which we don't currently use.  And as you might have guessed, they loved what they see and they want it right now.       My question to all of you what are your thoughts on IPA   Are you using it on V10 or Cloudsuite How hard was it to Implem...

Does anyone have an example of using a WebRun node with SmartyStreets street address API  Is so would you be interested in sharing it   Thanks

I first do a PA52 inquire and based on a condition then proceed to do a PA52 change which is to update the EFFECTIVE date. I get an error message 'pending action does not exist' while trying to do the PA52 change. Not really sure what that means....any ideas! _TKN=PA52.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&PCT-ACTION-CODE=TERM&_HK&_IMMEDIATE_ACTION=1&PCT-COMPANY=0100&PCT_NEW_EFFECT_DATE=20190511&PCT-EMPLOYEE=382723&PCT-REASON1=TERM20FINAL&_DELIM=09&_OUT=XML&_EOT=TRUE Thanks

I've been trying to code a process flow using LWSNTxn node to first delete a record and then add to PA52. Can someone please refer me to any available docs that might help me with this I feel like I am shooting in the dark and time is being wasted for something that should be straight forward....I think.       Thanks

We are looking to create reminders and timeouts to auto approve certain personnel actions based on varying period end dates (dependent on process levels). So the timers in hours or days on the user action node would not be set at all. So far, creating a flow to read PERSACTION and calculate when to send reminder emails works. In order to auto approve after a similar calculation I was going to use a call to PA53 to approve. That is still leaving the task in the users inbasket. How do I remove t...

I need a bit of guidance on how to update the Alpha field in the USERFIELD_STORAGE table using a LMTxn. I am not exactly sure what _module, _objectname, _actionName and _actionType to select.   Thanks

I am wondering how other IPD developers format the HTML message of an Email node. I tried to create a formula/variable with to simulate a CSS style sheet but it 'sorta' worked but not completely. I have had luck using inline styles but that spreads the formatting around (as I build the message) AND cannot be reused. What I'm hoping for is a way to define a CSS Style Sheet in a variable (or global configuration) and reuse for all flows that need to send an email that conform to a single standard....

Anybody know what error code 143 is on importdb I can run the command from the command prompt and the data imports into GMDISTREL without issue. I can run other GMDISTREL files using the same PF and they load without issue using IPA. But I have a file that keeps throwing the 143 error through IPA but not when I run the importdb from the command line. Any ideas I've been struggling with this all morning. Thanks in advance - Laura

We are working on implementing security automation for AD and other applications for contractors.  They are not, at this point, being entered into LTM but for other reasons the organization would like to enter them into LTM.  An option that is being pushed rather strongly is that the point of data entry for these contractors is external to LTM and that a data feed would be sent to LTM to update the 'employee table'. My concern is how to get the employee number generated.  Can the auto numbering...

I am running a flow that will update an employee group, I need to update the HR155 job prior to running it. I get an error on field 'TC', but there is no error message.. Anyone seen this   Process resumed Activity started: LwsnTxn6  (Run Id: 7) S3 Transaction LwsnTxn6: Calling transaction server https://***redacted***.org:1443 with string _PDL=LAWPROD&_TKN=HR155&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&COMPANY=15&HISTORY-DATE=20190218&JOB-NAME=HR15...

Hello All,    Have a question that I cannot find no doc on.    When using the Info Rich Client, there is a Release and Restart option available.    I am trying to find out what the Restart option would be used for.     IE:   If a flow that has multiple nodes ends up failing for some reason, and goes to failed status,  Will the restart pick up at the failed point or does it go back and execute the flow from the beginning  Thanks Terry

We have a process flow whereby the final SQL Transaction seems to have stopped working.  We can execute the UPDATE function via SQL Mgmt Studio but it will not function in the process flow.  The flow doesn't have any errors in the log file.  All columns are in the right order.  I have replaced the node.  I have rewrote the whole flow.  Nothing seems to work.   Thoughts   MERGE dbName.dbo.tblTarget as T USING dbName.dbo.tblSource as S ON (T.PeopleID = S.PeopleID) WHEN MATCHED THEN UPDATE...

How do I give a Lawson user access to the WFWK form  I am a Lawson user with the Admin role and I can access the form without a problem.  Another user who tries to access the WFWK for gets the following error:

I am trying to run the stored procedure using sql query node and selecting run sql procedure. When I click on select button, it connects me to the sql server, all I see is user ids defined in that database, I don't see the list of  Stored procedures. any suggestions why I can't see the stored procedures... I don't have access to sql server. I can run the sql query on this sql server, no issue there. I can run the stored procedure if I select type sql query,build, other(no SELECT) type proced...

How do I use the FTP node in IPA I'm not finding the place for FTP URL ,USER and password etc

Hello All, I need to write a sql query to list of all work units that have been ran on the system (those that are shown in the Work Units, Rich Client tool) including all status of Completed, Failed, Cancelled, etc. Can any one please advise which database tables that I can use for this query Thanks in advance. Han

I have a Process Trigger created for an Process Flow with 2 date trigger variables. I am trying to schedule this IPA to run everyday. I want the date variables to dynamically populate with the respective date of the day it is running. For example, if it kicks off today the 2 trigger variables should be today's date, tomorrow it should be tomorrow's date and so on and so forth. Attached is the image of what I am trying to do. What should I put in the value of the Trigger variables CheckBeginDate ...

I am trying to find an easy was that a user can easily pass 3 dynamic parameters to a Process flow and initiate the process.  I created jobs before that wait for a file and then read it, but I would like to do it from a custom Form if possible.  I'm not finding what I need so far.  Any ideas

I'd like to pick a few brains please.  I'm trying to determine if IPA is a viable option for running SQL code and FTP'g the file or moving it to a directory.  Most of my Lawson exports are created via a SQL View.  So the next step just pulls the entire view (select * from LawsonView).  Currently in order to get the file into csv, tab, excel, etc... I have to create a crystal report and schedule it via LBI which exports it to a specific directory.  My network team have to create the FTP connecti...

We Designed a Process Flow that has a Submitter and an Approver.  Sometimes, one of the users go on Vacation so I create a Proxy User for the person going on Vacation.  However, when running the Process Flow, the email that states that 'this needs to be approved' goes to the person on vacation not to the Proxy User.  Same thing for submitting a file to be processed by the processflow (workflow).  Any emails that would go to the Submitter should go to the Proxy user but they still go the Submitte...

We have a workflow that has a submitter and an approver.  Instead of me being the submitter and approver, I made a proxy user for both.  The file was submitted and goes through the workflow.  The proxy user gets the file in his inbasket to approve or reject but I am getting the email not him.  Is there something we must do in order for him to get the email instead of me  We want to use this feature for when people are on vacation or out of the office for an extended period of time.   Thank yo...

I have setup the users Filters in IPA so that the Filter Values correspond to 'Submitter' and and 'Approver' that will get emailed.  Currently I set the oCatValue to the Filter Value and get back the Email addresses associate with the users with that Filter Value. The requirements want us to allow multiple Filter Values, so I would like to do something like oCatValue = '3602402355,3601403355' where 3602402355 and 3601403355 are different filter values and get back all emails for users associate...

A file gets created on a completely separate server. I do work with the file, then I need to delete it from the remote server . . . Im using the File Access node to delete it, but it is not finding the path, actually doesnt even find the server. I have the server, user and password already in Richclient (sys config) under the FileTransfer tab (don't see spot to create one under FileAccess tab).   Any Help