PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 06/02/2017 2:00 PM by  Joan Herzfeldt
Positive Pay (PR170) flow
 7 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Joan Herzfeldt
System Analyst
Genesis Health System
Veteran Member
(137 points)
Veteran Member
Posts:51


Send Message:

--
05/04/2017 11:47 AM

    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 exist?  The user will run the PR170 and create the csv file containing the data I need for the flow.

    We will also be creating a positive pay file from CB170 or AP265, haven't decided which process to use.

    The outbound file to our bank is a fixed width file with header, detail and trailer records.  I'm assuming a message builder that reads the header record first all the details and then the trailer record.  (Creating a header/trailer file is much easier in IPA then it ever was when I wrote interfaces ;-)  but I'm open to suggestions.

    Any tips on fixed width fields?  Assuming I need to define each field.

    Thanks for any insight you share.

    JimY
    Private
    Private
    Veteran Member
    (1099 points)
    Veteran Member
    Posts:393


    Send Message:

    --
    05/05/2017 5:18 AM
    Using a File Channel to detect when the file is placed in the folder is one way. The trick is that you only want it to process the file when the program has completed creating it not when it is still writing to it. One of the ways that I resolved this was to modify the program such as PR170 to create an empty file at the end of its processing. The File Channel would detect that file and then the flow would kick off and process the Positive Pay file. As far as fixed length records you will have to use Javascript to format each field to the length that you need. Good luck.
    pbelsky
    Sr Analyst Project Manager
    Weyerhaeuser
    Veteran Member
    (215 points)
    Veteran Member
    Posts:75


    Send Message:

    --
    06/01/2017 9:10 AM
    Hey Joan, how are you doing with triggering your flow? We use a couple of methods here to trigger a flow that do not involve customizing the Lawson source code. Let us know if we can help in any way.
    Joan Herzfeldt
    System Analyst
    Genesis Health System
    Veteran Member
    (137 points)
    Veteran Member
    Posts:51


    Send Message:

    --
    06/01/2017 9:36 AM

    A File Channel is what I thought would be best.  I haven't gotten far enough to worry about the timing.  I know it will be an issue but figured I could put a wait node in the flow or something along those lines.  My problem with the File Channel is that I need to pick up ANY file in a specific directory and IPA doesn't like wildcards very much.  We've used them in other File Channels but the beginning of the filename is always the same.  In my case it will not be the same name.  Even if we made a naming convention part of the process/procedure our users wouldn't always do it.

    Another idea was to create a trigger when the PR170 was processed.  We've created custom forms in Lawson, so I have someone who knows Design Studio(?)  But of course the documentation to create a trigger doesn't exist, it just says that you can.  I've played with it, but I'm not the System Admin so some of the information I'm not sure about and/or I keep finding more layers to the Service and don't know what really needs to be completed and what doesn't.

    Does anyone know if there is documentation to create a trigger/service def, etc.  or do you have the steps or list of items that need to be created or modified?  My system admins will help me set it up if I knew exactly what needed to be set up.

    John Henley
    Private
    Private
    Senior Member
    (9587 points)
    Senior Member
    Posts:3213


    Send Message:

    --
    06/01/2017 10:53 AM
    While using the file channel approach would not require any customization to PR170, it is tricky since it looks for the *existence* of the file, and might trigger the flow before the file is complete. If you know roughly how long the job runs, you could work around that by putting in a wait in the flow, and then move the file to an archive location.

    Using Design Studio wouldn't work since it's a batch job, and the only trigger you could potentially capture would be the submit of the job, not the completion.
    Thanks for using the LawsonGuru.com forums!
    John
    Joan Herzfeldt
    System Analyst
    Genesis Health System
    Veteran Member
    (137 points)
    Veteran Member
    Posts:51


    Send Message:

    --
    06/02/2017 10:05 AM

    My Solution: I did get the File Channel/Receiver to work.  My process flow starts with a File Access Node to our LSF (Lawson) server, which is different than our IPA/Landmark server.

    1.      The system configuration for LSF/file access is set up as a remote with the http:\\win1461.ghxyz.com

    a.      The file access node is using this config.

    2.      The File Channel is set up as Local with the directory path \\win1461\directory1\dir2\... (even though the Landmark server is on \\win1462)

    3.      The Receiver is set up with File Name is * (because I want all files in the directory) and the Data field dropdown is File Name.

    4.      In the process flow the File Access Node is using variables that are created in the work order.

    a.      ProcessedFileDirectory and FileName

    b.      The variables do not show up in the Ctrl-Space list. You have to type them in the way they look in the Work Order Variable tab.


    c.     

     

    d.      Note that the File Access Node is using the Processed directory and Not the Monitor directory, because as soon as the File Channel sees a file to process in the Monitor directory it is moved to the In progress directory.

    5.      The process flow needs to determine file type before it starts the data iteration, which is why I am keeping the file access node, and having the File Name sent via the Channel/work order instead of the File Data, etc…

    6.      Note: There are some instructions on setting up a File Channel in the “Infor Process Automation Administration Guide”

     

    A couple of concerns/questions.  #2 above, what issue can this cause (or what should I look for)? Since the LSF server is not the same as the Landmark server, hence it’s not really Local.  Also, I wanted the In Progress directory to be on the Landmark server instead of the LSF server, but I couldn’t get the directory to work.  I think I read this could improve processing time and avoid losing the file due to connection issues.

    I can’t test the timing of the File being created and the File Channel trying to move it, until next week, so there might be some issues with The file channel, which looks every 10 minutes trying to move the file to In Progress directory prior to the file being finished writing.

    Attachments
    PBL
    Private
    Private
    Basic Member
    (16 points)
    Basic Member
    Posts:6


    Send Message:

    --
    06/02/2017 11:28 AM
    Creating/automating Positive Pay was recently discussed in the Infor Communities as well (https://community.inforxtreme.com/i...itive-pay)
    Joan Herzfeldt
    System Analyst
    Genesis Health System
    Veteran Member
    (137 points)
    Veteran Member
    Posts:51


    Send Message:

    --
    06/02/2017 2:00 PM

    yep... Thanks.

    You are not authorized to post a reply.