Display Total of Inbound Shipment Using a Custom Field

Scenario

There is currently no standard Total field in Inbound Shipment transactions therefore, users are manually calculating the total value based on the line items' amount.

Solution

1. Create a Saved Search
1. Navigate to Lists > Search > Saved Searches > New
2. Search Title: Enter Title
3. Select Inbound Shipment
4. Click Results
5. Field:
6. Select Formula (Numeric)
• Summary Type: Select Sum
• Formula: Enter {totalunitcost} * {quantityreceived}
7. Click Available Filters
8. Filter:
• Select Internal Id
9. Click Save & Run
   
   
2. Create a Custom Field
1. Navigate to Customisation > Lists, Records, & Fields > Other Record Fields > New
2. Record Type: Select Inbound Shipment
3. Label: Enter Label
   Example: Total Item Amount
4. Type: Select Integer Number
5. Store Value: Remove Checkmark
6. Click Validation & Defaulting
7. Search: Select Custom Inbound Shipment Search
8. Click Save