Prev
Next
Forums Integration / Customization S3 Customization/Development

Custom IC145 - Pandemic Reporting

 8 Replies
 2 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
LauraPat
Veteran Member
Posts: 50
Veteran Member
3/9/2020 2:27 PM

    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
    Veteran Member
    Posts: 1020
    Veteran Member
    3/9/2020 3:05 PM

      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
      Veteran Member
      Posts: 50
      Veteran Member
      3/9/2020 3:11 PM

        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
        Veteran Member
        Posts: 476
        Veteran Member
        3/9/2020 3:22 PM
          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
          Veteran Member
          Posts: 1020
          Veteran Member
          3/9/2020 3:25 PM
            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
            Veteran Member
            Posts: 50
            Veteran Member
            3/9/2020 3:33 PM

              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
              Veteran Member
              Posts: 50
              Veteran Member
              3/10/2020 12:53 PM
                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
                Veteran Member
                Posts: 476
                Veteran Member
                3/10/2020 1:23 PM
                  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
                  Veteran Member
                  Posts: 50
                  Veteran Member
                  3/10/2020 1:34 PM

                    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.