Alicia McCaffrey
Is there a report to pull for all inventory for a specific date? In order for me to reconcile my inventory at month end without having to pull it on the 31st?
<COMMENTS>
Chereen Dupuis
This would be super helpful! Also, we need the ability to choose one or more warehouses for the report.
0
·
February 8, 2022
·
Steven Chung
Merged in a post:
Inventory Report - Need to be able to select "As at Date"
Louise Lalor
Desperately need to add a date button to the above report so it can be run on a specific date. Need this to value inventory at month end.
November 15, 2021
December 14, 2021
·
Unmerge
Steven Chung
marked this post as
UNDER REVIEW
0
·
December 10, 2021
·
Steven Chung
https://untappd.atlassian.net/browse/OLLIE-532
0
·
Internal
·
December 10, 2021
·
Reply
Steven Chung
Choose specific date. Snapshot
0
·
Internal
·
November 26, 2021
·
Reply
Louise Lalor
Adding a date button to pull an Inventory by SKU Report would be an excellent addition to allow month entry inventory reconciliation from the CSV file that is relatively "clean" as compared the Inventory Reconciliation Report that has a date range field.
0
·
November 25, 2021
·
Kristina Dyk
Additional feedback from Hillside Winery:
My request to have a date button added to the Inventory by SKU Report is driven by the need to calculate our month end inventory value per the Ollie warehouses inventory. We have an inventory value in our accounting records however need to reconcile what is in Ollie and compare to our QuickBooks value. I am certain that being able to pull inventory at a specific date would be a hugely helpful to many users.
To calculate the inventory value the specific vintage of each SKU is multiplied by the Cost of Goods Sold (COGS).
The Inventory reconciliation report has a lot of information which is not needed to do this calculation and in addition the formatting makes pulling the SKUs and vintages difficult.
Any idea when the date button might be added to the Inventory by SKU report?
Thanks again for your help
0
·
Internal
·
November 25, 2021
·
Reply
Kristina Dyk
Additional feedback from Hillside Winery:
The Inventory Reconciliation is cumbersome to manipulate in Excel with VLOOKUPs - which is what I need to use to calculate inventory value. The Inventory report is clean in that it has the SKU and the number of bottles - I am sure it would be of great value to other Ollie customers.
Let me know if this might be possible? Otherwise I will have to use the above.
Thank you
Louise