Search this forum:
Search
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 1112345 > >>
Topics
 Replies
 Views
 Last Post
1 Replies and 32 Views FTP Node – Retrieve latest file from remote source folder    32  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 32
by  Kyle JorgensenJump to last post
02/20/2018 1:25 PM
1 Replies and 637 Views Check If file directory exists, if does not exists create directory    637  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 637
by  brox07Jump to last post
09/11/2017 4:07 PM
2 Replies and 900 Views Convert TXT to PDF    900  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 900
by  PDJump to last post
05/19/2017 12:57 PM
9 Replies and 3122 Views Create export files from SQL code via IPA or crystal and LBI?    3122  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 3122
by  TimCJump to last post
04/12/2017 2:39 PM
9 Replies and 6018 Views javascript functions in processflow    6018  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 6018
by  Joan HerzfeldtJump to last post
08/16/2016 8:04 AM
5 Replies and 1469 Views Use Javascript to format Rate of Pay and FTE values from database table to include decimals    1469  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 1469
by  Dave CurtisJump to last post
07/28/2016 12:48 PM
3 Replies and 2443 Views Email Node - Include a picture in email content    2443  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 2443
by  Corvette JimJump to last post
06/01/2016 1:16 PM
1 Replies and 1047 Views Can Process Flow execute a Crystal Report and Print the report to a specific Network Printer.    1047  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 1047
by  Shane JonesJump to last post
05/10/2016 2:28 PM
2 Replies and 1755 Views Having trouble determining the HR15.1 PageDown AGS Call    1755  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 1755
by  agershJump to last post
02/02/2016 4:04 PM
9 Replies and 3099 Views Parse CSV Comma Delimited File with Quotes and Embedded Comma    3099  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 3099
by  GeoffTSJYJump to last post
08/04/2015 4:23 PM
1 Replies and 3302 Views ActiveX Component can't create object when trying to run wizard    3302  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 3302
by  WoozyJump to last post
07/01/2014 9:15 AM
7 Replies and 2982 Views LPA- Default work title for UA    2982  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 2982
by  John HenleyJump to last post
02/14/2013 3:41 PM
23 Replies and 17821 Views Installing and Configuring MSSQL JDBC for ProcessFlow Integrator    17821  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 17821
by  masonpJump to last post
03/13/2012 11:07 AM
9 Replies and 9373 Views Someone - please share your PFlow Trigger form....    9373  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 9373
by  JeffRJump to last post
06/01/2010 12:13 PM
87 Replies and 43858 Views Migrating 8.0 Flows to 9.0    43858  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 43858
by  Shane JonesJump to last post
09/01/2009 1:58 PM
1 Replies and 221 Views Employee's last Lawson sign in  221  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 221
by  edisonJump to last post
02/15/2018 11:11 AM
1 Replies and 91 Views French characters not loading correctly with Ags call  91  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: https://lawsonsitapp10.gfs.com with string _PDL=S100&_TKN=PA31.1&_EVT=ADD&_RTN=DATA&_LFN=ALL&am...
1 91
by  Kwane McNealJump to last post
02/15/2018 7:52 AM
20 Replies and 2989 Views Sending Results of Query to a csv file  2989  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 2989
by  Orlando GrayJump to last post
02/13/2018 5:37 PM
1 Replies and 124 Views ipa sending duplicate email notifications  124  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 124
by  kflores01Jump to last post
02/12/2018 8:12 AM
4 Replies and 768 Views Custom Java Trigger API for IPA  768  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 768
by  Kyle JorgensenJump to last post
02/08/2018 1:35 PM
2 Replies and 137 Views getRMQuery  137  2 Started by  Ludy Does anyone know what file is being accessed by the method getRMQuery   Thanks, Ludy
2 137
by  LudyJump to last post
02/08/2018 8:18 AM
7 Replies and 333 Views scheduling flows  333  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 333
by  RandyJump to last post
02/05/2018 2:18 PM
3 Replies and 340 Views Check For File modified date  340  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 340
by  John HenleyJump to last post
01/23/2018 9:44 AM
0 Replies and 93 Views ActorID and AgentID  93  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 93
01/09/2018 2:35 PM
2 Replies and 422 Views Security violation  422  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 422
by  PDJump to last post
01/02/2018 8:00 AM
2 Replies and 391 Views Trigger WFWK.1 in a non-Design Studio form  391  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 391
by  Roger FrenchJump to last post
12/22/2017 7:16 AM
2 Replies and 329 Views Where do SQL Procs go???  329  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 329
by  dcasper70Jump to last post
12/21/2017 9:38 AM
3 Replies and 306 Views Create a field of spaces  306  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 306
by  FireGeek21Jump to last post
12/12/2017 11:15 AM
2 Replies and 215 Views Encryption Node  215  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 215
by  Jessica MJump to last post
12/12/2017 10:57 AM
4 Replies and 399 Views Add Approval History to Email Notification  399  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 399
by  Kat VJump to last post
12/05/2017 1:39 PM
1 Replies and 297 Views How to bypass AGS error prompt?  297  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 297
by  John HenleyJump to last post
12/01/2017 4:34 PM
4 Replies and 374 Views Webrun /lawsion-ios/action/AddAttachment  374  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 374
by  Lance JurgensenJump to last post
12/01/2017 8:26 AM
0 Replies and 100 Views ListAttachments, ReadAttachment  100  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 100
11/29/2017 9:14 AM
1 Replies and 325 Views Dynamically change SQL Proc in IPD?  325  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 325
by  dcasper70Jump to last post
11/28/2017 4:26 PM
2 Replies and 479 Views SQL Count not showing as variable  479  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 479
by  NabilJump to last post
11/16/2017 4:52 PM
2 Replies and 484 Views AddAttachment via process flow  484  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 484
by  NabilJump to last post
11/13/2017 11:37 AM
6 Replies and 368 Views How do I update information on page 3 of HR15.1  368  6 Started by  Todd Mitchell How do update an item on 'page 3', page down twice, of HR15.1. 
6 368
by  Bob CanhamJump to last post
11/10/2017 9:20 AM
15 Replies and 1003 Views processflow trigger  1003  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/menu.do.) 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 1003
by  edisonJump to last post
11/09/2017 1:10 PM
0 Replies and 115 Views Trigger flow on data change  115  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 115
11/07/2017 11:52 AM
0 Replies and 104 Views S3 Adapter  104  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 104
11/07/2017 9:31 AM
3 Replies and 481 Views PATCH web API triggered from IPA flow  481  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 481
by  David WilliamsJump to last post
11/04/2017 8:47 AM
1 Replies and 402 Views Managing Flows --Release VS Restart  402  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 402
by  Tim CochraneJump to last post
11/03/2017 12:37 PM
1 Replies and 396 Views po30 - PO Overshipment not trigger  396  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 396
by  Kat VJump to last post
10/30/2017 2:44 PM
3 Replies and 627 Views SysCommand Node - Landmark Command  627  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 627
by  JimYJump to last post
10/30/2017 7:01 AM
1 Replies and 348 Views IPA Enhancements  348  1 Started by  SurvivorAC Our version of Landmark is 10.0.  We will be engaging ICS to update our environment.  The suggested version of Landmark is 10.1.1.42.  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 348
by  David WilliamsJump to last post
10/25/2017 8:06 AM
0 Replies and 145 Views XML Output of Lawson Transaction Activity  145  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 McSharrytmcsharrgreenville.k12.sc.usGCS       0000000000001153Add Complete -...
0 145
10/24/2017 9:04 AM
4 Replies and 396 Views Landmark: Provisioning - Account Disabled Flag  396  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 396
by  Bob WCHNJump to last post
10/19/2017 10:40 AM
12 Replies and 730 Views Creating excel xlsx file instead of csv  730  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 730
by  jamesracesonJump to last post
10/10/2017 7:34 AM
2 Replies and 392 Views sending email-smtp settings  392  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 392
by  edisonJump to last post
10/04/2017 3:23 PM
4 Replies and 419 Views Workload Manager Tools  419  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 419
by  Kyle JorgensenJump to last post
10/03/2017 8:04 AM
1 Replies and 679 Views IPA Inbasket user guide  679  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 679
by  heartlandJump to last post
09/22/2017 10:40 AM
5 Replies and 663 Views PA Reviews notification via email from IPA  663  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 663
by  JuliaJump to last post
09/21/2017 2:52 PM
4 Replies and 563 Views Process flow performance issues in Cloud - possible grid issues???  563  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 563
by  Jessica MJump to last post
09/20/2017 1:40 PM
4 Replies and 1668 Views Intercept Action in custom inbasket  1668  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 1668
by  Ragu RaghavanJump to last post
09/13/2017 9:02 PM
8 Replies and 876 Views IPA Scheduler Not Working  876  8 Started by  Roger French This is a new instance. Win/SQL. LSF 10.0.9, Landmark 10.1.1.51. 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 876
by  Roger FrenchJump to last post
09/11/2017 4:26 PM
0 Replies and 205 Views Negative or zero dollar payment  205  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 205
09/11/2017 2:28 PM
0 Replies and 175 Views Sys Cmds Returning Unreadable Log  175  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 175
09/07/2017 1:28 PM
16 Replies and 2142 Views Create PO via PO23.1 in PF  2142  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 2142
by  PFlowNerdJump to last post
09/07/2017 11:28 AM
2 Replies and 477 Views File move/copy from within IPA (Processflow)  477  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 10.1.1.48 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 477
by  AriJump to last post
08/31/2017 5:36 PM
3 Replies and 798 Views WFWK call to LMRK Service failing  798  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 798
by  jdeverJump to last post
08/28/2017 10:47 AM
2 Replies and 588 Views How to Disable Landmark User ?  588  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 588
by  Bob WCHNJump to last post
08/15/2017 9:33 AM
0 Replies and 183 Views POST DATE ISSUE for AR130  183  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 183
08/01/2017 4:25 AM
0 Replies and 183 Views WFEVTSERV ?  183  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 183
07/26/2017 9:32 AM
0 Replies and 233 Views PFI to IPA - WFMETRICS and WFUSERCAT tables  233  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 233
07/18/2017 10:37 PM
2 Replies and 395 Views PFI table/column listing  395  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 395
by  timbomomJump to last post
07/18/2017 4:00 PM
10 Replies and 785 Views IPD Designer - Custom Function  785  10 Started by  Roger French IPD Designer version 10.1.1.49 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 785
by  John HenleyJump to last post
07/18/2017 9:38 AM
8 Replies and 765 Views IPA-Adding OS (Environment) Identity  765  8 Started by  Roger French So, attempting to add the OS Identity using the Resource Update node. This is Landmark on Windows 10.1.1.51 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 765
by  JimYJump to last post
07/12/2017 10:55 AM
4 Replies and 604 Views Trigger Process Flow  604  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 604
by  John HenleyJump to last post
07/12/2017 8:45 AM
1 Replies and 784 Views Trigger Node in IPA  784  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 com.law...
1 784
by  NHBBJump to last post
06/27/2017 10:49 AM
2 Replies and 544 Views IPA - Req Approval Flow w/ Logic on who to notify  544  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 544
by  RemiJump to last post
06/20/2017 10:27 AM
2 Replies and 764 Views PFI to IPA Landmark transaction  764  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 764
by  John HenleyJump to last post
06/13/2017 2:28 PM
3 Replies and 624 Views Check If file directory exists, if does not exists create directory  624  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 624
by  Kyle JorgensenJump to last post
06/13/2017 9:03 AM
2 Replies and 516 Views Using SysCommand instead of .bat file  516  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 516
by  FireGeek21Jump to last post
06/06/2017 8:59 AM
2 Replies and 428 Views IPA File Channels  428  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 428
by  John HenleyJump to last post
06/05/2017 5:59 PM
15 Replies and 2214 Views How to use IPA to importdb  2214  15 Started by  JasonP Any ideas on how to run importdb via IPA
15 2214
by  mthedfordJump to last post
06/05/2017 5:20 PM
0 Replies and 255 Views File Locking - Incrementing a value  255  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 255
06/05/2017 1:24 PM
7 Replies and 1163 Views Positive Pay (PR170) flow  1163  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 1163
by  Joan HerzfeldtJump to last post
06/02/2017 2:00 PM
3 Replies and 446 Views Launch flow from URL  446  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 446
by  TimCJump to last post
05/22/2017 11:55 AM
11 Replies and 1085 Views Help with SQL code for IPA flow  1085  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 1085
by  Bob CanhamJump to last post
05/12/2017 3:12 PM
1 Replies and 626 Views IPA S3 Commands  626  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 626
by  Srini RaoJump to last post
05/05/2017 6:38 AM
0 Replies and 194 Views Help with Landmark JMSChannel  194  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 194
05/03/2017 9:55 AM
1 Replies and 446 Views Wrong array length  446  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 446
by  PDJump to last post
05/01/2017 3:22 PM
8 Replies and 888 Views Data Files with LineFeeds and Carriage Returns Importdb  888  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 888
by  JasonPJump to last post
04/27/2017 2:33 PM
0 Replies and 270 Views Mobile Inbasket  270  0 Started by  Roger French Has anyone got the Mobile Inbasket to actually work completely I've got MIB 9.1.1.55 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 270
04/26/2017 11:08 AM
5 Replies and 675 Views Primary Table for S_PFQU  675  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 675
by  LynneJump to last post
04/25/2017 2:31 PM
0 Replies and 265 Views How do I use return codes from ftp node?  265  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 265
04/19/2017 12:40 PM
6 Replies and 709 Views File Channel - User/PrivateKey  709  6 Started by  Karen Sheridan We are on an older version of Landmark/Rich Client.  Rich Client - Version: 10.0.4.9.11 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 709
by  Karen SheridanJump to last post
04/18/2017 10:57 AM
0 Replies and 236 Views Null Pointer java exception  236  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 236
04/12/2017 11:22 AM
9 Replies and 946 Views Call javascript function call in Assign node  946  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 946
by  TimCJump to last post
04/12/2017 11:18 AM
5 Replies and 688 Views Format of link to inbasket, in email, to all task users (v10 IPA)  688  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 688
by  steve fingerJump to last post
04/11/2017 3:33 PM
14 Replies and 2276 Views Processflow Trigger  2276  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 .  http://ipa.example.com:8080/bpm/tri...ger20Test 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 2276
by  charliewilliamJump to last post
04/11/2017 2:58 PM
37 Replies and 1849 Views Multi-step Job Execution in IPD  1849  37 Started by  TimC How do I execute a multi-step job in IPD  the _JOB-TYPE defaults to MULTISTEP. Here's my S3 query: _PDL=TEST&_TKN=AP150&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&ADDENDA-OPTION=N&CURRENCY-OPT=I&DISC-OPTION=N&JOB-DESCRIPTION=&JOB-NAME=&PAY-GROUP=&PAY-INV-IMMED=N&PAY-THRU-DATE=&PAYMENT-CODE=CHK&PAYMENT-DATE=&PRINT-VOUCHER=N&RECONCILE-ADV-EXP=N&REPORT-SEQ=N&SEL-CASH-CODE=&_STEPNBR=1&SPEC-HANDLING=N&am...
37 1849
by  TimCJump to last post
04/06/2017 8:01 AM
0 Replies and 294 Views jscript function return object or JSON object  294  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 294
03/27/2017 11:55 AM
19 Replies and 3962 Views Webrun to submit job not working  3962  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 3962
by  TimCJump to last post
03/24/2017 3:04 PM
7 Replies and 1044 Views httpclient.LHCInvalidSessionException: Invalid session  1044  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 com.lawson.security.authen.httpclient.LHCInvalidSessionException: Invalid session   HELP! Infor is taking their sweet time.  
7 1044
by  TimCJump to last post
03/24/2017 3:02 PM
13 Replies and 1772 Views user Action, stuck  1772  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 1772
by  Ragu RaghavanJump to last post
03/21/2017 5:44 PM
13 Replies and 6045 Views Direct Link to a Lawson form in Mingle  6045  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 http://mingle.server.com/SitePages/...awson-s3.1   is there anything I can add to that to get to a particular form  
13 6045
by  Tedd NugentJump to last post
03/15/2017 11:41 AM
5 Replies and 621 Views Services triggered - before and After values  621  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 621
by  WoozyJump to last post
03/09/2017 8:18 AM
15 Replies and 1414 Views Full Audit Log  1414  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 1414
by  Richard LyonsJump to last post
03/06/2017 9:28 PM
4 Replies and 608 Views Compare files using IPA  608  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 608
by  SWilkinsJump to last post
03/03/2017 1:53 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 1112345 > >>


RSS Feed Available