Magnus von Koeller magnusvk
magnusvk
/ commercial_invoicing_data.rb
Last active
May 21, 2025 21:45
— forked from victor-tremendous/commercial_invoicing_data.rb
Pull commercial invoicing data
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| content = CSV.generate do |csv| | |
| csv << ["Program ID", "Program Name", "Master Organization ID", "Master Organization Name", "Organization ID", "Organization Name", "Schedule", "Credit Limit", "Credit Limit Note", "Last Invoice Created At", "Last Invoice Number", "Last Invoice Amount"] | |
| InvoiceAccount | |
| .includes({organization: [:program, :master_organization]}, :invoices) | |
| .commercial | |
| .active | |
| .order("programs.name", "organizations.name") | |
| .each do |invoice_account| | |
| organization = invoice_account.organization |