Related to http://jobinandjismi.in/create-a-connection-with-an-ftp-server/After creating a connection, you can transfer files to that server. Solution
Author: Hari Krishnan
Setting Values to a Country List/Record Field
In Netsuite, the Standard Country list’s internal id cannot be seen through UI. We need to find the internal id of the country we are about to set to the field Solution Get the country value from any of the Netsuite records and store it in a variable For ex: Pulling ship country from sales… Continue reading Setting Values to a Country List/Record Field
Create a connection with an FTP server
Solution We need a username, host key, password GUID, and URL of the FTP server to create a connection with Netsuite and FTP. Generate host key and Password GUID using this Suitelet below http://jobinandjismi.in/generating-passwordguid-and-hostkey-for-connecting-external-servers-via-suitelet/ See an example below
Email Case Capture
To enable email case capture go to Setup>Company>Enable features under the CRM subtab to enable Email Case Capture This enables you to capture cases through email. To capture email cases NetSuite has an inbound email address to send cases to NetSuite. Go to setup>Support>Support preferences>Inbound Email You can try sending case details to this email.… Continue reading Email Case Capture
Summary functions in Query
Example of using summary functions in a query (MIN, GROUP) We can use the summary functions in query as we use in the search
Retreive datas using Query
Solution Instead of using search, we can use query to retrieve data from NetSuite. Use the ‘N/query’ module. Simple Example: Retrieving an employee name using the query For more search SuiteQL in SuiteAnswers
Comparison of JSON objects
Solution
Print multiple page copies on single print PDF
Solution To print multiple copies of page in PDF template use <pdfset> tag Example <pdfset> <body> .. ….. </body> </pdfset> <pdfset> <body> .. ….. </body> </pdfset> While clicking on print, this prints 2 copies of that same page. The contents written on the pdfset tag considers as one page.
Grouping same items in the PDF template
Solution
Enable Item Display Image on Saved Searches
To show display images of Items in search, the ‘Web Store‘ feature needs to be enabled on Netsuite. To enable the Web Store feature, navigate to Setup > Company > Enable Features > Web Presence tab > Web Site section. This will provide you two fields in searches Store Display Image and Store Display Thumbnail fields which help to display images of items on saved searches. Note: Using the Formula(text) field to pull… Continue reading Enable Item Display Image on Saved Searches