Merge lp:~dorian-kemps/unifield-server/US-8384 into lp:unifield-server

Proposed by jftempo
Status: Needs review
Proposed branch: lp:~dorian-kemps/unifield-server/US-8384
Merge into: lp:unifield-server
Diff against target: 29 lines (+9/-10)
1 file modified
bin/addons/sales_followup/report/ir_follow_up_location_report.py (+9/-10)
To merge this branch: bzr merge lp:~dorian-kemps/unifield-server/US-8384
Reviewer Review Type Date Requested Status
UniField Reviewer Team Pending
Review via email: mp+405085@code.launchpad.net
To post a comment you must log in.

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== modified file 'bin/addons/sales_followup/report/ir_follow_up_location_report.py'
--- bin/addons/sales_followup/report/ir_follow_up_location_report.py 2020-11-09 16:15:15 +0000
+++ bin/addons/sales_followup/report/ir_follow_up_location_report.py 2021-07-02 09:34:23 +0000
@@ -329,16 +329,15 @@
329 fl_index = m_index329 fl_index = m_index
330 m_index += 1330 m_index += 1
331 else: # No move found331 else: # No move found
332 # Look for received qty in the IN(s) linked to a non-stockable product332 # Look for received qty in the IN(s)
333 if line.product_id and line.product_id.type in ['consu', 'service_recep']:333 self.cr.execute("""
334 self.cr.execute("""334 SELECT m.product_qty FROM stock_move m
335 SELECT m.product_qty FROM stock_move m 335 LEFT JOIN purchase_order_line pl ON m.purchase_line_id = pl.id
336 LEFT JOIN purchase_order_line pl ON m.purchase_line_id = pl.id336 LEFT JOIN sale_order_line sl ON pl.linked_sol_id = sl.id
337 LEFT JOIN sale_order_line sl ON pl.linked_sol_id = sl.id337 WHERE m.state = 'done' AND m.type = 'in' AND sl.id = %s
338 WHERE m.state = 'done' AND m.type = 'in' AND sl.id = %s338 """, (line.id,))
339 """, (line.id,))339 for move in self.cr.fetchall():
340 for move in self.cr.fetchall():340 received_qty += move[0]
341 received_qty += move[0]
342341
343 if first_line:342 if first_line:
344 data = {343 data = {

Subscribers

People subscribed via source and target branches