You can generate a Bartender label from Epicor without having to mess around with ODBC stuff.
It might be a bit easier to used the canned events like Receipt, Shipment, etc, sure but you can create the necessary bits yourself as well. The built in ones are all transaction based and what you are describing here is not.
Super High Level Overview
- Create BAQ that has all the things in it you need
- Create BAQ Report off of that BAQ
- Create Data Directives to trigger the report
Have a look at this to get started
The big appeal to this approach is that it not only works on prem, but also in the cloud*.
- After requesting that Cloud Support creates an Azure file share for you.