[Claytonm]

I have a native netsuite inventory report on my dashboard as a KPI

It shows what the $ value of total inventory is today, and what it was a month ago, with a % change next to it.

I would like to have the same report, but only count the value of available inventory. (inventory that is not committed to orders)

is there a way to make a copy of the native inventory report and add/change a filter to only look at non-committed inventory?
This is a cached copy. Click here to see the original post.

[kblasp]

You can do a saved inventory item search and and just show available inventory. We use this frequently.

[Claytonm]

RE: Available Inventory Report

Originally posted by kblasp

View Post

You can do a saved inventory item search and and just show available inventory. We use this frequently.

I did this, made a saved search that sums the value of the cost multiplied by the available qty for each item in inventory

But the only time frame this report can be viewed over is “Current” … its a live snapshot.

What I am trying to do is make it view-able over time like the native netsuite inventory report. I would like to see “available inventory today vs available inventory a month ago” like i do with the native netsuite inventory report on my KPI Portlet on the dashboard.

[Author]

Posts