Erpnext: Credit notes and payment reconciliation

Created on 29 Apr 2019 · 8Comments · Source: frappe/erpnext

Well, the idea is that the credit notes should appear in the payment reconciliation tool to be used against pending invoices.
I am working on a PR for this, I've already done the standalone credit note case. This is, when you have a standalone credit note and a pending invoice and you match them with the payment reconciliation tool.
But I've reached a stale point, I don't understand how does the credit notes generated against a payed invoice works. For what I can see, after the return is made, the payed invoice's outstanding amount becomes negative and the outstanding amount of the credit note is equal to zero.
So, we should be able to use the "payed" invoice (with negative outstanding amount) against another invoice, but, the question is, what should we do with the GL entries? I tryed to treat the "payed" invoice like a standalone credit note and it didn't work, so, I need some help to understand what's going on and what should I do.

I'm going to tag some members of the Accounts working group using this comment as an excuse.
@agritheory @clarkejj @umairsy @SaiFi0102

Source

Don-Leopardo

All 8 comments

Hi @Don-Leopardo. It's nice to see someone new working on the accounting system of ERPNext, so welcome. I know what you mean, there doesn't seem like there's a straight forward solution for that case, however, you can take a look at my proposal on which I am working on for v12 which can solve this problem: https://discuss.erpnext.com/t/proposal-payment-reconciliation-improvement/46873/

So the idea is to create new GL Entries rather than modifying old GL Entries to reconcile payments, invoices, credit/debit notes and sales/purchase orders

SaiFi0102 on 30 Apr 2019

Hello @SaiFi0102, that's a very nice solution to the problem, what's the actual status of it?
Anyways, I was wonder if there is a chance to do something for the meantime, like, a solution for v11, at least a partial one. What do you think?

Don-Leopardo on 30 Apr 2019

I'm working on some other features right now, hopefully in a month or 2 I'll create a PR for my that. The only way I can think of for v11 to reconcile something like that is to create a Journal Entry that references both, a credit/debit note and an invoice. Maybe you could automate that.

I'll probably develop my feature for both v11 and v12

SaiFi0102 on 30 Apr 2019

👍1

@SaiFi0102 Hi there, I just remembered this, do you have some news?

Don-Leopardo on 14 Jun 2019

Not yet

SaiFi0102 on 15 Jun 2019

👍1

@SaiFi0102 How is it going?

Don-Leopardo on 19 Jul 2019

Hey Don. I won't be working on this feature anytime soon. Let me know if I can help you in any other way :)

SaiFi0102 on 19 Jul 2019