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

In Netsuite, the WO screen has a filed {assemblyitem} which is obviously the Assembly item to be built on the WO.  If I try to use {assemblyitem} in the SQL query, the field is not found.  What am I doing wrong here?

You need a join. Share your query so far 

```SELECT					
WorkOrder.transactionnumber as WO,
WorkOrder.startdate as 'Start',
--   WorkOrder.assemblyitem,
WorkOrder.enddate as 'end',
BUILTIN.DF(WorkOrder.custbody_wo_so.id) as WOSO,
BUILTIN.DF(WorkOrder.entity) as Customer,
BUILTIN.DF(WorkOrder.custbody_wo_picking_status) as Status
FROM 
	Transaction as WorkOrder
WHERE 
	( WorkOrder.Type = 'WorkOrd' ) 
and (WorkOrder.custbody_4_work_centre=114554)```

The item info for the finished good (assembly item) is in the `transactionline` table where `transactionline.transaction = WorkOrder.id` and `transactionline.mainline = 'T'`