1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
|
# -*- coding: utf-8 -*-
# Part of Odoo. See LICENSE file for full copyright and licensing details.
from datetime import timedelta
from odoo import fields, tests
from odoo.tests.common import Form
class TestReportStockQuantity(tests.TransactionCase):
def setUp(self):
super().setUp()
self.product1 = self.env['product.product'].create({
'name': 'Mellohi',
'default_code': 'C418',
'type': 'product',
'categ_id': self.env.ref('product.product_category_all').id,
'tracking': 'lot',
'barcode': 'scan_me'
})
self.wh = self.env['stock.warehouse'].create({
'name': 'Base Warehouse',
'code': 'TESTWH'
})
self.categ_unit = self.env.ref('uom.product_uom_categ_unit')
self.uom_unit = self.env['uom.uom'].search([('category_id', '=', self.categ_unit.id), ('uom_type', '=', 'reference')], limit=1)
self.customer_location = self.env.ref('stock.stock_location_customers')
self.supplier_location = self.env.ref('stock.stock_location_suppliers')
# replenish
self.move1 = self.env['stock.move'].create({
'name': 'test_in_1',
'location_id': self.supplier_location.id,
'location_dest_id': self.wh.lot_stock_id.id,
'product_id': self.product1.id,
'product_uom': self.uom_unit.id,
'product_uom_qty': 100.0,
'state': 'done',
'date': fields.Datetime.now(),
})
self.quant1 = self.env['stock.quant'].create({
'product_id': self.product1.id,
'location_id': self.wh.lot_stock_id.id,
'quantity': 100.0,
})
# ship
self.move2 = self.env['stock.move'].create({
'name': 'test_out_1',
'location_id': self.wh.lot_stock_id.id,
'location_dest_id': self.customer_location.id,
'product_id': self.product1.id,
'product_uom': self.uom_unit.id,
'product_uom_qty': 120.0,
'state': 'partially_available',
'date': fields.Datetime.add(fields.Datetime.now(), days=3),
'date_deadline': fields.Datetime.add(fields.Datetime.now(), days=3),
})
self.env['base'].flush()
def test_report_stock_quantity(self):
from_date = fields.Date.to_string(fields.Date.add(fields.Date.today(), days=-1))
to_date = fields.Date.to_string(fields.Date.add(fields.Date.today(), days=4))
report = self.env['report.stock.quantity'].read_group(
[('date', '>=', from_date), ('date', '<=', to_date), ('product_id', '=', self.product1.id)],
['product_qty', 'date', 'product_id', 'state'],
['date:day', 'product_id', 'state'],
lazy=False)
forecast_report = [x['product_qty'] for x in report if x['state'] == 'forecast']
self.assertEqual(forecast_report, [0, 100, 100, 100, -20, -20])
def test_report_stock_quantity_with_product_qty_filter(self):
from_date = fields.Date.to_string(fields.Date.add(fields.Date.today(), days=-1))
to_date = fields.Date.to_string(fields.Date.add(fields.Date.today(), days=4))
report = self.env['report.stock.quantity'].read_group(
[('product_qty', '<', 0), ('date', '>=', from_date), ('date', '<=', to_date), ('product_id', '=', self.product1.id)],
['product_qty', 'date', 'product_id', 'state'],
['date:day', 'product_id', 'state'],
lazy=False)
forecast_report = [x['product_qty'] for x in report if x['state'] == 'forecast']
self.assertEqual(forecast_report, [-20, -20])
def test_replenishment_report_1(self):
self.product_replenished = self.env['product.product'].create({
'name': 'Security razor',
'type': 'product',
'categ_id': self.env.ref('product.product_category_all').id,
})
# get auto-created pull rule from when warehouse is created
self.wh.reception_route_id.rule_ids.unlink()
self.env['stock.rule'].create({
'name': 'Rule Supplier',
'route_id': self.wh.reception_route_id.id,
'location_id': self.wh.lot_stock_id.id,
'location_src_id': self.env.ref('stock.stock_location_suppliers').id,
'action': 'pull',
'delay': 1.0,
'procure_method': 'make_to_stock',
'picking_type_id': self.wh.in_type_id.id,
})
delivery_picking = self.env['stock.picking'].create({
'location_id': self.wh.lot_stock_id.id,
'location_dest_id': self.ref('stock.stock_location_customers'),
'picking_type_id': self.ref('stock.picking_type_out'),
})
self.env['stock.move'].create({
'name': 'Delivery',
'product_id': self.product_replenished.id,
'product_uom_qty': 500.0,
'product_uom': self.uom_unit.id,
'location_id': self.wh.lot_stock_id.id,
'location_dest_id': self.ref('stock.stock_location_customers'),
'picking_id': delivery_picking.id,
})
delivery_picking.action_confirm()
# Trigger the manual orderpoint creation for missing product
self.env['stock.move'].flush()
self.env['stock.warehouse.orderpoint'].action_open_orderpoints()
orderpoint = self.env['stock.warehouse.orderpoint'].search([
('product_id', '=', self.product_replenished.id)
])
self.assertTrue(orderpoint)
self.assertEqual(orderpoint.location_id, self.wh.lot_stock_id)
self.assertEqual(orderpoint.qty_to_order, 500.0)
orderpoint.action_replenish()
self.env['stock.warehouse.orderpoint'].action_open_orderpoints()
move = self.env['stock.move'].search([
('product_id', '=', self.product_replenished.id),
('location_dest_id', '=', self.wh.lot_stock_id.id)
])
# Simulate a supplier delay
move.date = fields.datetime.now() + timedelta(days=1)
orderpoint = self.env['stock.warehouse.orderpoint'].search([
('product_id', '=', self.product_replenished.id)
])
self.assertFalse(orderpoint)
orderpoint_form = Form(self.env['stock.warehouse.orderpoint'])
orderpoint_form.product_id = self.product_replenished
orderpoint_form.location_id = self.wh.lot_stock_id
orderpoint = orderpoint_form.save()
self.assertEqual(orderpoint.qty_to_order, 0.0)
self.env['stock.warehouse.orderpoint'].action_open_orderpoints()
self.assertEqual(orderpoint.qty_to_order, 0.0)
|
