Custom field in Inbound shipment to display item line total

Requirement: Need a custom body field in the inbound shipment record to display the total amount of all the item line amounts.

Solution: Create a saved search that results the item line total and source it to a custom field.
Create a transaction saved search of type Inbound Shipment. Add a formula(Numeric) field with formula – {totalunitcost} * {quantityreceived}.
The summary type should be “Sum”.
In the Available filter option, select internal ID

Then create a custom field of type decimal number. Since this is an Inbound Shipment record, we need to create an “Other Record Field”.
Store Value: Uncheck
Under validation and defaulting subtab – select the saved search created.

Leave a comment

Your email address will not be published. Required fields are marked *