This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Team, anyone knows how to access the Item Receipt landed cost allocation data from SuiteQL?

See list of all the records/fields in NetSuite in Excel format, and whether they are available in SuiteQL.
<https://nlcorp.app.netsuite.com/core/media/media.nl?id=127972055&amp;c=NLCORP&amp;h=34f6d25f34ab89fef9af&amp;_xt=.xls>
You might be able to find it there

<@U02BCAJ0BUZ> no luck, could not find any landed cost info on the tables there. Useful excel though, thanks a lot

I see landed cost info, like cost category and amount on some lines on the transactionline record

what I am missing is the relationship between an amount/cost category and the Item Receipt line