Custom Reporting for New System Analyst

Good Day Everyone,

I am a relatively new System Analyst (new to Supply Chain especially) in an organization that utilizes Lawson SCM, and I am looking for some opportunities to improve our existing processes:

1. We currently do not have any reporting when it comes to recommending par levels throughout our hospital, and I have not been able to find any forms within Lawson that perform this function. I am familiar with and have access to Crystal Reports; I am lacking the knowledge of which tables to pull from and what sort of formulas can be used to determine a safe 3-day par level. Any insight you could provide would be awesome!

2. Is there a field or flag somewhere in the IC setup that allows us to identify an item as a "Critical" or "Non-Critical" status? We have some important items that, due to backorders/missed counts, have not been replenished in our warehouse. I hope to be able to mark specific items as "Critical" so that we have a short-list of items we know have to be in stock.

Once again, thank you in advance for any help you can provide!

-Adam

0911060553270289.pdf

Find more posts tagged with

Infor Lawson Supply Chain Group - Discussion

Comments

unknown

Hi Adam, a starting (canned) report would be IC285. There are not many options to it but it might get you pointed in the right direction. I don't know of any flags that would indicate critical but it sounds like a good enhancement idea.

yvonne-grondin

A couple of Lawson reports/forms worth reviewing are IC182, IC285 and IC84.

I have an edited version of a crystal report that I received from another Lawson user. We have this published on our LBI dashboard for materials staff to manage their par levels. I am unable to upload the .rpt file into this thread. Send me your email address and I will forward it to you.

There are no critical flags but you may want to consider using item attributes or user fields in the IC12 or IC11 files.

dechevar

Adam,

There really aren't any good canned reports for managing par levels, especially for non-stock pars. We have been working with Infor's Dynamic Science Lab to implement their Inventory Intelligence for Healthcare. It uses algorithms to calculate both perpetual and par (stock and non-stock) locations recommended par levels based on 52 week history of replenishment and picks. We hope to be live by mid-September. Based on initial testing, we hope to obtain a 10-15% reduction in par levels. I highly suggest checking them out at Inforum if you attend.

As for the flag, if you do not do special item counts in your warehouses, you can use the Special flag to mark the items that you want to keep eye on and count those more frequently,

gtesche

Is Inventory Intelligence including the par reports available now?

dechevar

It replaces all other reporting.

dechevar

It replaces all other reporting.

unknown

Hi Gretchen. Yes, Inventory Intelligence had begun supporting par locations within the solution. You can review par levels, recommendations, and activity associated with the items by par location now similar to perpetual locations within the Inventory Intelligence for Healthcare application.

dechevar

LOL. Sorry Gretchen. I misunderstood your question. Yes, Par locations are included in the current version.

unknown

I can't help with 1 but as for 2 - Bins can belong to multiple bin groups. You could create a bin group that marks all critical and then build a report that runs SOH info for all items in the bin group. (And it's a custom report because the IC238 is the bin stock on hand report, but doesn't include bin or bin group as a parameter. Welcome to Lawson.)

IC145 and IC238 both filter for inventory class so you could also create a class and flag the item - but that it from the item master level, not warehouse.

Copyright © 2025 Infor. All rights reserved.