PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/31/2017 2:49 PM by  MattB
Import New and Changes to Existing POs
 13 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Kat V
Sr Supply Chain System Analyst
South Broward Hospital District
Veteran Member
(1831 points)
Veteran Member
Posts:625


Send Message:

--
01/27/2017 10:54 AM

    We're working on an interface with Construction and a program called e-builder.  It's basically taking the requisition process for new construction projects and handling approval routing.

    So when it sends to Lawson, the thought is that it will send a PO520 and create POs.

    The wrinkle is change order - is anyone accepting automated changes to existing POs?  Will PO520 do that?  We're looking at PO520 but are open to any suggestions

    alexrs
    Lawson Developer
    Private
    Basic Member
    (43 points)
    Basic Member
    Posts:15


    Send Message:

    --
    01/27/2017 4:10 PM

    Since you are receiving requisitions. Isn't it better to use RQ100?

    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    01/30/2017 10:08 AM
    No, we aren't getting reqs. e-builder is doing all of that side. We'd only need a PO Number at that point.

    If we had to, we'd bring it in as an RQ500 and run PO100s to add new. But we also want to make changes to existing POs.
    MattB
    Manager Financial Applications
    MetroHealth
    Basic Member
    (25 points)
    Basic Member
    Posts:9


    Send Message:

    --
    01/30/2017 1:07 PM
    Depending on what you change I believe you can bring in changes to POs from eBuilder.
    Mess around with PO53 and PO53.2 with PO520 to see what values you can change.
    You will need to pass back the PO number to eBuilder so if changes are made there they come in with the PO number and line to change. For the record type on the Header and Line you can interface with Change.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    01/30/2017 2:32 PM
    Thanks - we are working to feed the PO Numbers back to them, so it *sounds* plausible. Now to prove it's doable!
    MattB
    Manager Financial Applications
    MetroHealth
    Basic Member
    (25 points)
    Basic Member
    Posts:9


    Send Message:

    --
    01/30/2017 3:16 PM
    Keep me posted. We're going to integrate eBuilder with Lawson also. eBuilder does a nice job of sourcing for construction.

    We are looking at feeding activity information for capital projects but really want the requisition/PO in Lawson for cash management.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    01/30/2017 3:49 PM
    I'm at kvila@mhs.net or scmsystemdept2@mhs.net if you want to email me, I'll share the project as we go.

    As it stands:
    Currently all activities and vendors are being fed from Lawson into ebuilder. ebuilder is handling all the heavy lifting from project evaluation and bidding to the cads and approval routing for budget. So it's the complete requisition and approval.

    We require our vendors to have a PO and they want it for the full contracted amount. So the future state idea is that we create an export from ebuilder to Lawson - treat it as an approved req and create a PO from it. As the activity, budget and vendor information came from Lawson, we aren't anticipating too many issues. They should be able to give us all the values and Cloverleaf should be able to get it into PO520 format.

    PO53s seem to only be the errors. So we're going to try it but there's a knowledge base article listing a couple of "gotchas" - we may end up building an IPA with an upload.
    MattB
    Manager Financial Applications
    MetroHealth
    Basic Member
    (25 points)
    Basic Member
    Posts:9


    Send Message:

    --
    01/30/2017 4:00 PM
    PO53 can be used to input data and then run PO520 with DB input option. It will pick up what is on PO53.
    It should have all the same input fields as the PO520 in a form entry format.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    02/02/2017 7:22 AM
    That just helped sort this out in my head - thank you!

    So the file we bring in and place on the server is populating PO53 like PO23 gets populated with approved req lines. PO520 is a job that's running against that table like PO100. We can either import a file to populate PO53 OR input directly on it -- either way, PO520 will convert to PO as new or change and leave behind what it couldn't?
    MattB
    Manager Financial Applications
    MetroHealth
    Basic Member
    (25 points)
    Basic Member
    Posts:9


    Send Message:

    --
    02/02/2017 9:23 AM
    You got it. I'd recommend creating an extract from eBuilder and loading into POCHEADER, POCLINE and POCMMDIST which are the tables PO53 uses. If you back fill the PO number on Requisitions in eBuilder you should be able to determine if it's a Add or a Change before sending to Lawson. There are some key fields that you can't change...so you have to treat as an additional line.

    If you use the csv file option on PO520 I'm not sure the intermediate tables above (PO23) is used. Never tried it.
    Jeremy
    Private
    Private
    Veteran Member
    (204 points)
    Veteran Member
    Posts:82


    Send Message:

    --
    10/30/2017 3:26 PM
    Hello Kat and everyone else,
    We are starting a mini-project to bring in PO's from e-builder, too! I just started testing the PO520 for this process. I've used PO520 before to convert PO's from older system when implementing Lawson, but never for an on-going project like this. I'm running into a problem with PO number. Do you have to put in a PO Number in your file or can Lawson auto-assign it when running the PO520 so it just creates a PO Number in line with the normal PO Numbering scheme?
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    10/31/2017 2:13 PM
    This is where we are currently stalled at as well. In PO520 is "Rec Type" segment
    Rec Type Numeric 2 "Record type / action taken
    1 = Adding a Purchase Order Header Record (PURCHORDER)
    2 = Adding a Purchase Order Line Record (POLINE)
    3 = Changing a PO Header Record (PURCHORDER)
    4 = Changing a Purchase Order Line Record (POLINE)
    5 = Adding a PO Header Comment/Attachment (CMTPCR)
    6 = Adding a PO Line Comment/Attachment (CMTPLI)
    7 = Process a PO Header Cancel command (PURCHORDER)
    8 = Process a PO Line Cancel command (POLINE)
    9 = Process a PO AOC Spread Add command (POAOCSPRD)
    10 = Process a PO AOC Misc/Line Add command (POAOCDTL)
    11 = Process a PO AOC Comment add (POAOCDTL)
    12 = Process a PO AOC Change command (POAOCDTL)
    13 = Process a PO AOC Cancel command (POAOCDTL)
    14 = Process a PO MMDIST Add command (MMDIST)
    15 = Process a AM Defaults Add command (AMPODFLTS)
    16 = Process a AM Defaults Change command (AMPODFLTS)"


    In theory, if the segment is 1 - it should send an ADD command to PurchOrder and generate a PO Number. 3 - would be change existing.

    The project stalled due to vacations and FMLAs, but ebuilder did not seem to think they could populate this?
    Jeremy
    Private
    Private
    Veteran Member
    (204 points)
    Veteran Member
    Posts:82


    Send Message:

    --
    10/31/2017 2:22 PM
    Ouch, that's not reassuring. We are looking at probably doing a custom program to load to PO20, instead, because of the limitations of PO520 and auto-numbering.
    MattB
    Manager Financial Applications
    MetroHealth
    Basic Member
    (25 points)
    Basic Member
    Posts:9


    Send Message:

    --
    10/31/2017 2:49 PM

    As long as PO01 has numeric POs are auto numbering it should be able to add POs using option 1.  Make sure you have a number defined on PO01. 

    If I remember correctly the problem was you had to add the header before the lines (as in run a file with all the headers and a separate file with lines - don't remember).   Play with PO53.1 and PO53.2 to get the process down and then you can replicate using PO520.

    If you go the PO20 route I would still recommend using PO53 for a little more control.

    You are not authorized to post a reply.