Is there a way to create a report of the number of...
# beginnersb
Brandon Hunt
07/06/2023, 1:50 AMIs there a way to create a report of the number of orders fulfilled by each location organized by Date of fulfillment
m
MGBC
07/06/2023, 2:15 AMHow many locations do you have
MGBC
07/06/2023, 2:16 AMIf you don’t have a lot you can make a fun little pseudo-pivot table in a saved search
b
Brandon Hunt
07/06/2023, 2:27 AMJust two
m
MGBC
07/06/2023, 2:28 AMOk
MGBC
07/06/2023, 2:29 AMTry this
A transaction search with this criteria
Type = Item Fulfillment
Status = Shipped
Main Line = True
MGBC
07/06/2023, 2:32 AMIn the results do
Date - summary type Group
Formula (numeric) - CASE WHEN {location} = ‘Location A’ THEN {internalid} END summary type Count
Formula (numeric) - CASE WHEN {location} = ‘Location B’ THEN {internalid} END summary type Count
MGBC
07/06/2023, 2:33 AMThen you can sort by date descending
MGBC
07/06/2023, 2:33 AMOr add a date filer of last week, last month, whatever works
MGBC
07/06/2023, 2:36 AM(I guess this is assuming you ship 1 IF per sales order
MGBC
07/06/2023, 2:37 AMBut also sometimes it’s nice to capture partial shipments
b
Brandon Hunt
07/06/2023, 2:37 AM1 IF per order is preferred but not always 100% but this with partials is a good start
m
MGBC
07/06/2023, 2:39 AMYou could also do CASE WHEN {location} = ‘Location A’ THEN {created from.id} END
This will count the SO related to the IF instead of the IF itself
b
Brandon Hunt
07/10/2023, 8:59 PMTHis worked for me thanks all
m
MGBC
07/10/2023, 9:11 PM👍