Best Practices for CloudExtend Excel Data Management for NetSuite

XLNS | Learn about the best practices when using CloudExtend Excel Data Management for NetSuite

Updated over a week ago

In order to create and maintain records in NetSuite via CloudExtend, there are certain best practices that we recommend you follow.

βœ… Tip 1 - Review permissions and prerequisites

To validate the permission assigned per CloudExtend user role. Go to Setup > User/ Roles > Manage Roles and make sure to have SOAP Web Services and User Access Tokens added and set to Full.

βœ… Tip 2 - Install the performance bundle in NetSuite

Use the CloudExtend Excel bundle to customize the app and get access to advanced features. Read here to know how to install it and why it's important.

βœ… Tip 3 - Build a good template

Prepare beforehand, know how your NetSuite form works and what it looks like. Build a template with a nice structure and organized information flow.

πŸ’‘ Note: Put all the header fields first and your line-level fields on the latter part of the template. This is helpful when creating records with multiple lines, all lines with identical header fields will be treated as one record.

βœ… Tip 4 - Validate and push data to NetSuite

  • Use Picklist values for List field type in NetSuite (this inserts NetSuite internal ID behind the scenes). This will make the upload faster. πŸƒπŸ½β€β™€οΈ More on Picklists here.

  • If known, use internal ID only in [[nnnn]] format for picklists

  • Copy and pasting or using formulas to get the data to the CloudExtend template is possible but we recommend that the formula or values also include the internal ID noted in the format above to improve performance

  • Do not hide columns or rows from the active worksheet as they will not be ignored during an upsert operation

βœ… Tip 5 - Share templates with others

CloudExtend templates can be shared with other users, with no need to rebuild them from scratch.

  • An Admin can create a library of shared workbooks for each record type

  • Share or send template/workbooks to other CloudExtend users

  • Save and store shared templates in your template library

  • Check out this article on how to share CloudExtend templates with others

βœ… Tip 6 - Burst Upload (Enterprise Users)

If you are working with a large data set or want to send data simultaneously to NetSuite from one sheet to another, then the Burst upload feature is for you.

  • Use when uploading a large number of lines or records (example: a 5,000-line Sales Order, a 10,000-line Journal Entry, or thousands of individual transactions)

  • You can continue working in Excel and even submit other CloudExtend jobs while your job is processed in NetSuite in the background

  • You can even save the file and close Excel. The next time you open the workbook you will be notified of the status, and you can update your workbook with the latest results from CloudExtend

  • Learn more about the Burst Upload feature here

βœ… Tip 7 - Maximum Performance

Change your scripts and workflows

When a user builds a workflow, they often only want it to run in the NetSuite UI. Because only one record is updated at a time the performance impact appears minimal. If, however, your workflow is also running in the context of SOAP web services it can dramatically slow down an upload because it will run on each record uploaded via CloudExtend.

Check with your admin or developer and see if it's possible to de-select SOAP web services in your workflow or your script.

Did this answer your question?