One payment for two suppliers

Is there any way in which one invoice for two suppliers can be proceeded and register only one payment? For example, common among some customers, we have a single document that will be debited from the bank for the total amount of €226.66, however, this amount corresponds to 2 invoices from 2 different suppliers:

Invoice 1 supplier 1 157.52 €
Invoice 2 supplier 2 69,14 €

Any way to record that single payment in the amount of 226.66 €?, we would solve the case, if we could transfer the open item from supplier 2 to supplier 1, but we do not want to leave any invoice open.

Hello Saul,

Can you explain the business process that leads to two invoices and one payment? If there is one payment, how does the other supplier get their payment?

1 Like

Hello Mark,

It is common that enterprises that supply water or energy invoice this way:
You receive one document that contains two invoices (with different numbers), one corresponding to the water company (e.g. Water Ltd, 157.52 €) and another one corresponding to the town hall (69,14 €) for some services.

Then, one payment is done to Water Ltd for the sum of the two invoices (226.66 €). Therefore, the objective here should be that the system registers the payment to Water Ltd for the amount of 226.66 € and the receivables amount of the town hall should be settled (normally if you register the total payment amount to Water Ltd, the invoice of the town hall would appear as pending).

Thank you in advance.

1 Like

An option is to do it like we do our credit card statements. One AP group / invoice with individual misc lines for each charge. You can assign a GL for each line… If you’re getting one bill with the same BillTo (Town of X Tax Dept), you could have one invoice with multiple lines - one for town hall, other for water. In the big picture, do you need that information for year over year analysis? Are the lines going to different GL’s? If not, I’d let them join and be done with it :slight_smile: But I’m sure someone from finance is asking!

3 Likes

Another potential option is to use Purchase Points. The main supplier is the one who receives the payment, in your example Water Ltd. Under the Water Ltd, you could add a Purchase Point called CITY:

POs and Invoice LINES can use the Purchase Point.

image

After all invoices are entered, you will get one payment for the main supplier.

5 Likes

Thanks for the options, we will try this way. Appreciate your help! :slight_smile:

1 Like