Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Integration / Customization
S3 Interfaces/Conversion
IC527 Item Interface
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
LynneB
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5123
People Online:
Visitors:
262
Members:
0
Total:
262
Online Now:
New Topics
Lawson S3 Financials
PO Matched Dollars and Matched Quantity
5/10/2024 6:51 PM
Can anyone share the Lawson calculation to determi
S3 Customization/Development
COBOL CSV file
5/10/2024 2:36 PM
We have a custom Cobol program ZU200 that creates
S3 Systems Administration
Using MFA for Lawson S3 Access
5/8/2024 1:23 PM
Does anyone use Multi Factor Authentication when u
Lawson Landmark
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
IPA/ProcessFlow
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1357
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
S3 Interfaces/Conversion
IC527 Item Interface
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Steve Williams
Basic Member
Posts: 7
1/23/2006 9:17 PM
Do any users here use IC527 to generate an item master report, or any of the other IC52X reports?
I'm right now in a slightly heated email exchange with GSC, due to the fact that our IC527 reports have the purchase UOM price inserted into the "Patient Charge" field (CD3, field 25). We don't have or use the PC module at all, and the database element that this information is supposed to come from is empty - actually, the whole table is empty (PCCHRGITEM). None of the KB articles or the IC527 HL7 spec can remotely explain this behavior.
I can't seem to convince the GSC person that this is NOT how the application is supposed to function...and it's worth noting that it's only been doing this for the last 3 months (we were slow to catch it). I've had no recent MSPs or CPTs that have any relevance to that form (altho we've had others), so I'm convinced it's a flaw.
I guess I'm looking to see if anyone else uses this form, or have any experience with any of the HL7 Item Master interface forms...
Greg Moeller
Veteran Member
Posts: 1498
1/25/2006 3:03 PM
We use it here to generate files to interface to our Cerner SurgiNet module. I had to write a custom Perl script to meet our needs, though.
Greg Moeller
Veteran Member
Posts: 1498
1/25/2006 3:33 PM
Actually my documentation has CD3, Seq 25 as HCI-PRICE which equates to HCCHRGITEM table - field PRICE, and our HCCHRGITEM table does have info in it.
Greg Moeller
Veteran Member
Posts: 1498
1/25/2006 4:00 PM
OK, I finally see what you have been saying all along. The file produced by IC527 has purchase price in it, not the Patient price. I've opened a case with Lawson on the same subject. Maybe if enough people are complaining, it will get fixed.
Greg Moeller
Veteran Member
Posts: 1498
1/25/2006 6:13 PM
The version we were running in Prod on 12/1/05 was pulling the correct patient cost, the new version fixing the manufacturer problem (CTP38620) is pulling purchase cost instead.
Greg Moeller
Veteran Member
Posts: 1498
1/27/2006 3:11 PM
Steve and all:
The case I opened up with Lawson, the tech is seeing the same thing as we are, so she wrote up a patch request.
Case will be held with PT # 154789
Greg Moeller
Veteran Member
Posts: 1498
2/21/2006 8:11 PM
CTP to fix released just today... 40987
Greg Moeller
Veteran Member
Posts: 1498
5/1/2006 8:09 PM
Hey, following up on this whole thread... Anyone know of an EASY way to run the IC527 job (by location) and ALSO split the files into 1,000 item max??
say if there are 4,375 items in the file for one location, to create 5 different files?
John Henley
Posts: 3352
5/1/2006 8:54 PM
Thinking off the top of my head, I would suggest writing a pre-processor/wrapper program that splits the HL7 file by location, and then creates separate canonically-named files with < 1000 items in each file (e.g. HL7_LOC1.001, HL7_LOC1.002, etc.). The wrapper program could then create job records and submit the job (for each file) using 900-CREATE-AND-SUBMIT-JOB. Not necessarily "EASY", but is anything??
Steve Williams
Basic Member
Posts: 7
5/22/2006 8:46 PM
Greg,
Thanks for the updates, I guess I hadn't scrolled down far enough to notice that there were replies to this thread.
As you know, GSC did provide a patch to the IC527 process to correct the issue, and to put IC527 "in line" with other IC52X jobs.
This caused another problem for us: in the IC527 documentation (article id: 74456), the CD2, field 16 data is supposed to be pulled from ITL-AVERAGE-COST <- the average cost field from the item location (IC12) record. The data that is retrieved and the routine they use to retrieve this information is documented in KB article 525489, and is as follows:
In the Item location file:
PREFER-BIN, SOH-QTY, LEADTIME-DAYS, CHARGEABLE-FL, TRACKING-FL, LAST-ISSUE-DT, ACTIVE-STATUS, UOM. If the item location is inventory tracked, then if AVERAGE-COST is greater than zeroes, test it. If the item location is not inventory tracked, then if the replenishment location exists and its AVERAGE-COST is greater than zeroes, test it. If still no cost is arrived at, then if a requesting location exists and its AVERAGE-COST is greater than zeroes, test it. If still no cost is arrived at, test the LAST-REC-COST from the original item location.
Well, with CTP # 41209, they changed the routine used to the PO Cost Routine, which populates the field with the default purchase UOM cost instead of the each/unit average cost. Unfortunately, this doesn't work for me, as we use the IC527 to populate our OR clinical system with item cost information. So when we take a look at the cost of a procedure (in the OR system) that uses one pack or piece of suture, I'm now looking at the price of a box of 12 or 36 sutures, etc...
GSC has stated that this is the way it is intended to function (now), so I'm back to getting in touch with my client account manager to escalate the issue, or rewrite the interface from scratch...
Steve Williams
Basic Member
Posts: 7
5/22/2006 8:50 PM
Greg - just out of curiosity, are you wanting to split this file up do your Cerner system can handle the files?
We use GE's ORMIS (formerly iPath), and they've requested the same thing, basically...when I delete the WORK file, I send across ~5000 items, and their interface program chokes on the file and times out.
I'm pressing that issue with GE, calling it sloppy programming...if it can handle 500 items, it should handle 5,000 items too :)
Greg Moeller
Veteran Member
Posts: 1498
5/31/2006 10:01 PM
Steve: Yes, we (apparently) need to split the file up (and convert it to a more IC526 format file) so that our Cerner system can handle it. I agree with you, that the fault is shoddy programming on their part, but I figure it will be much faster for me to write a shell script or perl program to process the file than to wait for Cerner to fix their system. We've been told to split ours at 1,000 items... and that currently is creating about 11 files per week.
I've got a perl program that I run against the output IC527WK file that does almost everything it needs to do.
I'm no perl programmer, but was able to figure out how to write what we needed... with the exception of just ONE thing. I'm attempting to have the whole thing automated by the end of next month!!! Wish me luck!
Greg Moeller
Veteran Member
Posts: 1498
7/21/2006 2:39 PM
Just a follow-up: We have been able to make the interface work now. It was a combination of a perl program and a shell script on the Lawson side of things, but it all seems to be working now.
You are not authorized to post a reply.