Would love to see a random selection feature that randomly selects a wine from your cellar and puts you on its details page. Perfect for those days where you truly want to open something random.
What you want doesnāt current exist in CT, afaik. However, a workaround of sorts could be to create a āstoreā called āFutures.ā This would allow you the ability to segregate these bottles from all others, either by sorting by āStoreā or by Doing My Cellar ā Pending ā Store. I know both of these are different reports than what youāre asking for, but itās something.
I think it may be easier to just put the expected delivery date in, even if approximate. You can either lump them together with a dummy date, or put your approximate delivery date in. The āPendingā wines can be sorted by delivery date, year, quarter, month, etc.
*Edit - Sorry I didnāt read the above. It looks like there was already discussion about this.
I donāt really use the report function very much, but could you put āFuturesā as a private comment and run a pending report looking for that comment? @Andrew_Hall ?
I agree, but was just proposing a different workaround, as JDavis didnāt seem attracted to the other idea. Neither the Expected Delivery date idea or the Stores idea is exactly what heās looking for, but both will work, and thereās different usability features of each.
Interesting. I love the Reports function and use it frequently. Iām curious to see what Andrew says in response to your post, as itās never occurred to me that it might be possible to run a report using the Private Note field in some fashion.
Of course you could download it all to excel and then pull out the futures data from thereā¦thatās a lotta work for not just using the date received field to see whatās coming!
Perhaps Iām also missing the use case. I think all of the āfuturesā Iāve ever purchased have been Bordeaux wines, unless you are including āpre-arrivalsā in that mix. Itās pretty easy to search for āBordeaux 2022.ā If I want to separate the nearer term pending items from the āfutures,ā I use the delivery date. If my futures are supposed to arrive in the near term, I canāt think of a reason why Iād want to separate these from the other āpendingā wines I have.
Most other issues I have require me to search by retailer to see which pending wines I need to ask them about.
Not a problem nor complaint. Just a curiosity and interest in satisfying my less than ideal desire to check things off a list aka getting my PD list to zero bottles.
Meaning, if I know a group of bottles wonāt be delivered for a couple of growing seasons/years is there a way (either new or within current framework) to track those types of orders (ie futures).
Other than my compulsiveness, it was prompted because I was looking thru some CT data/app recently (I apologize for not recalling which) that showed current inventory + pending inventory of a given bottling. I know futures would always have the current inventory be zero, but just made wonder.
As of now, Iāve chosen to not enter the futures into CT and have the email order confirmations tagged and saved in a folder in my email client with a reminder set around the expected bottling/shipping date.
No big deal and happy to let the conversation move to next suggestion.
That sounds like way more work than just letting them comingle, but to each their own! I use my CT to see what Iāve already purchased, since some futures deals still pop up prior to delivery. It helps me see verticles I have going, and it helps me track my budget. Leaving something out would hurt the accounting side of my brain the way leaving it in does yours . I would 100% do something like change email clients or accidentally miss a reminder and forget about them .
To expand on this: Can one do a report on Purchases limited to those with ā{whatever you want}ā included within the Purchase note, but not necessarily comprising the entire Purchase note? (hope that makes sense)
Unlike at TWA (who I am STILL talking to BTW), Lisa/TWI seemed very, VERY eager to collaborate. Things seem to have ground to a halt with their developer. Anyway, in a world of finite resources and small teams I get it. Hopefully will get it done at some point.
This may have already been discussed, but is there any sort of way to run a report that shows value changes of wine in your cellar over time (Iām just looking at mobile this morning)? Iām guessing this would either need to be tied to W-S or based on the initial purchase price you log. Obviously, I can run reports and keep a historic record of my own, but it would be cool to see net decrease and increase in value if it falls or rises sharply.
I donāt expect it would make sense for CT to spend the time and resources to run jobs regularly that memorialize all average wine prices over time, but that would make alerting pretty straightforward (āalert if price increases +25% in 1 quarterā).