As @JohnHanrahan said, providing specific details about what you need will help us to help you.

Based on what you mentioned, you might want to try Sales Order>Insights >Explore>Sales Order Lines. You can filter based on the following combination:

1. STATUS ... IS EQUAL TO ... OPEN
2. PROMISED ... IS ON OR BEFORE ...<your cutoff date, likely the current date>

Depending on how you are populating the field in "Enter Sales Orders and Quotes" you may want to substitute the REQUESTED or SHIP DATE field for PROMISED.

• PROMISED: date you promised the order to the customer
• REQUESTED: date that the customer has requested to take delivery 
• SHIP DATE: date that the order is scheduled to be shipped

As @JohnHanrahan said, providing specific details about what you need will help us to help you.

Based on what you mentioned, you might want to try Sales Order>Insights >Explore>Sales Order Lines. You can filter based on the following combination:

1. STATUS ... IS EQUAL TO ... OPEN
2. PROMISED ... IS ON OR BEFORE ...<your cutoff date, likely the current date>

Depending on how you are populating the field in "Enter Sales Orders and Quotes" you may want to substitute the REQUESTED or SHIP DATE field for PROMISED.

• PROMISED: date you promised the order to the customer
• REQUESTED: date that the customer has requested to take delivery 
• SHIP DATE: date that the order is scheduled to be shipped