When I install this module and I print delivery slip with picking_type_code=[incoming], fields are not well placed.
I am going to show you with 4 pictures, 4 different scenarios.

@pedrobaeza @sergio-teruel @flagreenice @ao-landoo

Module

stock_picking_report_valued_sale_mrp

Describe the bug

When you try to install the module an error is displayed

odoo.tools.convert.ParseError: "Element 'xpath expr="//tr[@t-foreach='o.move_line_ids']" cannot be located in parent view

Error context:
View valued_report_picking
[view_id: 1206, xml_id: n/a, model: n/a, parent_id: 1204]" while parsing /mnt/data/odoo-addons-dir/stock_picking_report_valued_sale_mrp/report/stock_picking_report_valued.xml:2, near

To Reproduce

Affected versions: 13

Steps to reproduce the behavior:

1. try to install

You can check it on runbot, just unistall it and try to install it again

Expected behavior
Install without issues

Additional context
Add any other context about the problem here. (e.g. OS, Python version, ...)

See below the error listed in odoo's page for registered repositories:

Actually, I just edited it unintentionally.
I expected to receive a warning preventing me from saving the changes, but it was not.

But, I was trying to edit the wiki because I think it can be a good system to record the evolution of module migration. Replacing the migration issues like #75

So, any non-technical user can edit / follow the evolution of the migration.

See https://github.com/OCA/stock-logistics-reporting/wiki

When viewing report (button view report), we have this error

File ".../stock_inventory_valuation_report/reports/stock_inventory_valuation_report.py", line 61, in _compute_results
    'cost_currency_id': product.cost_currency_id,
AttributeError: 'product.product' object has no attribute 'cost_currency_id'

Error to render compiling AST
AttributeError: 'product.product' object has no attribute 'cost_currency_id'
Template: stock_inventory_valuation_report.report_stock_inventory_valuation_report_base
Path: /templates/t/div/div[2]/t[4]
Node: <t t-foreach="o.results" t-as="line">
                    <t t-call="stock_inventory_valuation_report.report_stock_inventory_valuation_lines"/>
                    <t t-set="n" t-value="n+1"/>
                    <t t-set="total" t-value="total+line.stock_value"/>
                </t>

I think it's 'cost_currency_id': product.currency_id instead of 'cost_currency_id': product.cost_currency_id

Hello!

Anyone have solve the issue of printing the "Customer Address" in all the pages of a Delivery slip?

If you send big deliveries with many lines and the report has 5 o 20 pages you can check in the footer the pages 1/2 .... 5/20 but the name of Customer is only in the first page.

We see limitations with wkhtmltopdf.

Any idea?

Thanks!
Regards

module: stock_quantity_history_location
version: 12.0

Steps to reproduce

• ...Under Inventory Valuation, I'm not seeing the "Location" field. It only appears under Inventory Report. I was under the impression that it should appear under both. Is there something I'm missing. Thanks.

Current behavior

Expected behavior

I looked for a module implementing stock reporting grouped by location at date.

I think this one fits nearly my needs : https://github.com/OCA/stock-logistics-reporting/tree/12.0/stock_report_quantity_by_location

@AaronHForgeFlow Do you think it could be a good feature to add date in the product context in order to obtain the good result ?

I think I will do it and migrate yours to 14.

Context

• 3-steps delivery process
• the pickers don't use Odoo and don't have mobile barcode scanners
• the packers use Odoo and have USB barcode scanners

Process

• The picker manager prints the picking wave/picking reports and hand it over to the pickers.
• The pickers run across the warehouse with their cart and pick items
• The picker leaves his cart with the picked items and the sheet of paper to the picker manager.
• The picker manager reviews/checks the content and validates the picking in Odoo
• The picker manager pushes the cart to one of the packing station

Problem

• The packer has no quick and easy way (= scan something) to open the corresponding packing order.

Proposed solution

• The barcode of the packing order is added on the "Picking Operations" report of the picking order.
• The packer scans the barcode to open the packing order

When I do an inventory valuation and click on "Export PDF" or "Export XLS" it gives : AttributeError: 'product.product' object has no attribute 'cost_currency_id'
Anyone experienced with this or is there a solution?

If you need a full error, please let me know i can provide it, thank you.

Hello,

could you please kindly advise how to start new translations for OCA modules?

I have registered on weblate and sent an email to transbot as per instructions, also tried contacting directly through OCA website to get permission, but the button for starting a new translation on weblate remains disabled.

Should I create a PR with the added .po translation file? Is weblate used only for existing .po files?

Hi all,

I am using FIFO with automatic valuation, when I do a "Reporting" --> "Inventory valuation" choosing a specific date and click on "Export XLSX" some product missing from the report. As I see those products missing which currently at Today's date has quantity 0, however at the chosen specific date it had available quantity either 1 or more.

If using the standard button "Retreive the inventory valuation" using the same specific date as earlier, it shows correctly. Displays those products which missing from the excel report.

Hello, is it possible to group the inventory valuation by Product Category instead of listing all product?

On Odoo12 CE

Thanks

We need to add a text field note in stock picking to be printed in delivery slip. The development is really simple.

• Create a new field client_note (html) in the same way note is created in core
• Print this new field in client delivery slip

I know already all the alternatives and no one is the requirement.

• https://github.com/OCA/stock-logistics-reporting/tree/14.0/stock_picking_comment_template when you have templates or comments. In this use case every comment is different in each picking
• https://github.com/OCA/stock-logistics-reporting/tree/14.0/stock_picking_report_custom_description bring the description of sales to picking

Odoo has a field note for internal comments for each picking which are only printed in picking operations

We need a external one to be printed only in delivery slip and not from sale order or any other related document

We will make a PR soon.

@moduon MT-2153

Regards

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-13.0

Modules to migrate

• stock_account_quantity_history_location - By @victoralmau - #146
• stock_account_valuation_report - By @AaronHForgeFlow - #113
• stock_card_report - By @ps-tubtim - #97
• stock_inventory_valuation_report
• stock_picking_comment_template - By @feketemihai - #109
• stock_picking_report_valued
• stock_quantity_history_location - By @HviorForgeFlow - #84
• stock_report_quantity_by_location - By @kranokporn - #112

Missing module? Check https://github.com/OCA/maintainer-tools/wiki/%5BFAQ%5D-Missing-modules-in-migration-issue-list

Error:
Odoo Server Error

Traceback (most recent call last):
File "/odooc2i-dev/odooc2i-dev-server/odoo/models.py", line 1036, in _validate_fields
check(self)
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/ir/ir_ui_view.py", line 330, in check_xml
view_def = view.read_combined(['arch'])
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/ir/ir_ui_view.py", line 720, in read_combined
arch = self.apply_view_inheritance(arch_tree, root.id, self.model)
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/ir/ir_ui_view.py", line 669, in apply_view_inheritance
source = self.apply_inheritance_specs(source, specs_tree, view_id)
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/ir/ir_ui_view.py", line 647, in apply_inheritance_specs
self.raise_view_error(("Element '%s' cannot be located in parent view") % tag, inherit_id)
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/ir/ir_ui_view.py", line 509, in raise_view_error
raise ValueError(message)
ValueError: El elemento '<xpath expr="//table[@t-if="o.move_line_ids and o.state=='done'"]/thead/tr">' no puede ser localizado en la vista padre

Contexto del error:
Vista valued_report_picking
[view_id: 1469, xml_id: n/a, model: n/a, parent_id: 428]

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/odooc2i-dev/odooc2i-dev-server/odoo/tools/convert.py", line 744, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/odooc2i-dev/odooc2i-dev-server/odoo/tools/convert.py", line 722, in _tag_template
return self._tag_record(record, data_node)
File "/odooc2i-dev/odooc2i-dev-server/odoo/tools/convert.py", line 654, in _tag_record
id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/ir/ir_model.py", line 1487, in _update
record = record.create(values)
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/ir/ir_ui_view.py", line 398, in create
return super(View, self).create(self._compute_defaults(values))
File "/odooc2i-dev/odooc2i-dev-server/odoo/models.py", line 3380, in create
self._fields[key].determine_inverse(record)
File "/odooc2i-dev/odooc2i-dev-server/odoo/fields.py", line 1071, in determine_inverse
getattr(records, self.inverse)()
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/ir/ir_ui_view.py", line 266, in _inverse_arch
view.write(data)
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/ir/ir_ui_view.py", line 414, in write
return super(View, self).write(self._compute_defaults(vals))
File "/odooc2i-dev/odooc2i-dev-server/odoo/models.py", line 3089, in write
self._write(old_vals)
File "/odooc2i-dev/odooc2i-dev-server/odoo/models.py", line 3255, in _write
self._validate_fields(vals)
File "/odooc2i-dev/odooc2i-dev-server/odoo/models.py", line 1040, in validate_fields
raise ValidationError("%s\n\n%s" % (("Error while validating constraint"), tools.ustr(e)))
odoo.exceptions.ValidationError: ('Error mientras se validaban las restricciones\n\nEl elemento '<xpath expr="//table[@t-if="o.move_line_ids and o.state=='done'"]/thead/tr">' no puede ser localizado en la vista padre\n\nContexto del error:\nVista valued_report_picking\n[view_id: 1469, xml_id: n/a, model: n/a, parent_id: 428]', None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/odooc2i-dev/odooc2i-dev-server/odoo/http.py", line 650, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/odooc2i-dev/odooc2i-dev-server/odoo/http.py", line 310, in _handle_exception
raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
File "/odooc2i-dev/odooc2i-dev-server/odoo/tools/pycompat.py", line 87, in reraise
raise value
File "/odooc2i-dev/odooc2i-dev-server/odoo/http.py", line 692, in dispatch
result = self._call_function(**self.params)
File "/odooc2i-dev/odooc2i-dev-server/odoo/http.py", line 342, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/odooc2i-dev/odooc2i-dev-server/odoo/service/model.py", line 97, in wrapper
return f(dbname, *args, **kwargs)
File "/odooc2i-dev/odooc2i-dev-server/odoo/http.py", line 335, in checked_call
result = self.endpoint(*a, **kw)
File "/odooc2i-dev/odooc2i-dev-server/odoo/http.py", line 936, in call
return self.method(*args, **kw)
File "/odooc2i-dev/odooc2i-dev-server/odoo/http.py", line 515, in response_wrap
response = f(*args, **kw)
File "/odooc2i-dev/odooc2i-dev-server/addons/web/controllers/main.py", line 938, in call_button
action = self._call_kw(model, method, args, {})
File "/odooc2i-dev/odooc2i-dev-server/addons/web/controllers/main.py", line 926, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/odooc2i-dev/odooc2i-dev-server/odoo/api.py", line 689, in call_kw
return call_kw_multi(method, model, args, kwargs)
File "/odooc2i-dev/odooc2i-dev-server/odoo/api.py", line 680, in call_kw_multi
result = method(recs, *args, **kwargs)
File "", line 2, in button_immediate_install
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/module/module.py", line 71, in check_and_log
return method(self, *args, **kwargs)
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/module/module.py", line 449, in button_immediate_install
return self._button_immediate_function(type(self).button_install)
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/module/module.py", line 542, in _button_immediate_function
modules.registry.Registry.new(self._cr.dbname, update_module=True)
File "/odooc2i-dev/odooc2i-dev-server/odoo/modules/registry.py", line 85, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/odooc2i-dev/odooc2i-dev-server/odoo/modules/loading.py", line 380, in load_modules
loaded_modules, update_module, models_to_check)
File "/odooc2i-dev/odooc2i-dev-server/odoo/modules/loading.py", line 274, in load_marked_modules
perform_checks=perform_checks, models_to_check=models_to_check
File "/odooc2i-dev/odooc2i-dev-server/odoo/modules/loading.py", line 181, in load_module_graph
_load_data(cr, module_name, idref, mode, kind='data')
File "/odooc2i-dev/odooc2i-dev-server/odoo/modules/loading.py", line 95, in _load_data
tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File "/odooc2i-dev/odooc2i-dev-server/odoo/tools/convert.py", line 791, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/odooc2i-dev/odooc2i-dev-server/odoo/tools/convert.py", line 852, in convert_xml_import
obj.parse(doc.getroot(), mode=mode)
File "/odooc2i-dev/odooc2i-dev-server/odoo/tools/convert.py", line 751, in parse
exc_info[2]
File "/odooc2i-dev/odooc2i-dev-server/odoo/tools/pycompat.py", line 86, in reraise
raise value.with_traceback(tb)
File "/odooc2i-dev/odooc2i-dev-server/odoo/tools/convert.py", line 744, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/odooc2i-dev/odooc2i-dev-server/odoo/tools/convert.py", line 722, in _tag_template
return self._tag_record(record, data_node)
File "/odooc2i-dev/odooc2i-dev-server/odoo/tools/convert.py", line 654, in _tag_record
id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/ir/ir_model.py", line 1487, in _update
record = record.create(values)
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/ir/ir_ui_view.py", line 398, in create
return super(View, self).create(self._compute_defaults(values))
File "/odooc2i-dev/odooc2i-dev-server/odoo/models.py", line 3380, in create
self._fields[key].determine_inverse(record)
File "/odooc2i-dev/odooc2i-dev-server/odoo/fields.py", line 1071, in determine_inverse
getattr(records, self.inverse)()
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/ir/ir_ui_view.py", line 266, in _inverse_arch
view.write(data)
File "/odooc2i-dev/odooc2i-dev-server/odoo/addons/base/ir/ir_ui_view.py", line 414, in write
return super(View, self).write(self._compute_defaults(vals))
File "/odooc2i-dev/odooc2i-dev-server/odoo/models.py", line 3089, in write
self._write(old_vals)
File "/odooc2i-dev/odooc2i-dev-server/odoo/models.py", line 3255, in _write
self._validate_fields(vals)
File "/odooc2i-dev/odooc2i-dev-server/odoo/models.py", line 1040, in validate_fields
raise ValidationError("%s\n\n%s" % (("Error while validating constraint"), tools.ustr(e)))
odoo.tools.convert.ParseError: "Error mientras se validaban las restricciones

El elemento '<xpath expr="//table[@t-if="o.move_line_ids and o.state=='done'"]/thead/tr">' no puede ser localizado en la vista padre

Contexto del error:
Vista valued_report_picking
[view_id: 1469, xml_id: n/a, model: n/a, parent_id: 428]
None" while parsing None:4, near




Qty Reserved

Unit Price

Discount

Subtotal
Taxes

getting testcase failing error.

Module

stock_account_valuation_report

Describe the bug

DB is fresh, No other apps installed,
getting testcase failing error.

To Reproduce

15.0:

Steps to reproduce the behavior:
1.
2.
3.

Expected behavior
A clear and concise description of what you expected to happen.

Additional context
Add any other context about the problem here. (e.g. OS, Python version, ...)

Module

stock_picking_report_valued

Describe the bug

When adding any line manually to stock picking (so that line is not linked to the sale order in any way) the valued delivery slip report fails with error "Expected singleton: res.currency() Template: stock.stock_report_delivery_has_serial_move_line".

To Reproduce

16.0

Steps to reproduce the behavior:

1. Login with admin user in runboat
2. Create a sale order with 1 line
3. Go to the stock picking associated with the sale order (truck icon), add a manual line at the end with any quantity in the done field (so that stock move line is not associated with the sale order). Confirm the picking.
4. Confirm that the customer has the "Valued picking" check in the partner form (for example "Deco Addict").
5. Go to Print --> Delivery Slip. The following error occurs:

Traceback (most recent call last):
File "/opt/odoo/odoo/models.py", line 5174, in ensure_one
_id, = self._ids
ValueError: not enough values to unpack (expected 1, got 0)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "<769>", line 562, in template_769
File "<769>", line 486, in template_769_content
File "/opt/odoo/odoo/addons/base/models/ir_qweb.py", line 2385, in _get_field
content = converter.record_to_html(record, field_name, field_options)
File "/opt/odoo/odoo/addons/base/models/ir_qweb_fields.py", line 500, in record_to_html
return super(MonetaryConverter, self).record_to_html(record, field_name, options)
File "/opt/odoo/odoo/addons/base/models/ir_qweb_fields.py", line 121, in record_to_html
return False if value is False else self.value_to_html(value, options=options)
File "/opt/odoo/odoo/addons/base/models/ir_qweb_fields.py", line 464, in value_to_html
formatted_amount = lang.format(fmt, display_currency.round(value),
File "/opt/odoo/odoo/addons/base/models/res_currency.py", line 208, in round
self.ensure_one()
File "/opt/odoo/odoo/models.py", line 5177, in ensure_one
raise ValueError("Expected singleton: %s" % self)
ValueError: Expected singleton: res.currency()

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/opt/odoo/addons/web/controllers/report.py", line 113, in report_download
response = self.report_routes(reportname, docids=docids, converter=converter, context=context)
File "/opt/odoo/odoo/http.py", line 697, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/opt/odoo-venv/lib/python3.10/site-packages/odoo/addons/report_xlsx_helper/controllers/main.py", line 52, in report_routes
return super().report_routes(reportname, docids, converter, **data)
File "/opt/odoo/odoo/http.py", line 697, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/opt/odoo-venv/lib/python3.10/site-packages/odoo/addons/report_xlsx/controllers/main.py", line 49, in report_routes
return super().report_routes(reportname, docids, converter, **data)
File "/opt/odoo/odoo/http.py", line 697, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/opt/odoo/addons/web/controllers/report.py", line 42, in report_routes
pdf = report.with_context(context)._render_qweb_pdf(reportname, docids, data=data)[0]
File "/opt/odoo/addons/account/models/ir_actions_report.py", line 61, in _render_qweb_pdf
return super()._render_qweb_pdf(report_ref, res_ids=res_ids, data=data)
File "/opt/odoo/odoo/addons/base/models/ir_actions_report.py", line 858, in _render_qweb_pdf
collected_streams = self._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
File "/opt/odoo/addons/account_edi_ubl_cii/models/ir_actions_report.py", line 58, in _render_qweb_pdf_prepare_streams
collected_streams = super()._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
File "/opt/odoo/addons/account_edi/models/ir_actions_report.py", line 14, in _render_qweb_pdf_prepare_streams
collected_streams = super()._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
File "/opt/odoo/addons/account/models/ir_actions_report.py", line 20, in _render_qweb_pdf_prepare_streams
return super()._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
File "/opt/odoo/odoo/addons/base/models/ir_actions_report.py", line 709, in _render_qweb_pdf_prepare_streams
html = self.with_context(**additional_context)._render_qweb_html(report_ref, res_ids_wo_stream, data=data)[0]
File "/opt/odoo/odoo/addons/base/models/ir_actions_report.py", line 907, in _render_qweb_html
return self._render_template(report.report_name, data), 'html'
File "/opt/odoo/odoo/addons/base/models/ir_actions_report.py", line 624, in _render_template
return view_obj._render_template(template, values).encode()
File "/opt/odoo/odoo/addons/base/models/ir_ui_view.py", line 2127, in _render_template
return self.env['ir.qweb']._render(template, values)
File "/opt/odoo/odoo/tools/profiler.py", line 292, in _tracked_method_render
return method_render(self, template, values, **options)
File "/opt/odoo/odoo/addons/base/models/ir_qweb.py", line 581, in _render
result = ''.join(rendering)
File "<773>", line 65, in template_773
File "<773>", line 52, in template_773_content
File "<768>", line 1849, in template_768
File "<768>", line 1831, in template_768_content
File "<768>", line 1814, in template_768_t_call_0
File "<768>", line 1195, in template_768_t_call_1
File "<769>", line 568, in template_769
odoo.addons.base.models.ir_qweb.QWebException: Error while render the template
ValueError: Expected singleton: res.currency()
Template: stock.stock_report_delivery_has_serial_move_line
Path: /t/t[4]/td[3]/span
Node:

The above server error caused the following client error:
RPC_ERROR: Odoo Server Error
at makeErrorFromResponse (http://oca-stock-logistics-reporting-16-0-469d732a0247.runboat.odoo-community.org/web/assets/459-d43c255/web.assets_backend.min.js:993:163)
at decoder.onload (http://oca-stock-logistics-reporting-16-0-469d732a0247.runboat.odoo-community.org/web/assets/459-d43c255/web.assets_backend.min.js:980:7)

Expected behavior
The delivery slip should be printed without error and the manually added line should have null price (or zero) in the report.

Additional context
Add any other context about the problem here. (e.g. OS, Python version, ...)

Module

stock_picking_report_valued

Describe the bug

Traceback (most recent call last):
File "<759>", line 1660, in template_759
File "<759>", line 1642, in template_759_content
File "<759>", line 1625, in template_759_t_call_0
File "<759>", line 506, in template_759_t_call_1
AttributeError: 'stock.picking' object has no attribute 'move_lines'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/opt/odoo/addons/web/controllers/report.py", line 113, in report_download
response = self.report_routes(reportname, docids=docids, converter=converter, context=context)
File "/opt/odoo/odoo/http.py", line 697, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/opt/odoo/addons/web/controllers/report.py", line 42, in report_routes
pdf = report.with_context(context)._render_qweb_pdf(reportname, docids, data=data)[0]
File "/opt/odoo/addons/account/models/ir_actions_report.py", line 57, in _render_qweb_pdf
return super()._render_qweb_pdf(report_ref, res_ids=res_ids, data=data)
File "/opt/odoo/odoo/addons/base/models/ir_actions_report.py", line 807, in _render_qweb_pdf
collected_streams = self._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
File "/opt/odoo/addons/account_edi_ubl_cii/models/ir_actions_report.py", line 58, in _render_qweb_pdf_prepare_streams
collected_streams = super()._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
File "/opt/odoo/addons/account_edi/models/ir_actions_report.py", line 14, in _render_qweb_pdf_prepare_streams
collected_streams = super()._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
File "/opt/odoo/addons/account/models/ir_actions_report.py", line 20, in _render_qweb_pdf_prepare_streams
return super()._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
File "/opt/odoo/odoo/addons/base/models/ir_actions_report.py", line 708, in _render_qweb_pdf_prepare_streams
html = self.with_context(**additional_context)._render_qweb_html(report_ref, res_ids_wo_stream, data=data)[0]
File "/opt/odoo/odoo/addons/base/models/ir_actions_report.py", line 884, in _render_qweb_html
return self._render_template(report.report_name, data), 'html'
File "/opt/odoo/odoo/addons/base/models/ir_actions_report.py", line 623, in _render_template
return view_obj._render_template(template, values).encode()
File "/opt/odoo/odoo/addons/base/models/ir_ui_view.py", line 2128, in _render_template
return self.env['ir.qweb']._render(template, values)
File "/opt/odoo/odoo/tools/profiler.py", line 292, in _tracked_method_render
return method_render(self, template, values, **options)
File "/opt/odoo/odoo/addons/base/models/ir_qweb.py", line 580, in _render
result = ''.join(rendering)
File "<764>", line 65, in template_764
File "<764>", line 52, in template_764_content
File "<759>", line 1666, in template_759
odoo.addons.base.models.ir_qweb.QWebException: Error while render the template
AttributeError: 'stock.picking' object has no attribute 'move_lines'
Template: stock.report_delivery_document
Path: /t/t/t/div/table[1]/thead/tr/th[1]
Node:

The above server error caused the following client error:
RPC_ERROR: Odoo Server Error
RPCError@http://oca-stock-logistics-reporting-16-0-c13047c88ed4.runboat.odoo-community.org/web/assets/466-d4393d1/web.assets_backend.min.js:969:274
makeErrorFromResponse@http://oca-stock-logistics-reporting-16-0-c13047c88ed4.runboat.odoo-community.org/web/assets/466-d4393d1/web.assets_backend.min.js:973:163
download._download/</xhr.onload/decoder.onload@http://oca-stock-logistics-reporting-16-0-c13047c88ed4.runboat.odoo-community.org/web/assets/466-d4393d1/web.assets_backend.min.js:961:7

Steps to reproduce the behavior:

1. Picking valued with reserved quantity
2. Go to Print > Delivery Slip
3. Error

Expected behavior
To can print a Delivery Slip with the reserved quantity

@moduon
MT-3021

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-16.0

Modules to migrate

• delivery_line_sale_line_position - By @ivantodorovich - #261
• stock_account_valuation_report - By @RicardCForgeFlow - #291
• stock_average_daily_sale - By @rousseldenis - #257
• stock_card_report
• stock_picking_report_custom_description - By @carolinafernandez-tecnativa - #288
• stock_picking_report_external_note - By @Shide - #322
• stock_picking_report_internal_delivery_address - By @stefan-tecnativa - #290
• stock_picking_report_summary - By @quentinDupont - #304
• stock_picking_report_valued - By @miguel-S73 - #259
• stock_quantity_history_location - By @slitheryduke11 - #275
• stock_report_quantity_by_location - By @HugoCordobaLeal - #298

Missing module? Check https://github.com/OCA/maintainer-tools/wiki/%5BFAQ%5D-Missing-modules-in-migration-issue-list

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-9.0

Modules to migrate

• stock_picking_partner_lang
• stock_picking_webkit
• stock_analysis

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-14.0

Modules to migrate

• stock_account_valuation_report - By @AaronHForgeFlow - #170
• stock_card_report
• stock_inventory_valuation_report - By @solo4games - #292
• stock_picking_comment_template - By @fredzamoabg - #119
• stock_picking_report_custom_description - By @ernestotejeda - #209
• stock_picking_report_valued
• stock_quantity_history_location
• stock_report_quantity_by_location - By @AlvaroTForgeFlow - #173

Missing module? Check https://github.com/OCA/maintainer-tools/wiki/%5BFAQ%5D-Missing-modules-in-migration-issue-list

When i install module stock_inventory_valuation_report, i have this error:

ParseError: "External ID not found in the system: stock_account.view_stock_quantity_history" while parsing .../stock_inventory_valuation_report/wizard/stock_quantity_history_view.xml:3, near

<record id="view_stock_quantity_history_inherit" model="ir.ui.view">
        <field name="name">view_stock_quantity_history_inherit</field>
        <field name="model">stock.quantity.history</field>
        <field name="inherit_id" ref="stock_account.view_stock_quantity_history"/>
        <field name="arch" type="xml">
            <xpath expr="//button[@name='open_table']" position="after">
                <button name="button_export_html" string="View report" type="object"/>
                <button name="button_export_pdf" string="Export PDF" type="object"/>
                <button name="button_export_xlsx" string="Export XLSX" type="object"/>
            </xpath>
        </field>
    </record>

The quantities column added by module stock_account_valuation_report takes the sum of quantity in account move lines, this results in an incorrect quantity when products are used in manufacturing orders since all quantities are positive.

Wanted to make a demo video but runbot doesn't seem to work?

Need to be updated for getting green.

After installing stock_account_valuation_report and get an xlsx report, it shows 0 value for inventory with the header.
It is doesn't matter choosing current date or specifying an earlier one.

After uninstallation of stock_account_valuation_report inventory valuation will include items in excel report.

Is your feature request related to a problem?
The valued picking is often used during the export of goods to another country, and it is aimed to show the value of goods being delivered. However, if the picking is related with an order which is free of charge, then the value is 0.
Customs expects to value the goods sent based on the market price of the product. They still need to apply customs to a product that is sold free of charge.

Describe the solution you'd like
I would like to have a setting to decide if the discount should be considered in the valued picking.

@victoralmau @sergio-teruel Have you come across this use case?

Module

stock_quantity_history_location

Describe the bug

The Inventory at date report is working for only parent locations, For the most child locations the report showing wrong qty for past date.

To Reproduce

Affected versions: 13.0

Steps to reproduce the behavior:

1. Add stock in WH/stock/Shelf 1 for any stockable product [Ex Date:01/01/2022 ]
2. create a Delivery order on [Ex Date: 05/01/2022] and done that.
   3.Now check inventory at Date report with WH/Stock location selected & WH/Stock/Shelf 1 selected with date: 01/01/2022

Expected behavior
On WH/Stock it will display correct qty for past date & for same date it will show wrong qty on Shelf 1 location, it should be display same qty for both the locations.

getting error while downloading the excel report

Module

stock_card_report

Describe the bug

while downloading the excel getting error

To Reproduce

odoo CE 14.0

Steps to reproduce the behavior:

1. after pulling data click on the download button

Expected behavior
need that data in excel.

Additional context
ubunutu 18.04

Hi,

I found this report not compatible with the newer version of Odoo. Please help to update the new version. so everyone can use it for the newer version. i try to update on v14 odoo it's becoming failed in odoo.sh. please help me to check.

Thanks Regards
Pubalan

Read OCA/maintainer-tools#29 to know more about it

Hi, we are looking into developing the stock_card_report in pdf and excel, which should be similar to this one,

https://apps.odoo.com/apps/modules/12.0/hyd_stock_card/

Search criteria:

• Start date
• End date
• Products
• Warehouse / Location

The result should show product one by one, with result -> Initial Balance, In, Out, End Balance

May I check whether some work has been developed in OCA, and/or should I develop it (i.e., stock_card_report)

@ps-tubtim

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-17.0

Modules to migrate

• delivery_line_sale_line_position - By @xaviedoanhduy - #310
• stock_card_report - By @Youstina-NR - #301
• stock_picking_report_custom_description - By @David-Luis-Mora - #311
• stock_picking_report_external_note - By @sbiosca-s73 - #323
• stock_picking_report_internal_delivery_address
• stock_picking_report_valued - By @nguyenminhchien - #300
• stock_quantity_history_location

Removed:

• stock_picking_report_valued_delivery made redundant by @nguyenminhchien - #300

Missing module? Check https://github.com/OCA/maintainer-tools/wiki/%5BFAQ%5D-Missing-modules-in-migration-issue-list

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-15.0

Modules to migrate

• delivery_line_sale_line_position - By @ajaniszewska-dev - #194
• stock_account_quantity_history_location - By @ernestotejeda - #268
• stock_account_valuation_report - By @AaronHForgeFlow - #171
• stock_card_report - By @emadshaaban92 - #186
• stock_move_value_report - By @LudLaf - #220
• stock_picking_comment_template - By @olveracuenca - #205
• stock_picking_report_custom_description - By @pilarvargas-tecnativa - #251
• stock_picking_report_undelivered_product - By @sergio-teruel - #241
• stock_picking_report_valued - By @flachica - #181
• stock_picking_report_valued_sale_mrp - By @ernestotejeda - #266
• stock_production_lot_traceability_shipment_report - By @ivantodorovich - #255
• stock_quantity_history_location - By @ernestotejeda - #272
• stock_report_quantity_by_location - By @JasminSForgeFlow - #203

Missing module? Check https://github.com/OCA/maintainer-tools/wiki/%5BFAQ%5D-Missing-modules-in-migration-issue-list

@chienandalu @carlosdauden @pedrobaeza @ao-landoo @flachica

I have been testing stock_picking_report_valued and data shown on stock picking report is not correct.

I attach a few pictures to describe the problem detected on runboat.

1. There is a missing label for last field on stock picking
2. Order of fields is wrong.

module: stock_quantity_history_location
version: 14.0

Please see video attached outlining the Steps to reproduce the issue, the current behavior, and expected behavior.

Thanks.

https://watch.screencastify.com/v/DClVqc1gGfCWyRB86atS

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-10.0

Modules to migrate

• stock_analysis - By @omejia26 - #34
• stock_picking_partner_lang
• stock_picking_webkit
• stock_valued_picking_report - By @chienandalu - #35

Hi @ps-tubtim @kittiu ,

To reproduce:

• Your company works in Dollars
• You make a purchase in CNY
• Report should be in Dollars, this module show report mixing Dollars and CNY

Do you think you could fix it?

Thanks
Regards

• Odoo 12.0 C.E.
  Generating report with too many Products and Moves take long long time.

About 40.000 Products

Is it possible to solve?

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-12.0

Modules to migrate

• stock_account_quantity_history_location - By @hveficent - #68
• stock_account_valuation_report - By @hveficent - #67
• stock_move_value_report - By @CarlosRoca13 - #117
• stock_picking_comment_template - By @emagdalenaC2i - #61
• stock_picking_report_custom_description - By @sergio-teruel - #83
• stock_picking_report_valued - By @antoniorubiopesol - #50 By @ernestotejeda - #63
• stock_quantity_history_location - By @hveficent - #65
• stock_report_quantity_by_location - By @hveficent - #66

When printing report (PDF or XLS), we have this error

File ".../stock_inventory_valuation_report/reports/stock_inventory_valuation_report.py", line 58, in _compute_results
    'qty_at_date': product.qty_at_date,
AttributeError: 'product.product' object has no attribute 'qty_at_date'

I think it's qty_available instead of qty_at_date

To replicate this issue:

1 - Set the Round globally option (Invoicing settings) and allow discounts (sale settings)

2- Create the next quotation

3 - Confirm the quotation and check the differences in the quotation, invoice and the Delivery Slip report

When activating the followin setting on Inventory app:

• Display Lots & Serial Numbers on Delivery Slips (group_lot_on_delivery_slip)

Picking report's table's values are not placed correctly.

I'm adding an image of a report without this setting, and after another with the setting activated.

@flagreenice @flachica @ernestotejeda @sergio-teruel @pedrobaeza @ao-landoo

If you have installed MRP and use a product with build of materials as kit, when you sale it, the pickig report valued get wrong data, get the product of components quantityt by proudct price.

Module

• stock_picking_report_valued
• mrp

To Reproduce

All versions:

Sell demo product FURN_78236, confirm sale order, confirm delivery and print delivery slip.

Hello,
We would like to imitate the current stock valuation report in Odoo to also print PDF (qweb) and Excel report (report_xlsx).
Just a normal check here whether it will be ok here, and not already been developed.
Thank you.

Note: we plan to make it new addon, i.e., stock_inventory_valuation_report

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-11.0

Modules to migrate

• stock_picking_partner_lang
• stock_picking_webkit
• stock_picking_report_custom_description - By @sergio-teruel - #45
• stock_valued_picking_report > stock_picking_report_valued - By @luismontalba - #44