how to pull expense line item on a bill payment search

AI generated answer (using internal Slack threads):

To pull expense line item on a bill payment search, you would need to create a search from the Vendor Bill as opposed to the Bill Payment and then link to the applying transaction of the Bill Payment. The item info is a separate sublist on the record and the bill payment is only "applied" to the header information (AP account), so you run into the multiple join limitation. Here's a step-by-step guide: 1. Create a new saved search from the Vendor Bill. 2. In the criteria section, add a new criteria for 'Applying Transaction : Type' and set it to 'Bill Payment'. 3. In the results section, add the fields you need from the Vendor Bill line items, such as 'Item', 'Quantity', 'Amount', etc. 4. Also add the fields you need from the Bill Payment, such as 'Applying Transaction : Document Number', 'Applying Transaction : Amount', etc. Please note that the item information will show at the non-Main lines and the application (bill payment information) will show only on the main lines. This is due to the way NetSuite structures its 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. ******