3 Replies Latest reply: Aug 2, 2013 10:18 AM by Andrea Rebora RSS

    back order visualization

      Hi,

       

      I would like to have a chart that displays backorders, but only for customers who also have an order for delivery tomorrow.

      I have those two table

      Cod.CusCompanyName
      001Company1
      002Company2
      003Company3
      004Company4
      005Company5
      006Company6
      007Company7
      008Company8
      009Company9
      010Company10
      011Company11
      012Company12
      013Company13
      014Company14
      015Company15
      016Company16
      017Company17
      018Company18
      019Company19

       

      ordN°CodCusCodArt.DeliveryDateRequiredQtyPriceStatus
      Ord001Cus001Art00129/07/2013110Delivered
      Ord001Cus001Art00229/07/2013212pending
      Ord001Cus001Art00329/07/201349pending
      Ord002Cus002Art00429/07/201313Delivered
      Ord003Cus003Art00529/07/2013278pending
      Ord004Cus001Art00630/07/2013112Delivered
      Ord005Cus002Art00730/07/2013315Delivered
      Ord005Cus002Art00830/07/20131212Delivered
      Ord005Cus002Art00930/07/201331pending
      Ord010Cus003Art01030/07/2013143pending
      Ord011Cus001Art01131/07/2013323Delivered
      Ord011Cus001Art01231/07/2013154Delivered
      Ord012Cus002Art01331/07/2013412Delivered
      Ord012Cus002Art01431/07/201321Delivered
      Ord013Cus003Art01531/07/201333pending
      Ord016Cus001Art01601/08/201314pending
      Ord016Cus001Art01701/08/201375pending
      Ord017Cus002Art01801/08/201341pending
      Ord017Cus002Art01901/08/20131323pending

       

      I would see only the order in status pending, but only of customers Cus001 and Cus002, because they have an order with DeliveryDateRequired tomorrow (today is 31-07-2013).

       

      Many Thanks

       

      Andrea