This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

hey guys! does anyone know how to search for a transaction which has a sublist that contains my filter value?

Try building a saved search or dataset in the UI and exporting it to code with the Saved Search / Dataset Export Chrome extensions.

i want to do this from a suite script; more specifically, i'm trying to find linked transactions to the journal that i'm trying to delete

this is the error that im getting
```This transaction cannot be deleted because it is linked to by one or more transactions. Click app/accounting/transactions/payments.nl?id=9999999&amp;label=Journal&amp;type=journal&amp;alllinks=T```

Build a saved search in the UI. This will help you formulate what filters are needed to get the correct transaction. Once the UI search works, you can do the same via script.

I guess before you even do that, find which transaction is linked using the UI.

If you can find this use case in the sandbox, try causing the same error, finding the linked transaction, then you will understand what need to be done... if other transactions should be deleted, unlinked, or what have you

i cannot create a saved search that shows currency revaluations affecting a certain journal

couldn't find anything in the dataset fields; only nexttransacionlink and prevtransactionlink and those dont link back to original journal

I don't know the accounting side of things. That's how I would figure out where the linkage is

i'm not into that either, but i cant find the data link either