Yeah we'd like to make it automatically. According to my small research, it does not seem like you can add a transaction line through a workflow?

You can use your Create Line WF action to add lines to Sales Orders