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

Inventory Reports

 5 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Patti D
Basic Member Send Private Message
Posts: 10
Basic Member
11/3/2015 9:53 AM

Unfortunately we do not have a storeroom supervisor at this time.

I am the Material Analyst.

 

I think I know inventory well enough to keep us out of trouble.

 

But my question is –

          I currently run daily IC233, IC222, PO230, Wh222 step 1 to 5, and IC243.

 

Are there any other reports I should run – daily, weekly, monthly

I I do use Microsoft Add-ins and Crystal.

 

Do you have any tips or tricks?

 

Also, is there a report to help set min and max reorder points in IC12?

I know that they need changed on several of our items.

 

If you have any reports or information you would be willing to share, I would be most appreciative.

 

Thanks in Advance for your help

                                                Patti 

SCMaster-jk2
Veteran Member Send Private Message
Posts: 100
Veteran Member
11/5/2015 2:43 PM
What do you mean help set mins and maxes? Like do you want an add-in template that you can run when you have to change a bunch of them at the same time?
Patti D
Basic Member Send Private Message
Posts: 10
Basic Member
11/5/2015 5:40 PM

I am referring to IC12.1 the reorder tab - your can set your reorder point (when reordering for this item is triggered to occur when the item available quantity falles below this reorder point) and Maximum reorder quantity.

I know most of ours have not been adjusted for at least 3+ years.

SCMaster-jk2
Veteran Member Send Private Message
Posts: 100
Veteran Member
11/5/2015 8:23 PM
I know what you're referring to but do you want a report that shows you what your current reorder points are or did you want a template that can load in new mins/maxes?
Patti D
Basic Member Send Private Message
Posts: 10
Basic Member
11/6/2015 6:00 PM
Sorry, I want to be able to calculate new min and max and
load them into IC12
SCMaster-jk2
Veteran Member Send Private Message
Posts: 100
Veteran Member
11/6/2015 6:31 PM
I would probably run a custom add ins query that has each items mins/maxes in IC12. From there, you can assess every item's mins/maxs and can change.

After, you just need to create a custom upload add in that will change those two fields.