2 Replies Latest reply on Apr 4, 2018 3:46 AM by Benjamin Rubattel

    Open Orders at End of Month

    Benjamin Rubattel

      Hello,

       

       

       

      i am looking to analyse the backlog in our order fulfillment activities.

       

      My datasource contains the Order Created and the Good Issue Created for each order lines. If the order lines has not been issued then no Good Issue number will be referenced. 

       

      I am looking to review how many order lines where not referenced to a good issue number at the end of each month. Is there anyone that would know a way of analyzing the below?

       

      1. I would like to know how many order lines are still open (created but not shipped, no Good Issue Number) at the end of each month in order to identify the evolution of the backlog over a period.

       

       

      I attached an extract of my data.

       

      thanks

      Benjamin