Pacejet

NetSuite - How to Measure Import Times

Overview

For NetSuite integration 2.0, how to create a Saved Search to measure the time it takes to import an IF from the time the IF was created to the time it was imported into PaceJet.

Steps

1. Create a new Saved Search

  • The Type for your new Saved Search will be Transaction.

2. Give it a name and add the following criteria:

3. Go to the Results tab and add the following as highlighted below:

  • Here is the Formula:

    CASE WHEN (to_number(to_char({systemnotes.date}, 'MI')) - to_number(to_char({datecreated}, 'MI')))< 0 THEN (to_number(to_char({systemnotes.date}, 'MI')) - to_number(to_char({datecreated}, 'MI')))+ 60 ELSE (to_number(to_char({systemnotes.date}, 'MI')) - to_number(to_char({datecreated}, 'MI'))) END

Here is and example result: