Prev
Next
Forums Financial Management Infor CloudSuite Financials

V11 IC527

 3 Replies
 1 Subscribed to this topic
 7 Subscribed to this forum
Sort:
Author
Messages
Jimmie
Basic Member
Posts: 22
Basic Member
3/5/2021 9: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
    Veteran Member
    Posts: 1020
    Veteran Member
    3/8/2021 10: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
      Basic Member
      Posts: 22
      Basic Member
      3/11/2021 3:05 PM
        Hi Kat, thanks for the reply.

        Are you doing this through and IPA or something? Is there anything you can share?
        Kat V
        Veteran Member
        Posts: 1020
        Veteran Member
        3/11/2021 4:25 PM
          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.