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
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
    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
      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
        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.