I'm using Tim's SuiteQL Query tool and I am getting this error message due to the Due To/From Subsidiary field. Search error occurred: Field 'dueToFromSubsidiary' for record 'transactionLine' was not found. Reason: REMOVED - Field is removed

SELECT

tl.transaction                          AS internal_id,

TO_CHAR(t.trandate, 'YYYY-MM-DD')       AS transaction_date,

ap.periodname                           AS posting_period,

e.entityid                              AS entity,

sub.name                                AS subsidiary,

t.memo                                  AS header_memo,

tl.memo                                 AS line_memo,

a.acctnumber                            AS account_number,

a.fullname                              AS account,

tl.linesequencenumber                   AS line_sequence_number,

tl.id                                   AS line_id,

tal.amount                              AS amount_consolidated_currency,

tl.dueToFromSubsidiary                  AS due_to_from_subsidiary

FROM

TransactionLine tl

INNER JOIN Transaction t

ON t.id = tl.transaction

INNER JOIN TransactionAccountingLine tal

ON tal.transaction = tl.transaction

AND tal.transactionline = tl.id

LEFT JOIN AccountingPeriod ap

ON ap.id = t.postingperiod

LEFT JOIN Entity e

ON e.id = t.entity

LEFT JOIN Subsidiary sub

ON sub.id = tl.subsidiary

LEFT JOIN Account a

ON a.id = tal.account

WHERE

tl.eliminate = 'T'

AND t.posting = 'T'

AND ap.periodname = 'Dec 2025'

In Record Catalog, it shows that the dueToFromSubsidiary field belongs to a feature named "Centralized Purchasing and Billing". If it really is removed, it could be that this feature is turned off. But I wonder if it's not removed but rather that it's not accessible to the role or user running the query. Check on that too.

Yeah it was due to that feature