Search code examples
netsuitesaved-searches

Set Offset = +75 minutes in Sales Order saved search

How do I set Offset = +75 minutes (this is for cancellation reasons) in SalesOrder saved search in NetSuite , can you provide me in any detail by applying any filters?

I tried by using filters in criteria , but I haven't seen any offset kind of field.

Solution

  • Upon running tests, I believe the following output is what you need:

    enter image description here

    The above is achieved by adding the following in the RESULTS subtab: enter image description here

    That is:

    • FIELD = Formula (Numeric)
    • FUNCTION = Number as Time
    • FORMULA = ({today} - {lastmodifieddate}) * 1440

    In this example, TODAYs date is compared against the LAST MODIFIED date of the record to output the time difference in minutes.

    For your requirement, you want to only return records where the time difference is GREATER THAN 75 minutes; thus you will need to add the following as a filter in your saved search:

    • Click the CRITERIA subtab
      • Filter = FORMULA (numeric)
      • Description = IS GREATER THAN 75
      • Formula = ({today} - {lastmodifieddate}) * 1440

    If you are seeking to track the DATE CREATION of record, then change {lastmodifieddate} to {datecreated} accordingly.

    Hope this helps.