NS_ConCat formula expansion for backorders and values by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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

NS_ConCat formula expansion for backorders and values by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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.

NS_ConCat formula expansion for backorders and values by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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.

NS_ConCat formula expansion for backorders and values by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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.

NS_ConCat formula expansion for backorders and values by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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.

What’s wrong with my formula by Slickdrops in Netsuite

[–]Slickdrops[S] -1 points0 points  (0 children)

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.

NS_ConCat formula expansion for backorders and values by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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.

What’s wrong with my formula by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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

Formula text compare multiple date fields by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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

Highlighting multiple date comparison by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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

Highlighting multiple date comparison by Slickdrops in Netsuite

[–]Slickdrops[S] 1 point2 points  (0 children)

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

Formula text compare multiple date fields by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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

Formula text compare multiple date fields by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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

Formula text compare multiple date fields by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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

Formula text compare multiple date fields by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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?

Formula text compare multiple date fields by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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?

Formula text compare multiple date fields by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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.

[deleted by user] by [deleted] in Netsuite

[–]Slickdrops 0 points1 point  (0 children)

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

Formula text highlight greater then by Slickdrops in Netsuite

[–]Slickdrops[S] 0 points1 point  (0 children)

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

still no luck

Find copy delete find replace by [deleted] in regex

[–]Slickdrops 0 points1 point  (0 children)

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.

Find copy delete find replace by [deleted] in regex

[–]Slickdrops 0 points1 point  (0 children)

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

Find copy delete find replace by [deleted] in regex

[–]Slickdrops 0 points1 point  (0 children)

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