Value Of Inventory

[Former Member]

Hello All --

We are looking for a Query that will show us the total value (total dollar value of item costs) of our stock inventory at the end of each month. Can someone help with this?!

Thanks!

Mike

[Former Member · Accepted solution]

Hi Mike

Did you look at Inventory Audit report ? I think this should solve solve problem.If not , please specify how you want your query to work .

Thank you

Bishal

[Former Member]

Last question on this.

[jitin_chawla]

Hi,

The values will be till the date which you have ended at the TO field from the begaining.

Regards,

Jitin

[jitin_chawla]

Hi Mike,

Inventory Audit report is the best bet for your query as Bishal mentioned.

You can take the date range for the items for which you want the value.

Regards,

Jitin

[Former Member]

Looks like this may work. If we leave the beginning date blank and fill in the ending date then the values that we receive are the values on that ending date, correct?

Thanks,

Mike