Merge lp:~unifield-team/unifield-addons/unisup-adjustment-move-report into lp:unifield-addons

[Quentin THEURET @Amaris]

=== added directory 'stock_inventory_type'
=== added file 'stock_inventory_type/__init__.py'
--- stock_inventory_type/__init__.py	1970-01-01 00:00:00 +0000
+++ stock_inventory_type/__init__.py	2011-03-15 15:12:37 +0000
@@ -0,0 +1,28 @@
+#!/usr/bin/env python
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+
+import stock
+import stock_move_report
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+
 
=== added file 'stock_inventory_type/__openerp__.py'
--- stock_inventory_type/__openerp__.py	1970-01-01 00:00:00 +0000
+++ stock_inventory_type/__openerp__.py	2011-03-15 15:12:37 +0000
@@ -0,0 +1,50 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+{
+    "name" : "Stock Adjustment/Move Report",
+    "version" : "1.0",
+    "author" : "TeMPO Consulting, MSF",
+    "category": "Inventory Control",
+    "description": """
+        This module aims to help you to determine the type \
+    of your inventory adjustment and to search stock move \
+    by type of adjustment.
+    """,
+    "website": "http://unifield.msf.org",
+    "init_xml": [
+    ],
+    "depends" : [
+        "stock",
+    ],
+    "update_xml": [
+        "stock_view.xml",
+        "stock_data.xml",
+        "security/ir.model.access.csv",
+    ],
+    "demo_xml": [
+        "test/adjustment_type.yml",
+    ],
+    "test": [
+        "test/adjustment_type.yml",
+    ],
+    "installable": True,
+    "active": False,
+}
 
=== added directory 'stock_inventory_type/security'
=== added file 'stock_inventory_type/security/ir.model.access.csv'
--- stock_inventory_type/security/ir.model.access.csv	1970-01-01 00:00:00 +0000
+++ stock_inventory_type/security/ir.model.access.csv	2011-03-15 15:12:37 +0000
@@ -0,0 +1,2 @@
+"id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink"
+"access_stock_adjustment_type_all","stock.adjustment.type all","model_stock_adjustment_type",,1,1,1,1
 
=== added file 'stock_inventory_type/stock.py'
--- stock_inventory_type/stock.py	1970-01-01 00:00:00 +0000
+++ stock_inventory_type/stock.py	2011-03-15 15:12:37 +0000
@@ -0,0 +1,133 @@
+#!/usr/bin/env python
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+
+from osv import osv
+from osv import fields
+
+from tools.translate import _
+
+
+class stock_adjustment_type(osv.osv):
+    _name = 'stock.adjustment.type'
+    _description = 'Inventory/Move Adjustment Types'
+
+    _columns = {
+        'name': fields.char(size=64, string='Name', required=True),
+    }
+
+stock_adjustment_type()
+
+
+class stock_inventory_line(osv.osv):
+    _name = 'stock.inventory.line'
+    _inherit = 'stock.inventory.line'
+
+    _columns = {
+        'type_id': fields.many2one('stock.adjustment.type', string='Adjustment type'),
+        'comment': fields.char(size=128, string='Comment'),
+    }
+
+stock_inventory_line()
+
+
+class stock_move(osv.osv):
+    _name = 'stock.move'
+    _inherit = 'stock.move'
+
+    _columns = {
+        'type_id': fields.many2one('stock.adjustment.type', string='Adjustment type', readonly=True),
+        'comment': fields.char(size=128, string='Comment'),
+    }
+
+stock_move()
+
+
+class stock_inventory(osv.osv):
+    _name = 'stock.inventory'
+    _inherit = 'stock.inventory'
+
+    def action_confirm(self, cr, uid, ids, context={}):
+        """ Confirm the inventory and writes its finished date
+        @return True
+        """
+        # to perform the correct inventory corrections we need analyze stock location by
+        # location, never recursively, so we use a special context
+        product_context = dict(context, compute_child=False)
+
+        location_obj = self.pool.get('stock.location')
+        for inv in self.browse(cr, uid, ids, context=context):
+            move_ids = []
+            for line in inv.inventory_line_id:
+                pid = line.product_id.id
+                product_context.update(uom=line.product_uom.id,date=inv.date)
+                amount = location_obj._product_get(cr, uid, line.location_id.id, [pid], product_context)[pid]
+         
+                change = line.product_qty - amount
+                lot_id = line.prod_lot_id.id
+                type_id = line.type_id.id
+                if change:
+                    location_id = line.product_id.product_tmpl_id.property_stock_inventory.id
+                    value = {
+                        'name': 'INV:' + str(line.inventory_id.id) + ':' + line.inventory_id.name,
+                        'product_id': line.product_id.id,
+                        'product_uom': line.product_uom.id,
+                        'prodlot_id': lot_id,
+                        'date': inv.date,
+                        # @@@override@ stock.stock_inventory.action_confirm()
+                        'comment': line.comment,
+                        # @@@end
+                    }
+                    if change > 0:
+                        value.update( {
+                            'product_qty': change,
+                            'location_id': location_id,
+                            'location_dest_id': line.location_id.id,
+                        })
+                    else:
+                        value.update( {
+                            'product_qty': -change,
+                            'location_id': line.location_id.id,
+                            'location_dest_id': location_id,
+                        })
+                    if lot_id:
+                        value.update({
+                            'prodlot_id': lot_id,
+                            'product_qty': line.product_qty
+                        })
+                    # @@@override@ stock.stock_inventory.action_confirm()
+                    if type_id:
+                        value.update({
+                            'type_id': type_id,
+                        })
+                    # @@@end
+                    move_ids.append(self._inventory_line_hook(cr, uid, line, value))
+            message = _('Inventory') + " '" + inv.name + "' "+ _("is done.")
+            self.log(cr, uid, inv.id, message)
+            self.write(cr, uid, [inv.id], {'state': 'confirm', 'move_ids': [(6, 0, move_ids)]})
+            
+        return True
+
+stock_inventory()
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+
 
=== added file 'stock_inventory_type/stock_data.xml'
--- stock_inventory_type/stock_data.xml	1970-01-01 00:00:00 +0000
+++ stock_inventory_type/stock_data.xml	2011-03-15 15:12:37 +0000
@@ -0,0 +1,23 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<openerp>
+	<data>
+
+        <record id="adjustment_type_loss" model="stock.adjustment.type">
+            <field name="name">Loss</field>
+        </record>
+
+        <record id="adjustment_type_scrap" model="stock.adjustment.type">
+            <field name="name">Scrap</field>
+        </record>
+
+        <record id="adjustment_type_expired" model="stock.adjustment.type">
+            <field name="name">Expired</field>
+        </record>
+
+        <record id="adjustment_type_broken" model="stock.adjustment.type">
+            <field name="name">Broken</field>
+        </record>
+
+	</data>
+</openerp>
+
 
=== added file 'stock_inventory_type/stock_move_report.py'
--- stock_inventory_type/stock_move_report.py	1970-01-01 00:00:00 +0000
+++ stock_inventory_type/stock_move_report.py	2011-03-15 15:12:37 +0000
@@ -0,0 +1,128 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from osv import osv
+from osv import fields
+
+from decimal_precision import decimal_precision as dp
+
+import tools
+
+
+class report_stock_move(osv.osv):
+    _name = 'report.stock.move'
+    _inherit = 'report.stock.move'
+    
+    _columns = {
+        'type_id': fields.many2one('stock.adjustment.type', string='Adjustment type'),
+    }
+    
+    def init(self, cr):
+        tools.drop_view_if_exists(cr, 'report_stock_move')
+        cr.execute("""
+            CREATE OR REPLACE view report_stock_move AS (
+                SELECT
+                        min(sm_id) as id,
+                        sm_type_id as type_id,
+                        date_trunc('day',al.dp) as date,
+                        al.curr_year as year,
+                        al.curr_month as month,
+                        al.curr_day as day,
+                        al.curr_day_diff as day_diff,
+                        al.curr_day_diff1 as day_diff1,
+                        al.curr_day_diff2 as day_diff2,
+                        al.location_id as location_id,
+                        al.picking_id as picking_id,
+                        al.company_id as company_id,
+                        al.location_dest_id as location_dest_id,
+                        al.product_qty,
+                        al.out_qty as product_qty_out,
+                        al.in_qty as product_qty_in,
+                        al.address_id as partner_id,
+                        al.product_id as product_id,
+                        al.state as state ,
+                        al.product_uom as product_uom,
+                        al.categ_id as categ_id,
+                        coalesce(al.type, 'other') as type,
+                        al.stock_journal as stock_journal,
+                        sum(al.in_value - al.out_value) as value
+                    FROM (SELECT
+                        CASE WHEN sp.type in ('out') THEN
+                            sum(sm.product_qty * pu.factor)
+                            ELSE 0.0
+                            END AS out_qty,
+                        CASE WHEN sp.type in ('in') THEN
+                            sum(sm.product_qty * pu.factor)
+                            ELSE 0.0
+                            END AS in_qty,
+                        CASE WHEN sp.type in ('out') THEN
+                            sum(sm.product_qty * pu.factor) * pt.standard_price
+                            ELSE 0.0
+                            END AS out_value,
+                        CASE WHEN sp.type in ('in') THEN
+                            sum(sm.product_qty * pu.factor) * pt.standard_price
+                            ELSE 0.0
+                            END AS in_value,
+                        min(sm.id) as sm_id,
+                        sm.date as dp,
+                        sm.type_id as sm_type_id,
+                        to_char(date_trunc('day',sm.date), 'YYYY') as curr_year,
+                        to_char(date_trunc('day',sm.date), 'MM') as curr_month,
+                        to_char(date_trunc('day',sm.date), 'YYYY-MM-DD') as curr_day,
+                        avg(date(sm.date)-date(sm.create_date)) as curr_day_diff,
+                        avg(date(sm.date_expected)-date(sm.create_date)) as curr_day_diff1,
+                        avg(date(sm.date)-date(sm.date_expected)) as curr_day_diff2,
+                        sm.location_id as location_id,
+                        sm.location_dest_id as location_dest_id,
+                        sum(sm.product_qty) as product_qty,
+                        pt.categ_id as categ_id ,
+                        sm.address_id as address_id,
+                        sm.product_id as product_id,
+                        sm.picking_id as picking_id,
+                            sm.company_id as company_id,
+                            sm.state as state,
+                            sm.product_uom as product_uom,
+                            sp.type as type,
+                            sp.stock_journal_id AS stock_journal
+                    FROM
+                        stock_move sm
+                        LEFT JOIN stock_picking sp ON (sm.picking_id=sp.id)
+                        LEFT JOIN product_product pp ON (sm.product_id=pp.id)
+                        LEFT JOIN product_uom pu ON (sm.product_uom=pu.id)
+                        LEFT JOIN product_template pt ON (pp.product_tmpl_id=pt.id)
+                        LEFT JOIN stock_location sl ON (sm.location_id = sl.id)
+
+                    GROUP BY
+                        sm.id,sp.type, sm.date,sm.address_id, sm.type_id,
+                        sm.product_id,sm.state,sm.product_uom,sm.date_expected,
+                        sm.product_id,pt.standard_price, sm.picking_id, sm.product_qty,
+                        sm.company_id,sm.product_qty, sm.location_id,sm.location_dest_id,pu.factor,pt.categ_id, sp.stock_journal_id)
+                    AS al
+
+                    GROUP BY
+                        al.out_qty,al.in_qty,al.curr_year,al.curr_month, al.sm_type_id,
+                        al.curr_day,al.curr_day_diff,al.curr_day_diff1,al.curr_day_diff2,al.dp,al.location_id,al.location_dest_id,
+                        al.address_id,al.product_id,al.state,al.product_uom,
+                        al.picking_id,al.company_id,al.type,al.product_qty, al.categ_id, al.stock_journal
+               )
+        """)
+    
+report_stock_move()
 \ No newline at end of file
 
=== added file 'stock_inventory_type/stock_view.xml'
--- stock_inventory_type/stock_view.xml	1970-01-01 00:00:00 +0000
+++ stock_inventory_type/stock_view.xml	2011-03-15 15:12:37 +0000
@@ -0,0 +1,193 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<openerp>
+	<data>
+
+        <!-- Stock Adjustment Types -->
+
+        <record id="stock_adjustment_type_form_view" model="ir.ui.view">
+            <field name="name">stock.adjustment.type.form.view</field>
+            <field name="model">stock.adjustment.type</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Adjustment Type">
+                    <field name="name" colspan="4" select="1" />
+                </form>
+            </field>
+        </record>
+
+        <record id="stock_adjustment_type_tree_view" model="ir.ui.view">
+            <field name="name">stock.adjustment.type.tree.view</field>
+            <field name="model">stock.adjustment.type</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="Adjustment Types">
+                    <field name="name" />
+                </tree>
+            </field>
+        </record>
+
+        <record id="action_stock_adjustment_type" model="ir.actions.act_window">
+            <field name="name">Stock Adjustment Types</field>
+            <field name="res_model">stock.adjustment.type</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">tree,form</field>
+        </record>
+
+        <menuitem
+            name="Inventory"
+            id="menu_configuration_inventory"
+            parent="stock.menu_stock_configuration" />
+
+        <menuitem
+            action="action_stock_adjustment_type"
+            id="menu_stock_adjustment_type"
+            parent="menu_configuration_inventory" />
+
+
+        <!-- Overrirde Stock Inventory Lines -->
+        <record id="stock_inventory_line_tree_type_id" model="ir.ui.view">
+            <field name="name">stock.inventory.line.tree.type.id</field>
+            <field name="model">stock.inventory.line</field>
+            <field name="type">tree</field>
+            <field name="inherit_id" ref="stock.stock_inventory_line_tree" />
+            <field name="arch" type="xml">
+                <xpath expr="/tree/field[@name='prodlot_id']" position="after">
+                    <field name="type_id" widget="selection" />
+                    <field name="comment" />
+                </xpath>
+            </field>
+        </record>
+
+        <record id="stock_inventory_line_form_type_id" model="ir.ui.view">
+            <field name="name">stock.inventory.line.form.type.id</field>
+            <field name="model">stock.inventory.line</field>
+            <field name="type">form</field>
+            <field name="inherit_id" ref="stock.stock_inventory_line_tree" />
+            <field name="arch" type="xml">
+                <xpath expr="/form/field[@name='prodlot_id']" position="after">
+                    <field name="type_id" widget="selection" />
+                    <field name="comment" />
+                </xpath>
+            </field>
+        </record>
+
+        <record id="stock_inventory_form_type_id" model="ir.ui.view">
+            <field name="name">stock.inventory.form.type.id</field>
+            <field name="model">stock.inventory</field>
+            <field name="type">form</field>
+            <field name="inherit_id" ref="stock.view_inventory_form" />
+            <field name="arch" type="xml">
+                <data>
+                    <xpath expr="/form/notebook/page/field[@name='inventory_line_id']/tree/field[@name='product_id']" position="after">
+                        <field name="type_id" widget="selection" />
+                        <field name="comment" />
+                    </xpath>
+                    <xpath expr="/form/notebook/page/field[@name='inventory_line_id']/form/field[@name='product_id']" position="after">
+                        <field name="type_id" widget="selection" />
+                        <field name="comment" />
+                    </xpath>
+                    <xpath expr="/form/notebook/page[@string='Posted Inventory']/field[@name='move_ids']/tree/field[@name='prodlot_id']" position="after">
+                        <field name="type_id" widget="selection" />
+                    </xpath>
+                </data>
+            </field>
+        </record>
+
+        <!-- Override Stock Moves -->
+        <record id="stock_move_tree_type_id" model="ir.ui.view">
+            <field name="name">stock.move.tree.type.id</field>
+            <field name="model">stock.move</field>
+            <field name="type">tree</field>
+            <field name="inherit_id" ref="stock.stock_move_tree" />
+            <field name="arch" type="xml">
+                <xpath expr="/tree/field[@name='prodlot_id']" position="after">
+                    <field name="type_id" widget="selection" />
+                    <field name="comment" />
+                </xpath>
+            </field>
+        </record>
+
+        <record id="stock_move_tree2_type_id" model="ir.ui.view">
+            <field name="name">stock.move.tree2.type.id</field>
+            <field name="model">stock.move</field>
+            <field name="type">tree</field>
+            <field name="inherit_id" ref="stock.stock_move_tree2" />
+            <field name="arch" type="xml">
+                <xpath expr="/tree/field[@name='prodlot_id']" position="after">
+                    <field name="type_id" widget="selection" />
+                    <field name="comment" />
+                </xpath>
+            </field>
+        </record>
+
+        <record id="view_move_tree_type_id" model="ir.ui.view">
+            <field name="name">view.move.tree.type.id</field>
+            <field name="model">stock.move</field>
+            <field name="type">tree</field>
+            <field name="inherit_id" ref="stock.view_move_tree" />
+            <field name="arch" type="xml">
+                <xpath expr="/tree/field[@name='create_date']" position="after">
+                    <field name="type_id" widget="selection" />
+                    <field name="comment" />
+                </xpath>
+            </field>
+        </record>
+
+        <record id="view_move_form_type_id" model="ir.ui.view">
+            <field name="name">view.move.form.type.id</field>
+            <field name="model">stock.move</field>
+            <field name="type">form</field>
+            <field name="inherit_id" ref="stock.view_move_form" />
+            <field name="arch" type="xml">
+                <xpath expr="/form/group/button[@string='Scrap']" position="after">
+                    <field name="type_id" widget="selection" />
+                    <field name="comment" />
+                </xpath>
+            </field>
+        </record>
+
+        <record id="view_move_search_type_id" model="ir.ui.view">
+            <field name="name">view.move.search.type.id</field>
+            <field name="model">stock.move</field>
+            <field name="type">search</field>
+            <field name="inherit_id" ref="stock.view_move_search" />
+            <field name="arch" type="xml">
+                <xpath expr="/search/group/field[@name='product_id']" position="before">
+                    <field name="type_id" widget="selection" />
+                    <field name="comment" />
+                </xpath>
+            </field>
+        </record>
+        
+        <record id="view_stock_tree_type_id" model="ir.ui.view">
+        	<field name="name">view.stock.tree.type.id</field>
+        	<field name="model">report.stock.move</field>
+        	<field name="type">tree</field>
+        	<field name="inherit_id" ref="stock.view_stock_tree" />
+        	<field name="arch" type="xml">
+        		<xpath expr="/tree/field[@name='type']" position="after">
+        			<field name="type_id" />
+        		</xpath>
+        	</field>
+        </record>
+        
+        <record id="view_stock_search_type_id" model="ir.ui.view">
+        	<field name="name">view.stock.search.type.id</field>
+        	<field name="model">report.stock.move</field>
+        	<field name="type">search</field>
+        	<field name="inherit_id" ref="stock.view_stock_search" />
+        	<field name="arch" type="xml">
+        		<data>
+	        		<xpath expr="/search/group/separator[3]" position="after">
+	        			<field name="type_id" widget="selection" />
+	        		</xpath>
+	        		<xpath expr="/search/group[@string='Group By...']/filter[@name='group_type']" position="after">
+	        			<filter string="Adjustment Type" name="group_type_id" icon="terp-stock_symbol-selection" context="{'group_by':'type_id'}" />
+	        		</xpath>
+        		</data>
+        	</field>
+        </record>
+
+	</data>
+</openerp>
+
 
=== added directory 'stock_inventory_type/test'
=== added file 'stock_inventory_type/test/adjustment_type.yml'
--- stock_inventory_type/test/adjustment_type.yml	1970-01-01 00:00:00 +0000
+++ stock_inventory_type/test/adjustment_type.yml	2011-03-15 15:12:37 +0000
@@ -0,0 +1,117 @@
+- 
+  In order to test the stock_inventory_type module, I will create product,
+  create a physical inventory, fill inventory lines from location
+-
+  I create a product category
+-
+  !record {model: product.category, id: product_category1}:
+    name: Categ1
+-
+  I create the first product (P1)
+-
+  !record {model: product.product, id: product_p1}:
+    valuation: manual_periodic
+    supply_method: produce
+    mes_type: fixed
+    uom_id: product.product_uom_unit
+    uom_po_id: product.product_uom_unit
+    type: product
+    procure_method: make_to_stock
+    cost_method: standard
+    categ_id: stock_inventory_type.product_category1
+    name: P1
+    standard_price: 10.0
+-
+  I create the second product (P2)
+-
+  !record {model: product.product, id: product_p2}:
+    valuation: manual_periodic
+    supply_method: produce
+    mes_type: fixed
+    uom_id: product.product_uom_unit
+    uom_po_id: product.product_uom_unit
+    type: product
+    procure_method: make_to_stock
+    cost_method: standard
+    categ_id: stock_inventory_type.product_category1
+    name: P2
+    standard_price: 20.0
+-
+    I create the third product (P3)
+-
+  !record {model: product.product, id: product_p3}:
+    valuation: manual_periodic
+    supply_method: produce
+    mes_type: fixed
+    uom_id: product.product_uom_unit
+    uom_po_id: product.product_uom_unit
+    type: product
+    procure_method: make_to_stock
+    cost_method: standard
+    categ_id: stock_inventory_type.product_category1
+    name: P3
+    standard_price: 30.0
+-
+    I create a physical inventory
+-
+  !record {model: stock.inventory, id: stock_inventory1}:
+    company_id: base.main_company
+    date: !eval time.strftime('%Y-%m-%d %H:%M:%S')
+    inventory_line_id:
+      - company_id: base.main_company
+        location_id: stock.stock_location_stock
+        product_id: stock_inventory_type.product_p1
+        product_qty: 70.0
+        product_uom: product.product_uom_unit
+        type_id: stock_inventory_type.adjustment_type_loss
+        comment: Loss items
+      - company_id: base.main_company
+        location_id: stock.stock_location_stock
+        product_id: stock_inventory_type.product_p2
+        product_qty: 50.0
+        product_uom: product.product_uom_unit
+        type_id: stock_inventory_type.adjustment_type_expired
+        comment: Expired product at 12/12/2012
+      - company_id: base.main_company
+        location_id: stock.stock_location_stock
+        product_id: stock_inventory_type.product_p3
+        product_qty: 10.0
+        product_uom: product.product_uom_unit
+        type_id: stock_inventory_type.adjustment_type_scrap
+    name: Test of UNI-SUP-1.15
+    state: draft
+-
+    I confirm the Inventory
+-
+  !python {model: stock.inventory}: |
+    self.action_confirm(cr, uid, [ref('stock_inventory1')])
+    self.action_done(cr, uid, [ref('stock_inventory1')])
+-
+    I check the 'Loss' stock moves
+-
+  !python {model: stock.move}: |
+    move_ids = self.search(cr, uid, [('type_id', '=', ref('stock_inventory_type.adjustment_type_loss'))])
+    assert move_ids, "No lines with 'Loss' type"
+    move = self.browse(cr, uid, move_ids[0])
+    assert move.product_id.id == ref('stock_inventory_type.product_p1'), "Move product (P1) is not correct"
+    assert move.product_qty == 70.0, "Move quatity (70.0) is not correct"
+    assert move.comment == 'Loss items', "Move comment (Loss items) is not correct"
+-
+    I check the 'Expired' stock moves
+-
+  !python {model: stock.move}: |
+    move_ids = self.search(cr, uid, [('type_id', '=', ref('stock_inventory_type.adjustment_type_expired'))])
+    assert move_ids, "No lines with 'Expired' type"
+    move = self.browse(cr, uid, move_ids[0])
+    assert move.product_id.id == ref('stock_inventory_type.product_p2'), "Move product (P2) is not correct"
+    assert move.product_qty == 50.0, "Move quatity (50.0) is not correct"
+    assert move.comment == 'Expired product at 12/12/2012', "Move comment (Expired product at 12/12/2012) is not correct"
+-
+    I check the 'Scrapped' stock moves
+-
+  !python {model: stock.move}: |
+    move_ids = self.search(cr, uid, [('type_id', '=', ref('stock_inventory_type.adjustment_type_scrap'))])
+    assert move_ids, "No lines with 'Scrap' type"
+    move = self.browse(cr, uid, move_ids[0])
+    assert move.product_id.id == ref('stock_inventory_type.product_p3'), "Move product (P3) is not correct"
+    assert move.product_qty == 10.0, "Move quatity (10.0) is not correct"