11 Replies Latest reply: Apr 28, 2017 7:13 AM by Sunny Talwar RSS

    Inventory status calculations

    Birkir Björnsson

      Hi,

       

      I have an app where I need to calculate inventorystatus per day, per product, per store.  So we have an beginning inventory status and then transaction on top of that gives the current status of the inventory, so sold items are subtracted from the inventory and purchases added.

      So I would like to create a column either during load or via set analysis that calculates the inventorystatus. I am having some problems with this I tried to work with something like rangesum(above(Sum(Qty),0,RowNo(Total))), but this works in someways but when I productno to it it looses track.

      So any Idea on how to solve this?

       

       

      PostingDateStoreNoProductNoEntryTypeQtyTotalInvQty
      28.2.201711Counted10001000
      28.2.201721Counted100100
      28.2.201712Counted300300
      28.2.201722Counted10001000
      1.3.201711Sales-100900
      1.3.201721Purchase400500
      2.3.201712Purchase200500
      3.3.201722Sales-100900
      3.3.201711Sales-50850
      4.3.201722Sales -50850

       

       

      Regards

      Birkir