Get list of negative recurring invoices

gistfile1.txt

negative_recurring_invoice_profiles = []
count = RecurringInvoiceProfile.active.count
progress = ProgressBar.new(count)

RecurringInvoiceProfile.includes(
  :company,
  :contact,
  {recurring_invoice_profile_items: [:general_ledger_account, :company]},
).active.find_each do |recurring_invoice_profile|
  if recurring_invoice_profile.value.total.negative?
    negative_recurring_invoice_profiles << recurring_invoice_profile
  end
  progress.increment!
end