Discussions
Here are some examples to get your creative juices flowing.
"Did I pay vendor John Doe last month?"
"Take me to my largest sales order for this month."
"What invoices haven't been paid yet?"
Search (Script) for Yesterday's Sales
I have a few saved searches (and also scripts running the same criteria) so show data for 'yesterday' - but on a Monday I need it to show Friday's data.
The Formula I've found that enables me to do this is fairly complex:
["formulanumeric: CASE WHEN TO_CHAR({TODAY},'Dy') = 'Mon' THEN (CASE WHEN {trandate} = (TO_DATE(TO_CHAR({TODAY},'dd/mm/yyyy'),'dd/mm/yyyy'))-3 THEN 1 ELSE 0 END) ELSE (CASE WHEN {trandate} = (TO_DATE(TO_CHAR({TODAY},'dd/mm/yyyy'),'dd/mm/yyyy'))-1 THEN 1 ELSE 0 END) END","equalto","1"]
As I've started to use this in scripts, I am noticing that this particular search is noticeably slower than other searches (even searches potentially returning more data/results).