Sales Pack - multiple credit notes to invoice (updated values based on credit notes)

[emillod]

Hello Guys,
I'm working with one of our clients on implementation of Credit Notes. I wonder whether I'm missing something.

1. Let's assume that we have Invoice with two items - Product A and Product B
2. After issuance, Client decides to issue a Credit Note, because one of the products prices was changed. He is going to the Credit Notes, choosing invoice and item list is filled with items from the invoice - that's great.
3. Unfortunately, after that he received a complaint and had to return 100% for one of the products. In such scenario he needs to issue another Credit Note, but when he chooses invoice in Credit Note, his item list is filled with products from the invoice, without changes made in Credit Note #1.

Obviously, he needs to have updated values based on credit notes already issued to that invoice. Question is whether you planning to implement it? Or maybe it's working that way and I'm missing something?

Thanks for your time.

[yuri]

Hi,

Needs a correction for the subject, as multiple Credit Notes already can be applied. It subject can be read like it's not possible.

The point of this request, is that for a new credit note the sum of the previous credit notes is not taken into accounts. If I understood correctly.

There's no plan for this at the moment. Note that Credit Notes can have arbitrary items, not necessarily matching the invoice ones. It can be tricky.

[emillod]

Yes - you're correct, it's already possible to add multiple credit notes. I'm not sure how it works in other tax systems, but in Poland there is a requirement to show item list before correct and after. As long we have one credit note to the invoice, there is no problem, because we can simply show values from invoice as item list before correct. When we have multiple credit notes, values of item list before correct will be from the previous credit note.

I wanted to ask, because if it's not possible, we'll have to code it. No problem.
Thank you for short response.

[yuri]

Do you mean that in the second Credit Note all items that were negated by the previous Credit Note should be absent? E.g. Item 1 in an Invoice. Fully negated by the first Credit Note. Then in the next Credit Note there won't be this item (it's collapsed).

[emillod]

Yes.. It should combine all changes in next credit notes.
On invoice we have 2x items A, 3x items B, on Credit Note #001 to this invoice we're removing 2x from items B, then on Credit Note #002 to this invoice we only should have 2x items A and 1x of item B.

[yuri]

This could be solved if we had references for credit note items pointing to respective invoice items. Without it, there are edge cases not allowing for reliable match.

Though even with the reference, there are possible scenarios of not reliable matching.

[emillod]

I'm not sure even how i would do it yet, but i wanted to ask whether you're planning to do something like that, because i don't want to work on it if you'll do it soon

[yuri]

Not planned for now.

The simple way: Match by product_id and tax_code_id. If every CN item is matched, then negate all matches. Otherwise, just serve an empty Item List in the 2nd Credit Note. It will prompt the user to do everything manually with a lesser risk to incidentally negate wrongly.

[emillod]

I thought about the table with current values? Which would show all items with their newest parameters. Then i would have a nice summary in invoice (because it may be different from invoice item list), thanks to that user would not have to go through all credit notes to establish final values. And i would just copy it while creating another credit note.

[yuri]

The problem is what is the current values. There's no such a construct in accounting as far as I understand it. We have Debit and Credit documents, each increase or decrease the AR balance. It's relatively simple when all items in CN are present in the referenced Invoice with the same product_id and they have the same tax_code. Then, we can infer a second CN so that it fully negates the remainder.