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

0 on hand

 2 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Sheri
Veteran Member Send Private Message
Posts: 163
Veteran Member
5/8/2018 3:20 PM

Hello, we have a report that shows us the items with a 0 on hand balance. Is there a table that records this so we could go back a month and see what items hit 0 on hand and what date? Or does this have to be a current status ?

 

 

JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
5/8/2018 3:47 PM
Stock on hand is stored in the ITEMLOC table but sorry to tell you that it's only the current status. But you can see SOH history in IC50 or export IC220 to csv to calculate SOH for a certain date.
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
Sheri
Veteran Member Send Private Message
Posts: 163
Veteran Member
5/8/2018 6:30 PM

Exporting IC220 is a good ideal, thank you!