Best Of

Hello,

You can not convert a saved report into a saved search. You can recreate the report into a saved search, but some of the criteria won't be listed in the 'filters' area of your report. For example, if the report is open sales orders, the filters won't show the transaction type=sales orders & Status = not closed, billed, etc.

Reports can be added to your dashboard as report snapshots. Searches can be added via the 'custom search' portlet. If you recreate a report as a saved search, you can then add it to your dashboard as a custom search or dashboard reminder.

I hope this helps!
~angela

Hello Angelica Mae Segador-Oracle,

Thanks for the information.

Its fine if it is the limitation of NetSuite.

Thanks and Regards,

Hello @Dwight Schrute

SQL functions only work with server-side actions such as "Before Record Load", "Before Record Submit", "After Record Submit". Since you use "Before Field Edit" which is a client action, you need to use SuiteScript APIs.

You can use below formula to extract the date and compare whether it is less than or equal to 07

nlapiStringToDate(nlapiGetFieldValue('trandate')).getDate() <= 07

Thank you, @Ivy Lopez-Oracle and @K Mukesh for sharing your go to shortcuts!

@Ganesh Karan, you can also check SAID: 8956 Keyboard Shortcuts for more shortcut tips.

For other users, feel free to show your go to NetSuite shortcuts too!

Hi @User_DU7YV,

Have you seen the new suggestions above? Let us know if it helps!

-Lyka

User_W5P2B

As to tracking actual time on tasks… There are a few ways on the task itself

1.) Manually Enter the Duration

2.) Use the Timer. the Assignee would "Start" the timer, Pause it and Stop it as appropriate.
3.) Use the Calculate Time feature, Enter the Start and End Time and any time spent on break for the Total calculation.

Automated billing? Someone else?

We use NetSuite.

The Inactive check box resolved my issue.