How to adjust supplier outstanding amount using new invoice?

1

We have a requirement and still not sure if we can achieve this using current system.

We have supplier A from whom we have purchased products of Rs 5000 now in turn supplier A has purchased some products from us worth Rs 4000. So ultimately we should pay Supplier A only Rs 1000.

How can we achieve this?

2

I think the answer to your question is in the blog, see How to do a contra when a customer is also a supplier?

3

Thanks @itmoto. But the problem it that I have to pay Rs 5000 (more than 10 invoice of RS 500, 700, 1000, 1900 etc.) to supplier A.

The option mentioned in the blog is only for matching 1 sales invoice with 1 purchase invoice so the solution is not applicable to my case.

4

I’m not 100% sure but I think you can add lines and add multiple invoices.

5

What @itmoto said may be possible. Have a look at the this:

6

The example described in the blog is simple but the same principle applies when you need to match multiple sales invoices with multiple purchase invoices.

7

Dear @lubos as i said it is possible with the method which you told but I am asking is it possible to pay in a single go (on total amount) ? or any plan in future for this ?

@Michael_Links : Thanks for replying.And yes i have asked the same if we can group multiple purchase invoices per supplier to pay off in one go to @lubos .

8

There is no easier way than this right now. In future, it will be possible to do this transactions in more automated way, see another feature request which is a bit related:

9

yes @lubos .Thanks.Any idea when this feature will be out because it will be very helpful.