need to create a suiteql query that gets all the lines of bills that don't have any custom record 'landedcost' asociated with. the relation for it is with the bill line value landedcostcategory and the custom record is custrecord_mc_landedcostcategory and the relation with the bill id is custrecord_mc_landedcostbill

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you are trying to create a SuiteQL query that gets all the lines of bills that don't have any custom record 'landedcost' associated with them. The relationship is with the bill line value 'landedcostcategory' and the custom record is 'custrecord_mc_landedcostcategory'. The relationship with the bill id is 'custrecord_mc_landedcostbill'. Unfortunately, the conversations provided do not contain a specific example of a SuiteQL query that meets your exact requirements. However, they do provide some insights on how to approach this problem. 1. You might need to use a JOIN clause in your SuiteQL query to connect the relevant tables and fields. This is suggested in the first conversation where a user is trying to join the 'Transactionline' table with another table to get tax information. 2. You might need to use a CASE statement in your SuiteQL query to filter out certain records. This is suggested in the second conversation where a user is trying to exclude bills that include a specific 'sales tax' expense account. 3. You might need to use the 'main line' field in your SuiteQL query to filter out certain records. This is suggested in the third conversation where a user is trying to get POs that are open and have a bill associated with them. Please note that these are just suggestions based on the conversations provided and might not work for your specific use case. You might need to adjust these suggestions based on your specific requirements and the structure of your NetSuite data. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******