PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/10/2020 9:34 AM by  LauraPat
Custom IC145 - Pandemic Reporting
 8 Replies
Sort:
You are not authorized to post a reply.
Author Messages
LauraPat
Sr. Application Engineer
Private
Advanced Member
(82 points)
Advanced Member
Posts:40


Send Message:

--
03/09/2020 10:27 AM

    Good Morning - wondering if anyone has already done this before I "reinvent the wheel".  I've been asked to add Current Average Daily Usage and Current Day's Supply On Hand to the existing Lawson-delivered IC145 report in order to do Pandemic reporting.  These fields are visible in IC44 form but according to Infor Support they are not included in any delivered report.  Because of the emergency need for Pandemic reporting - looking up every time individually, in IC44, is just not feasible or sustainable at this point.  I'm going to start working on adding these additional values to the IC145 report - but Lawson isn't extremely clear on how these calculations are done.  I have some rough calculations that I'm going to have to play around with.  I was really hoping someone had already done something similar in a batch report that they would be willing to share.  Thanks so much in advance.

    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2621 points)
    Veteran Member
    Posts:895


    Send Message:

    --
    03/09/2020 11:05 AM

    We've got our pandemic flagged with an item attribute - so the IC145 can run by item attribute list - but no, I don't particularly know where the IC44 info comes from.

    LauraPat
    Sr. Application Engineer
    Private
    Advanced Member
    (82 points)
    Advanced Member
    Posts:40


    Send Message:

    --
    03/09/2020 11:11 AM

    Hi Kat - we do that as well.  However, IC145 doesn't contain the values of Current Average Daily Usage and Current Day's Supply on Hand.  Inventory Control has informed us that these 2 values are also critical to them for pandemic reporting and Infor has confirmed that none of their reports contain these values - the only place these values are visible is in the IC44 form.  It just isn't a viable option for the users to have to look up one item at a time considering the criticality of the situation.  I was just hoping someone else had already customized a report to contain these values (I figured it couldn't hurt to ask!)

    Thanks, Laura

    Ragu Raghavan
    Private
    Private
    Veteran Member
    (1065 points)
    Veteran Member
    Posts:371


    Send Message:

    --
    03/09/2020 11:22 AM
    If it is difficult to figure out the logic from IC44, maybe just INVOKE IC44 from IC145, with FC=I, so the screen values will be available to you?
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2621 points)
    Veteran Member
    Posts:895


    Send Message:

    --
    03/09/2020 11:25 AM
    Infor couldn't share the source or the formula? The itemloc table has SOH, Avg_SOH_Qty and Turn Rate. That should get you somewhere - yes?
    LauraPat
    Sr. Application Engineer
    Private
    Advanced Member
    (82 points)
    Advanced Member
    Posts:40


    Send Message:

    --
    03/09/2020 11:33 AM

    Hi - Infor "kind of" shared the formula.  For a while they were reluctant to do that believe it or not.  But it still isn't exact and would take a little hoop-jumping to make sure I had it correct.

     

    However - Ragu - THANK YOU!!!  I can't believe I didn't think of that.  I've used Invoke MANY times - but always for sending data from a file to update data within a Lawson form.  It didn't even enter my mind to do an invoke using the inquire function and just grab the data.  THAT IS A FANTASTIC IDEA!!  I'm sorry for the CAPS - but I can't believe how much time you saved me!  I'm just praying IC45 will let me set it for invoke.  I think I've only had one instance in the past where a program was not invokable - but I don't see why this one wouldn't be.

    This is why I LOVE these forums!!!

    LauraPat
    Sr. Application Engineer
    Private
    Advanced Member
    (82 points)
    Advanced Member
    Posts:40


    Send Message:

    --
    03/10/2020 8:53 AM
    I need some more help please... I'm trying to do the invoke of IC44 within my new custom BI145 (clone of IC145) program. I am only passing the company, location and item to IC44, along with the Function Code of "I" (Inquire) but I am getting back an error of "Cannot Insert On Blank Key". I have no idea what this means. I didn't think IC44 was doing any kind of updates? I am just trying to do an inquire and then grab the Current Days Stock and Hand and Current Average Daily Usage and move those values to my new report. What am I missing? Are there other fields I should be populating before I do my invoke? I really appreciate any help - thanks in advance!
    Ragu Raghavan
    Private
    Private
    Veteran Member
    (1065 points)
    Veteran Member
    Posts:371


    Send Message:

    --
    03/10/2020 9:23 AM
    Not sure what that means. Just to rule out other possibilities -
    1. did you initialize IC44F1 before the call?
    2. did you set CRT-ERROR-NBR to 0 before the call?
    LauraPat
    Sr. Application Engineer
    Private
    Advanced Member
    (82 points)
    Advanced Member
    Posts:40


    Send Message:

    --
    03/10/2020 9:34 AM

    Thanks once more Ragu.  I wasn't looking at the simplest thing - the error message threw me for a loop.  I added the initialize of the form (which I KNOW I needed to do but totally forgot to put it in there) and I am getting back all the right values now.

    Thanks once again for your help - I really appreciate it.

    You are not authorized to post a reply.