Does anyone know if there is a history table for whether an account was set to revalue at a point in time? Theres

revalue

in

account

but that's just a boolean, and I need to be able to look back at what the value was on a given period

The history is in the

systemnote

table, you can take a look if you can find that info there

Thanks @Shai Coleman! Any idea what are the permissions we need for that, because if I give it

Lists	Notes Tab

I still don’t have access to the account change records.

You need to be an admin to search all system notes, otherwise you'll only be able to see your own changes. There's also

systemnote2

which might give you more details. Try first as an admin via a SuiteQL GUI to confirm that the data is there https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/subsect_158108595525.html#Viewing-System-Notes-v2 To install a SuiteQL GUI, go to

Page: Search & Install Bundles

and search for

SuiteQL Query Tool

or alternatively

NimbusQL Full Release

Strange, so when I run this as an admin I see a bunch of data come back but nothing with

field = 'ACCOUNT.BINCLUDEINREVAL'

which according to

SELECT
	SystemNoteField.key,
	SystemNoteField.label
FROM
	SystemNoteField
WHERE lower(label) like '%reval%'

should be the key for

Revalue Open Balance

If I do a normal object search on these I do see many system notes with

Revalue Open Balance

though

You should be searching the

systemnote

or

systemnote2

tables

of course, what I'm saying is that I found the value to look for within the

SystemNoteField

table