Hi there -

We take in Sales Orders, but they sometimes sit "Pending Approval" for a while. This creates a problem when they ship in a different month from when they were ordered - using the Sales Order Date isn't correct (for us) since we want to report only when the order has been approved and shipped.

I can't seem to make this work.

I've tried:
- setting a criteria on "Date Billed" - this just hangs or takes forever to run
- setting a criteria on the date of the Fulfilling/receiving transaction, but this seems to deliver the invoice date if there is a billing schedule, otherwise it returns the correct date