How to know if an invoice is refunded (has a credit note associated)?

91 views
Skip to first unread message

Sergi Almacellas Abellana

unread,
May 28, 2013, 7:15:13 AM5/28/13
to try...@googlegroups.com
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,

We are using account_invoice module to track invoices for our company.
One problem that we are facing is that we don't know if and invoice
has a credit note related, and we aren't able to cancel the invoice as
it's already confirmed.

So we get refunded invoices with amount to pay greater than 0, but it
hasn't to be paid because it has and credit note that compensates de
amount.

How do you track this use case?

For us that will be two solutions of this case:

1. Add a new states to invoices to know that has a related credit note.
2. Show in amount to pay from both (invoice and credit) invoices 0.0

Any thoughts?

- --
Sergi Almacellas Abellana
www.koolpi.com
Twitter: @pokoli_srk

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJRpJG9AAoJEGRfwiQCVal5VHIH/iV/xl0/CiFYrTvyZEgaEJ/B
XCaQJoV7R7sd6Rwm8w179S3yJZW4/OHMFydYyMeijsCbp3yNdtN4ZySEthZCb9Ol
XBmftVZOxaXvvIjsKYR8P5bGK1vtg8wAd/5fqfLb5QIN7unNKTQKPpWw3nHkDGN/
WeX6zVIq5AYsmrAcOs5FkPPYNPNlMin3Yqx0Dnm5KOqpJmnSpbx8aAXK4kctJsJF
njf0QgLfQ/wANVE41vdyfkOF/tC5eP2OtntlmkEynpNBNcAwqhokZsw87DlK2nsc
bOs0oL1rDjyTFqkODVNcweX9YIxbna2DY75/WHrOF8K/C/5RJX8xoxsPjXpx+M4=
=QS9W
-----END PGP SIGNATURE-----

Cédric Krier

unread,
May 28, 2013, 7:55:38 AM5/28/13
to try...@googlegroups.com
On 28/05/13 13:15 +0200, Sergi Almacellas Abellana wrote:
> Hi all,
>
> We are using account_invoice module to track invoices for our company.
> One problem that we are facing is that we don't know if and invoice
> has a credit note related, and we aren't able to cancel the invoice as
> it's already confirmed.
>
> So we get refunded invoices with amount to pay greater than 0, but it
> hasn't to be paid because it has and credit note that compensates de
> amount.
>
> How do you track this use case?
>
> For us that will be two solutions of this case:
>
> 1. Add a new states to invoices to know that has a related credit note.
> 2. Show in amount to pay from both (invoice and credit) invoices 0.0
>
> Any thoughts?

Just refund the credit note which means reconcile the lines.
Second, you have to look at the "amount to pay" to really know how much
a customer owns you.

--
Cédric Krier

B2CK SPRL
Rue de Rotterdam, 4
4000 Liège
Belgium
Tel: +32 472 54 46 59
Email/Jabber: cedric...@b2ck.com
Website: http://www.b2ck.com/

Sergi Almacellas Abellana

unread,
May 28, 2013, 9:48:17 AM5/28/13
to try...@googlegroups.com
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Al 28/05/13 13:55, En/na Cédric Krier ha escrit:
> On 28/05/13 13:15 +0200, Sergi Almacellas Abellana wrote:
>>> Hi all,
>>>
>>> We are using account_invoice module to track invoices for our
>>> company. One problem that we are facing is that we don't know
>>> if and invoice has a credit note related, and we aren't able to
>>> cancel the invoice as it's already confirmed.
>>>
>>> So we get refunded invoices with amount to pay greater than 0,
>>> but it hasn't to be paid because it has and credit note that
>>> compensates de amount.
>>>
>>> How do you track this use case?
>>>
>>> For us that will be two solutions of this case:
>>>
>>> 1. Add a new states to invoices to know that has a related
>>> credit note. 2. Show in amount to pay from both (invoice and
>>> credit) invoices 0.0
>>>
>>> Any thoughts?
> Just refund the credit note which means reconcile the lines.

Perfect, that worked. I have both invoices payed and amounts to pay
correctly. Thanks.

So if we want to do this automatically we have to develop it in a
separate module as it's not a standard behaviour, Am I right?



- --
Sergi Almacellas Abellana
www.koolpi.com
Twitter: @pokoli_srk

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJRpLWhAAoJEGRfwiQCVal5D3oH/iZp0/ykNkzCuMkD0kX2tRG8
JPr0C4GOelvkEpt/o/TArJKwb3pNTBSYSollwrzpKxNc+rOZUkIXa/y4ltaTs42l
59q+7oEoXqyvUJ1i+gHgMVNXc3UxOSEG+x3QK8ax/c61/ONfWGGwNgIEG2Ym+CzO
t3gZE/EnmWgsmmeFMvDUtgiDhpuDsWeiVk+viP1Bt+hyg5PGXWv4WTG0oZzQ8inj
M6Y3G5yoMZtZHKIfJ64GQYX7CKtx2u5tXpvPU9dncid+ShMKHkiY1fsaJCDcdX3G
nsx7odnZf7i7CRz92jnCk6GOftbqwwBaUH3iggs8Im9l7Jmbe+y1XH63EHsqrWo=
=huoj
-----END PGP SIGNATURE-----

Cédric Krier

unread,
May 28, 2013, 10:08:14 AM5/28/13
to try...@googlegroups.com
On 28/05/13 15:48 +0200, Sergi Almacellas Abellana wrote:
> So if we want to do this automatically we have to develop it in a
> separate module as it's not a standard behaviour, Am I right?

No need to develop, on the credit wizard, there is a check box for
refund.

Ossi Viljakainen

unread,
Dec 17, 2015, 3:43:40 PM12/17/15
to tryton


On Tuesday, May 28, 2013 at 4:08:14 PM UTC+2, Cédric Krier wrote:
On 28/05/13 15:48 +0200, Sergi Almacellas Abellana wrote:
> So if we want to do this automatically we have to develop it in a
> separate module as it's not a standard behaviour, Am I right?

No need to develop, on the credit wizard, there is a check box for
refund. 

So what actually happens, when you check the box "refund"? And what happens if I don't check the box?

Use case:
A sale has been created, confirmed and processed, and it has generated an invoice. The invoice has been posted and sent to customer. After receiving the invoice customer cancels the transaction, but no goods have been shipped, and the invoice has not been paid.

So in this case, using the action wizard "Credit" -> "credit invoice" and leaving the "refund" unchecked, will just create an opposite transaction (a credit note) with negative sales & tax lines. 
1. Will it also create associated stock moves?
2. What is the difference whether "refund" is selected or not?

-Ossi

Cédric Krier

unread,
Dec 17, 2015, 7:25:04 PM12/17/15
to tryton
On 2015-12-17 12:43, Ossi Viljakainen wrote:
> So in this case, using the action wizard "Credit" -> "credit invoice" and
> leaving the "refund" unchecked, will just create an opposite transaction (a
> credit note) with negative sales & tax lines.
> 1. Will it also create associated stock moves?

No you have to cancel the shipments.

> 2. What is the difference whether "refund" is selected or not?

It will just reconcile the credit note with the original invoice.

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Website: http://www.b2ck.com/

Ossi Viljakainen

unread,
Dec 18, 2015, 4:24:09 AM12/18/15
to tryton


On Friday, December 18, 2015 at 1:25:04 AM UTC+1, Cédric Krier wrote:
On 2015-12-17 12:43, Ossi Viljakainen wrote:
> 2. What is the difference whether "refund" is selected or not?

It will just reconcile the credit note with the original invoice.

When "refund" is selected, it will reconcile? In that case the text is very unclear.
Again, the user's manual would be much needed! :)

I like this suggestion by Okko, which he had posted in 2011 on this list: 

On Monday, December 19, 2011 at 3:50:47 PM UTC+1, Okko wrote:
I want to propose to rename 'Refund' into "Reconcile invoices" if
checked. Unchecked should give a tooltip: 'Draft invoice. Allows the
user to edit the credit-note".

regards,

Okko

Cédric Krier

unread,
Dec 18, 2015, 5:03:26 AM12/18/15
to tryton
On 2015-12-18 01:24, Ossi Viljakainen wrote:
>
>
> On Friday, December 18, 2015 at 1:25:04 AM UTC+1, Cédric Krier wrote:
> >
> > On 2015-12-17 12:43, Ossi Viljakainen wrote:
> > > 2. What is the difference whether "refund" is selected or not?
> >
> > It will just reconcile the credit note with the original invoice.
> >
>
> When "refund" is selected, it will reconcile? In that case the text is very
> unclear.

"Refund" is the correct word because the credit note will pay the
invoice. Is it not what a refund is?

> Again, the user's manual would be much needed! :)
>
> I like this suggestion by Okko, which he had posted in 2011 on this list:
>
> On Monday, December 19, 2011 at 3:50:47 PM UTC+1, Okko wrote:
> >
> > I want to propose to rename 'Refund' into "Reconcile invoices" if
> > checked. Unchecked should give a tooltip: 'Draft invoice. Allows the
> > user to edit the credit-note".

Reconcile is a term for low level accounting. It doesn't speak when you
are talking about document. Indeed you don't reconcile an invoice but
the some move lines of it.

Cédric Krier

unread,
Dec 18, 2015, 5:10:03 AM12/18/15
to tryton
On 2015-12-18 11:02, Cédric Krier wrote:
> On 2015-12-18 01:24, Ossi Viljakainen wrote:
> >
> >
> > On Friday, December 18, 2015 at 1:25:04 AM UTC+1, Cédric Krier wrote:
> > >
> > > On 2015-12-17 12:43, Ossi Viljakainen wrote:
> > > > 2. What is the difference whether "refund" is selected or not?
> > >
> > > It will just reconcile the credit note with the original invoice.
> > >
> >
> > When "refund" is selected, it will reconcile? In that case the text is very
> > unclear.
>
> "Refund" is the correct word because the credit note will pay the
> invoice. Is it not what a refund is?
>
> > Again, the user's manual would be much needed! :)

Fill free to propose a better tooltip for this checkbox:
https://bugs.tryton.org/
Better than: "If true, the current invoice(s) will be paid."
(probably better to say "If checked")

TPH

unread,
Dec 21, 2015, 10:50:05 AM12/21/15
to tryton



On 2015-12-17 12:43, Ossi Viljakainen wrote:
> So in this case, using the action wizard "Credit" -> "credit invoice" and
> leaving the "refund" unchecked, will just create an opposite transaction (a
> credit note) with negative sales & tax lines.
> 1. Will it also create associated stock moves?

I generate Invoice and Shipment from Sale - so we always use Sale -> Return Sale, because this will generates Credit Note AND Return Shipment (if there was a Shipment).
 
Reply all
Reply to author
Forward
0 new messages