Hi Folks, I'm looking for a time-phased inventory...
# general
p
Hi Folks, I'm looking for a time-phased inventory report that for an item shows: "Qty On hand" + Open POs + Open WOs - Customer orders by date for a running total of available inventory for supply chain planning. The data can be found by running the Open Sales orders, Open Purchase orders, and Open Work Orders reports, then exporting the data to Excel and pivoting it by date. Several options are available for creating a time-phased inventory report in NetSuite, including built-in reporting, SuiteScript, Analytics, or a low-code app that uses the REST API. Could a canned report be written if one knows the correct data fields? Any thoughts or suggestions on how to proceed would be appreciated. Thanks!