Crear Búsqueda Guardada para Calcular el Nro. de Días y Horas Laborables desde que se Abrio un Caso

Se aplica a

Producto: Netsuite 2024.1

Escenario

Un usuario desea crear una búsqueda guardada para contar la cantidad de días hábiles y horas hábiles que lleva abierto un caso.

Solución

1. Navegue a Listas > Búsqueda > Búsquedas Guardadas > Nuevo
2. Tipo de Búsqueda: Haga clic en Caso
3. Título de Búsqueda: Introduzca un Título
4. Haga clic en Resultados
5. Haga clic en Columnas
6. Campos:

• Seleccione Número

  • Seleccione Fórmula (Texto) Formula: Introduzca CASE WHEN {closed} IS NULL THEN decode(((TRUNC({now},'D')-TRUNC({createddate}+6,'D'))/7*5)+MOD(7-TO_CHAR({createddate},'D'),6)+LEAST(TO_CHAR({now},'D')-2,5)- 1,-1,0,((TRUNC({now},'D')-TRUNC({createddate}+6,'D'))/7*5)+MOD(7-TO_CHAR({createddate},'D'),6)+LEAST(TO_CHAR({now},'D')-2,5)-1)+ decode(trunc({createddate}),trunc({now}),0,trunc(((decode(to_char({createddate},'D'),1,0,7,0,case when to_char({createddate},'hh24') between 8 and 17 then 17-to_char({createddate},'hh24') when to_char({createddate},'hh24')<8 then 10 else 0 end)+decode(to_char({now},'D'),1,0,7,0,case when to_char({now},'hh24') between 8 and 18 then to_char({now},'hh24')-8 when to_char({now},'hh24')<8 then 0 else 10 end))+trunc((decode(to_char({createddate},'D'),1,0,7,0,case when to_char({createddate},'hh24') between 8 and 17 then 60-to_char({createddate},'mi') else 0 end)+decode(to_char({now},'D'),1,0,7,0,case when to_char({now},'hh24') between 8 and 17 then to_number(to_char({now},'mi')) else 0 end))/60))/10))||' days '||mod(decode(to_char({createddate},'D'),1,0,7,0,case when to_char({createddate},'hh24') between 8 and 17 then 17-to_char({createddate},'hh24') when to_char({createddate},'hh24')<8 then 10 else 0 end)+decode(to_char({now},'D'),1,0,7,0,case when to_char({now},'hh24') between 8 and 18 then to_char({now},'hh24')-8 when to_char({now},'hh24')<8 then 0 else 10 end)+trunc((decode(to_char({createddate},'D'),1,0,7,0,case when to_char({createddate},'hh24') between 8 and 17 then