Find Orders Sent to One Supplier That Are Older Than 10 Days
Summary
There is no single saved view for this, but you can build it on the Fulfillment Requests page by combining the Sources filter with an Older Than filter on the date the request was generated. The Orders page can narrow by supplier and open status, but it has no 'older than' option on the Sources side that ties to the supplier's request.
Flxpoint does not have a one-click 'open orders older than 10 days for one supplier' report. You can build it yourself with filters. The most direct way is the Fulfillment Requests page, because each row there is one request sent to one supplier (source).
Flxpoint has no status called 'open' for a fulfillment request. Orders have an Open status, and fulfillment requests have their own statuses (for example Unprocessed, Processed, Acknowledged). You choose which of those count as 'still open' for you.
- Go to Orders, then open the Fulfillment Requests tab at the top.
- In the filter panel on the left, open Sources and select the supplier.
- Under Fulfillment Request Statuses, select the statuses you treat as still open, such as Unprocessed, Processed or Processing Error. Leave Acknowledged, Canceled and Voided unselected if you want to skip those.
- To drop requests that already shipped, open Shipment Statuses and select Awaiting Shipment and Partially Shipped.
- Click the + (Add filter) button above the table, choose the field Generated On, choose the condition Older Than, enter 10 and pick Days.
The table now lists that supplier's requests generated more than 10 days ago that match your status choices. The default columns include the request status, Generated On, the order number and the source name. You can save the combination with Saved Filters in the left panel so you can reuse it.
- Go to Orders.
- Under Order Status, select Open.
- Under Sources, select the supplier.
- Click + (Add filter), choose Ordered On, choose Older Than, enter 10 and pick Days.
This age is counted from when the order was placed, not from when the request was sent to the supplier. If you want the age of the supplier request, use the Fulfillment Requests steps above. Imported On is also available if you want to count from when the order arrived in Flxpoint.
- The Start Date and End Date pickers at the top of each list are for a date range. For a rolling 'older than N days' rule, use the Older Than condition, which does not need updating each day.
- You can also pick Within Last or Between in the same filter if you need a different window.
