Short description: Is it possible to combine saved search templates into 1 template without using SuiteScript? I have a wonderful table join issue that means I cannot run 1 search to get all the data I need to create a batch of pdfs. Long description: I'm creating a custom packing list form because we have made a decision to set up "kit" items as assemblies in our ERP. This was done for accounting and inventory reasons, namely having the COGS and Revenue ride with the "kit" item (normal kit items have the revenue ride with the kit item, but COGS stays on components, making reporting more difficult). Because of this I've created a flag on our assembly items being treated as kits so I know when to show the components of the "kits" for picking purposes (packing list doubles as picking ticket even though we have pick/pack/ship). I've created an item saved search template that grabs all the information I need from the order as well as has the proper join so I can get to the member items of these "kit" items so I can properly display their name/description, quantity, and bin (if they have one). This is great except for we have multiple brands that sell our products and we can list the same product with more than 1 brand. When printing the packing list, we will want the brand of the order to be referenced on the printed form. This data is stored as a field on the order record, it's a custom record select value. This is where the join issue comes into play. It's possible to create additional fields on the order record that are sourced from the brand custom record, but that seems like over engineering and will add more overhead to the form than should be required when I could simply use a join. I'm open to any thoughts on how best to approach this if anyone has done it before, or something similar.

Qualifier: Replying to only the short description. Have you looked into the SuiteAnalytics Workbooks to see if your deeper joins are available there?

I haven't. Deeper joins should be available there but can you drive an advanced PDF from them?

I just saw that one, I don't believe you can.

thanks for the thought!

Create a saved search for your main dataset and then create a second saved search for the join. You can join the 2 results set int one JSON object that you can use to generate the PDF using the N/render module.

right, but that requires suitescript. I was seeing if there was an option without that. Nevertheless this is the route I think i'm going to have to go anyways since i'll need one-off capability and batch printing capability. thanks for the snip!