hey guys! how could i get this information in a suitescript? tried search with applyingtransaction, analytics query, but nothing seems to work; i'm trying to delete some journals, but i get the

This transaction cannot be deleted because it is linked to by one or more transactions. Click

error; now i want to delete this currency revals, but i'm not able to achieve this. seems like noone was able to solve this...

Maybe Because you need to delete the reversal currency revaluation Whe you have unrealized currency revaluation at the end of the month , you have another currency revaluation the first day of the next month Have u try to delete the currency revelation by UI ?

that works, but i have thousands of journals to delete and i cannot do this manually

JE's will have related records that wont allow you to delete until related records are removed

yes, i understand that; how can i find them in a suite script?

You can make saved search for related records and run that in the search

how do i create such a saved search? applied to transaction field didn't work for me

What is the type of currency revaluation ? Realized or unrealized ?

unrealized

maybe not accessible in saved search criteria then?

Open unrealized currency revaluation and launch the Netsuite field explorer Look if you find something

is there any way that i can find if there's any transactions where 'openrecv' field contains the journal i'm trying to delete?

Maybe in another sens Create saved search on JE and search if you have related record type = currency revaluation unrealized

there's no criteria for related record type

Applying transaction …type = currency revaluation Or try applied to transaction…type = currency revaluation Search applying or applied to… ( join )

idk if im looking in the wrong place, but there's no filtering by type

On the end of your list Search applied to… ( with the …)

what am i doing wrong? the id is the journal affected by the currency revals

Put the id of your JE in criteria And in the result add applied to transaction ( without …) and applying to transaction ( without…) Check the result and if you have currency revaluation

this is what i get

9960654 is the id of your JE ?

yes

otherwise take the id of your currency revaluation and check the result

all i get is the reversal of the currency reval, but nothing about the inital JE

I send you a message