Year end inventory

Melissa71
Tourist
8 0 1

Is there a way to get a report of what I had in inventory at year end?

Replies 5 (5)

LBLLC
Visitor
1 0 0

yes, if I remember correctly...

go to Analytics, Reports, 

Month-end inventory snapshot

and change the date to Dec 31, 2020.

Melissa71
Tourist
8 0 1

Thank you, however that doesn't give a total amount and that's what I need.

Melissa71
Tourist
8 0 1

I figured it out, thanks.

audaciousgrace
Visitor
1 0 0

Can you share how you figured it out?

Thanks

Ben_Busse
Tourist
4 0 2

We're glad you found a solution to a problem that many of us have.  Could you be the "helper" that you sought and share with us your method? 

 

My guess would be to follow LBLLC's direction to get to "Month-End Inventory Snapshot".  From there, click the hyperlink in blue marked "export the report", which will download a .CSV file that you can open up in Microsoft Excel.  I'm terrible with Excel but I believe  you can then use Excel tools to remove any items with a value of "0" so you can see only items with stock on Dec, 31st.  Add them up and assign value to those quantities to come up with your "Cost of Inventory Remaining". 

 

Thanks and God bless you.