This question has been flagged
1 Reply
3674 Views

I am using Odoo V12 CE and I have a plugin stock_picking_invoice_link which would show the picking on the invoice, but somehow it stopped working. I noticed that entries are not put in anymore into the database in the "account_invoice_stock_picking_rel" table.

Can anyone help me debug this? I don't know where to start looking, I enabled debug in the logs but I don't see anything unusual.

Avatar
Discard
Best Answer

Hi,

Seems you are using the module from OCA and  v12 is not yet published yet in the odoo store: https://apps.odoo.com/apps/modules/11.0/stock_picking_invoice_link/

As you mentioned stopped working , was it working in v12 and suddenly get stopped ? if so check the changes you have made in the database and in the code.


if yet it haven't worked in v12, check the corresponding github repository of the author and see whether the v12 is there in the repository or any PR for the same, https://github.com/OCA/stock-logistics-workflow

Thanks

Avatar
Discard
Author

It was working and suddenly stopped from one day to the other. I tested the module on other Odoo instance and it runs correctly, so the problem is somewhere in our settings, but I don't know how to debug such an issue, unfortunately my DB backups go back only one day I didn't think of keeping them longer.

check the settings you have changed over that day, also make sure that no newly added custom code or addons is not a reason for this

Author

Is there a history? We are working more people on the same platform so I don't know for sure.

There is log for this i guess, if you have any old database backups just restore it in local and see what is missing

Correction, hope there is no logs by default, if you havent configured some custom module for this purpose, as per my knowledge

Author

I have the latest code from branch 12.0 and I have a clean database with only Sales, Invoices, stock_picking_invoice_link apps installed and if I create a sale, deliver the products and create invoice, I don't see the Pickings on the invoice. If I go to the database and insert into the table "account_invoice_stock_picking_rel" the values (1,1) which is the invoice id and the picking id, then it will show the relation. To me it seems that it stopped inserting into that table.