Sorry if this has been asked recently but is there...
# suitescript
m
Sorry if this has been asked recently but is there any way to identify all the 'hidden' currency revaluations related to a journal record? Striking out with both saved searches and suiteql/query module. Trying to delete a journal it says I can't because of related records, sends me to
...<http://sb1.app.netsuite.com/app/accounting/transactions/payments.nl?id=4626747&label=Journal&type=journal&alllinks=T|sb1.app.netsuite.com/app/accounting/transactions/payments.nl?id=4626747&label=Journal&type=journal&alllinks=T>
, so basically trying to find any programmatic way of finding this list of 'alllinks'/'payments' (which in our case is about 50 currency revaluations. These currency revaluations do not show up on the Related Record list on the journal
s
Not in the
nexttraansactionlinelink
table?
m
I don't think that's a sublist-
Copy code
rec.getSublists()
(3) ['openrecv', 'openpay', 'foreignaccts']
and
Copy code
rec.getSublistFields('openrecv')
(19) ['typekey', 'type', 'typeurl', 'ddate', 'entity', 'currency', 'tfxrate', 'cfxrate', 'balance', 'variance', 'previous', 'netvar', 'accttype', 'acct', 'origdoc', 'origline', 'kentity', 'dummy', 'isPymt']
(thank you for the response)
origdoc and tpekey on the line are both the internalid of the journal but they don't seem to be searchable fields