2 Replies Latest reply on Nov 30, 2016 11:08 PM by Revealer Business Intelligence

    Inventory Stock Purchase Alert

    Revealer Business Intelligence

      Hi,

       

      Stock ledger has got data where every receipt or issue of material is registered in a row format.

       

      We are expected to provide an alert whenever a second purchase happen without the previously purchased item is not issued

       

      Here in the sample sheet, Item B is bought on 1st June ,11th June and 12th June and same is issued on 1st June and 13th June. There should be an alert on 12th June since the item bought on 11th June is not issued yet

       

       

       

      Date

      Item Code

      Item Name

      Receipt_Qty

      Issue_Qty

      Notification

      01-Jun-2016

      I651211936

      A

      100

      0

      01-Jun-2016

      I651254122

      B

      120

      80

      01-Jun-2016

      I651261182

      C

      50

      0

      10-Jun-2016

      I651211936

      A

      100

      100

      Alert

      11-Jun-2016

      I651254122

      B

      200

      0

      12-Jun-2016

      I651254122

      B

      150

      0

      Alert

      13-Jun-2016

      I651254122

      B

      0

      100

       

      Quick response is much appreciated

       

      Regards,

      Bernie