2 Replies Latest reply: Nov 30, 2013 2:58 AM by Vishwaranjan Kumar RSS

    Inventory Aging


      In inventory ageing report ,I am having two quantities -StockQty and ReceiptQty as expression.

      My output should come based on the below condition,

      for eg: If the StockQty is 1000, then the receiptQty have to be splitted in agewise as follows

      0to30days-250,30to60days-500,60to90days-250,90to120days-0 and >120 days-0

      But in my application receiptQty not coming within the range of StockQty,its exceeding.

      Please suggest me the condition for satisfying the above criteria.