240 lines
7.4 KiB
ReStructuredText
240 lines
7.4 KiB
ReStructuredText
==================================
|
|
Stock Reporting Inventory Scenario
|
|
==================================
|
|
|
|
Imports::
|
|
|
|
>>> import datetime as dt
|
|
>>> from decimal import Decimal
|
|
>>> from unittest.mock import patch
|
|
|
|
>>> from proteus import Model
|
|
>>> from trytond.ir.date import Date
|
|
>>> from trytond.modules.company.tests.tools import create_company
|
|
>>> from trytond.modules.currency.tests.tools import get_currency
|
|
>>> from trytond.tests.tools import activate_modules, assertEqual
|
|
|
|
>>> period_close = globals().get('period_close', False)
|
|
>>> product_type = globals().get('product_type', 'product.template')
|
|
|
|
Patch today::
|
|
|
|
>>> mock = patch.object(Date, 'today', return_value=dt.date(2025, 1, 15))
|
|
>>> _ = mock.start()
|
|
|
|
Activate modules::
|
|
|
|
>>> config = activate_modules('stock', create_company)
|
|
|
|
>>> Inventory = Model.get('stock.reporting.inventory')
|
|
>>> InventoryMove = Model.get('stock.reporting.inventory.move')
|
|
>>> InventoryDaily = Model.get('stock.reporting.inventory.daily')
|
|
>>> InventoryTurnover = Model.get('stock.reporting.inventory.turnover')
|
|
>>> Location = Model.get('stock.location')
|
|
>>> Move = Model.get('stock.move')
|
|
>>> Period = Model.get('stock.period')
|
|
>>> ProductTemplate = Model.get('product.template')
|
|
>>> ProductUom = Model.get('product.uom')
|
|
|
|
Get currency::
|
|
|
|
>>> currency = get_currency()
|
|
|
|
Create product::
|
|
|
|
>>> unit, = ProductUom.find([('name', '=', 'Unit')])
|
|
|
|
>>> template = ProductTemplate()
|
|
>>> template.name = 'Product'
|
|
>>> template.default_uom = unit
|
|
>>> template.type = 'goods'
|
|
>>> template.save()
|
|
>>> product, = template.products
|
|
|
|
Get stock locations::
|
|
|
|
>>> warehouse_loc, = Location.find([('code', '=', 'WH')])
|
|
>>> supplier_loc, = Location.find([('code', '=', 'SUP')])
|
|
>>> customer_loc, = Location.find([('code', '=', 'CUS')])
|
|
>>> storage_loc, = Location.find([('code', '=', 'STO')])
|
|
|
|
Fill warehouse::
|
|
|
|
>>> move = Move()
|
|
>>> move.product = product
|
|
>>> move.from_location = supplier_loc
|
|
>>> move.to_location = storage_loc
|
|
>>> move.quantity = 10
|
|
>>> move.effective_date = dt.date(2025, 1, 1)
|
|
>>> move.unit_price = Decimal('10.0000')
|
|
>>> move.currency = currency
|
|
>>> move.click('do')
|
|
>>> move.state
|
|
'done'
|
|
|
|
>>> move = Move()
|
|
>>> move.product = product
|
|
>>> move.from_location = storage_loc
|
|
>>> move.to_location = customer_loc
|
|
>>> move.unit = unit
|
|
>>> move.quantity = 1
|
|
>>> move.effective_date = dt.date(2025, 1, 1)
|
|
>>> move.unit_price = Decimal('20.0000')
|
|
>>> move.currency = currency
|
|
>>> move.click('do')
|
|
>>> move.state
|
|
'done'
|
|
|
|
>>> move = Move()
|
|
>>> move.product = product
|
|
>>> move.from_location = storage_loc
|
|
>>> move.to_location = customer_loc
|
|
>>> move.unit = unit
|
|
>>> move.quantity = 2
|
|
>>> move.effective_date = dt.date(2025, 1, 10)
|
|
>>> move.unit_price = Decimal('20.0000')
|
|
>>> move.currency = currency
|
|
>>> move.click('do')
|
|
>>> move.state
|
|
'done'
|
|
|
|
Forecast some moves::
|
|
|
|
>>> move = Move()
|
|
>>> move.product = product
|
|
>>> move.from_location = supplier_loc
|
|
>>> move.to_location = storage_loc
|
|
>>> move.quantity = 10
|
|
>>> move.effective_date = dt.date(2025, 1, 5)
|
|
>>> move.unit_price = Decimal('10.0000')
|
|
>>> move.currency = currency
|
|
>>> move.save()
|
|
>>> move.state
|
|
'draft'
|
|
|
|
>>> move = Move()
|
|
>>> move.product = product
|
|
>>> move.from_location = storage_loc
|
|
>>> move.to_location = customer_loc
|
|
>>> move.unit = unit
|
|
>>> move.quantity = 3
|
|
>>> move.planned_date = dt.date(2025, 1, 20)
|
|
>>> move.unit_price = Decimal('20.0000')
|
|
>>> move.currency = currency
|
|
>>> move.save()
|
|
>>> move.state
|
|
'draft'
|
|
|
|
Close period::
|
|
|
|
>>> period = Period(date=dt.date(2025, 1, 5))
|
|
>>> if period_close:
|
|
... period.click('close')
|
|
|
|
|
|
Check inventory::
|
|
|
|
>>> with config.set_context(
|
|
... location=warehouse_loc.id,
|
|
... product_type=product_type,
|
|
... date=dt.date(2024, 1, 1)):
|
|
... Inventory.find([])
|
|
[]
|
|
|
|
>>> with config.set_context(
|
|
... location=warehouse_loc.id,
|
|
... product_type=product_type,
|
|
... date=dt.date(2025, 1, 1)):
|
|
... inventory, = Inventory.find([])
|
|
>>> inventory.quantity
|
|
9.0
|
|
>>> assertEqual(inventory.product.__class__.__name__, product_type)
|
|
|
|
>>> with config.set_context(
|
|
... location=warehouse_loc.id,
|
|
... product_type=product_type,
|
|
... date=dt.date(2025, 1, 15)):
|
|
... inventory, = Inventory.find([])
|
|
>>> inventory.quantity
|
|
7.0
|
|
|
|
>>> with config.set_context(
|
|
... location=warehouse_loc.id,
|
|
... product_type=product_type,
|
|
... date=dt.date(2025, 1, 20)):
|
|
... inventory, = Inventory.find([])
|
|
>>> inventory.quantity
|
|
4.0
|
|
|
|
>>> with config.set_context(
|
|
... location=warehouse_loc.id,
|
|
... product_type=product_type):
|
|
... inventory_moves = InventoryMove.find([])
|
|
... inventories_daily = InventoryDaily.find([])
|
|
|
|
>>> [i.quantity for i in inventory_moves]
|
|
[4.0, 7.0, 9.0, 10.0]
|
|
>>> [(i.input_quantity, i.output_quantity) for i in inventory_moves]
|
|
[(None, 3.0), (None, 2.0), (None, 1.0), (10.0, None)]
|
|
|
|
>>> [i.quantity for i in inventories_daily]
|
|
[4.0, 7.0, 9.0]
|
|
>>> [(i.input_quantity, i.output_quantity) for i in inventories_daily]
|
|
[(None, 3.0), (None, 2.0), (10.0, 1.0)]
|
|
|
|
>>> with config.set_context(
|
|
... location=warehouse_loc.id,
|
|
... from_date=dt.date(2025, 1, 15),
|
|
... to_date=dt.date(2025, 1, 29),
|
|
... product_type=product_type):
|
|
... inventory_moves = InventoryMove.find([])
|
|
... inventories_daily = InventoryDaily.find([])
|
|
|
|
>>> [i.quantity for i in inventory_moves]
|
|
[4.0, 7.0]
|
|
>>> [(i.input_quantity, i.output_quantity) for i in inventory_moves]
|
|
[(None, 3.0), (None, None)]
|
|
|
|
>>> [i.quantity for i in inventories_daily]
|
|
[4.0, 7.0]
|
|
>>> [(i.input_quantity, i.output_quantity) for i in inventories_daily]
|
|
[(None, 3.0), (None, None)]
|
|
|
|
>>> with config.set_context(
|
|
... location=warehouse_loc.id,
|
|
... from_date=dt.date(2025, 1, 10),
|
|
... to_date=dt.date(2025, 1, 29),
|
|
... product_type=product_type):
|
|
... inventory_moves = InventoryMove.find([])
|
|
... inventories_daily = InventoryDaily.find([])
|
|
|
|
>>> assertEqual(
|
|
... [i.quantity for i in inventory_moves],
|
|
... [4.0, 7.0] if period_close else [4.0, 7.0, 9.0])
|
|
>>> assertEqual(
|
|
... [(i.input_quantity, i.output_quantity) for i in inventory_moves],
|
|
... [(None, 3.0), (None, 2.0)] if period_close
|
|
... else [(None, 3.0), (None, 2.0), (None, None)])
|
|
|
|
>>> [i.quantity for i in inventories_daily]
|
|
[4.0, 7.0]
|
|
>>> [(i.input_quantity, i.output_quantity) for i in inventories_daily]
|
|
[(None, 3.0), (None, 2.0)]
|
|
|
|
Check Inventory turnover::
|
|
|
|
>>> with config.set_context(
|
|
... location=warehouse_loc.id,
|
|
... from_date=dt.date(2025, 1, 10),
|
|
... to_date=dt.date(2025, 1, 29),
|
|
... product_type=product_type):
|
|
... turnover, = InventoryTurnover.find([])
|
|
|
|
>>> turnover.output_quantity
|
|
0.25
|
|
>>> turnover.average_quantity
|
|
5.5
|
|
>>> turnover.turnover
|
|
0.045
|
|
>>> assertEqual(turnover.product.__class__.__name__, product_type)
|