[eleran]

My search-fu is fairly strong but I need some help on this one.

I have been asked to create a search to determine how many orders in the previous month were shipped complete. I can calculate fill rate but that is not exactly the same thing.

Any help would be appreciated.
This is a cached copy. Click here to see the original post.

[michoel]

If the Sales Order is complete and there is only one Fulfilment against, that should indicate that it was shipped complete.

Something like this should give you a list of all completed Sales Orders from the previous month, and how many shipments they were sent in:

CriteriaType is Item Fulfillment
Main Line is true
Created From : Type is Sales Order
Created From : Date is within last month
Created From : Status is any of Sales Order:Billed, Sales Order:Pending Billing

ResultsCreated From, Summary Type = Group
Internal ID, Summary Type = Count

[Author]

Posts