Tip: NetSuite Custom Records and Built-in Timestamp Date Information

Here is a quick NetSuite SuiteScript development tip that isn’t well documented.

When you create custom records in NetSuite, all the fields you recreate are well named — by you.  Hence you can reference these easily in your code because you named them.  However, what if you need to get to NetSuite’s built-in date timestamp information?

The date timestamp field names are as follows:

1. Date Created: “created”
2. Last Modified: “lastmodified”

Sample NetSuite Timestamp SuiteScript Code

var custrec = "customrecord_btc_trx_request";
var id = 1543;
var custrecord = nlapiLoadRecord(custrec, id);

nlapiLogExecution('DEBUG', 'value of created ', custrecord.getFieldValue('created') );
nlapiLogExecution('DEBUG', 'value of lastmodified ', custrecord.getFieldValue('lastmodified') );

Summary

If you are considering enhancing your NetSuite account to improve your business operations and need help, contact us.

Marty Zigman

Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - YouTube