How do I get a saved search of all my assembly items and the components and quantities in the assembly?

AI generated answer (using internal Slack threads):

To get a saved search of all your assembly items and the components and quantities in the assembly, you can follow these steps: 1. Navigate to

Reports > Saved Searches > All Saved Searches > New

. 2. Select

Item

as the type of search. 3. In the

Criteria

tab, set the

Type

to

Assembly/Bill of Materials

. 4. In the

Results

tab, add the following fields: -

Name

(this is the assembly item name) -

Member Item

(this is the component item) -

Member Quantity

(this is the quantity of the component item in the assembly) 5. If you want to group by assembly item and sum the quantities, you can use the

Summary Type

field. Set

Group

for the

Name

field and

Sum

for the

Member Quantity

field. 6. Save and run the search. This will give you a list of all assembly items, along with their components and the quantities of each component in the assembly. Please note that if you want to filter for specific components (like in the second conversation where they only wanted to see 'Packaging Labor' and 'Mixing Labor'), you can add a

Formula (Text)

field in the

Criteria

tab with a

CASE

statement to only include those specific components. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

recently i did it by using suiteql and suitescript