Scenario
The user would like to calculate the item's weight by quantity * weight per line in Sales Order transaction.
Solution
1. Navigate to Customization > Lists, Records, & Fields > Transaction Columns Fields > New.
2. Set the following:
- Label = Item Weight
- Type = Decimal Number
- Store Value = False
3. Under Applies To tab, mark the Sale checkbox.
4. Under Sourcing & Filtering tab, set:
- Source List = Item
- Source From = Weight
5. Click Save. Take note of the ID created for this custom field.
Note:
It is not yet possible to directly source the item's weight through field or formula. This will result an empty value on your field. This is being tracked under Enhancement #142605.
6. Click New to create another custom column field with the following setting:
- Label = Total Weight
- Type = Decimal Number
- Store Value = False
7. Under Applies To tab, mark the Sale checkbox.
8. Under Validation & Defaulting tab, set:
- Default Value = {quantity}*{ID from Step 5}
- Optional: You may try {quantity}*{ID from Step 5}/1000 to get the KG value conversion
- Formula = T
9. Click Save.
Reminder
The user needs to save the sales order record first before getting the calculated value from Total Weight field.