Anyone seen that you can see certain values (inter...
# administration
s
Anyone seen that you can see certain values (internal id) on the search but when you download it in excel you get blank, null or error
c
@Suitestallion I've seen this before and worked around this by creating a formula (in my cases text) instead of referencing the field name. In the formula below there are four single quotes and when this is exported to Excel it forces the Zip code to have a single quote in front of it. The use case here is to make sure leading zeros don't get stripped off. Maybe this helps in your case? CONCAT('''', {zip})
s
Thanks, yes I will pass it along , we are missing internal ids for the item which is basic/primary for any item in NetSuite
s
Internal ID's are the database key for any records or object in NS. You can see this id in the URL of that record too. I am wondering you should not be having any issue with the internal id since they are system generated and cannot be modified. Most likely you are using a custom id field as internal id. Check this by going to preference and set the show internal ID option.
Note without internal ID nothing in NS would work
s
I can see those IDs in NS but it gets null when i download it to excel
c
@Suitestallion can you send a screenshot of your results tab (the definition)?
s
I apologize I should have been clearer they were looking for member item internal id, but the thing I don't get is if they can see it in NetSuite on the screen then why the heck it doesn't download