Best Of

Re: Saved Search formula

Please try the following:

CASE WHEN {trandate} BETWEEN TO_DATE(TO_CHAR(ADD_MONTHS(SYSDATE, -12), 'YYYY') || '-01-01', 'YYYY-MM-DD') AND TO_DATE(TO_CHAR(ADD_MONTHS(SYSDATE, -12), 'YYYY') || '-12-31', 'YYYY-MM-DD') THEN 'LY'

WHEN {trandate} BETWEEN TO_DATE(TO_CHAR(SYSDATE, 'YYYY') || '-01-01', 'YYYY-MM-DD') AND TO_DATE(TO_CHAR(SYSDATE, 'YYYY') || '-12-31', 'YYYY-MM-DD') THEN 'Current'

WHEN {trandate} >= TO_DATE(TO_CHAR(ADD_MONTHS(SYSDATE, 12), 'YYYY') || '-01-01', 'YYYY-MM-DD') THEN 'LT' END

I tested the first two and it seems to work on my end, but I wasn't able to test the 3rd one since we don't have transactions in future periods.

Hope this helps.

User_WX408

2

Re: SFTP payments from NetSuite to Banks

Hi @PaulRipley

What country are you based in? In some places, such as Australia, the local banks have the ability to set this up such as NAB Direct.

Zone SFTP can also be used to send bank files as well as receive bank feeds.

Vernita

2

Re: Posting Period vs Transaction Date

Hi, @User_MP4W2

To reduce the issue of error in posting period, First you need to filter the transaction date and posting date in the report , create a saved search for the particular transaction type for which the report is created , add the criteria , and results in which basis the details need to be displayed, filter and sort it, at last save and run.

Hope it will be useful for You.

Anuja R M

2

Re: Gateway Time-out when deploying with SDF

Yes, the project was too big. I broke it up into groups of 5 forms per project, and was able to successfully deploy.

Sharna Kinsey

1

Re: Script error SSS_INVALID_SRCH_COL Item Record for location quantity available

Hello! I just figured it out —

The filter was wrong:

filters:
        [
            ['itemid','anyof',itemId],

Changed 'itemid' to 'internalid' and it works now.

Thanks for the help! Love you, NetSuite.

Judy Perry

3

Re: NetSuite Admin Tip | Best practice to inactivate a resigned employee

Maybe this process could be helpful to others.

The process is simple, when a user's employment is terminated, we set a termination date and revoke their login access. This triggers a scheduled script to take action. The script automatically sends an email notification to the supervisor, informing them of the termination and providing details of all open transactions and activities associated with the terminated user. This empowers the supervisor to decide on the necessary course of action.

Furthermore, after a 30-day period, a reminder email is automatically sent, clearly stating that the account will now be closed. The reminder also includes a list of any remaining open transactions. Following this, the account is completely inactivated.

This process streamlines the termination procedure, ensuring smooth transitions while maintaining data integrity and security.