We receive about 60 invoices per week that need to be paid before receipt. Do you suggest creating a prepayment for each of them. Essentially having to process them twice?
Sounds like a lot of extra work and sensitive to error.
That's why you have an ERP system. For exactly such a thing. So processing the invoice once should cover all this and netting the costside of the invoice to receipts can be done at a later time from a "open" list.
Our former 15 year old ERP system had no problems handling this.
The only way I would see that working is if it worked as follows.
Post invoice, link it to a purchase order and due to a payment term. It would automatically create a prepayment of the total amount of the the inputted invoice. Once paid. The invoice cannot be deleted or the total amount changed. Its needs to be processed.
The reason I say that is because the problem with dealing with the rest of the world is that the total amount of purchase orders often varies from the invoice for several reason. Which you cannot recuperate. We aren't all Microsoft...
So using purchase order total amounts to generate prepayments is a no no all together. You'd be stuck with constant payment differences. The amount paid, needs to come from the actual invoice.