Scenario: To confirm the weight per item in transaction records such as Sales Order or Item Fulfillment, customers would like to expose the Item Weight field. However, there is no standard way to show this field in transaction records.
Solution: Exposing the Item Weight field in Transactions is logged as an enhancement request under Enhancement # 20387 -Transactions> Display total weight of items on transactions
In the standard NetSuite Account, an Item Weight field is not available in Sales Order or Item Fulfillment records. But a custom field may be created for it. Otherwise, another option would be installing the Bill of Lading bundle wherein the Item Weight field is available.
If users do not want to install the bundle, here's how to create a new custom transaction column field for Item Weight:
- Navigate to Customization > Lists,Records, & Fields > Transaction Line fields > New
- Assign a label
- Type is Decimal Number
- Store Value is True
- In Applies to tab, mark Sale item and Item Fulfillment (Note: The weight should show on the Sales Order then show on the Item Fulfillment when processed.)
- You can add Values in fields under the Validation and Defaulting tab if needed
- Under Source & Filtering tab, Source list is Item and Source from is Weight
If users prefer to install the Bill of Lading, it is documented in SuiteAnswers ID 93980. With this bundle installed, you can see that custom fields are added to the Item Fulfillment page including Item Weight. SuiteAnswers ID 93986 - Custom Fields on Item Fulfillment Page enumerates the custom fields added to the Item Fulfillment transactions.