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

How can I get standard costs for inventory items and assemblies in suiteql?

You should be able to use the aggregateItemLocation table for this

select
  i.id,
  i.itemid,
  i.displayname,
  a.cost,
  BUILTIN.DF(a.location) as location
from
  item i
  INNER JOIN aggregateItemLocation a on i.id = a.item
where
  i.id = @itemId