Purchase exception when missing obsolete invoice

Support User
1

I have created a purchase with two lines, but only one is about a product which creates a stock move.
The second line is about tiny objects than I don’t even stock. It just creates an invoice line.

The supplier provides a single invoice on shipment, so I set the invoicing method on shipment.
Here is what happens: the purchase module creates two invoices: one immediately after validating the purchase (the line not associated to a product) and later another once I have received the product.

Since I only want one invoice, I merged the two and deleted one of them. Everything is paid but the purchase module still recreates the second invoice.
The exception wizard has no option to “forget” the missing invoice.

How to clean it up?

(Tryton 7.2)

2

You must manually deselect the invoice line when handling the exception. It is marked as active by default.

3

How did you do that? Tryton does not have a merge functionality in standard.

This is probably because the line on the first invoice for this consumable is not really linked to the purchase line. So the system does not consider this line has been invoiced.

As you want to follow delivery and that it trigger the invoicing, you must still use a goods for this tiny objects but you can define them as consumable.

4

I am unable to unselect the invoice proposed for recreation in the exception wizard. Wherever I click on the displayed line or elsewhere, the invoice is still recreated.

5

I manually copied and pasted the line from the invoive I don’t want to keep, into the unique full invoice.

I realize that I forgot to link the copy-pasted line with the purchase line (origin field). I assume it may have solved my problem.

Sure. Or I create the purchase order with only the product(s) I want to stock; then I add any little stuff (like shipment fees) on the generated invoice. But consumable is more appropriate.

Anyway, Now I have entered too many entries in my system so I cannot afford reverting to a previous backup.
I just want to link the posted invoice line with the original purchase line. The field is grayed out. Is there any expert way, even python programmatically, to force the link so my purchase order can cleanly end up in fully paid state?

6

Then you must add it via SQL query.

1 Like
7

Right to the point:

UPDATE account_invoice_line SET origin = 'purchase.line,xx' WHERE id = 'yy';

where xx and yy are custom values.

Thank you very much!

8

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.