Search this forum:
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 1 of 612345 > >>
 Last Post
1 Replies and 135 Views Email Node - High Importance Option    135  1 Started by  agersh Does anyone know if the Email node for IP Designer V10. provides an option to send emails as an High Importance email 
1 135
by  JimYJump to last post
06/29/2018 12:12 PM
2 Replies and 540 Views Calling Jobrun.exe to submit jobs    540  2 Started by  KJB Hi, We can submit jobs via Webrun node in Process Flow which internally calls jobrun.exe to execute jobs. Can we call the jobrun.exe to execute jobs using our own written desktop application just like LID    
2 540
by  KJBJump to last post
03/12/2018 9:37 AM
1 Replies and 870 Views FTP Node – Retrieve latest file from remote source folder    870  1 Started by  agersh Using the FTP node I am trying to build a process that file transfers the latest file of a list of files located on a remote source folder.  Has anyone written a process that searches a remote folder for that latest file then transfers the file using the FTP node
1 870
by  Kyle JorgensenJump to last post
02/20/2018 1:25 PM
1 Replies and 947 Views Check If file directory exists, if does not exists create directory    947  1 Started by  agersh Using V10 IPA is it possible to check if a network directory exits If the directory does not exist then create the directory on the network drive
1 947
by  brox07Jump to last post
09/11/2017 4:07 PM
2 Replies and 1283 Views Convert TXT to PDF    1283  2 Started by  PD I have a formatted txt file that is converted to pdf using the bldxffiles utility, but the pdf does not look as nice as the formatted txt file. Can someone give me pointers on how to make that happen I use a MsgBuilder node to create the file and tab is used for spacing.....see attached files for comparison
2 1283
by  PDJump to last post
05/19/2017 12:57 PM
9 Replies and 3603 Views Create export files from SQL code via IPA or crystal and LBI?    3603  9 Started by  Joan Herzfeldt 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 t...
9 3603
by  TimCJump to last post
04/12/2017 2:39 PM
9 Replies and 6710 Views javascript functions in processflow    6710  9 Started by  Maynard F. Hello.  I would like to see some of the custom functions that PFI users have developed.  Specifially, I am wanting a function that will format a numeric field into an alpha numeric field complete with currency sign, commas and a decimal point.  Any other functions will be appreciated.  Please reply or post the code and tell me where to find it.  Thank you.
9 6710
by  Joan HerzfeldtJump to last post
08/16/2016 8:04 AM
5 Replies and 1774 Views Use Javascript to format Rate of Pay and FTE values from database table to include decimals    1774  5 Started by  agersh I am working on a ProcessFlow that uses an SQL Query Node to query the PERSACTION table. Two of the New_Value_ fields the query is referencing are the values for Rate of Pay and FTE. The values are stored in the table without decimals. For example Rate of Pay is stored as 000000000032050000 and FTE as  000000000000900000 . Using Javascript I am trying to find a way to format these values so that my ProcessFlow could use these values in their valid/correct decimal format.   A...
5 1774
by  Dave CurtisJump to last post
07/28/2016 12:48 PM
3 Replies and 2990 Views Email Node - Include a picture in email content    2990  3 Started by  agersh Is it possible to include a pictures/graphics in the email content area of the Email node I am assuming that the content type will need to ne HTML.   
3 2990
by  Corvette JimJump to last post
06/01/2016 1:16 PM
1 Replies and 1334 Views Can Process Flow execute a Crystal Report and Print the report to a specific Network Printer.    1334  1 Started by  agersh Is it possible to create a process flow that would execute a Crystal Report located on our Lawson V10 LBI Server and instruct Crystal to printer the report to a specific network printer.
1 1334
by  Shane JonesJump to last post
05/10/2016 2:28 PM
2 Replies and 2078 Views Having trouble determining the HR15.1 PageDown AGS Call    2078  2 Started by  agersh I am working on a process to delete specific User Fields (User Field Values) from an employee. Using the following HR15.1 ags transaction call I am able to inquire the first page of HR15.1 for the employee. But I seem to be unable to successfully build the ags call to PageDown to the next page of user fields.   &91;Inquire&93; _PDL=PROD&_TKN=HR15.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=I&HEU-COMPANY=1&HEU-EMPLOYEE=299&HEU-EFFECT-DATE=&_DELIM...
2 2078
by  agershJump to last post
02/02/2016 4:04 PM
9 Replies and 3486 Views Parse CSV Comma Delimited File with Quotes and Embedded Comma    3486  9 Started by  agersh Using the Data Iterator node I've been trying to figure out how I can parse the following CSV file/row, Comma Delimited with Quotes and Embedded Comma. '1375','Annual','GRETA','GOLD','082189','Yes','REGINA','BRONZ','01/21/2014','BRONZ, REGINA;FRANKEN, JANET','TRANSCRIPTIONIST PATHOLOGY','12354','Yes','No','Yes','','','Submitted to HR','','','','2.03','01/21/2014','01/21/2014','0.00','0.00','0.00','','','01/21/2014' Has anyone else come across this situation  
9 3486
by  GeoffTSJYJump to last post
08/04/2015 4:23 PM
1 Replies and 3707 Views ActiveX Component can't create object when trying to run wizard    3707  1 Started by  jocelyn I've been using LPA for about a year now, and wanted to develop a new flow that includes a Lawson Transaction node.   When I click 'Build' to build the transaction, I get the following error: Run-time error '429':  ActiveX component can't create object. I've written flows before that utilize the Lawson Transaction and Lawson Query nodes and have used the Build wizards to create the transaction/query strings.   Suddenly I cannot.    However, the big...
1 3707
by  WoozyJump to last post
07/01/2014 9:15 AM
7 Replies and 3296 Views LPA- Default work title for UA    3296  7 Started by  Lynne Hi- I need to modify some of the inbasket work titles and can't figure out where I can see what the default title is.  If I look at the UA, work title, it is blank.  But, when the inbasket generates there is a title that displays.  Is there a default title that is used if you don't enter anything in the Work tab Work Title field of the UA node  Thanks! 
7 3296
by  John HenleyJump to last post
02/14/2013 3:41 PM
23 Replies and 18526 Views Installing and Configuring MSSQL JDBC for ProcessFlow Integrator    18526  23 Started by  John Henley Using SQL Update (as well as the SQL Query) nodes require locating/downloading and then installing/configuring JDBC drivers for your desired database(s) (e.g., Oracle, SQL Server, DB2, etc.) on your development workstation as well as your Lawson LSF9/ProcessFlow Server. You will also need some knowledge of JDBC connection string syntax. None of this is well-documented by Lawson (nor is configuration support provided by GSC). Here are instructions for installing/configuring MSSQL JDBC for Proc...
23 18526
by  masonpJump to last post
03/13/2012 11:07 AM
9 Replies and 9842 Views Someone - please share your PFlow Trigger form....    9842  9 Started by  Shane Jones I am looking for a simple form that an HR user could access to trigger a processflow. I was going to just schedule the flow but they need to be able to trigger the flow their schedule. I do NOT want to give them access to Process Flow Administrator. I have heard others say that they have created a form that triggers a processflow. Is anyone willing to share their form (My other option is to create a flow that is connected to a PA52 action and then have the user enter a personnel action...
9 9842
by  JeffRJump to last post
06/01/2010 12:13 PM
87 Replies and 44687 Views Migrating 8.0 Flows to 9.0    44687  87 Started by  Joe O'Toole We have some flows written in designer V 8.036 and they reference RD30. Is there a migration utility to move these to LSF 9 and will it move the flows even though the RD30 logan objects no longer exist
87 44687
by  Shane JonesJump to last post
09/01/2009 1:58 PM
3 Replies and 174 Views Change the sys cmd user to pfuser?  174  3 Started by  NHBB We have a system command node configured to invoke Windows PowerShell on the application server and run a PowerShell script file.  We need to use the PowerShell Active Directory module to update Active Directory. Currently pfuser is the account that can update Active Directory.  The system command node runs as Lawson so we get a security violation when the PowerShell script runs.  Can the system command node be configured to run as a different user  Configuring the Sys Cmd t...
3 174
by  Joan HerzfeldtJump to last post
08/15/2018 7:58 AM
2 Replies and 575 Views USPS Address Validation API Through IPA  575  2 Started by  Dave Curtis Anyone using IPA to do validation of address USPS has an API that allows the use of XML calls and returns address validation through their API.  Was wondering if anyone has done this.   Dave
2 575
by  ChrisJump to last post
08/01/2018 9:35 AM
12 Replies and 4399 Views Data Iterator Question  4399  12 Started by  Brian Berenger I'm using the data interator to input a file.&160;&160; The file is comma seperated.&160; The fields are 'Name', 'ID', 'Email','Company', etc. I have four variables, varName, varID, varEmail, varCompany What I want to do is simply loot is through the file and assign each of the fields to its corresponding variable in an assignment node that is nested within the data iterator loop.&160; I do not want to have to read the whole line into one variable and then use code to parse the line into i...
12 4399
by  Dave CurtisJump to last post
07/30/2018 2:09 PM
0 Replies and 137 Views Lp51 Trigger - Pull Employee Information  137  0 Started by  tommyg-006 Hello,   I am working on a flow that is triggered from LP51.  I am running into an issue though if there are multiple people that have the leave in a pending status.  For example I have an employee EE 202065 that has a personal leave entered, but the flow has stopped on a User Action Node to determine the employee's eligibility.  Then I put in a leave request for EE 200367 (myself), however, when the flow runs it is pulling the employee with the higher number.  ...
0 137
07/17/2018 2:15 PM
7 Replies and 219 Views Effective Date of Action From A User Action Node  219  7 Started by  tommyg-006 Hello,   I am working on a flow in IPA for Leave of Absence Processing.  In the flow there is a User Action Node where the end user choose one of the following actions:   Employee Returned from Leave Employee Failed to Return (Terminate) Extend Employee Leave I need a way to get the effective date of the action, but this may not be the same date as when the User Action was completed.  Lawson recommended having the end-user put in the date as a message on the action, wh...
7 219
by  tommyg-006Jump to last post
07/17/2018 1:58 PM
0 Replies and 94 Views Resource Update Node - Remove specific Role or Group  94  0 Started by  Nabil Hi All, I'm trying to delete a specific Group from the existing list. I only want to delete 'Manager Self Serve' but instead it deletes all group the user has.   In the Group value, here is what I have:    
0 94
07/11/2018 12:01 PM
0 Replies and 98 Views IPA Proxies - Trigger on Creation  98  0 Started by  Bob Canham We recently upgraded to v11 Landmark (v10 LSF) and we want to revisit the proxy functionality now that it will proxy tasks rather than roles.  One concern that has come up is if someone were to assign a proxy to someone who is not of the appropriate leadership level (i.e. a Director setting up a manager under them as a proxy).  One way I was thinking to avoid this would be if I could trigger a flow when someone creates a proxy record that would check if the person is of the appropriate...
0 98
07/10/2018 3:43 PM
2 Replies and 205 Views IPD error when using Query node.  205  2 Started by  Kenn
2 205
by  David WilliamsJump to last post
07/07/2018 7:40 AM
3 Replies and 139 Views Data Transformation Node  139  3 Started by  cpaine216 Has anyone used the Data Transformation node in IPA...WE are trying to figure out the data transformation node mapping file....
3 139
by  John HenleyJump to last post
07/05/2018 9:06 AM
2 Replies and 1450 Views File Channel Receiver _inputData  1450  2 Started by  Kyle Jorgensen We're just starting our PFI-to-IPA upgrade project.  We're going from a local AIX PFI installation to a remote Windows IPA installation.  LSF is still on AIX/DB2. In PFI ScanFileClient. when the 'batch' option is set to true it passes the fully qualified path for the trigger file as '_inputData'. In IPA File Channel Receiver, when the 'Data' option is set to 'File Name' it only passes the file name as '_inputData'.  It doesn't include the full path. Is there a setting that can ...
2 1450
by  Joe Van DenburgJump to last post
06/22/2018 11:56 AM
4 Replies and 391 Views Looping through S3 reports  391  4 Started by  Bob Canham I am looking at ways to loop through the content from an S3 report such as BN101 and then to perform an action on each record.  One way is to use bldxffiles to turn it into a pipe-delimited csv and then iterate through that.  While that will work, I want to see if anyone has instead converted a report to XML and then used the For Each to iterate through the nodes successfully.  I attempted it earlier today, and ran into issues first because there aren't any published schemas for t...
4 391
by  Bob CanhamJump to last post
06/05/2018 8:43 AM
4 Replies and 321 Views Check if value in array  321  4 Started by  Nabil Hello, I query a table and add values to a Message Builder array (var1) then run another SQL to check if the value is part of 'var1'.   I'm using a Branch to determine if I need to add or remove Security access. My branch condition is    var1.includes(SQLQuery8410_POSITIONCODE);    The problem is it skips it, even if the POSITIONCODE is in the var1 array.   Any ideas how I can tackle this   Thank you!
4 321
by  NabilJump to last post
05/30/2018 5:04 PM
4 Replies and 353 Views User Action Node - Notification Message Email, include file attachment  353  4 Started by  agersh Is it possible for a User Action node notification message email to include a file attachment
4 353
by  agershJump to last post
05/24/2018 12:20 PM
2 Replies and 572 Views ProcessFlow inventory - nodes used  572  2 Started by  Joe Van Denburg I'm looking to create a list of our active ProcessFlows and the node types utilized in each flow - or a list of unique node types used in each flow. I was thinking of using a Landmark transaction to find a list of active flows and the current version, a second Landmark node to query the version to pull the FlowXML. Not sure how to parse the xml to leave me just with a list of the node types. Any ideas Thanks Joe
2 572
by  JimYJump to last post
04/16/2018 7:05 AM
2 Replies and 368 Views Employee Audit Information via Landmark Transaction Node  368  2 Started by  Randall Hi all,   Hopefully this isn't a duplicate as I've been looking all over for an answer to this.   I've been working with a Multi-Tenant instance of LTM.  If you're not aware, in this configuration, you're not able to use the SQL Query node to retrieve information from the database.  This is posing a bit of a problem when attempting to get at the audit data behind the Employee record.   In short, I'm attempting to get when the Relationship Status and Work Type chang...
2 368
by  RandallJump to last post
04/09/2018 10:34 AM
7 Replies and 443 Views IPA Installation Guide  443  7 Started by  JonA Anyone have the latest IPA install guide  Infor Extreme is useless for finding documentation. I'm really looking for the list of Infor provided IPA flows and their descriptions.  I'm thinking I've seen them in the install guide.
7 443
by  JonAJump to last post
04/06/2018 9:40 AM
1 Replies and 255 Views Inbasket view in S3  255  1 Started by  Casy We had a custom approval flow created for our RQC approvals.  Users typically click a link in a notification email that launches the S3 Portal application for them to view their inbasket.  After approving a requisition, occasionally the screen will revert to the users task list and what they call 'nonsensical' data.  They are unable to easily get back to their inbasket to approve additional requisitions and is causing some confusion.  Has anyone else had this occur  Try...
1 255
by  kflores01Jump to last post
04/05/2018 8:42 AM
5 Replies and 485 Views Javascript  485  5 Started by  Jeff I am new to IPA and javascripting but so I was wondering if anyone can help me on how to create a fixed length field for use in an Assign node.  I have a field that can vary in length that I need to include it in a flat file interface I have been able to use 'addTrailingSpaces' but this wont work when the data in the field are different lengths.  Probably an easy solution but I cant seem to find anything that works...Thanks in advance for any assistance you can provide!
5 485
by  JeffJump to last post
03/30/2018 1:47 PM
4 Replies and 470 Views Cannot configure M3 Transactions in Process Designer  470  4 Started by  ScottGTM Whenever I attempt to configure an M3 Transaction node in the Process Designer application, I am given an error upon clicking 'Build' in the properties pane.    After clicking OK the M3 Program Query Wizard does launch, but there are no M3 programs/transactions available to choose from. The program should have a list of available APIs, and when selected the available transactions for the selected program should populate.  Here is the console 
4 470
by  ScottGTMJump to last post
03/26/2018 3:07 PM
0 Replies and 217 Views Infor Process Automation to Process Async Errors  217  0 Started by  JoseLuis Any ideas or suggestions are appreciated.
0 217
03/07/2018 8:23 AM
5 Replies and 513 Views PFI Schedule  513  5 Started by  FireGeek21 What database/table is the PFI Schedule details stored in  Looking to do a quick dump as a reference using SQL if possible but cannot seem to locate the table where this information is stored.   Thanks!
5 513
by  FireGeek21Jump to last post
02/25/2018 11:27 AM
1 Replies and 613 Views Employee's last Lawson sign in  613  1 Started by  TBonney Does anyone have a simple flow to determine when an employee last signed into the Lawosn application (that they would be willing to share as a ample/point of reference) At this time of year, we get inundated with numerous help desk calls that users are unable to log into Lawosn. Often times ,we investigate, find nothing wrong with their profil and leave messages for the user to contact us back. However, they frequently do not respond, thereby leaving us to waste our time chasing them down befo...
1 613
by  edisonJump to last post
02/15/2018 11:11 AM
1 Replies and 408 Views French characters not loading correctly with Ags call  408  1 Started by  Todd Mitchell I have a New Hire process flow that uses PA31 as one of the Lawson activity Nodes.  The data being processed comes from a flat file and occasionally contains French characters.  When I review the log from the work unit I can follow the flow and see where the French character is displaying correctly right up to the point where PA31 stores the data.  Here is the AGs call: with string _PDL=S100&_TKN=PA31.1&_EVT=ADD&_RTN=DATA&_LFN=ALL&am...
1 408
by  Kwane McNealJump to last post
02/15/2018 7:52 AM
20 Replies and 3628 Views Sending Results of Query to a csv file  3628  20 Started by  Brad Schauer New to creating ProcessFlows. I created a flow that has three queries, the result of which I can use MsgBuilder and an Email node to send the results via e-mail. I am trying to figure out how to send the results to a csv file. I have tried using the file access node 'write to file' but my results come back on one line. For example if I am returning ID and Name into a txt file, I want to see: ID,Name 1,Tom 2,Mary What is being written to the file is: 1,Tom,2,Mary Can anyone po...
20 3628
by  Orlando GrayJump to last post
02/13/2018 5:37 PM
1 Replies and 378 Views ipa sending duplicate email notifications  378  1 Started by  FireGeek21 We have an approval process sending duplicate email notifications to all users through the User Action node.  We checked the User Configuration and confirmed the users are not duplicated in there.  Any ideas on how to stop/prevent this   Thanks!
1 378
by  kflores01Jump to last post
02/12/2018 8:12 AM
4 Replies and 1204 Views Custom Java Trigger API for IPA  1204  4 Started by  Kyle Jorgensen We are experimenting with creating our own custom java trigger API for Infor Process Automation (as described in the 'Creating a Custom Java Trigger API for Infor Process Automation' section of the Landmark InfoCenter). We've been able to use the brief example in the InfoCenter to create a proof-of-concept custom java trigger API, but now we want to take it to the next level. We want to be able to set and pass the flow name/value pairs, set category keys and category values as well as the input...
4 1204
by  Kyle JorgensenJump to last post
02/08/2018 1:35 PM
2 Replies and 423 Views getRMQuery  423  2 Started by  Ludy Does anyone know what file is being accessed by the method getRMQuery   Thanks, Ludy
2 423
by  LudyJump to last post
02/08/2018 8:18 AM
7 Replies and 714 Views scheduling flows  714  7 Started by  Ragu Raghavan I have a need to schedule a IPA flow to run every 15 minutes. Simple flow that checks for some condition and does an AGS call to a GL Screen to change status, Most of the time it will just kick off, find condition not met and end. The sysadmin is concerned that just running it 96 times daily and the WU's created and other overheads will bring the landmark server to its knees. V10. Anybody does this kind of high frequency scheduling Thanks.   Ragu
7 714
by  RandyJump to last post
02/05/2018 2:18 PM
3 Replies and 643 Views Check For File modified date  643  3 Started by  Jessi I need to access a file in IPA and check for it's last modified date. Based on the modified date I'd perform different options. What's the best way to access the modified date of the file 
3 643
by  John HenleyJump to last post
01/23/2018 9:44 AM
0 Replies and 213 Views ActorID and AgentID  213  0 Started by  PD  When a user with their ID goes into Infor MyHR, she sees someone else's name and information and that person has a completely different ID. Terminated employee seems to be the thread, on all three cases thus far, the terminated employee ID has been the common thread......we just went live on cloud v10. How do I query the ERP (or IPA flow) to catch other records  
0 213
01/09/2018 2:35 PM
2 Replies and 925 Views Security violation  925  2 Started by  PD I am using a LwsnTxn and WebRun node for a PR295 job. I then reference the bldxffiles utility to convert the PR295.prt to a csv file. The csv is not being created because the .prop and .grp files are not being generated neither from the job or the utility. Might anyone be knowledgeable on how to generate the .prop and .grp files with the prt job or   I am using this command: bldxffiles -SCp 382396 D:\lsenv\law/print/INFORBC_382396/pr295-ju/1  PR295.prt     I am ...
2 925
by  PDJump to last post
01/02/2018 8:00 AM
2 Replies and 674 Views Trigger WFWK.1 in a non-Design Studio form  674  2 Started by  Roger French I've got a custom htm form I am using for a customization. It's working. It's not a Design Studio form. Design Studio is not available on this environment.   So question, I've tried the 'normal' method of using the portalWnd.AGSPath in the call to WFWK, but, in the html form, it does not work. I've spent alot of time debugging why it won't work. There isn't any error messages, but the javascript function does not like the method of  var s = portalWnd.AGSPath .....   So qu...
2 674
by  Roger FrenchJump to last post
12/22/2017 7:16 AM
2 Replies and 621 Views Where do SQL Procs go???  621  2 Started by  dcasper70 IPD v11.0.1.43,  single tenant, cloud, SQL Server. A developer had created a SQL Procedure using the 'Create/Update SQL Procedure' option.  Now that proc is available to me in the 'Run SQL Procedure' option -> Select -> 'SQL Procedure Selector' window. Original developer then deleted that SQL node from his original flow.  The proc exists, but we don't have a copy of the original source. Is there any way for us to view the SQL behind that proc Does it actually create ...
2 621
by  dcasper70Jump to last post
12/21/2017 9:38 AM
3 Replies and 611 Views Create a field of spaces  611  3 Started by  FireGeek21 I am using process flow to build a fixed field .txt file.  Several of the fields require a specific number of spaces because no value is being passed.  In SQL it is quite easy to use space(10) for a field with 10 spaces.  How can I do this in an Assign node maybe with javascript  I have tried the addtrailingspaces(' ', 10  but the spaces appear as 202020...  instead of true spaces.  Using '      ' is out of the question because the h...
3 611
by  FireGeek21Jump to last post
12/12/2017 11:15 AM
2 Replies and 535 Views Encryption Node  535  2 Started by  Jessica M I need to encrypt an outgoing file to a 3rd party vendor using the PGP key they provided.  Do I need to provide that key to Cloud Services to install in our system  Is that where I get the 'service name' for the encrypt node  I would greatly appreciate any assistance.  Thanks, Jessica
2 535
by  Jessica MJump to last post
12/12/2017 10:57 AM
4 Replies and 707 Views Add Approval History to Email Notification  707  4 Started by  JonA One of our medical center presidents asked if he could see who has approved a requisition before him in the email notification.  He's at the top level (level 5) so he would like to see who approved at levels 1-4.  I've been able to add the history to the notification email by adding this...         Which looks like this APPROVER ACTIONS Level 1 approved by M123450 Level 2 approved by A95687 Level 3 approved by&nbs...
4 707
by  Kat VJump to last post
12/05/2017 1:39 PM
1 Replies and 565 Views How to bypass AGS error prompt?  565  1 Started by  Lance Jurgensen I am trying to delete an employee group - HR55.1 and when that group contains employees the system prompts you to hit Delete again to confirm.  Anyone know how to bypass that in the AGS call LwsnTxn5370_errorCode = 5 LwsnTxn5370_informationCode = 197 LwsnTxn5370_returnMessage = Warning-Employees in group; okay to delete
1 565
by  John HenleyJump to last post
12/01/2017 4:34 PM
4 Replies and 764 Views Webrun /lawsion-ios/action/AddAttachment  764  4 Started by  Lance Jurgensen I am attempting to add a Delivery comment to the POLINE.  One of the things I do not understand and can not find documentation on is what the K1 through K5 should be. I am guessing here on these settings from running this ListAttachment in the browser and looking at the values it spits out. The editor is killing the text I'm trying to put here, please see attachment
4 764
by  Lance JurgensenJump to last post
12/01/2017 8:26 AM
0 Replies and 194 Views ListAttachments, ReadAttachment  194  0 Started by  Garry Ferwerda I am in the process of modifying some flows and converting the CGI getattachment processing to the ListAttachments service.  I am having trouble getting the ATTACHMENT-NAME and ATTACHMENT-TEXT values.  I am able to access orther values such as LIST numRecords value.  I took a XML file returned from a call to the service in a browser and created an .xsd file from it.  I don't know if the issue I am having is with the xsd or how I am trying to access the values in the flow.&nbs...
0 194
11/29/2017 9:14 AM
1 Replies and 583 Views Dynamically change SQL Proc in IPD?  583  1 Started by  dcasper70 IPD v11.0.1.43,  single tenant, cloud, SQL Server.  Business has about a dozen or so bonus programs.  Each program has different criteria, run dates/frequencies, and payout amounts.  We're attempting to use a single flow to create the EmployeeSpecialIncentivePayout (ESIP) business class records for the desired program.  We figure that all the ESIP entries can be done in one Landmark transaction node, and all that we need to vary is the SQL that runs to get the peop...
1 583
by  dcasper70Jump to last post
11/28/2017 4:26 PM
2 Replies and 784 Views SQL Count not showing as variable  784  2 Started by  Nabil Hi All,   I'm running a SQL query and doing a count which should determine how the flow would proceed, however, when I try to pull the Count on my Branch Node, I'm failing to see it.   Any ideas why this is happening  Here is the SQL SELECT PAY.APCOMPANY ,PAY.INVOICE ,PAY.VENDOR ,PAY.INVOICEURL ,to_char(cast(PAY.USTIMESTAMP as date),'DD-MM-YYYY') as UPDATE_TIME ,PAY.CREATIONDATE ,PAY.USTIMESTAMP ,API.INVOICE ,API.L_INDEX ,URL.L_INDEX ,COUNT(URL.L_INDEX) ...
2 784
by  NabilJump to last post
11/16/2017 4:52 PM
2 Replies and 781 Views AddAttachment via process flow  781  2 Started by  Nabil Hello,   Has anyone implemented the AddAttachment that's supposedly replacing writeattachrec.exe SERVER: PORT/lawson-ios/action/AddAttachment Lawson documentation has this as an example POST data but I haven't been able to get it to work. I'm looking to add Invoice comments to APINVOICE from our Landmark Financial suite.   Attaching a KB article (1937446) that talks about the replacements for writeattach   Thanks, Nabil
2 781
by  NabilJump to last post
11/13/2017 11:37 AM
6 Replies and 643 Views How do I update information on page 3 of HR15.1  643  6 Started by  Todd Mitchell How do update an item on 'page 3', page down twice, of HR15.1. 
6 643
by  Bob CanhamJump to last post
11/10/2017 9:20 AM
15 Replies and 1771 Views processflow trigger  1771  15 Started by  edison Apologies for the very basic question;   We're migrating from v9 to v10. I need to have a process flow execute when a user changes their address in ESS.  I'm just assuming that the EMSSAddrChg service is the key to running the process flow (that's what I saw in our v9 bpm/ I made a very simple processflow that just sends an email and upload it.  Then on Process Server Administrator > Configuration > Service Definitions Double click on EMSSAddrChg Click t...
15 1771
by  edisonJump to last post
11/09/2017 1:10 PM
0 Replies and 224 Views Trigger flow on data change  224  0 Started by  Kidd Kasper Process flows are uploaded to the server in a few different PFI tables. I have a flow that will query those tables, create a summary document, email the developer, etc. It's easy enough to schedule my process flow to run every hour to look for any other flow that was uploaded in the past hour.  However, I would love to be able to trigger my flow based on a new record in these PFI tables (new flow having been uploaded). Anyone aware that this is even possible
0 224
11/07/2017 11:52 AM
0 Replies and 219 Views S3 Adapter  219  0 Started by  Lynne Hello- I am looking for some help on the S3 Adapter node in IPA.  The manual says to run process FormFldLoad to get the fields loaded in rich client for my form.  Does anyone know where to find it or how to run it  I found a rich client form that has some of the S3 form fields built out.  Do I have to add all my fields manually  Thanks!
0 219
11/07/2017 9:31 AM
3 Replies and 772 Views PATCH web API triggered from IPA flow  772  3 Started by  brox07 I'm trying to run a web API, using the PATCH method, that our web dev team developed.  I set up a webrun node with the information that I needed but it's returning an 'Invalid HTTP method: PATCH' error.  I tried using 'POST' with 'X-HTTP-Method-Override: PATCH' in the Post String with no luck.  Has anyone had any experience with this  Any information would be greatly appreciated.  
3 772
by  David WilliamsJump to last post
11/04/2017 8:47 AM
1 Replies and 640 Views Managing Flows --Release VS Restart  640  1 Started by  tambrosi 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...
1 640
by  Tim CochraneJump to last post
11/03/2017 12:37 PM
1 Replies and 671 Views po30 - PO Overshipment not trigger  671  1 Started by  PD In Po30, when the quantity received is greater than what was ordered, it should create a work unit with the 'has buyer message'. The buyer message is created but it does not trigger a work unit through 'PO Overshipment' Service definition. What is my problem   Thanks
1 671
by  Kat VJump to last post
10/30/2017 2:44 PM
3 Replies and 1062 Views SysCommand Node - Landmark Command  1062  3 Started by  Maestro I have tried to search for the answer prior to asking this but unfortunately when trying to go past page one of posts i'm getting an error. I'm sure this is relatively simple answer. When using SysCommand node how can i reference a landmark command like dbupdatelobs and wait for it to finish   Thanks Michael 
3 1062
by  JimYJump to last post
10/30/2017 7:01 AM
1 Replies and 638 Views IPA Enhancements  638  1 Started by  Survivor Our version of Landmark is 10.0.  We will be engaging ICS to update our environment.  The suggested version of Landmark is  I remember about a year ago there was a webinar about the various CUs and the impact on IPA.  I believe CU 48 had many performance enhancements.  When I look at the Infor technology blogs, it appears that the webinar is no longer there as Landmark version 11 is available for LSF 10.0.9.  Does anyone have any suggested CUs ...
1 638
by  David WilliamsJump to last post
10/25/2017 8:06 AM
0 Replies and 281 Views XML Output of Lawson Transaction Activity  281  0 Started by  Layne.Ingle I was wondering if you might could help with something.  This is XML output from a Lawson transaction.  I need the value called REQUEST-NBR, so I would want 1153 returned.  What can I use to extract this into a variable so I can use it.   Thanks   LSAPPSPD10.1TRUEPD10.1AGCSGreenville County Schools>11530NewCard CompaniesNT00005704212350Mickey Mouse106134Terese       0000000000001153Add Complete -...
0 281
10/24/2017 9:04 AM
4 Replies and 709 Views Landmark: Provisioning - Account Disabled Flag  709  4 Started by  Bob WCHN In ISA, on the Landmark Tab, there is an Account Disabled checkbox. I can't find a means of setting this flag with a Landmark Transaction Activity Node. I’ve tried setting the IsActorDisabled and AccountLockout.IsAccountDisabled Flags for the Actor and tried doing a ‘DisableActor’ update, but the checkbox still is unchecked. Then, I thought that maybe the flag is a reflection of the DELETEFLAG value (off for 0, on when the DeleteFlag has a non-zero value) in the GEN ACTOR Tab...
4 709
by  Bob WCHNJump to last post
10/19/2017 10:40 AM
12 Replies and 1097 Views Creating excel xlsx file instead of csv  1097  12 Started by  HDAustin13 Hello All, I have a flow that using SQL to produce an output to CSV file but the vendor keeps having an issue of opening it. In order to successfully open it, he has to rename the file extension from .csv to .xlsx each time. Does any know if IPA can produce an output excel file to .xlsx instead of .csv file Can you please advise Thanks, Han
12 1097
by  jamesracesonJump to last post
10/10/2017 7:34 AM
2 Replies and 676 Views sending email-smtp settings  676  2 Started by  edison Hello,  I'm very new to lawson. I started this job last month and we're converting from v9 to v10. Still getting to figure out all the terms.  I've been tasked to convert our old process flow in v9 to the v10 Infor Process Designer(IPD) I created a test processflow that just sends email. I could not get this to work. I always get an authentication failure. Our sysadmin has supplied me with the username/password for the smtp server. There is an online tool called 'Process Server Ad...
2 676
by  edisonJump to last post
10/04/2017 3:23 PM
4 Replies and 703 Views Workload Manager Tools  703  4 Started by  Kyle Jorgensen Is anyone using Control-M (a cross-application and cross-platform workload management tool) with Lawson and/or Landmark If not Control-M, any other workload management tool Thanks in advance, Kyle Jorgensen
4 703
by  Kyle JorgensenJump to last post
10/03/2017 8:04 AM
1 Replies and 1096 Views IPA Inbasket user guide  1096  1 Started by  Karen Ploof I cannot find anything on the Infor site that would help us understand what all the bells and whistles in the InBasket do.  It's taking us a while to play around with each and I'm hoping someone out there has some kind of documentation. So far Infor helpdesk has not come up with anything.
1 1096
by  heartlandJump to last post
09/22/2017 10:40 AM
5 Replies and 983 Views PA Reviews notification via email from IPA  983  5 Started by  Julia   We are trying to create emails to send to supervisors for their upcoming reviews.  I have the query written to gather the data to send and have it is a action node in a message, but I am have trouble determining the best way to parse that data and send to the supervisors their rows of data. Should I be putting this information into a file and parsing that way, should I be able to loop through the email node with using the variables.   I am self taught and have be...
5 983
by  JuliaJump to last post
09/21/2017 2:52 PM
4 Replies and 895 Views Process flow performance issues in Cloud - possible grid issues???  895  4 Started by  Jessica M We are getting ready to go live in the cloud on 9/22/17.  Our grid was tuned in the spring and our process flow performance  was better in the cloud than our on-prem version as of mid summer.  Now, all of the sudden, our performance has gotten worse.  Flows are running anywhere from 30 minutes more to 4 hours longer than they previously were in the cloud.  We are not getting anywhere with our project team and the support personnel they have assigned.  At this poi...
4 895
by  Jessica MJump to last post
09/20/2017 1:40 PM
4 Replies and 1967 Views Intercept Action in custom inbasket  1967  4 Started by  MarkH2002 I am trying to figure out how I can intercept the action being taken on an inbasket workunit and perform a test.  If the test = true the action will be taken, if false show an alert.  Similar to what you would do in design studio with OnBeforeTransaction. 
4 1967
by  Ragu RaghavanJump to last post
09/13/2017 9:02 PM
8 Replies and 1417 Views IPA Scheduler Not Working  1417  8 Started by  Roger French This is a new instance. Win/SQL. LSF 10.0.9, Landmark LSF and Landmark have been running for a few months. IPA's have been installed, configured and running OK. Trying to schedule an existing IPA flow using Rich Client. The IPA runs fine and OK for a manual schedule meaning 'Start'. It runs fine in IPD too. The issue is that if I create a schedule in My Actions, Schedule for any type of periodic schedule for the IPA to run (one a day, once a week, etc.) it fails to launch. I'm log...
8 1417
by  Roger FrenchJump to last post
09/11/2017 4:26 PM
0 Replies and 360 Views Negative or zero dollar payment  360  0 Started by  Todd Mitchell We are currently working on a project in which a customer has the ability to pay their invoices via credit card.  On some occasions, the amount of credits could be the same or exceed the amount of invoices, resulting in a zero dollar payment or a negative payment.  In the Lawson EFT world (AR115), Lawson creates a debit memo to offset the amount of the negative payment and then interjects a zero dollar payment into the payment table. Has anyone had to create a similar situation and if...
0 360
09/11/2017 2:28 PM
0 Replies and 286 Views Sys Cmds Returning Unreadable Log  286  0 Started by  ehuso Hello, When we issue a system command, the response is completely unreadable regardless of if the process completes or it fails. This is especially an issue with our FTP manager. After IPA creates a file, our FTP client on the iSeries performs the FTP. The FTP manager needs the file to be generated with a CCSID of 37. In the attributes, it is shown as 37 but when the hex of the file is examined, the true CCSID is not 37. I noticed in our process flow logs that this occurs for all system comman...
0 286
09/07/2017 1:28 PM
16 Replies and 2406 Views Create PO via PO23.1 in PF  2406  16 Started by  Lynne I am attempting to create a PO via PO23.1 in my PF.  I would prefer to do it this way as opposed to running a PO100 job from PF.  My problem is that I have to inquire on the PO23.1 before doing an 'Add'.  I have read some posts about this same problem on different forms and have not been able to get mine to work.  On one it said that you had to have _EVT=CHG.  I've tried that and _EVT=ADD.  I also saw where you had to have the hidden key, _HK, set.  I also trie...
16 2406
by  PFlowNerdJump to last post
09/07/2017 11:28 AM
2 Replies and 833 Views File move/copy from within IPA (Processflow)  833  2 Started by  SWilkins Lawson environment 10 LSF on one windows 2012 VM and Landmark on another windows 2012 VM.  IPA (Processflow) running on the Landmark VM.  Using designer and using the SysCommand node to run a COPY or MOVE command.  The flow works fine if the source and destination for the file location is either the C or D drives of the LSF server (D is where LSF is installed).  But if we want IPA to move the file to a network location it fails, even if we map a network drive on the...
2 833
by  AriJump to last post
08/31/2017 5:36 PM
3 Replies and 1141 Views WFWK call to LMRK Service failing  1141  3 Started by  Vikram Narasimhareddy Hello, We are upgrading from V9 to V10. I am trying to call a Landmark service using AGS call over WFWK form. Service on the Landmark side is enabled and I am passing all the required parameters (Criteria, Variables and Prodline). When I checked the LPS log under $GENDIR/bpm/, the last message in the log is 'isLPSServiceExistAndEnabled(), sending socket message for isLPSServiceExistAndEnabled'. I assume that there is no response back to the S3 server for the socket call. I checked the BPM servi...
3 1141
by  jdeverJump to last post
08/28/2017 10:47 AM
2 Replies and 921 Views How to Disable Landmark User ?  921  2 Started by  Bob WCHN I'm doing analysis to design a Process Flow to disable terminated employees. When looking at a User Account in ISA, I see there is an 'Account Disabled' checkbox on the Landmark Tab. I haven't been able to find a way to set that in my searching of the available functions in the Landmark Transaction or Resource Update activity Nodes. Is there a way to set that flag from a Process Flow
2 921
by  Bob WCHNJump to last post
08/15/2017 9:33 AM
0 Replies and 300 Views POST DATE ISSUE for AR130  300  0 Started by  vishwanath We are facing issue with the post date for job AR130. The deposit date is getting applied to the post date instead of posting date i.e user selected date or current date when we try to apply the payments after submitting the AR130 job. Please let me know the solution for this issue.
0 300
08/01/2017 4:25 AM
0 Replies and 292 Views WFEVTSERV ?  292  0 Started by  timbomom Migrating to V10 from V9, where can I find equivalent IP-ADDRESS and PORT-NUMBER from WFEVTSERV in V10 Thanks, Pat
0 292
07/26/2017 9:32 AM
0 Replies and 361 Views PFI to IPA - WFMETRICS and WFUSERCAT tables  361  0 Started by  timbomom Working at client to covert PFI to IPA.  Have some flows that make extensive use of WFMETRICS table in PFI. The conversion scripts muck up the IPA conversion.  Anybody have any samples of WFMETRICS to PFIMETRICS I have a file mapping from for PFI to IPA but it's not much help for WFMETRICS.   The V9 node is: PROD=LOGAN&FILE=WFMETRICS&INDEX=WMESET8&KEY==2=&FIELD=WORKUNIT;PROCESS-ID;END-DATE;END-TIME;STATUS;WF-RM-ID;TASK;ACTIVITY-ID;OPERATION;COMMENT;START-DATE...
0 361
07/18/2017 10:37 PM
2 Replies and 666 Views PFI table/column listing  666  2 Started by  timbomom Hi..  I'm looking for a table column listing of PFI tables.  I need a detailed description of how to convert a WFMETRICS v9 node in a flow to the corresponding PFI table.  The landmark node build function in ipd is very confusing and unclear to use. The v9 node has this code: PROD=LOGAN&FILE=WFMETRICS&INDEX=WMESET8&KEY==2=&FIELD=WORKUNIT;PROCESS-ID;END-DATE;END-TIME;STATUS;WF-RM-ID;TASK;ACTIVITY-ID;OPERATION;COMMENT;START-DATE;DUE-DATE&OUT=CSV&DELIM=~ &n...
2 666
by  timbomomJump to last post
07/18/2017 4:00 PM
10 Replies and 1099 Views IPD Designer - Custom Function  1099  10 Started by  Roger French IPD Designer version Windows 2012, Landmark 10.x So I want to add a custom function to utilize in designer. I've added the custom code in pflow.js in \system\LPS I stopped/restarted all services in Landmark and LSF. Exited and logged back into Process Designer. I still can't see the custom function I just created in the drop down of any assignment node. I rechecked everything. Still the custom function doesn't appear. Yes, I'm using this in the header part of the pflow.js. I eve...
10 1099
by  John HenleyJump to last post
07/18/2017 9:38 AM
8 Replies and 1104 Views IPA-Adding OS (Environment) Identity  1104  8 Started by  Roger French So, attempting to add the OS Identity using the Resource Update node. This is Landmark on Windows LSF 10.x So in the IPA is working and the Basic LSF Security record using the Resource Update node. The SSOP and the EMSS identities are also added correctly. The OS Environment identity is not. Here is a snippet from the error log of the work unit. The SID is not an attribute to populate in the build in the Resource Node, and thus it can't be manually added. I've already confirmed that...
8 1104
by  JimYJump to last post
07/12/2017 10:55 AM
4 Replies and 937 Views Trigger Process Flow  937  4 Started by  FireGeek21 Is it possible to trigger a process flow (PFI, Lawson S3 v9) if a file is present in a specific folder
4 937
by  John HenleyJump to last post
07/12/2017 8:45 AM
1 Replies and 1149 Views Trigger Node in IPA  1149  1 Started by  Gok87 So below is what i am trying to do 1. Submit an action request  2. have a trigger node an trigger a process flow which has an user action in it. 3. Try view the details (actually i want to edit some details) and approve. In the user action under display tab > i confugured as action request.   When i try to open the workunit in the Inbasket i get an error saying ViewException:   Class Name: null Stack Trace: com.lawson.rdtech.opf.OPFNoSuchElementException at
1 1149
by  NHBBJump to last post
06/27/2017 10:49 AM
2 Replies and 886 Views IPA - Req Approval Flow w/ Logic on who to notify  886  2 Started by  Remi We have a Req Approval flow on our system that was built for us by a Lawson Consultant several years ago.  Most recently, our Purchasing department is interested in seeing how this process flow works in hopes of implementing it for their requisition approval process. There's a portion in the flow that is supposed to get the object ID of the items on the req., account number, and sub account number from the reqline, and from there, determine who in our organization to send th...
2 886
by  RemiJump to last post
06/20/2017 10:27 AM
2 Replies and 1161 Views PFI to IPA Landmark transaction  1161  2 Started by  Daniel Here is the current Landmark transaction node: it returns no data _dataArea='LSAPPS' & _module='pfi' & _objectName='PfiUserCategory' & _actionName='Find' & _actionOperator='NONE' & _actionType='MultipleRecordQuery' & _runAsUser='' & _setName='ByTaskCategoryValueUser' & PfiUserProfile & PfiTask.TaskName='Level1;Level2;Level3' & PfiFilterKey='Req Loc' & PfiUserCategory=''  and here is our PFI query PROD=LOGAN&FILE=WFUSERCAT&INDEX=WFTSET3&...
2 1161
by  John HenleyJump to last post
06/13/2017 2:28 PM
3 Replies and 933 Views Check If file directory exists, if does not exists create directory  933  3 Started by  agersh Using V10 IPA is it possible to check if a network directory exits If the directory does not exist then create the directory on the network drive
3 933
by  Kyle JorgensenJump to last post
06/13/2017 9:03 AM
2 Replies and 796 Views Using SysCommand instead of .bat file  796  2 Started by  FireGeek21 I have the following in a .bat file but we are moving to the cloud and cannot use .bat files.  How can I do the same thing using a syscommand node  Or is there a different node/combination of nodes I should use to count the number of a certain type of files in a folder echo off setlocal enableextensions set count=0 for x in (\\servername\appprodline\foldername\*.RQ500) do (set /a count=1 > nul) echo count endlocal   Thanks!
2 796
by  FireGeek21Jump to last post
06/06/2017 8:59 AM
2 Replies and 744 Views IPA File Channels  744  2 Started by  Vikram Narasimhareddy Hey Guys, I have an issue with File channel. The file on the FTP server is getting deleted after the 'Scan Now' action. The WU getting created successfully. Can someone tell what could be reason for the file deletion Thanks, Vikram
2 744
by  John HenleyJump to last post
06/05/2017 5:59 PM
15 Replies and 2772 Views How to use IPA to importdb  2772  15 Started by  JasonP Any ideas on how to run importdb via IPA
15 2772
by  mthedfordJump to last post
06/05/2017 5:20 PM
0 Replies and 381 Views File Locking - Incrementing a value  381  0 Started by  Steven.Morales Essentially, I am trying in increment CPY-LAST-BATCH by 1, but I don't think there is any file/record locking in place to prevent two programs from reading the same value before they have a chance to write it.   Is there something I can do to make this work properly
0 381
06/05/2017 1:24 PM
7 Replies and 1665 Views Positive Pay (PR170) flow  1665  7 Started by  Joan Herzfeldt We have to create a positive pay file process flow rather quickly.  I'm still learning the complicated pieces of IPA and wondering if anyone had this flow or parts of it already created and were willing to share  Or some advice on the best ways to create the different pieces (see below). Thanks - Joan Some additional information/questions: Our current production flows are inbound into Lawson, so what is the best way to get data from Lawson if a Service/trigger does NOT already exis...
7 1665
by  Joan HerzfeldtJump to last post
06/02/2017 2:00 PM
3 Replies and 718 Views Launch flow from URL  718  3 Started by  TimC I would like to allow the user to run a flow on demand from a URL. It does an extract and will send them an email. How do I launch a PFlow from a URL
3 718
by  TimCJump to last post
05/22/2017 11:55 AM
11 Replies and 1427 Views Help with SQL code for IPA flow  1427  11 Started by  Brooks Saunders Pulling in Data for use two fields.  Once I added the TRIM expression to the selection, I was receiving undefined when I reviewed my data in a text document.  If I leave the expressions out of the selection code, the fields are blank where I have null values (which is expected but I need to TRIM those fields).  Can anyone shed light to as why my COALESCE works for my POLINE.DESCRIPTION but does not work for APINVOICE.PO_NUMBER  (Keep in mind ISN...
11 1427
by  Bob CanhamJump to last post
05/12/2017 3:12 PM
1 Replies and 909 Views IPA S3 Commands  909  1 Started by  Srini Rao Hello, We run LSF and Landmark on windows. I'm trying to get the record count using count command in syscommand node. But IPA is not recognizing the count command.    My syscommand node has following command..  count test EMPLOYEE.    Error: 'count' is not recognized as internal or external command.  Any recommendations
1 909
by  Srini RaoJump to last post
05/05/2017 6:38 AM
0 Replies and 288 Views Help with Landmark JMSChannel  288  0 Started by  Kyle Jorgensen We're trying to add a JMS channel in Landmark to connect to our corporate JMS.  We use RabbitMQ as our JMS. The technical documentation is lacking (surprise!) and we're running into all sorts of dead-ends.  Any help would be appreciated. Has anyone been successful with creating a JMS channel in Landmark (connecting to RabbitMQ would be a bonus) Thanks in advance, Kyle  
0 288
05/03/2017 9:55 AM
1 Replies and 676 Views Wrong array length  676  1 Started by  PD I have this Property (RPT_022_ Div  and Value ('One, 'Two', 'Three') declaration in system Config Interface. I then reference it as type Array in the Start Node and the array length. In Debug mode, the Array elements show up OK as the value above but the array.length returns 1 as oppose to 3, what am I missing
1 676
by  PDJump to last post
05/01/2017 3:22 PM
8 Replies and 1214 Views Data Files with LineFeeds and Carriage Returns Importdb  1214  8 Started by  JasonP I'm planning on doing any importdb on a file that contains both a line feed and a carriage return at the end of each record and that doesnt seem compatible with the importdb command.  when I use notepad and change the EOL to UNIX which leaves just the line feeds, the importdb works fine.  Any ideas on how to remove those Carriage returns easily  is there some param on importdb Im missing
8 1214
by  JasonPJump to last post
04/27/2017 2:33 PM
0 Replies and 385 Views Mobile Inbasket  385  0 Started by  Roger French Has anyone got the Mobile Inbasket to actually work completely I've got MIB installed, with a V10 LSF and Landmark all Windows installed. IPA is running and requisitions flow is installed and running using IPA. The desktop inbaskets are working, but the Mobile Inbasket isn't. On either Android or Iphone, after logging in, and navigating to the Task Folder, and clicking inside of the Task folder, the message says 'No inbasket items found.' Actually there are several work units in pro...
0 385
04/26/2017 11:08 AM
5 Replies and 991 Views Primary Table for S_PFQU  991  5 Started by  Lynne I've read a past blog where Kelly explains the relationship between tag tables and the primary table.  We are implementing v10 and I am working on the conversion of req approval to IPA.  With it being on landmark now, I can make the actions of 'reject' and 'unrelease' pop up a box for entry of a required 'Action Reason'.  My problem is that I cannot figure out how to retrieve the reason after it has been taken.  I found tag table S_PFQU where the reason they entered resides.&...
5 991
by  LynneJump to last post
04/25/2017 2:31 PM
0 Replies and 410 Views How do I use return codes from ftp node?  410  0 Started by  Gene B. I have a series of ftp nodes in an IPA flow. On the error tab the below variables exist.   Error code: Information code: Return message: I would like to use these to test for successful transfers but do not see them in an assignment node Ctrl-Space list of variables. I tried removing the but still cannot assign them. Is there a way to use these error codes in subsequent nodes    
0 410
04/19/2017 12:40 PM
6 Replies and 1037 Views File Channel - User/PrivateKey  1037  6 Started by  Karen Sheridan We are on an older version of Landmark/Rich Client.  Rich Client - Version: 2013-10-31 I am trying to set-up a file channel on a remote server using User/Private Key authentication.  I have a ticket open with Infor on how to use this option and they did provide a word document with set-up information.  However, it is confusing and doesn't appear to work with the version we are on.  And, I have asked several times for clarification and received no reply/help. On ...
6 1037
by  Karen SheridanJump to last post
04/18/2017 10:57 AM
0 Replies and 370 Views Null Pointer java exception  370  0 Started by  TimC Here's the Error: 'Error executing iteration loop java.lang.NullPointerException'   The oddity is, I'm fetching unprocessed WorkAssignmentExport rows. For each WA row, I'm doing a lookup to the EE row to fetch EE header data. There are 3 WAExport rows.   the LandmarkTransaction reads the EMPLOYEE value into a variable then passes that into the GetEmployee LT. On the first iteration, the row is executed. On the second iteration, I'm getting the above record. Could it have someth...
0 370
04/12/2017 11:22 AM
9 Replies and 1186 Views Call javascript function call in Assign node  1186  9 Started by  TimC 1. I initialize a variable in start node:      calcDates (string) = '' 2. Then init the variable in an assign node (script):             calcDates=function(freq){                    doDateLogicHere freq            }     3. need to call the function from ...
9 1186
by  TimCJump to last post
04/12/2017 11:18 AM
5 Replies and 965 Views Format of link to inbasket, in email, to all task users (v10 IPA)  965  5 Started by  Lynne Hi- I am trying to send an email to all users of a specific task, Buyer, with a link that they can click on to get to their inbasket.   I was able to do this in v9 without having to include their user profile.  The link would take them to their Buyer inbasket.  In v10 inbasket, I cannot figure out how to get the link to take them to their buyer inbasket.   Here is what I have.  The hard coded user profile is in red.  This link works but I cannot hard co...
5 965
by  steve fingerJump to last post
04/11/2017 3:33 PM
14 Replies and 2790 Views Processflow Trigger  2790  14 Started by  brainet I have found in the process flow documentation that you can trigger a process or service with an HTTP call. I am using IPA on a landmark server. The documentation gives this as an example . I have tried all kinds of combination but keep getting a error saying it can not find the object.. 404 error. Has anyone had success setoff a trigger with a HTTP call Thanks for any help.  
14 2790
by  charliewilliamJump to last post
04/11/2017 2:58 PM
37 2387
by  TimCJump to last post
04/06/2017 8:01 AM
0 Replies and 429 Views jscript function return object or JSON object  429  0 Started by  TimC Use Case:     Have central flow that returns a structure of 2 dates: paymentDate and payThroughDate;      I tried two techniques that I debugged in VisualStudio and they work there. So, pasted them in to an Assign script var.   Abridged Version subFlow: function calcDates(frequency) {      logicToCalcDates;      var pDates      pDates = {'paymentDate':paymentDate,'payThroughDate':p...
0 429
03/27/2017 11:55 AM
19 Replies and 4416 Views Webrun to submit job not working  4416  19 Started by  Terry P I have a simple flow to submit a job PO120. We are running on a Windows server. I have tried  using both my userid with and without the domain - both give the same result. Listed below is the Post String and the log that indicates it ran successfully - but it doesn't. Any clues on what is going on I never see the job in the job log in Portal even. FUNC=run&USER=4JLSFDEV\pickering&JOB=PO120&OUT=text&WAIT=true Started on server: Apr 24, 2013 3:22:05 PM PDT Process ...
19 4416
by  TimCJump to last post
03/24/2017 3:04 PM
7 Replies and 1381 Views httpclient.LHCInvalidSessionException: Invalid session  1381  7 Started by  TimC MISSION CRITICAL!! We have an InvoiceApproval flow with a Lawson S query that was running successfully. Now, without any changes to the environment, it's now failing with the following error: S3 query Invalid session   HELP! Infor is taking their sweet time.  
7 1381
by  TimCJump to last post
03/24/2017 3:02 PM
13 Replies and 2248 Views user Action, stuck  2248  13 Started by  Joan Herzfeldt I have a requisition in my inbasket,  I approve the req and it disappears from the inbasket, but doesn't continue through the flow.  If I go to my Actions or my requests the item is not there either.  This is the first time testing in the Lawsn 10 IPA 10 .  Everything was working in EPI v10.
13 2248
by  Ragu RaghavanJump to last post
03/21/2017 5:44 PM
13 Replies and 6997 Views Direct Link to a Lawson form in Mingle  6997  13 Started by  Jason Beard Does anyone know if it is possible to create a URL that links directly to a form in Portal without bypassing Mingle ie, I know that I can call https://server/lawson/portal_TKN=GL10.1 but this bypasses Mingle altogether. Further... I know that I can get to the 'home' page for S3 under Mingle by calling   is there anything I can add to that to get to a particular form  
13 6997
by  Tedd NugentJump to last post
03/15/2017 11:41 AM
5 Replies and 754 Views Services triggered - before and After values  754  5 Started by  JasonP In landmark, I have a service that is hooked to a form. When the form get a change event, it fires off my service and creates a work unit.  The work unit has all the variables readily available except whats being changed anotherwards the previous value.  Is there a way to access this information also not from a custom form
5 754
by  WoozyJump to last post
03/09/2017 8:18 AM
15 Replies and 1973 Views Full Audit Log  1973  15 Started by  Richard Lyons For my current client, I have been requested to extract employee termination history to show why the employee was terminated.  I can easily do this in S3, but I am not sure where to look in the Landmark database.  Can anyone point me in the right direction  In S3, the reason code I need was stored in the PERSACTHST table.  I am hoping there is an easy way to extract the data I need out of the Audit Log.
15 1973
by  Richard LyonsJump to last post
03/06/2017 9:28 PM
4 Replies and 724 Views Compare files using IPA  724  4 Started by  Nabil Hello   Is there any way to compare two dumps of the HRSUPER table I'm creating a flow that modifies the Manager access and need to compare today's output to yesterdays for any changes.    Thank you, Nabil
4 724
by  SWilkinsJump to last post
03/03/2017 1:53 PM
0 Replies and 619 Views IPA - Include Job Requisition Attachments to Email  619  0 Started by  Randall Hi everyone, I'm attempting to take the attachment that is attached to a Job Requisition in LTM and include it on an email related to the approval process in IPA.  The attachments don't seem to be stored on the Landmark server, so I'm assuming they're being stored as blobs in the database (not sure 100 on this).  I'm able to query the JobRequisitionDocument business class and retrieve the attributes related to the attachment, but nothing specific to location and content. Has anyone ...
0 619
03/01/2017 12:30 PM
10 Replies and 1378 Views Invoice Approval  1378  10 Started by  Srini Rao Hello - We are trying to implement the Invoice Approval process using the IPA. We have Req approval and it works great. Invoice approval is little different, i'm trying to understand the process. Any one can suggest me any KB article or provide me some insights for Invoice approvals.     
10 1378
by  Srini RaoJump to last post
03/01/2017 11:30 AM
0 Replies and 275 Views Web Service Authentication Options  275  0 Started by  Kyle Jorgensen What are the authentication options for external systems to use when calling a service into Lawson Specifically, we want external systems to call a service in Landmark to be able to start a flow in one of two ways: 1.) Use the delivered /bpm/trigger service or 2.) Use configuration console to create our own service to start flows Either way, both methods will require authentication. Is /sso/SSOServlet the only option for authentication into Lawson If so where can I find more deta...
0 275
03/01/2017 8:35 AM
7 Replies and 3159 Views No Procedure defined for service 4GL Error  3159  7 Started by  Robert My 4GL successfully calls PERFORM 1000-CHK-WF-STATUS. If I have the documentation right, I am supposed to invoke 1000-WF-SERVICE, passing WFAPI-I-SEVICE and at least WFAPI-I-CRITERION-1. Working through debug/batchanim I arrive at the following code block: 'WORKFLOWSERVICEINQUIRE' USING WFAPI-I-PRODUCT-LINE WFAPI-I-SERVICE WFAPI-I-CRIT-1-15 WFAPI-I-CRIT-2-15 WFAPI-I-CRIT-3-15 WFAPI-I-OBJECT-NAME WFAPI-O-PROCEDURE WFAPI-O-ROLE WFAPI-O-AGENT WFAPI-O-LOG-METRICS WFAPI-O-RET-MSG ...
7 3159
by  Vikram NarasimhareddyJump to last post
02/28/2017 4:30 PM
2 Replies and 515 Views XML Node issue with flow dispatcherPO  515  2 Started by  JimY I am running the flow dispatcherPO that has an xml node that converts the xml output from PO120 so that it can be transmitted to the vendor.  The xml node works fine on our test system, but in production I am getting the error - A DOCTYPE is not allowed in content.  I did some testing by creating a simple flow that parses the xml file and ran it on production and test and as expected it does not work in production, but does test.  In test we are on Landmark version and i...
2 515
by  JimYJump to last post
02/24/2017 11:07 AM
11 Replies and 4738 Views Mobile Inbasket  4738  11 Started by  Susan I understand that Lawson 9.x apps can now use mobile inbasket via handhelds (i.e. BlackBerry, iPhone) for the self service applications. Has anyone had any luck with this I'm finding zero information on about this. Thanks.
11 4738
by  Errol MisquitaJump to last post
02/20/2017 3:57 PM
9 Replies and 877 Views Work Unit Variable(s)  877  9 Started by  PD I am trying to make sense out of a user defined Flow (FTP node using File Channel) which is using Work Unit Variables and I can't find where the variables are defined or coming from. I do see where the variable values are coming from which is from Channels Administrator->File Channels tab but not the six variables. Where should I look   Flow:    
9 877
by  FireGeek21Jump to last post
02/14/2017 4:06 PM
5 Replies and 578 Views UserAction email to group mailbox  578  5 Started by  Rick McCahan I'm working on a new flow for the benefits department.  They've requested that instead of sending UserAction notification emails to the individual actors, one email should be sent to their shared department mailbox.  This will allow them to share the workload by working from a single queue. It's not clear to me if this is possible nor how to set it up. Thoughts Thanks!
5 578
by  David WilliamsJump to last post
02/13/2017 12:15 PM
0 Replies and 331 Views Workunit Maintenance  331  0 Started by  Jessica M I'm not sure if this is quite the right place for this questions, but here goes.  I have a few questions about how you handle maintenance/clean up of your workunits  Do you keep a certain number of days  Do you use a process flow to delete workunits Do you delete activities and variables separate from workunits Do you use a process flow to delete the related action requests Every time we go to do a big upgrade we run into issues with the size o...
0 331
02/03/2017 1:12 PM
10 Replies and 1383 Views How to setup process to run when a PO line is released?  1383  10 Started by  PD In need of help setting up this part of the process:             1. The process will run when a PO Line is released  when approved requisitions are converted to released PO   it looks like I need to create some type of trigger or service definition in the Rich Client. Please be as specific as possible....Thanks
10 1383
by  PDJump to last post
02/02/2017 7:42 AM
14 Replies and 3875 Views Webrun error  3875  14 Started by  JimY I am testing the Webrun node and it works, but I receive the error below.  It looks as if it is a time out problem so  I did some checking on the Infor Support site and found the parameter SSOTimeout which can be added to the file.  I set it to 10 minutes, but that did not resolve the problem.  I ran the command below in the browser also.  We are on Landmark &91;code&93;
14 3875
by  alexrsJump to last post
01/27/2017 3:07 PM
8 Replies and 1045 Views Timeout for Webrun  1045  8 Started by  Matt Gordon I am trying to get processes organized and repeatable using IPA. One problem I am running into is when we have a batch job running via Webrun (i.e. PR530, LP570, etc.) the job may run longer than IPA waits for a result. I have found posts mentioning a timeout parameter in settings but nothing that explicitly states what needs to be changed. I have contacted AMS, because we are hosted, to have it changed but they do not understand what I am talking about. Can anyone tell me exactly what needs to ...
8 1045
by  Matt GordonJump to last post
01/27/2017 2:08 PM
1 Replies and 414 Views Resource Query  414  1 Started by  PD I am passing an email address to a RMQRY to get to the Actor ID. If I hardcode the email address in an Assign node and pass it on, the RMQRY returns the Actor ID as expected. But if I remove the hardcoded email address and run it as regular, the RMQRY_EMAIL has an undefined value as the Actor_ID. What am I missing   see Query string below: x1854danhosp.priv' method='getRMQuery'>)&93;&93;>
1 414
by  PDJump to last post
01/27/2017 9:04 AM
2 Replies and 453 Views Resource Query (RMQRY) Error message  453  2 Started by  PD I get this error msg when I click on Build...need to get an idea what it means so I can go about solving it.  
2 453
by  PDJump to last post
01/26/2017 2:31 PM
3 Replies and 646 Views General Question about process  646  3 Started by  Bill Alt General question regarding what others do when a user changes job duties or assignments as it relates to what their access is within Lawson. For example, say a person changes the req location that they are responsible for. Usually you might go into IPA and change the filter plus RQ04 and if they are at all doing grants as part of that GM03. I know it can be done various ways, just looking at what others may be doing. Thanks ahead of any answers.
3 646
by  kflores01Jump to last post
01/25/2017 8:51 AM
5 Replies and 1377 Views Effective date change during User Action  1377  5 Started by  Jessica M We have email notifications set up on all our hr type actions in LTM (TransferHr, HireApproval, etc).  Our HRAdmin often makes a change to the effective date within the UserAction.  Does anyone know where I would pull that new effective date from  I do not see it in the PFIACTIVITYVARIABLE business class.
5 1377
by  WoozyJump to last post
01/24/2017 3:04 PM
1 Replies and 532 Views Resource Query Environment Info / Default Printer  532  1 Started by  mikefortuna I'm trying to get user environment information, specifically their default printers, from the resource query. It doesn't appear to be in there. Is there another way to get this  Ideally I'd like to be able to update the printers as well.
1 532
by  John HenleyJump to last post
01/20/2017 10:44 AM
8 Replies and 1216 Views Get EE Supervisor's EEID in straight SQL  1216  8 Started by  TimC Hello all, I'm building an integration and connecting to the Landmark database directly. What is the table relationships/keys I need to fetch the EE's, supervisor EEID   Thanks, TIm
8 1216
by  TimCJump to last post
01/20/2017 8:54 AM
1 Replies and 414 Views Add Action  414  1 Started by  PD Process is to first retrieve info from the PO line and compare quantity input by the Receiver against the quantity from the PO Line. I must first solve ' Process will execute when the Receiver executes the line add action.' and I am not sure how to do that.....any ideas. Thanks
1 414
by  LauaLuauJump to last post
01/11/2017 4:28 PM
5 Replies and 879 Views Pass Parameter to IPA flow in URL  879  5 Started by  Gene B. I have an IPA flow that funs a particular IA120 job then ftp's the files to our Essbase server. I am trying to pass a parameter in the URL in order to set up multiple URL's with different parameters to submit different IA120 jobs. The issue is that while the variable does seem to be recognized in Designer its use returns an Error Evaluating Expression error.   The URL is: Is this the correct format to pass a parameter The variable w...
5 879
by  Gene B.Jump to last post
01/09/2017 12:04 PM
5 Replies and 1023 Views Communication Trace Null  1023  5 Started by  TimC Hello, I'm constantly getting this error and I can no longer debug into a flow.  Any thoughts   Tim
5 1023
by  TimCJump to last post
12/30/2016 7:07 AM
2 Replies and 793 Views Non-PO workflow  793  2 Started by  CMNew We are looking to implement a non-PO invoice workflow. We are using Process Automation on Lawson Ver 10. We are struggling with how to implement this. We have a custom approval table by Company/AU for requsition approvals and it works pretty well. We would like to use this for non-PO invoice approval also. The core problem is that AP cannot release an invoice for approval without knowing what AUs to charge it and route it for approval.  Currently paper invoices gets distributed e...
2 793
by  David WilliamsJump to last post
12/19/2016 9:49 AM
1 Replies and 659 Views Newbee to IPA  659  1 Started by  PD While looking at an example process flow written by Infor, I stumble on this expression below and I am unable to make sense out it. Can someone please explain it to me; more specifically ( *:: ) ParseInvoice_output.*:ataArea..*::Invoice.*::InvoiceHeader.*:ocumentID.*::ID   Thanks
1 659
by  John HenleyJump to last post
12/13/2016 8:20 AM
2 Replies and 751 Views Does not exist exception - LMRK Transaction Node  751  2 Started by  FireGeek21 Attempting to build a new LMRK Transaction node so I can get all the location information to return for a .csv file.  I plan on saving the data off to a variable and then to the .csv file. I have a LMRK Transaction node to query the HRLocation business class.  Here is the node...  The only criteria is as shown. Landmark:LMRK_Facility Executing transaction_dataArea=dev & _module='hr' & _objectName='HRLocation' & _actionName='Find' & _actionOperator='NONE' & _a...
2 751
by  FireGeek21Jump to last post
12/06/2016 8:54 AM
2 Replies and 954 Views IPA node assignment and null values  954  2 Started by  DavidV Just curious what the best practice is with node assignment and dealing with null or undefined values.  We have a capital req approval flow that is based upon the reqline_PO_CODE  -- We assign reqline_PO_CODE to a variable called PO_CODE and then in a branch node check the value for that variable.  In the assignment node we had: Variable name: PO_CODE Variable type: String Variable value: reqline_PO_CODE  This would work fine when the requisition had a PO_CODE but w...
2 954
by  jamesracesonJump to last post
12/01/2016 7:07 AM
0 Replies and 527 Views Best practice for removing processed files  527  0 Started by  Todd Mitchell I use File Channels to pick up and process data files on non-IPA locations.  Once the file is processed it is placed in a 'processed' folder on the IPA server.  Is there a best practice, another process flow or a cron job, for archiving/deleting these files that are X days old    
0 527
11/29/2016 10:47 AM
9 Replies and 2155 Views Cancelling work units?  2155  9 Started by  ThomasT How can I remove workunits from appearing in user inbaskets I've got some workunits I'd like to cancel and remove from user inbaskets. I set the status to those workunits as 8-Cancelled completed. I stopped and restarted bpm, rmi and em, and refreshed IOS Cache. But the workunits are still appearing in the user inbaskets.
9 2155
by  kflores01Jump to last post
11/22/2016 1:29 PM
0 Replies and 567 Views Trigger a custom flow using GHR Standard Action Tag  567  0 Started by  xxxxxttysfh Trigger a custom flow using GHR Standard Action Tag.   can any one give the steps , please
0 567
11/22/2016 12:52 PM
6 Replies and 587 Views IPA and GL20 Automate Posting account  587  6 Started by  Randy Can I use IPA to automate adding an account in GL20 I have COMPANY,ACCT_UNIT,ACCOUNT & SUB_ACCOUNT coming from budget System. I use IPA to load (FB165), but sometimes the accounts are not turned on for a given Company/Acct Unit. I could do a test to see what accounts are not in the GLMASTER, but how can I add them, as the GL20 does    
6 587
by  RandyJump to last post
11/21/2016 10:30 AM
2 Replies and 599 Views How to reset For Each loop  599  2 Started by  JasonP Im using a For Each loop to loop through an array which contains a list of strings that looks like this COMPANYNO|DATE.  When my outer SQL1 company equals Company from Data Iterator (which is being used to split the string), I want to exit the For Each loop.  When I exit the For Each Loop, it never really ends or resets.     On the second iteration of SQL1, we go back into the For Each loop and I want to start back over at the beginning of the array with...
2 599
by  JasonPJump to last post
11/18/2016 9:23 AM
0 Replies and 419 Views How to reset For Each loop  419  0 Started by  JasonP Im using a For Each loop to loop through an array which contains a list of strings such as COMPANYNO|DATE.  When my SQL1 company equals Company from Data Iterator which is being used to split the string, my for each never really ends.  When the second record from SQL1 hits, we go back into the For Each loop but the iteration doesn't reset.  So in the first pass, we find a match on iteration 3, we exit the for each and data iterator. on SQL1 second record, the for each starts where...
0 419
11/17/2016 7:36 AM
0 Replies and 568 Views AP30.5 Remit To Code update  568  0 Started by  Steph76 I need to use process designer to loop through a list of invoices and update the Remit To Code. Do I need to add a Lawson Transaction for AP30.5 first or can I skip it and and have one for AP30.1 with an event of Change All of the fields seem to be there for AP30.1, even the REMIT-TO-CODE.  When I run it the message returned is 'Change Complete - Continue' and the process ran successfully, yet my data has not been updated.   Below is my Transaction string: _PDL=LSAPPS&_TKN=AP30...
0 568
11/16/2016 9:03 AM
0 Replies and 484 Views DispatcherPO and Amazon  484  0 Started by  JimY Has anybody used dispatcherPO to transmit cXml files to Amazon for Purchase Orders  I am getting the error that there is no active configuration for the uri.  I have set up the config file with the information that was sent, but I am not having any luck.  Thank you. 
0 484
11/15/2016 9:36 AM
3 Replies and 794 Views IPA - Upload Process Automation  794  3 Started by  Maestro We are trying to automate our promotion process. IPA is causing us a roadblock b/c of the need to upload the process in designer. We were wondering if anyone knew of a way to automate this OR of a webservice we could possibly leverage. Thanks.  
3 794
by  MaestroJump to last post
11/15/2016 7:44 AM
10 Replies and 2411 Views Transaction Node Error: AGS error: Must inquire on code before adding  2411  10 Started by  Chris12 I am trying ot add a record to PA52.4 and I am receiving the above error. I have been struggling with this so I was hoping maybe some one encountered the same issue and can share the resolution with me.  Belos is my ags call .... Any help is appreciated. _PDL=TEST6&_TKN=PA52.4&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=A&PCT-COMPANY=9009&PCT-APPLICANT=&PCT-EFFECT-DATE=&PCT-ACTION-CODE=XNE-HIREAP&IMMEDIATE-ACTION=Y&PCT-NEW-VALUE-1r0=&PC...
10 2411
by  RickyYJump to last post
11/11/2016 10:46 AM
2 Replies and 666 Views Process types?  666  2 Started by  Thibaud Lopez Schneider Hello,   In Infor Process Automation (IPA) > Process Definitions, what is the difference between the types: User, System, and Application   Thank you.   Thibaud Lopez Schneider
2 666
by  Thibaud Lopez SchneiderJump to last post
11/10/2016 3:18 PM
1 Replies and 634 Views IPA - Inbasket  634  1 Started by  sreeP I am trying to create a new IPA flow with User Action node. I want to display a Design studio Form Under Display for Desktop sub type.  When i provided the URL (Same as what we use to create a link in LBI Dashboard), in the Inbasket display Only portal home page is loading - the form is not getting loaded. Is there any specific way to provide the URL in User Action Node
1 634
by  kimJump to last post
11/10/2016 12:45 PM
3 Replies and 681 Views Include Image in Email Body  681  3 Started by  charliewilliam Using Infor Process Designer and LTM.  Need to include an image in the email body.  Where do we store the image (don't say server - looking for a location.  We are using Windows/SQL Server). Also, what is the directory structure that should be used under 'Attachments'  Not sure if , , , etc should be used and the \ / confuse me!   Help!  Thanks!
3 681
by  JimYJump to last post
11/09/2016 5:24 AM
1 Replies and 604 Views UserAction attachment?  604  1 Started by  Thibaud Lopez Schneider How can we add an attachment to the email notification of a UserAction activity node The UserAction has the ability to take actions via email (e.g. approve/reject buttons), but does not have the ability to add attachments. Whereas the email activity node does have the ability to add attachments, but does not for taking actions via email (unless we create the buttons ourselves and deal with authentication). Here are two screenshots:
1 604
by  Thibaud Lopez SchneiderJump to last post
11/08/2016 12:45 AM
2 Replies and 556 Views generate a dynamic report based on certain variables in infor lawson IP Designer  556  2 Started by  HDAustin13 Greeting Everyone! Can any one please advise on how to generate a dynamic report based on certain variables e.g from date 1 to date2 with a specific region like north, south, etc. in IPA Designer flow.   Thanks in advance, HD
2 556
by  HDAustin13Jump to last post
11/01/2016 11:36 AM
10 Replies and 2891 Views Attaching Employee Pictures using Process Automation  2891  10 Started by  DanB We currently have employee pictures in jpg format stored in a file system directory that are created by our employee badge system.  I am attempting to attach these picture to the employees in Talent Management using the Landmark node in Process Automation.  Here is the Landmark transaction string I am using. _dataArea='ltmtest' & _module='hr' & _objectName='Employee' & _actionName='Update' & _actionOperator='NONE' & _actionType='CreateUpdateDelete' & _pageSize=...
10 2891
by  ChrisJump to last post
10/28/2016 3:33 PM
1 Replies and 496 Views Move all files using SysCommand Node  496  1 Started by  FireGeek21 Is there a way to use the SysCommand node to move all files in a folder to another location  Key here is all the file names will not be known.
1 496
by  JimYJump to last post
10/26/2016 11:29 AM
10 Replies and 2314 Views Hide Inbasket Menu Links  2314  10 Started by  Kyle Jorgensen How do I hide links on the horizontal menu in the inbasket of IPA  See below screenshots and text for details. Before: Landing page links to “My Proxies” and “Options” are visible.   After: I created a new Landing page and hid those two links.   Menu links: However, the horizontal menu that is persistent throughout the inbasket still shows links to these pages.  How are those hidden
10 2314
by  jamesracesonJump to last post
10/25/2016 2:28 PM
3 Replies and 725 Views Schedule FileChannel On/Off  725  3 Started by  Kyle Jorgensen Can I Schedule a FileChannel in IPA to be deactivated/activated on a particular schedule Our LSF and Landmark servers are on different machines.  We'd like to schedule our FileChannel that scans for trigger files on the LSF server to be deactivated on the same schedule as when LSF is down for back-ups (at a certain time each evening). If a trigger file from a system other than Lawson shows up (accounting interfaces) when LSF is down, IPA still starts a flow and then immediately bomb...
3 725
by  Kyle JorgensenJump to last post
10/21/2016 1:47 PM
1 Replies and 613 Views UA-Node Variables  613  1 Started by  Srini Rao Hello - We added the logic(html box ) in UA node to capture the message and we like to use this message out side the UA node.  Seems to be we can't access the UA variables out side UA . So what will be the best way to capture a message/information in UA and use it out side UA.     
1 613
by  steve fingerJump to last post
10/17/2016 1:18 PM
2 Replies and 620 Views REQLINE Detail in Email Notification  620  2 Started by  JonA I'm currently testing IPA and I've set up the html code in the email notification to display some REQHEADER information: Requester Name, User ID, Req Location, Total Req Value. I'd like to display REQLINE information so that the approver will have the information they need to take action within the email. Similar to what we see in the portal inbasket (recsum.htm).  But I can only get the first line of the req to display.  How do I get all lines to display in the email ...
2 620
by  JonAJump to last post
10/12/2016 1:55 PM
4 Replies and 928 Views IPDesigner Error. Can't log in.  928  4 Started by  JonA I'm getting this error when I try to log into IPDesigner. An error has occurred. See the log file C:\IPDesigner\IPDProd\workspace\.metadata\.log.   It was working fine until last Thursday.  I noticed that when I was modifying a flow there were some errors but they weren't listed in the window.  So I thought maybe a restart of the application would fix that.  But after the restart I got this error when I tried to log in.  I've attached the log file but I don't thi...
4 928
by  JonAJump to last post
10/10/2016 11:44 AM
2 Replies and 727 Views Trigger a Flow  727  2 Started by  adnan512 Hello everyone, I want to trigger a flow when someone populates 'is a manager' flag in LTM. I want this flow to kick off and assign the 'DirectSuperviros_ST' role in security. it's already being done as part of new hire security provision but I need to do it when someone is promoted to a supervisor position. Please let me know your suggestions. Thanks
2 727
by  adnan512Jump to last post
10/07/2016 12:40 PM
0 Replies and 540 Views OBJECT-NAME  540  0 Started by  Ragu Raghavan On PF, when creating a work-unit, I could specify an Object_name (usually an index, PCTSET1 etc.). This object was defined in the Administrator (menu,do). I assume on IPA, this is the 'Apps Key' Where/how do I set this up Thanks.   Ragu
0 540
10/06/2016 11:37 AM
8 Replies and 772 Views Edit list in Excel option  772  8 Started by  Greg Moeller Our 'Edit List in Excel' option remains dithered. Yet, I've followed everything that the install docs and even a call with Infor have suggested. Is there a setting that I'm missing somewhere See attached.
8 772
by  Greg MoellerJump to last post
10/05/2016 11:33 AM
5 Replies and 5051 Views Process Flow Integrator  5051  5 Started by  prakash Hi, Can any one help me with the Process Flow Integrator for M3. I am new to this. Any tutorials or documents may help me. Thanks in advance.
5 5051
by  cymaanoJump to last post
10/04/2016 5:45 AM
0 Replies and 522 Views IPA and attaching files/data  522  0 Started by  andi Hello, We are V10 implementing IPA.  We have a number of sketched process flows that start with a fillable form.  Along the way in the process flow different associates need to update the form with different information/data.  Does anyone have something in place for a process like this Right now we are thinking the form will have to live on a shared drive and folks will have to access it there in order to update the information as necessary, but was hoping someone might have a ...
0 522
10/03/2016 2:35 PM
4 Replies and 743 Views Workflow is not enabled  743  4 Started by  Brett We are in the process of upgrading from on premise 9 to hosted 10 and we just finished refreshing the data. We have 2 workflows that were working prior to the refresh but now they are not. We have checked that Service and Process definitions for both workflows are enabled. The workflow flag in GL10.1 is set to 'Y' for journal entry and the Requisition approval type is set to 'Header using Process Flow' for the req approval flow. Is there any where else I can check to see why ...
4 743
by  David WilliamsJump to last post
09/29/2016 4:30 PM
1 Replies and 1005 Views IPA XML Node  1005  1 Started by  ArthurThum I have an XML file along with and XSD schema and I am trying to get the XML node to work and I have several questions not easily found in the doc. 1. How does the input data get to the XML node Does it need to be within a file or data iteration If so how is this specified 2.I assume for Output parsing that the XML node with give me 1 itterration per record. Is this how it works. 3. Any examples of its use for parsing XML input files would be helpful. Thank you
1 1005
by  Rick McCahanJump to last post
09/29/2016 2:30 PM
2 Replies and 728 Views Reason code via email?  728  2 Started by  Thibaud Lopez Schneider Hi,   Is it possible to enter a reason code and reason comment when taking action via email The UserAction activity node shows the reason code popup in the Inbasket, but not in the email, the click on the button 'Approve' goes straight to 'Your action (Approve) has been processed'.   Thank you.
2 728
by  Thibaud Lopez SchneiderJump to last post
09/28/2016 6:09 PM
20 Replies and 3343 Views Email authentication action Process Automation  3343  20 Started by  CMNew With Process Automation I can set Action items to take place from emails - Approve, Reject etc If the user who receives the approval email forwards that email to another user, the user its forwarded to can also take an action and basically impersonate the original intended approver. Is there any way to prevent this from happening
20 3343
by  Thibaud Lopez SchneiderJump to last post
09/28/2016 5:55 PM
4 Replies and 1232 Views IPA User Actions - Sending emails from Main Config  1232  4 Started by  Preston Burdwell I have been struggling with a problem that exists when I use the IPA User Action to send emails. I can send emails correctly if I use our system configuration name, but then my display exec: recsum.htm displays an error 404 (File not found) in the users Inbasket. If I use the main/default configuration name with User Action Node, the display exec works, but the emails fail with the following error: Notification failed with javax.mail.AuthenticationFailedException: No authentication mechansims ...
4 1232
by  Thibaud Lopez SchneiderJump to last post
09/28/2016 5:51 PM
4 Replies and 547 Views PFI Mapping  547  4 Started by  Srini Rao Hello - we are migrating from PFI to IPA migration.    in V9 PFI, we used lot of map Map(s). Now in V10 we do not have map future, how do we do it   Thanks Srini  
4 547
by  Srini RaoJump to last post
09/27/2016 4:15 PM
12 Replies and 844 Views SysCommand  844  12 Started by  charliewilliam Hi, I am trying to copy a file using the SysCommand node and running into some trouble.  Hoping someone can assist. Here is what I have but I am getting an error:  The system cannot find the file specified.  This is the very path I am using to create the file - works just fine.  At the end of the flow, I want to copy the file to an Archive folder and now it is saying it cannot find the file.  BUT, it is there! SysCommand - Command: Copy \prod\work\Vendor_Files\O...
12 844
by  charliewilliamJump to last post
09/26/2016 2:17 PM
0 Replies and 506 Views SQL Query Date Cast/Convert Oddity  506  0 Started by  Ethan I was cleaning up some of the date output from selects in SQL Query nodes this afternoon, removing the time from datetime fields using CONVERT(DATE,DATEVALUE) and noticed that when I ran the LPA, two days were removed along with the time. I checked a few different date fields and they were two days short of the date value stored in the database. I set up an isolated test, creating a LPA flow with a single SQL Query node with the following select statement: SELECT CONVERT(date,GETDATE()), GETDAT...
0 506
09/22/2016 7:02 PM
2 Replies and 575 Views Send email by Actor ID?  575  2 Started by  Thibaud Lopez Schneider Hi,   I have an email activity node in a process flow, and I need to set the To: field to an Actor ID, not to an email address. I was hoping IPA would resolve the Actor ID to the email address that is stored in the Contact Info of the Actor, but it doesn't, thus the SMTP server throws an error that the recipient doesn't exist. How to do that   Otherwise, I added a Landmark Transaction activity node to Find the Actor by ID, it works, but it only reflects the Actor ID as an output, ...
2 575
by  Thibaud Lopez SchneiderJump to last post
09/19/2016 5:00 PM
17 Replies and 2736 Views Add Actor to Landmark via IPA  2736  17 Started by  Willie I have a flow which adds new users to LSF nightly. We are upgrading to Lawson 10 and would like to add a node to add the users to Landmark. Can anyone offer some guidelines on this node as searches have not been very helpful. The majority of the adds are for EMSS users. Any assistance greatly appreciated.   Thanks
17 2736
by  Thibaud Lopez SchneiderJump to last post
09/16/2016 3:07 PM
6 Replies and 1625 Views Command line to add Users and Tasks in IPA?  1625  6 Started by  Thibaud Lopez Schneider Hello,   How can I programmatically add Users, Tasks, and User-Tasks to a specified data area (e.g. DEV, TST) in Infor Process Automation (IPA) That's PFIUSERPROFILE, PFITASK, and PFIUSERTASK in the IPA database.   I need to synchronize M3 Users (MNS150), M3 Roles (MNS405), M3 User-Roles (MNS410), and M3 Email addresses (CRS111) with their counterparts in IPA. That's for Infor Smart Office users to take action in the Inbasket for approval flows.   With the command
6 1625
by  Thibaud Lopez SchneiderJump to last post
09/12/2016 4:09 PM
27 Replies and 5085 Views SQL versus standard Lawson queries  5085  27 Started by  Terry P A few of us at work today had a 'philosophical discussion' on the merits of the 'best practice' for writing Process Flows (IPA or PFI). One developer is very skilled in SQL, so whether it is writing a Crystal Report or a Process Flow - he uses SQL over other methods. My take (with limited SQL knowledge) is while SQL might be more efficient, the advantage of Process Flow is you can visually figure out what is going on, and is easier to read and understand. Three or four nested queries is better t...
27 5085
by  cymaanoJump to last post
09/08/2016 9:25 AM
17 Replies and 2333 Views Trigger Flow within a FLow/dynamically.  2333  17 Started by  tambrosi Hello all,  hope somebody can point me in the right direction, I need to set up a process flow that can kick off another process flow within it. I tested with the trigger node, and can see the process run,  my problem/question is, under the trigger node in IPA, is there a way to make the triggered process a variable that can be set.   Example:   Main IPA Process will run,                           Based on som...
17 2333
by  tambrosiJump to last post
09/01/2016 6:49 AM
2 Replies and 1104 Views IPA Designer Issues  1104  2 Started by  JonA We're having some issues with the IPA Designer.  First, when I log in I immediately get this error.  The application still runs and I can see/modify the flows. And here's the full details for the error...   Aug 25, 2016 7:40:23 AM EDT      Plug-in Vendor: Infor   Plug-in Name: Infor Process Designer   Plug-in ID: com.lawson.bpm.designer   Product Version: 10.0.3.v201511232056      Exception dete...
2 1104
by  JonAJump to last post
08/25/2016 9:47 AM
6 Replies and 5582 Views Pushing and Pulling Files via FTP  5582  6 Started by  DaveW We have a need to push and pull files via FTP using PFI&160;to and from external client servers.&160; What is the easiest way to do that
6 5582
by  JimYJump to last post
08/23/2016 5:57 AM
10 Replies and 1284 Views UA Node Question  1284  10 Started by  Srini Rao   I created a CER approval process, as part of the set up I created a TASK called ”CerBuyer” and group of buyer assigned to the task.   When new req goes to CerBuyer’s Inbasket flow is sending an email to every buyer defined in task. (I’m using the UA). Instead of every buyer receiving the email, they like me to send it to generic email and buyers will work on the queue.  How do I do it    
10 1284
by  Srini RaoJump to last post
08/17/2016 7:08 PM
29 Replies and 7299 Views Process Flow Approvers on Vacation  7299  29 Started by  Jeremy We have a Process Flow for requisitions approvals that is based on Accounting Units, Dollar Amounts, and Approval levels.  Example:  if it is for a certain dollar amount, it goes to the dept. manager for that accounting unit for approval.  After that, if it over a certain dollar amount, it goes up the chain to the director of that accounting unit. My question is this:  How do other places handle users going on vacation  Currently, if a Vice President, for example...
29 7299
by  Wil PowerJump to last post
08/08/2016 5:34 PM
0 Replies and 504 Views Adding years to date function  504  0 Started by  Roger French Old Processflow in V9,  Date = getDateDME(AddYear(pfDate(Query1_BIRTHDATE,'mm/dd/yyyy'),AgeVar))   Let's say Birthdate = 2/1/1990 and AgeVar=40 Where Date is defined as a String type. Query1_BIRTHDATE is from a DME query. AgeVar is an integer. This returns a correct formatted date: Date =  2/1/2030 .   In IPA in V10, this same flow  returns an incorrect string. It returns Date = 2/2/199040 In other words, it is concactenating the AgeVar to the Birthdate. I'm ...
0 504
08/08/2016 2:54 PM
4 Replies and 1172 Views Req Approval - Multiple users  1172  4 Started by  Lynne We'd like to make our capital req approval process more efficient by sending the approval request to 4 users at one time.  Currently, they are sent sequentially and it doesn't move on to the next approver until the one prior has approved it.  This slows down the process.  To accomplish this, I set the UA options tab to '  of recipients take a specific action' at Approve for 100.  It seems to work in that it doesn't move on until all have approved.  The...
4 1172
by  David WilliamsJump to last post
07/21/2016 9:20 AM
2 Replies and 864 Views Build a tab delimited file  864  2 Started by  charliewilliam   I am trying to use PFI process flow to create a tab delimited file.  Using SQL to pull data.  What do I use for the tab delimiter  Is there something I can use in the SQL node to string together all the data  Tried \t including assigning it to a variable.  Also tried char(9) to string data along as well.     Thoughts     Thanks!
2 864
by  charliewilliamJump to last post
07/20/2016 12:08 PM
1 Replies and 679 Views Is there a limit to resource querry i IPA  679  1 Started by  xxxxxttysfh Limit to Resoiurce querry in IPA   i am not ble to queery all user using Lawson reource query node 
1 679
by  xxxxxttysfhJump to last post
07/20/2016 6:54 AM
0 Replies and 494 Views Can not open SQL node in IPA  494  0 Started by  xxxxxttysfh java.lang.ClassNotFoundException   Jul 19, 2016 6:57:09 PM PDT      Plug-in Vendor: Infor   Plug-in Name: Infor Process Designer   Plug-in ID: com.lawson.bpm.designer   Product Version: 10.0.3.v201409111802      Exception detected in Class: com.lawson.bpm.designer.wizards.SQLQueryBuilderPage      Error message: Unable to load table types. Cannot access data necessary for requested node type.      Exceptio...
0 494
07/19/2016 9:00 PM
2 Replies and 704 Views Add coloumsn in CSV via IPA  704  2 Started by  xxxxxttysfh I would like to create columns using IP, rather than having them in one Coloum   Please advice 
2 704
by  xxxxxttysfhJump to last post
07/19/2016 1:39 PM
1 Replies and 1923 Views BL520 mass import file  1923  1 Started by  Joe Haveman Is anyone familiar with the invoice import process that uses a BL520 import file versus the BL98 import tables We are currently using the import tables with AGS calls. The problem is that we have so many invoices and too little time to run the flow. Apparently, if you put the invoices in a specially formatted file, with a specific name in a specific folder and run the BL520, a bulk load will be performed. If anyone has done this or knows of any documentation, help would be awesome! T...
1 1923
by  LKEN2002Jump to last post
07/18/2016 8:35 AM
2 Replies and 793 Views How to append to file from a Doing resource query  793  2 Started by  xxxxxttysfh Hello I am new to IPA and I am not able to append the files  I have upload the IPDd in xt foramt
2 793
by  xxxxxttysfhJump to last post
07/16/2016 12:18 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 1 of 612345 > >>

RSS Feed Available