https://jira.we.co/browse/REVENG-580

REVENG-580.rb

begin
  TenantService.switch_to_rest_of_world_tenant
  account = Account.find_by_short_code("DYD9GC")
  location = Location.find_by_code("LON11")
  
  # Get billing period
  start_of_two_months_ago = Date.today.last_month.last_month.beginning_of_month
  end_of_two_months_ago = Date.today.last_month.last_month.end_of_month
  two_months_ago_range = start_of_two_months_ago..end_of_two_months_ago
  billing_period = two_months_ago_range # Invoice for December covers Nov 1 - Nov 30th
  
  # Mid month refunds created during November 
  # prevents December invoice to be generated
  # We need to archive them
  Reservation.
    where(account: account).
    where(ended_on: billing_period).
    select{ |r| r.reservable.name == "Mid-Month Move Out Refund" }.
    map(&:archive!)
  
  # Regenerate December invoice
  # We are going to generate the active invoice for December
  # and let billing finalize it.
  Invoices::InvoiceManager.new.update!(account, location, two_months_ago_range)
end

Yeah, that returns all within the range.

They are not on any invoices, they are mid month refunds with price set to 0. I pinged Dan and Michelle to get more context on how this ended up happening in the first place.

👍

👍

👍