Important – This report must be done in Salesforce Classic as the joined report function is not available yet.
Step 1
Create a report for ‘UPS Shipments with Order’
Step 2
Select Report type ‘Joined’. This will allow you to add other relationships to the report.
Step 3
Click add report type
Step 4
Add a new ‘Orders with Products’ Report type.
This is what you should see
Step 5
Remove order number from each of the reports
Step 6
Add order number into here:
Step 7
Add the following filter:
Order: Status equals “Activated, Replacement Shipped, Replacement received, Delivered”
Step 8
Save the report
Final Result
