Daily Item Inventory Levels

Hello,

I am inquiring to see if there is a stock on hand canned report that I could run for a date range that would show the stock on hand qty for the item each day of the date range. So if I ran for 2/01 - 2/05 it would show me stock on hand for 2/1, 2/2, 2/3, 2/4, & 2/5. I reached out to Infor on this and they only suggested query out the SOHDetail table. I am not seeing a date range in that table on the related tables. I wasn't sure if there was something similar to the IC234 that could be ran for a date range.

Brandon Nolan

Brandon.Nolan@mymlc.com

Find more posts tagged with

Infor Lawson Supply Chain Management - Discussion

Comments

unknown

You could try the IC220. It's used to show transaction history but it also has a field for the stock on hand and the difference as each PO is received, adjustment is processed or item is issued. It's a field that I usually have to delete....but it might work for you.

jcollins

I appreciate the reply, we do utilize the IC220. I was trying to create an easy to run add in report that could be run daily. I am surprised Lawson doesn't have a canned report that is similar to the ic44/ic49.

ERPCOM_monthly_proactive201007.pdf

unknown

IC49 pulls from the ICHISTORY table I have a Report Center report call "IC49 All Items" that is just that - the IC49 in columns and then a row per item in the IC12. It's only using ICHistory and ItemMast so it shouldn't be too difficult to link.

I don't know how that gets you a specific date though - it's by period. (My sql attached)

[View:/cfs-file/__key/communityserver-discussions-components-files/54/MHS-IC49-Report.txt:320:240]

Copyright © 2025 Infor. All rights reserved.