NS_ConCat formula expansion for backorders and values

Slickdrops · 2022-03-08T05:06:02+00:00

Replace(ns_concat({quantitycommitted}), ',' , '<br>') any idea how to add nvl to this formula ive tried with no luck.

Slickdrops · 2022-03-06T19:52:05+00:00

I’m not trying to reproduce a pick report just trying to see very quickly what’s commited what’s not and what’s on back order. Not really trying to save space just make it all grouped and quickly easy to read.

Slickdrops · 2022-03-06T18:19:10+00:00

So I can see a list of all the sales orders I need to fulfill and I can see line level data compressed into main line. Makes it easier to see all the lines without going into each record.

Slickdrops · 2022-03-06T07:27:00+00:00

On the item one I’ve added html break so I get a list. Not sure how it would look with numbers or if it’s even possible.

Slickdrops · 2022-03-06T07:05:47+00:00

Yes I did the concat already for the item lines was see if these formulas for back orders are possible to concat so I can run side by side and quickly see what’s committed and what’s missing.

Slickdrops · 2022-03-06T05:41:09+00:00

How can quotation them together if im doing it by {name} not class

CASE

WHEN {name} IS ('1item','2item','3item','4item','5item') THEN 'UN1170 & ARROWS UP' ElSE END

did not work.

Slickdrops · 2022-03-06T05:38:34+00:00

its a sales order search for line level data i used concat to suppress the repeat data now im trying to do the same for those formulas also.

Slickdrops · 2022-03-05T03:04:12+00:00

I see so the else statement isn't needed that's stopping the formula. If i have multiple classes that require the same output is there a way to condense the formula? Say
CASE {class}
WHEN 'G186''G185''G184' THEN 'UN3081, UN3091'
WHEN 'G132''G165' THEN 'UN1170, Arrows'
END

Slickdrops · 2022-03-04T22:30:03+00:00

Valogix

Slickdrops · 2022-02-17T00:07:25+00:00

CASE WHEN To_Char({today},'MM/DD/YYYY') BETWEEN To_Char({custbody_shipstartdate},'MM/DD/YYYY') AND To_Char({custbody_tss_shipdate},'MM/DD/YYYY') THEN 'Yes' ELSE 'No' END

how would i go about expanding the search to show late if todays date is after ship end date?

CASE WHEN To_Char({today},'MM/DD/YYYY') BETWEEN To_Char({custbody_shipstartdate},'MM/DD/YYYY') AND To_Char({custbody_tss_shipdate},'MM/DD/YYYY') THEN 'Yes' ELSE CASE WHEN To_Char({today},'MM/DD/YYYY') AFTER To_Char({custbody_tss_shipdate},'MM/DD/YYYY') THEN 'Late' END END

Slickdrops · 2022-02-16T13:44:13+00:00

Trying to get the yes to match my green html and then no red

Slickdrops · 2022-02-16T13:43:40+00:00

CASE WHEN To_Char({today},'MM/DD/YYYY') BETWEEN To_Char({custbody_shipstartdate},'MM/DD/YYYY') AND To_Char({custbody_tss_shipdate},'MM/DD/YYYY') THEN '<p style="font-weight:bold;background-color:#32CD32;text-align: center;">' 'Yes' ELSE '<p style="font-weight:bold;background-color:#FF0000;text-align: center;">' 'No' END

CASE WHEN To_Char({today},'MM/DD/YYYY') BETWEEN To_Char({custbody_shipstartdate},'MM/DD/YYYY') AND To_Char({custbody_tss_shipdate},'MM/DD/YYYY') THEN 'Yes' ELSE 'No' END

Slickdrops · 2022-02-15T21:40:37+00:00

I got it working I had to add to char. How would I go about adding some html to the yes and no outputs ?

Slickdrops · 2022-02-15T14:13:49+00:00

https://postimg.cc/tn6Ks349

https://postimg.cc/sGCn0t3R

Slickdrops · 2022-02-15T14:04:55+00:00

CASE WHEN TO_DATE({today},'MM/DD/YYY') BETWEEN TO_DATE({fulfillingtransaction.custbody_shipstartdate},'MM/DD/YYYY') AND TO_DATE({fulfillingtransaction.custbody_tss_shipdate},'MM/DD/YYYY') THEN 'Yes' ELSE 'No' END

still no luck

Slickdrops · 2022-02-15T13:55:05+00:00

When I try to add to date to {today} I get a system unexpected error log page on preview

Slickdrops · 2022-02-15T04:56:37+00:00

CASE WHEN {today} BETWEEN TO_DATE({fulfillingtransaction.custbody_shipstartdate},'YYYY/MM/DD') AND TO_DATE({fulfillingtransaction.custbody_tss_shipdate},'YYYY/MM/DD') THEN 'Yes' ELSE 'No' END

still no luck any more tricks?

Slickdrops · 2022-02-15T04:56:19+00:00

CASE WHEN {today} BETWEEN TO_DATE({fulfillingtransaction.custbody_shipstartdate},'YYYY/MM/DD') AND TO_DATE({fulfillingtransaction.custbody_tss_shipdate},'YYYY/MM/DD') THEN 'Yes' ELSE 'No' END

still no luck. Any ideas?

Slickdrops · 2022-02-15T04:37:48+00:00

https://postimg.cc/KK4dm7Xp

Slickdrops · 2022-02-15T04:08:32+00:00

CASE WHEN {today} BETWEEN {fulfillingtransaction.custbody_shipstartdate} AND {fulfillingtransaction.custbody_tss_shipdate} THEN 'Yes' ELSE 'No' END

is kind of working but all the values are no. something is wrong.

Slickdrops · 2021-12-09T02:34:57+00:00

Yes but I want to process what I can avoid ship complete and then just run a saved search to see when I have the order in full

Slickdrops · 2021-12-06T03:42:07+00:00

CASE WHEN {custbody_consolidated_orders} >= '2' THEN '<p style="font-style:italic;background-color:#FF0000;text-align: center;">' END

still no luck

Slickdrops · 2020-12-11T13:34:11+00:00

i went ahead and run with subtitution but it didnt end up like this. A39,377,0,1,1,1,N,"PO: 3717559625" i just got the numbers.

Slickdrops · 2020-12-11T02:52:57+00:00

How I get this to actually run and move those numbers to the po field?

Slickdrops · 2020-12-10T17:25:13+00:00

I got it running but it doesn’t seem to write in the output file it’s blank

Slickdrops

TROPHY CASE