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?
I think the answer to your question is in the blog, see How to do a contra when a customer is also a supplier?
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.
I’m not 100% sure but I think you can add lines and add multiple invoices.
What @itmoto said may be possible. Have a look at the this:
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.
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 .
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:
yes @lubos .Thanks.Any idea when this feature will be out because it will be very helpful.