Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Supply Chain Management
Lawson S3 Supply Chain
Lawson and EPIC Optestia
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
NonnieBear1776
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5161
People Online:
Visitors:
291
Members:
0
Total:
291
Online Now:
New Topics
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
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson S3 Supply Chain
Lawson and EPIC Optestia
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
brooke
Posts: 21
11/21/2013 5:39 PM
Does anyone have experience with interfacing Supply Chain item data with EPIC's Optime or Optesia? The costs on the IC525 and IC527 don;t seem to work and we need to create something else.
Kat V
Veteran Member
Posts: 1020
11/21/2013 7:25 PM
We have an SQL going through our IT JAMS (no idea what that is - they make things talk to each other!
). We have a query running to calculate actual cost per EA based on the buy cost of PO25.6 and that's what's populating Optime and Epic's EAP looks at it as well. Same process is going to feed Epic's Cupid and Radiant eventually.
Greg Moeller
Veteran Member
Posts: 1498
11/21/2013 7:40 PM
We've noticed the same thing here with our Cerner item master interface. We are using IC527, but I wrote a Perl script to take that file that IC527 produces and manipulate the cost and put it back in the correct location.
Contact me off-line if you'd like more details. I'd be happy to share my Perl script as well, so you'd have a place to look anyway!
Lynne
Veteran Member
Posts: 122
11/22/2013 11:31 AM
We use a customized IC527 for our interface to Optime. It was a little painful at first to get the cost correct, but after many cases with Lawson, it is working correctly. That was not the part we customized. I will look back at my notes and see if I can find the details. It had to do with certain forms having to be populated.
brooke
Posts: 21
11/25/2013 3:15 PM
Thank you Kat ! I wrote a SQL query that captures all the data they would like however they need an incremental running every hour and I am struggling with the numeric "Time" field on ICAUDIT - did you have this issue?
Kat V
Veteran Member
Posts: 1020
11/25/2013 4:26 PM
No - but we're running that interface only once daily. The time field is in a very bizarre format - I would basically make IT do it. But icaudit.R-TIME >= '9000000' get you everything after 9am, >='13000000' gets you every thing after 1pm. It's military hhmm with FOUR zeros trailing.
brooke
Posts: 21
11/25/2013 5:11 PM
Thanks!
brooke
Posts: 21
11/25/2013 5:15 PM
I want to create one script that runs hourly rather than having to schedule different scripts all day, I will keep looking - thanks!
Lloyd Warnes
Basic Member
Posts: 9
12/3/2013 2:58 PM
We use a modified IC527, and have had the same experience as many on this thread - after many CTP's stabilizing the IC527, I modified price to STOCK UOM and also included several user fields for EAPID, HCPCS, etc for driving Optime Patient Charge Markup. This runs 3x daily and has been very stable but is succeptable to CTP/MSP code changes. Currently working incident with GSC regarding defaulting - Lawson MAY have changed the rules for IC52x programs to depart from cost defaulting used in PO20 and RQ10 which I am taking an issue with,
Kat V
Veteran Member
Posts: 1020
12/9/2013 8:32 PM
We had the same issue - apparently a Gold Partner requested it and I protested that the field values are set by international standards - not a user preference - and they were changed back with a ctp. Then we every upgrade we had to change the IC527 - so we went with SQL.
You are not authorized to post a reply.