Using SuiteQL, get the cost of goods sold for each ItemFulfillment item line

AI generated answer (using internal Slack threads):

To get the cost of goods sold for each ItemFulfillment item line using SuiteQL, you would need to join the necessary tables and filter the results appropriately. However, the exact SuiteQL query would depend on your specific NetSuite setup and the data you have available. Based on the conversations, it seems that the cost of goods sold (COGS) for serialized items is linked to the specific serial number shipped on the Item Fulfillment (IF). The cost would come from the assembly build or Work Order Completion (WOC) that built the serial number on the IF. In the case of a transaction search showing Item Fulfillments with the Quantity on the IF line and the Inventory Detail of Bin and Bin Qty, it was suggested to filter the account line and use the COGS account only. This should produce one line only. Here is a general approach to get the cost of goods sold for each ItemFulfillment item line: 1. Start with a saved search of type = Item Fulfillment, Mainline = F, Tax Line = F, Shipping Line = F. 2. Add columns for Date, Doc number, Status, Line ID, Item, item:description, Quantity, Item Rate, Amount. 3. Add an inventory detail join as columns for Inventory Detail:Bin, Inventory Detail: Quantity. 4. Filter the results by the COGS Line filter to remove cogs lines. 5. Use the COGS amount column to get the amount on the cogs lines. Please note that this is a general approach and might need to be adjusted based on your specific requirements and NetSuite setup. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******