Ir al contenido
Odoo Menú
  • Iniciar sesión
  • Pruébalo gratis
  • Aplicaciones
    Finanzas
    • Contabilidad
    • Facturación
    • Gastos
    • Hoja de cálculo (BI)
    • Documentos
    • Firma electrónica
    Ventas
    • CRM
    • Ventas
    • PdV para tiendas
    • PdV para restaurantes
    • Suscripciones
    • Alquiler
    Sitios web
    • Creador de sitios web
    • Comercio electrónico
    • Blog
    • Foro
    • Chat en vivo
    • eLearning
    Cadena de suministro
    • Inventario
    • Manufactura
    • PLM
    • Compras
    • Mantenimiento
    • Calidad
    Recursos humanos
    • Empleados
    • Reclutamiento
    • Vacaciones
    • Evaluaciones
    • Referencias
    • Flotilla
    Marketing
    • Redes sociales
    • Marketing por correo
    • Marketing por SMS
    • Eventos
    • Automatización de marketing
    • Encuestas
    Servicios
    • Proyectos
    • Registro de horas
    • Servicio externo
    • Soporte al cliente
    • Planeación
    • Citas
    Productividad
    • Conversaciones
    • Aprobaciones
    • IoT
    • VoIP
    • Artículos
    • WhatsApp
    Aplicaciones externas Studio de Odoo Plataforma de Odoo en la nube
  • Industrias
    Venta minorista
    • Librería
    • Tienda de ropa
    • Mueblería
    • Tienda de abarrotes
    • Ferretería
    • Juguetería
    Alimentos y hospitalidad
    • Bar y pub
    • Restaurante
    • Comida rápida
    • Casa de huéspedes
    • Distribuidora de bebidas
    • Hotel
    Bienes inmuebles
    • Agencia inmobiliaria
    • Estudio de arquitectura
    • Construcción
    • Gestión de bienes inmuebles
    • Jardinería
    • Asociación de propietarios
    Consultoría
    • Firma contable
    • Partner de Odoo
    • Agencia de marketing
    • Bufete de abogados
    • Adquisición de talentos
    • Auditorías y certificaciones
    Manufactura
    • Textil
    • Metal
    • Muebles
    • Comida
    • Cervecería
    • Regalos corporativos
    Salud y ejercicio
    • Club deportivo
    • Óptica
    • Gimnasio
    • Especialistas en bienestar
    • Farmacia
    • Peluquería
    Trades
    • Personal de mantenimiento
    • Hardware y soporte de TI
    • Sistemas de energía solar
    • Zapateros y fabricantes de calzado
    • Servicios de limpieza
    • Servicios de calefacción, ventilación y aire acondicionado
    Otros
    • Organización sin fines de lucro
    • Agencia para la protección del medio ambiente
    • Alquiler de anuncios publicitarios
    • Fotografía
    • Alquiler de bicicletas
    • Distribuidor de software
    Descubre todas las industrias
  • Odoo Community
    Aprende
    • Tutoriales
    • Documentación
    • Certificaciones
    • Capacitación
    • Blog
    • Podcast
    Fortalece la educación
    • Programa educativo
    • Scale Up! El juego empresarial
    • Visita Odoo
    Obtén el software
    • Descargar
    • Compara ediciones
    • Versiones
    Colabora
    • GitHub
    • Foro
    • Eventos
    • Traducciones
    • Conviértete en partner
    • Servicios para partners
    • Registra tu firma contable
    Obtén servicios
    • Encuentra un partner
    • Encuentra un contador
    • Contacta a un consultor
    • Servicios de implementación
    • Referencias de clientes
    • Soporte
    • Actualizaciones
    GitHub YouTube Twitter LinkedIn Instagram Facebook Spotify
    +1 (650) 691-3277
    Solicita una demostración
  • Precios
  • Ayuda

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Contabilidad
  • Inventario
  • PoS
  • Proyectos
  • MRP
All apps
Debe estar registrado para interactuar con la comunidad.
Todas las publicaciones Personas Insignias
Etiquetas (Ver todo)
odoo accounting v14 pos v15
Acerca de este foro
Debe estar registrado para interactuar con la comunidad.
Todas las publicaciones Personas Insignias
Etiquetas (Ver todo)
odoo accounting v14 pos v15
Acerca de este foro
Ayuda

Odoo WIP valuation

Suscribirse

Reciba una notificación cuando haya actividad en esta publicación

Se marcó esta pregunta
4 Respuestas
13223 Vistas
Avatar
jpeluso@outlook.com

Can anyone recommend a tutorial or instructions on how to calculate WIP?

-1
Avatar
Descartar
Avatar
Ray Carnes (ray)
Mejor respuesta

Although I am posting an answer to a similar question from a few years back - the principles remain the same.

Let’s look at a very simple example.  

A single product “Finished Widget” is created from a combination of components and labor – with the exact amounts of both not known until after each Manufacturing Order is completed. 

Note: We will not include purchasing of raw materials in this example and will model Labor as a component instead of a service (reducing complexity of the example).  The principles here should help you understand what is possible. I don't recommend this approach (using Labor as a product) if you use Work Orders and Work Centers.

Four Products:


The cost price of the Finished Widget is set to $0 to make the point that Odoo will calculate the actual product cost based on the number of components and labor used in each Manufacturing Order.

The Bill of Materials:


Odoo allows us to increase or decrease the quantity of components used in an actual Manufacturing Orders – supporting cases where the actual quantity of components and labor is not known until after a product is created.  What we have above is what gets used in a ‘perfect’ case.  It could be more or less.

Before we start making anything, let’s review how the Product Categories and Locations need to be setup - critical to all this working.

For both Raw Materials and Finished Goods Product Categories:


For Labor Product Category, it is the same as the above with the following Account Stock Properties:


For the Production Location:


Finally, to see what I will show in this example, you will need to add the PRODUCT_ID field to the account_move_line tree view (Journal Items) and the PRICE_UNIT field to stock_move tree view.

Let’s produce three “Finished Widgets” – one with exactly what is on the Bill of Materials, one with more, one with less – and look at how the product cost changes.

1. MO1 – same as BoM:

We will confirm; reserve; and then produce this Manufacturing Order.

The Stock Moves (This product cost us $19.95 to make):

The Accounting Moves for the Components:


A total of $19.95 is moved from Stock to WIP.

The Accounting Moves for the Finished Product:

A total of $19.95 is moved from WIP to Stock.

2. MO2 – more than BoM:

In the Produce wizard, we adjust the quantities – increasing everything by 1 unit:

 

The Stock Moves (This product cost us $38.05 to make):


The Accounting Moves:


(Both the $38.05 from stock to WIP and the $38.05 from WIP to stock)

3. MO3 – less than BoM:

In the Produce wizard, we adjust the quantities – decreasing Component Two and Labor and removing Component One entirely:


The Stock Moves (This product cost us $9.35 to make):


The Accounting Moves:


(Both the $9.35 from stock to WIP and the $9.35 from WIP to stock)

So you can see Odoo correctly costed the product each time:


And correctly values them in Inventory:



Again, I have deliberately simplified the exercise, but it does demonstrate ONE way to model the real manufacturing costs associated with variable materials and labor inputs. 

The way I have completed the Manufacturing Orders in a single step means that the value of WIP will be increased and decreased in a single step - you can have it increase, then decrease (two steps) if you consume materials first, then produce.  You can do this via the Produce Wizard by changing "Consume and Produce" to "Consume" and clicking the PRODUCE button on the Manufacturing Order twice, once to Consume, once to Produce.  You will get the same accounting movements, but the timing will allow you to measure WIP for each job. 

 

5
Avatar
Descartar
jpeluso@outlook.com
Autor

Thanks Ray. I appreciate this.

John

Amr El-Sawy

Hello Ray, Regarding the Last part of your answer:

"The way I have completed the Manufacturing Orders in a single step means that the value of WIP will be increased and decreased in a single step - you can have it increase, then decrease (two steps) if you consume materials first, then produce. You can do this via the Produce Wizard by changing "Consume and Produce" to "Consume" and clicking the PRODUCE button on the Manufacturing Order twice, once to Consume, once to Produce. You will get the same accounting movements, but the timing will allow you to measure WIP for each job."

Is that still feasible to be done in odoo V14 ? and how ? because there is no consume & produce button anymore i guess its merged in Mark as Done Button.

Thanks in Advance

Ray Carnes (ray)

@Amr - no - at v14 we only support (without customization) "PLANNED WIP" (the BoM Structure and Cost report) and "ACTUAL WIP" (Manufacturing Order Cost Analysis report)

jbarnhart@minespress.com

"at v14 we only support (without customization) "PLANNED WIP" (the BoM Structure and Cost report) and "ACTUAL WIP" (Manufacturing Order Cost Analysis report)"

If this is the case, then WIP is a misnomer, because there is not longer an "in process" aspect to it. At least from what I've seen in 14.

Hi Ray

With regards your comment below any changes in this behavior in V15? Ideally, we do not want WIP to be updated in a single step, but rather as the product is being manufactured.

Ray Carnes (ray)

@Amy - no change - WIP being updated while a Manufacturing Order is in progress requires customization. See https://apps.odoo.com/apps/modules/13.0/mrp_timesheets/ and https://apps.odoo.com/apps/modules/14.0/mrp_services/ for ideas on how.

Avatar
Nosayba Sulieman
Mejor respuesta

Are you sure this works for version 15? labour category does not generate stock journal entries for service products (worker hours).

Stock moves are only generated for storable products

Thanks


0
Avatar
Descartar
Avatar
vishalratani
Mejor respuesta

Valuation in Odoo is on the cost price. So if some inventory is in the form of WIP then it would be treated as ( cost of WIP product* WIP Product quantity) 

Thanks

Vishal

0
Avatar
Descartar
Avatar
Yogi Rismawan
Mejor respuesta

Hi,

I am using Odoo V12 CE Version, and trying to follow your steps to set WIP.

But I didn't find the menu when I tried to follow to set Work in Progress account for the production location.


Thanks,

Yogi

0
Avatar
Descartar
Mustafa Bashier

Go to inventory > settings enable storage locations option, then go to inventory > configuration > locations and remove the filter so that all locations do appear and i think you will find what you're looking for.

Yogi Rismawan

Yes I found where to set WIP account for production location. Now I get error pop-up saying that the cost of finished product is 0 when trying to complete MO.

¿Le interesa esta conversación? ¡Participe en ella!

Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.

Registrarse
Comunidad
  • Tutoriales
  • Documentación
  • Foro
Código abierto
  • Descargar
  • GitHub
  • Runbot
  • Traducciones
Servicios
  • Alojamiento en Odoo.sh
  • Soporte
  • Actualizaciones del software
  • Desarrollos personalizados
  • Educación
  • Encuentra un contador
  • Encuentra un partner
  • Conviértete en partner
Sobre nosotros
  • Nuestra empresa
  • Activos de marca
  • Contáctanos
  • Empleos
  • Eventos
  • Podcast
  • Blog
  • Clientes
  • Legal • Privacidad
  • Seguridad
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo es un conjunto de aplicaciones de código abierto que cubren todas las necesidades de tu empresa: CRM, comercio electrónico, contabilidad, inventario, punto de venta, gestión de proyectos, etc.

La propuesta única de valor de Odoo es ser muy fácil de usar y estar totalmente integrado.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now