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

Using N/Query, I need to get the last customer invoice date for every inventory item in a given location... Can anyone help me to figure out how to construct the query?

`SELECT` 
`MAX(t.trandate) as trandate,`
`FROM transactionline tl` 
`LEFT JOIN transaction t ON t.id = tl.transaction` 
`WHERE recordtype = 'invoice' AND t.void= 'F' AND tl.location = 308` 
`GROUP BY` 
`tl.item,t.trandate` 

But it gives me duplicates... How can I get only the latest item/date ?