Report that will count the Number of Days from Invoice Creation to when the Payment was Received

1. Navigate to Reports > Saved Searches > All Saved Searches > New.
2. Choose Transaction.
3. Modify the Search Title.

4. On the Criteria tab > Standard subtab > set the following Filters:
--Type = Invoice
--Main Line = True
--Status = Paid in Full
--Date = set any date range

5. On the Results tab > Columns subtab > set the following Fields:
--Name
--Number
--Date
--Amount
-- Paying Transaction : Amount
-- Paying Transaction : Date
-- Paying Transaction
--Formula (Text) = trunc(to_number({payingtransaction.trandate}-{trandate}) )

6. Save & Run.