Inventory Activity Detail balance column
A few months ago we went live with a customer who first used Microsoft AX. They dropt a request to make a report which should be equal to the report in AX.
Screenshot of AX report (Dutch interface):
In this report you see a total quantity on hand (Samengevoegd) which starts at 381,80. Every row uses the amount of the row above to create a new quantity. For example: Total = 381,80. Verkooporder 1107925 quantity = 30. The new total amount = 351,80.
When I look within NetSuite I think the 'Inventory Activity Detail' is the report that comes closest to the result of the AX report. Does anyone know if it is possible to use the result of the row above for calculating the new row, so I can create a column like 'Samengevoegd' in the AX Report screenshot?