Suite Script 2.0 - Handling Duplicate Fields in Saved Search

Question

I have a Transaction's saved search, in which I have used Account fields three times with custom label. please see attached screenshot.

but when pulling data for this saved search using suite script 2.0, netsuite returns first account field as 'account', second as 'account_1' and third as 'account_2', please see attached screenshot of json output

So I am not able to determine which account is 'Account Two' and which one is 'Account Three' (based on my screenshot), and this is causing my mapping screen failure.

Can anyone please help me regarding this.

Thanks in advance.

I think here it is showing as Account_one as Account and Account_two as Account_1 and Account 3 as the Account_2.. Please try to get the values from of account records in script and match it with your Account records.. You can easily find out... — Phanikumar Jatavallabhula, Aug 14 '18 at 12:15

score 1 · Answer 1 · answered Aug 14 '18 at 20:44

1

Is your saved search filtering (criteria) for Main Line?

answered Aug 14 '18 at 20:44

dcrs

294
1
4

No, currently I don't have any filter on my saved search – umesh shukla Aug 17 '18 at 04:23

score 0 · Answer 2 · answered Jun 01 '21 at 18:30

As per your screenshot, here is which one is which saved search column

Account is first occurance - (with no label)
Account_1 is the 2nd occurance of the same field (with Label Account Three)
Account_2 is the 3rd occurance of the same field (with Label Account Two)

Suite Script 2.0 - Handling Duplicate Fields in Saved Search

2 Answers2