• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

IC44.1 - Associated Report?

 3 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
RobCarignan
Basic Member Send Private Message
Posts: 16
Basic Member
2/23/2015 6:04 PM

I'm searching for a report that shows the "Current Days Stock On Hand" as displayed in IC44.1. I'm also looking for this field in Lawson Add-ins: Query so I can build a custom report if needed.

 

Does anyone know if a report exists with this information?

 

Thanks,

Rob Carignan

Mercy Hospital

Portland, Maine

JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
2/24/2015 2:15 PM
I don't know of any report equivalent to IC44 and I believe a lot of the fields are calculated unfortunately. If you have Crystal it wouldn't be difficult to create a report with those calculations.
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
Stephanie
Veteran Member Send Private Message
Posts: 86
Veteran Member
2/24/2015 6:45 PM
This is a calculation and not a field.

Current Average Daily Usage: *Outflows this period + *Outflows last period / Number of days this period + Number of Days last period
* = IssuesQty + SalesQty + TransfersOutQty, which are viewable on IC49.1 (Usage History)

Current Days On Hand: Item Location Quantity Available/ Current Average Daily Usage

We replicated and modified this calculation using Crystal reports. I would be happy to share, just send me an email stephanie.kowal@bhs.org.
Stephanie Kowal | skowal@rpic.com
RobCarignan
Basic Member Send Private Message
Posts: 16
Basic Member
2/26/2015 4:05 PM
Thank for the calculation. I'll have to take a look and see. I don't trust my IC49 data.