Skip to Content
avatar image
Former Member

Custom query for all WH instock < min inventory level by item

Hi,

Before I run the schedule alert by displaying the min inventory level by item on specific WH.

But now I wish to run the query if the sum of the (sum of all WH).onhand < oitm.minlevel.

Can anyone please help.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 25, 2015 at 09:34 AM

    Hi Olga,

    Please try below query and revert back.

    Select A.ItemCode, A.ItemName, A.MinLevel, A.Onhand

    from OITM A

    Where A.MinLevel > A.Onhand

    Thanks

    Unnikrishnan

    Add comment
    10|10000 characters needed characters exceeded