I can give you few steps to do this…
So, as the starting point, use the form that you are using to input the billing date for the process.
Now, have another workflow that logs in to the application
Next workflow, will navigate from the lading page to the page where you need to extract data from.
The next part is, include a data scraping activity that will scrape the data from the table you have in the application. This data scraping will give you a datatable variable… This also has the capability of extracting URL’s from links so that it can be used later
What you can do now is, you can use a filter datatable activity to filter the data for the date you entered in the initiation part.
Now, check for the row count to make sure you have the record you filtered for…
This can be done using DT.rows.Count check to check the number of rows.
If you have more than 0 rows, now, use the Navigate To activity to navigate to the link
hope it helps