https://netsuiteprofessionals.com logo
s

Suitestallion

03/23/2022, 4:40 PM
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

Chris Corcoran

03/23/2022, 5:12 PM
@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

Suitestallion

03/23/2022, 5:14 PM
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

Sam-I-Am

03/23/2022, 7:11 PM
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

Suitestallion

03/23/2022, 7:18 PM
I can see those IDs in NS but it gets null when i download it to excel
c

Chris Corcoran

03/23/2022, 7:19 PM
@Suitestallion can you send a screenshot of your results tab (the definition)?
s

Suitestallion

03/24/2022, 1:48 AM
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