PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/11/2021 11:25 AM by  Kat V
V11 IC527
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Jimmie
application engineer
Private
Basic Member
(40 points)
Basic Member
Posts:20


Send Message:

--
03/05/2021 4:34 PM
    We are in the process of moving from v10 to Cloudsuite V11. One of our issues is that the IC527 DeRoyal no longer utilizes the WK file and you cannot send 'changes'. It appears that this file can only send out a full file each time.

    Does anyone have an alternate method they'd be willing to share with us on how they are sending daily additions and changes from their Item Master (following the IC527 rules and layout) to external applications like SSC, PYXIS or other hospital inventory/cost systems?
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2824 points)
    Veteran Member
    Posts:966


    Send Message:

    --
    03/08/2021 5:04 PM
    We went to sql for Epic Optime - but Cloverleaf has had success just sending changes from that - so it's got some "store last image" capability.
    Jimmie
    application engineer
    Private
    Basic Member
    (40 points)
    Basic Member
    Posts:20


    Send Message:

    --
    03/11/2021 10:05 AM
    Hi Kat, thanks for the reply.

    Are you doing this through and IPA or something? Is there anything you can share?
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2824 points)
    Veteran Member
    Posts:966


    Send Message:

    --
    03/11/2021 11:25 AM
    Sorry - I'm SCM so this all happens on the IT side of the fence. I helped with the original sql to tell them where the information lived in Lawson.

    To get things to Epic (Optime, Radiant and Cupid - SUP and BAL records) our current process is:

    Our BI Team run a sql pulling in data from IC11, IC12, PO25.6 etc - they're also going to start pulling in GTIN info from a separate file from NIH)
    This SSIS package gets moved to Cloverleaf.
    Cloverleaf does the heavy lifting of converting the Lawson Value to Epic Value for both SUP and BAL. (Example Lawson gives 0,1,2,3 in Latex - Cloverleaf converts to Y/N for Epic)
    Cloverleaf then passes off to Epic
    Epic processes the file.

    We're currently sending a "full file" every night. Once the GTINs are sorted, BI and Cloverleaf are working on retaining an image and only sending changes as the file size has grown quite a bit and Epic is having some timing issues processing it.
    You are not authorized to post a reply.