Related industry post, seemingly of pre-batch ERPNext era, discussing alternative approaches to solving similar problem -