Odoo Help


How to record food waste/loss in OpenERP 7

Kevin Shenk
on 5/10/13, 3:23 PM 6,300 views

I've setup OpenERP 7 for a small coffee shop. The POS is working fine, but I need a way to track the inventory.

Inventory tracking through receiving and selling products seems rather straight forward, but there is one problem that I can't seem to get a handle on.

One significant factor affecting the inventory is food that is discarded because or age, spoilage, contamination, etc. What is the best way to input and account for this in OpenERP?


Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 5/10/13, 4:01 PM


You can do this when receiving, when delivering, when manufacturing, and via an Internal Move when you need to do it not related to one of the previous events.

Make sure Manage multiple locations and warehouses is checked via

Settings -> Configuration -> Warehouse

under the Location & Warehouse section.

When you scrap products, they are transferred to the Scrap location. You have two ways to review the quantity of items scrapped.

1) For all products, go to

Warehouse -> Inventory Control –> Location Structure

Then select Vitrual Locations from the dropdown, click Scrapped, choose either Current or Period and click View Product Inventory.

2) For an individual product, open the Product and from the More menu, select Stock by Location.

Thank-you so much for your quick and helpful answer Ray!

I just have one question about actually recording scrap. What is the most straight-forward method? What is the best way to use the internal move function? If all we're doing is scrapping an item, do we open the internal move form, mark items as scrapped, and then discard the internal move? Or do they also need moved to a different physical location as well to be actually deducted from inventory?

Thanks again for your help!

Kevin Shenk
on 5/13/13, 11:33 AM

Just complete the move. From every place you can move stock, you can scrap. It doesn't make sense to scrap in the middle of a move that is meant to record scrap. Complete the move and forget about the scrap button there. Nothing else needs to happen - the quantity is removed from inventory as soon as it is scrapped.

Ray Carnes
on 5/16/13, 7:34 PM

Makes sense. Thanks so much for your helpful advice!

Kevin Shenk
on 5/17/13, 7:32 AM

There is a case, where you need to manage a waste, no a product scrap but a waste or variable result of a production process... for example in the food industry, when you cook something with a weight of 1 kg and after the cooking, it weights 0,8 kg. How to do that?

Blanco Martín & Asociados, Ing. Daniel Blanco
on 10/2/17, 11:02 PM
Aurélien DUMAINE
On 12/16/13, 12:39 AM

I would like to create a kind of batch action that put in the scrapp virtual location the whole stock of a product list each day. What is the best way to implement that ?

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 5/10/13, 3:23 PM
Seen: 6300 times
Last updated: 10/8/16, 6:31 AM