Getting Transaction Location in Multi location inventory.
Hello, I am building a Netsuite integration, more specifically we are using the REST endpoints and SuiteQL to pull Netsuite data.
Some of the data we are interested in are Purchase Orders (stored as Transactions), however we need to filter those POs based on their location. In the Netsuite UI we can see this information in the Classification section, when I fetch a specific order through REST it’s also visible. However when trying to find the associated location of a Transaction through SuiteQL I cannot (I am using the Record Catalog to try to find it). Any hints how to do that??
You should be able to see location on transactionline.
Thank you! Got an answer from the Slack channel. Apprently I can join with mainLine = 'T' transaction line which is a 1-1 relation and has the Location info
Great. One thing to add is that I think that will bring you the location if it is set at header level.
If you have locations set at line level then you will need to look at the other lines.
