How can I get the total weight of an item fulfillment

AI generated answer (using internal Slack threads):

To get the total weight of an item fulfillment in NetSuite, you can use a saved search with a formula. The formula would be

{item.weight}*{quantity}

. This formula multiplies the weight of each item by the quantity of that item in the order, giving you the total weight for the order. Here's a step-by-step guide: 1. Navigate to

Reports > Saved Searches > All Saved Searches > New

. 2. Select

Transaction

as the type of search. 3. In the

Criteria

subtab, set

Type

to

Item Fulfillment

. 4. In the

Results

subtab, add a new line with

Formula (Numeric)

as the summary type. 5. In the

Formula

field, enter

{item.weight}*{quantity}

. 6. Name the formula as you wish, for example,

Total Weight

. 7. Save the search. Now, when you run this saved search, it will return the total weight of each item fulfillment. Please note that this method calculates the total weight based on the item's weight and the quantity fulfilled, not the weight entered at the time of fulfillment. If you need the weight entered at the time of fulfillment, you might need to customize your fulfillment process or use a SuiteScript to capture this information. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******