Hi. Just started getting errors in a script using a assembly suiteql query running in a 2024.2 environment:

Record 'bomAssembly' was not found.

Looking in the Record Catalog on the "bom" the join to "bomAssembly" is no longer there but assemblyItemBom and/or itemAssemblyItemBom is. Looking in a 2024.1 environment the join is still possible. Can't find any information about this, has anyone come across anything similar where a "record" disappear in SuiteQL?

Is there a feature that's not enabled? The records and columns available to SuiteQL can be different depending on which features are enabled/disabled.

yes, I have this same problem; they have definitely changed the joins in 2024.2

The thing is that it worked before updating to 2024.2. Netsuite should not turned of any features when upgrading🤞 and I cant see that anything been switched of. @Sandii Have you been in contact with Netsuite about this?

No it’s a changed schema, I’ve changed the queries