Hello! I need to add a case statement in my search...
# generals
sandra
10/08/2019, 1:16 PMHello! I need to add a case statement in my search- is anyone good at that? 🙂
o
Olivier Gagnon (DXC)
10/08/2019, 1:19 PMwhat do you need?
s
sandra
10/08/2019, 1:20 PMi need to pull the discounts for the month of september
sandra
10/08/2019, 1:20 PMmessage has been deleted
sandra
10/08/2019, 1:21 PMmy results criteria is:
sandra
10/08/2019, 1:21 PMi think i have to add case statements as a formula
o
Olivier Gagnon (DXC)
10/08/2019, 1:21 PMis amount discount not returning what you need?
s
sandra
10/08/2019, 1:22 PMcorrect- it returns zero
o
Olivier Gagnon (DXC)
10/08/2019, 1:22 PMhmm.
s
sandra
10/08/2019, 1:22 PMapparently it returned something before
o
Olivier Gagnon (DXC)
10/08/2019, 1:22 PMlike, last month it worked?
s
sandra
10/08/2019, 1:22 PMmessage has been deleted
sandra
10/08/2019, 1:23 PMi am told last month it worked. this is not my original search.
o
Olivier Gagnon (DXC)
10/08/2019, 1:24 PMok let's do this: change your date criteria to include august and september, remove all your grouping on the search, and remove the main line = true criteria (you may want to save this as a side-search not to mess up the live one)
Olivier Gagnon (DXC)
10/08/2019, 1:24 PMwhen you run it, I want to see if we can see lines where Amount Discount has values
Olivier Gagnon (DXC)
10/08/2019, 1:25 PM(basically, I don't think you need any formulas, we just need to debug this search)
s
sandra
10/08/2019, 1:25 PMkk lets see... i wont save the search, just clicking
previewsandra
10/08/2019, 1:27 PMIt is now running.
sandra
10/08/2019, 1:31 PMIt is still running and i am afraid it will time out
o
Olivier Gagnon (DXC)
10/08/2019, 1:32 PMok then try reducing it to run only for august
Olivier Gagnon (DXC)
10/08/2019, 1:33 PMhow many invoice lines you guys have per month6
Olivier Gagnon (DXC)
10/08/2019, 1:33 PM?
s
sandra
10/08/2019, 1:37 PMinvoice lines? in 1 order pwople can order from 1 thing - 100!
sandra
10/08/2019, 1:37 PMor more
o
Olivier Gagnon (DXC)
10/08/2019, 1:41 PMany luck on getting results?
k
KevinJ of Kansas
10/08/2019, 1:54 PMI would look at the audit trail and see what changed
KevinJ of Kansas
10/08/2019, 1:56 PMGranted it's plausible that you have changes something else about your way you are entering transactions
s
sandra
10/15/2019, 2:10 AM@Olivier Gagnon (DXC) it allowed me to see transactions but discount amount still zero...
sandra
10/15/2019, 2:10 AMI opened a case with NS... they are still looking at it.
sandra
10/17/2019, 2:36 AMThey couldn’t help lol I ended up figuring it out myself
k
KevinJ of Kansas
10/17/2019, 3:53 AMWhat did it turn out to be?
4 Views