PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/14/2019 7:40 AM by  Kat V
Lawson IC with Cerner Surgi-Net
 27 Replies
Sort:
You are not authorized to post a reply.
Page 2 of 6 << < 12345 > >>
Author Messages
Greg Moeller
Private
Private
Veteran Member
(3970 points)
Veteran Member
Posts:1412


Send Message:

--
09/20/2011 8:59 AM
Jon (others):
Since we maintain all of our items in Lawson, we found the need to update the item master in Surginet, so mostly by trial and error we worked out a modified IC527 job that does what we needed. This is an outbound (to Lawson) interface. We do have an inbound (to Lawson) interface for creating Req's and/or pick tickets based off of the information that is on the surgeon's pref card for cases that are scheduled tomorrow... so that they can be picked today. Really 2 separate interfaces, but accomplish "pretty much" a bi-directional flow.
yvonne
Private
Private
Basic Member
(15 points)
Basic Member
Posts:7


Send Message:

--
12/19/2013 10:03 AM
Greg, great to hear someone has an interface with Surginet.  Our project plan has started to replace ORSOS to Surginet in collaboration with another project to consolidate 3 sterile processing (SPD) areas into 1 location.  Each of these locations have their own cost center for the supporting OR.  So the consilidation of items may need to continue to issue out to varius cost centers.  Our current model in each of the SPD areas is an expense inventory using MSCM to replenish.

You mentioned you had a second inbound interface to Lawson.  Is this area set up as a perpetual inventory or expense invenotry.  I am intersted in learning more about your process.  Do you support more than one cost center using this model?  How are your returns managed? etc.,  How do you manage items such as implants that would not be itemized on a preference card? 

Thanks,

Greg Moeller
Private
Private
Veteran Member
(3970 points)
Veteran Member
Posts:1412


Send Message:

--
12/19/2013 10:35 AM
yvonne: unforunately I don't know much of this process... I'm just the technical guy behind the scenes.
I can tell you that all of our OR's are set up as perpetual inventory.. they replenish from distribution as well as vendors and each other. (setup in IC12)
Our main 2 OR's were separate cost centers when we started, but have since merged into one, with little to no changes to the interface. There is a whole bunch of timing that we needed to get correct, but so far it's worked well. Except when we have holidays.... then it gets a little screwed up, but we manage.
The interface (inbound) uses tables in Cerner/Suginet that aren't populated all the time, to run a Crystal report against and create an RQ500 input file which we happily load into Lawson.
Returns are handled by purchasing tied to the original PO they came in on if possible. Receiving puts return into shipped state once it actually goes out the door.
Implants are put in RQ10 with the SN Lot # etc that go to a bill only PO. This is handled by distribution. Some have item #s some do not.This part is for vendor payment. Above are entered free text or using an item # in Cerner by OR staff. This part is for the patient charging.

I'll attach the scripts and Crystal report file when I can dig it up again...
Greg Moeller
Private
Private
Veteran Member
(3970 points)
Veteran Member
Posts:1412


Send Message:

--
12/19/2013 1:49 PM
Script to run the job to import the file that the Crystal report file produces.
Export the Crystal report with no delimiters.
Attachments
Veleria
Private
New Member
(4 points)
New Member
Posts:2


Send Message:

--
01/03/2014 5:06 PM
We recently instsalled Surginet/Supply Chain into Lawson. Everything is working fine. We did the following:
- A cerner consultant wrote the interface file from Cerner and formatted it into the IC500 layout.
- A daily recurring job runs the IC500 job
- Someone manaully release the records from the IC21
- IC142 and IC141 runs to create the requisitions
- Someone approve the requistions in RQ10

We currently have 3 perpetual inventories. We replaced ORSOS.
You are not authorized to post a reply.
Page 2 of 6 << < 12345 > >>