I'm trying to determine the costs of all supplies used in a surgery. Our surgical system is Cerner Surginet and we're using Lawson S3 Procurement. I imagined I'd be able to match up the manufacturer and manu catalog number in Cerner with the manufacturer and manufacturer's number in the Lawson table itemmast. I can match the manufacturer but the product numbers aren't matching up. Has anyone been able to do this? Thanks in advance.

We set up an item master interface here. We're using a customized IC527 and a couple of scripts to get it to work. We store all of the items in Lawson and feed Surginet with that item master file.

I'd be happy to share my scripts and some explanation if you'd like.

For the most part, we use the Lawson item number as the Surginet item number.  The Surginet item number is not a unique field and can be changed if you were to find matches and want to change to the Lawson item number.  We are exploring a bi-directional interface solution.  Currently developing an inerface to our Interventional Radiology system using ProcessFlow Integrator.