We have a need to push and pull files via FTP using PFI to and from external client servers.  What is the easiest way to do that

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...

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, goes on vacation, I hav...

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.

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 some criteria,  I will need to run, IPA Process A or IPA Process B,  I would like to pas...

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...

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

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 problem is that I would like to write a...

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

Hi, I have a PF, which uses a web run node with url type as External and the method is 'POST'.  While executing the flow, i am getting the below error. Appreciate any thoughts on this.   WebRun WebRun8620: Failed with error java.net.SocketException: java.lang.ClassNotFoundException: Cannot find the specified class com.ibm.websphere.ssl.protocol.SSLSocketFactory at javax.net.ssl.DefaultSSLSocketFactory.a(SSLSocketFactory.java:2) at javax.net.ssl.DefaultSSLSocketFactory.createSocket(SSLSock...

Hello I am new to IPA and I am not able to append the files  I have upload the IPDd in xt foramt

I would like to create columns using IP, rather than having them in one Coloum   Please advice

Limit to Resoiurce querry in IPA   i am not ble to queery all user using Lawson reource query node

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.      Exception detail:            java.lang.ClassNotFoundException:                at java...

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!

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.   Any suggestions

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 fairly certain this has b...

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

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... java.io.FileNotFoundException   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 detected in Class: com.lawson.bpm.designer.util.LoginConnection ...

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 secadm.bat I can create ...

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 ...

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, and I don'...

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...

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\OutFile.csv \prod\work\Vendor_F...

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