We need to find all the receipts that are in Awaiting Processing state so we can find out why they're stuck in this state and fix it, how can we get that?

You can use Analytical Reports functionality to get a report of all the receipts and then filter them based on the processing state. To do that, you can follow these steps:

1. Login to your SAP Ariba realm.
2. Click Create.
3. Click Analytical Report.
4. Choose the Main Fact as Receipt.
   • You can set the other fields such as Title, Description, etc.
5. Select a field from the Available Measures section.
   • Click on the desired field.
   • Click on Add to Report.
   • You need at least one field.
6. Click Next.
7. Click Next.
8. Check the box Advanced Options.
9. Check the box Include data with dates not set (unclassified).
10. Set any other fields you need, e.g. Time Period.
11. Click Run Report.
12. Click on Aggregate View and select Detail View.

This will show you the receipts with their processing state and you can save, export, and filter the exported results to use them.

Purchasing > Receiving
Purchasing > Receiving > Receipt Import/Export