Create accounting customer from manual billing rows and send alert

Your billing query returns incomplete customer details, causing reconciliation work and delayed invoices. It links or creates customer records and alerts billing so invoices process the same day.