[5.0][report_intrastat] confused product_template ref instead of product_product ref

[Omar (Pexego)]

Hi,

I'm working with product variants, then I saw that in report.instrastat list my invoice lines not had intrastat_id, it occurs because in the database view query it has a join between invoice.line and product.template and object that reference to product in invoice.line is product.product instead of product.template then it didn't find the right product intrastat_id.

I include the small fix.

[Raphaël Valyi - http://www.akretion.com (rvalyi)]

Hello folks,

I wanted to notify that at Akretion we have a customer using report_intrastat in production in France. We didn't address this particular issue, however we fixed lot's of others report_intrastat issues.
The branch we use for report_intrastat v5 is that one:
https://code.launchpad.net/~akretion-team/openobject-addons/openobject-addons_5.0_report_intrastat
I think the commit messages are self explanatory but we also have French (including legal) specifications.

We would have loved to have our work merged into v6 at least, even more that OpenERP S.A. themselves told us that the current report_intrastat was more of a proof of concept.

We are available to talk about it for a merge and already proposed it in the past in the accounting expert lists. So far no move from OpenERP S.A. May be it's not too late for a decent report_intrastat in V6 and a merge. Don't hesitate to contact us for that.

[Jay Vora (Serpent Consulting Services) (jayvora)]

Thank you Omar for the wonderful bug and its patch.
It has been fixed by revision 2812 <email address hidden>.

[Omar (Pexego) (omar7r)]

Hi Raphaël Valyi,

I 'm looking your source, it has many improvements, it's good but you have the same bug in the query.
it is a good merge for v6.

[Alexis de Lattre (alexis-via)]

I had a issue with November's DEB of Anevia (we use the report_intrastat from akretion's branch https://code.launchpad.net/~akretion-team/openobject-addons/openobject-addons_5.0_report_intrastat)... I found out the cause and fixed the bug. Then I had a look at the source code of report_intrastat in the official addons to see if the bug was there too. I saw that the bug was already fixed there. In the commit details, I found this bug report... and here I am ! :-)

So the bug is now also fixed in akretion's report_intrastat branch.