I am in trying to find a way to pull ItemReceipt a...
# suiteql
e
I am in trying to find a way to pull ItemReceipt and its landed cost data using SuiteQL. I am using Tim Dietrich's SuiteQL tool in NetSuite. He has a table lookup reference, but when I use his query, I am getting an error:
Copy code
SELECT
    LandedCostItem.id,
    LandedCostItem.name
FROM
    LandedCostItem;
S*earch error occurred: Record 'LandedCostItem' was not found.* How do I get from ItemRecept to landed cost? Which table landed cost is stored in?
e
Make sure the SuiteQL script is running as a user/role that has permission to see that table.
e
I am Administrator. What table is it? Does this query returns data for you?
e
I see the same thing. I see the table but cannot retrieve anything from it - Search error occurred: Record 'LandedCostItem' was not found.