Discussions
Inventory report
Hi,
I would like a report that shows the value of a particular inventory item and its movements in and out of stock. Please refer to the screenshot below from our legacy accounting package.
I have succeeded in reproducing some of the report in Netsuite but I am having difficulty getting a running balance of the CURRENT VALUE of the item. The CURRENT ON HAND VALUE column returns the current on hand value of the item as of today, and not as of the date of each transaction as I need the results to show. This problem could be solved if I had the option of ticking the "Add running balance column" for more than one column - I have already used the running balance option for the QUANTITY column. . Can anyone