RE: SuiteQL REST API filter invoices by subsidiary

When trying to filter invoices by subsidiary via SuiteQL we get the following error:

{“type”:”https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1″,”title”:”Invalid search query Search error occurred: Field ‘subsidiary’ for record ‘transaction’ was not found. Reason: NOT_EXPOSED – Field is marked as internal for channel SEARCH\n.”,”status”:400,”o:errorCode”:”INVALID_PARAMETER”}

POST https://xxx-sb1.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql

Data: {“q”:”SELECT id FROM transaction WHERE transaction.subsidiary = 49″}

Is it possible to filter invoices by subsidiary ID?

It is not listed here: https://5603533-sb1.app.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/analytics/record/transaction.html (but subsidiary taxRegnumber is)

Laurens Rookie Asked on July 1, 2020 in SuiteTalk.
Add Comment
1 Answers

Hi Laurens,

There’s subsidiary on Transaction Line though:
https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/analytics/record/transactionLine.html

Strange that it’s not on the header but I guess maybe they flow it down to line level.

Hope that might help you.

Thanks,

Chris

Intermediate Answered on July 1, 2020.

Thanks Chris.

I can get the transaction IDS by filtering transaction lines on Subsidiary ID. But I only need the “Invoice” transactions with “status IS CustInvc:A”.

It seems this is not possible in one query.

What I can try to do is fetch all invoices via the REST API and select only the IDS that are returned from the SuiteQL query on Subsidiary ID. Very inefficient, but that should work.

Kind regards, Laurens

on July 2, 2020.

It seems this does the job: “SELECT id FROM transaction WHERE type = ‘CustInvc’ AND status = ‘A’ AND id IN (SELECT transaction FROM transactionline WHERE subsidiary = 19)”

on July 2, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.