I have no idea if this is possible using anything less than SAP, but below is an example of what I would like to be able to do.
I create a sales invoice for a customer for £50 to fit an oven and £500 to paint the flat. The invoice goes out and eventually the customer will pay. What I would like is to be able to link my purchases to each sale item so that when the sale is posted it also creates a £35 purchase on the contract electrician and £420 purchase on the contract decorator.
At the end of the month we could then pay each supplier what we owe (self billing style) without having to manually do anything.
I guess it is almost like having each item made up using a “bill of materials” where some of the materials are actually contract labour, but even then that would not post the purchase to the suppliers account. Am I chasing the impossible