See different ways of creating a record using CloudExtend.
In this guide, we will use the Journal Entry records type, the same logic applies to other transaction records (Invoice, Vendor Bill, Expense report etc.)
Creating One Record
Creating One Record with multiple lines
Creating Multiple Records
Create One Record
π‘ Tip: To create one record. You may use the trandate field, enter the same trandate value, and all the lines along with it will be created as one record in NS.
Creating a new entry based off an existing records from NetSuite
If you have an existing journal entry you want to recreate, get the internal ID from NetSuite and put the internal ID values in the internalID cell. Hit Reload Records then Reload Records, this will pull the latest data of that record, then do the following:
Step 1: Clear out internalID and tranID fields and update other header fields such as Transaction Date and line level debits and credits.
Because the internalId is now empty, this will create a new record in NetSuite.
The tranID by default is automatically generated by NetSuite, clear it out to avoid duplicates.
Step 2: Click to Upload to NetSuite > Upload Records to create a new record.
If the internal ID is returned and is highlighted green, it means the new journal entry has been created successfully (yay for you).
Creating One Record with multiple lines
Copy/paste data prepared from other systems
If you have data from other systems, you can prepare them beforehand and easily use the copy/paste feature of Excel and you are ready to upload to NetSuite in a few clicks!
Manually key in data using picklist to get the values from NetSuite
You can create records from scratch. Make sure to have all the mandatory and necessary fields to populate loaded into the template. Picklist values are available for list data type in NetSuite.
Picklist Feature
Use the picklist feature to select items from the list.
Type Data into the sheet
CloudExtend Excel dynamically identifies picklist values while you type data into the sheet and tab/enter off the cell. Just put in the part of the name, no need to remember or look up the Ids.
π Click here to learn more about the pick list feature!
Creating Multiple Records
To create transactions with multiple lines (line-level detail) ensure that all header level fields are identical.
π‘ Tip: As long as another header field is different NetSuite will recognize it as a new set of record.
Using Trandate Field only
For this example, there are 3 different header values. There were three records created in NetSuite.
Using Trandate and Memo field
π‘ Tip: To create multiple records, we can use memo and other header values to split and create multiple records.
The first 6 lines have the same trandate and memo values which equates to one Journal Entry.
The last 3 lines have the same trandate and memo value which created a separate Journal entry.
Internal Ids highlighted in green means a successful push to NetSuite.
π Learn about the other error notification, when uploading records to NetSuite here.