Back to Community Threads
1
Stock Value
Question asked by Shibana Abdulsattar - 7/20/2020 at 7:12 AM
Answered
would like to know how do you take stock value by date to date

3 Replies

Reply to Thread
0
Mark Culos Replied
7/20/2020 at 10:32 AM
Employee Post
Shibana,

The inventory valuation for any date other than the current date can be calculated by taking the current value, adding the value of all invoiced inventory, and subtracting the value of all received inventory.  This assumes that you have not manually altered the on hand quantity over the period.
0
Shibana Abdulsattar Replied
7/20/2020 at 12:28 PM
Thanks, but my question was how to generate a report which can show value of inventory items based on cost price and on a specific date 
0
Mark Culos Replied
7/20/2020 at 2:34 PM
Employee Post Marked As Answer
Shibana,

The method I suggested will give you that value by working back to the date in question.  There is no report that allows you select a date and display the value as of that date, the only inventory value report is as of the current date.

If you have a backup from the date you want the inventory valued, you can restore that backup and print the inventory valuation report which will give you what you are seeking.
Back to Community Threads

Reply to Thread