[kmd]

Hi,

On our Profit and Loss report we need to show the inventory change from the start of the year to the end of the year. Does anyone else need to show this? If so, how do you do so? Any help or recommendations would be great. Thank you!
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC]

RE: Inventory change on Profit/Loss report

I’m not sure how you’d show that much info ON the P&L… you’re basically talking about the Inventory Activity Detail report. I’d run it as a seperate report.

[kmd]

Thanks. What we are trying to show is the value difference of the inventory (the change from the start of the year to the end of the year). We’re new to Netsuite and this is our first year end using the Netsuite reports so I am not sure how we would show this change in the Inventory Activity Detail report either.

[Olivier Gagnon NC]

RE: Inventory change on Profit/Loss report

Ahh, I see.

Ok, couple of options. You’ll notice at the bottom right of the P&L (and most other financial reports) that there is a “Total” footer filter. You can set that to “Period” – this will show you the evolution of your P&L throughout periods, so that’s one very quick and simple way to run basic comparative.

To monitor inventory value specifically, oddly enough there is no out-of-the-box straight comparative report. But, you could run something like the Inventory Valuation report, which has an As Of date. So you can run it at different dates and see your evolution.

[kmd]

Thanks for your help. I think we’ll use the Inventory Valuation report and just run for different dates. Thank you!

[Author]

Posts