Ir al contenido
Odoo Menú
  • Identificarse
  • Pruébalo gratis
  • Aplicaciones
    Finanzas
    • Contabilidad
    • Facturación
    • Gastos
    • Hoja de cálculo (BI)
    • Documentos
    • Firma electrónica
    Ventas
    • CRM
    • Ventas
    • TPV para tiendas
    • TPV para restaurantes
    • Suscripciones
    • Alquiler
    Sitios web
    • Creador de sitios web
    • Comercio electrónico
    • Blog
    • Foro
    • Chat en directo
    • eLearning
    Cadena de suministro
    • Inventario
    • Fabricación
    • PLM
    • Compra
    • Mantenimiento
    • Calidad
    Recursos Humanos
    • Empleados
    • Reclutamiento
    • Ausencias
    • Evaluación
    • Referencias
    • Flota
    Marketing
    • Marketing social
    • Marketing por correo electrónico
    • Marketing por SMS
    • Eventos
    • Automatización de marketing
    • Encuestas
    Servicios
    • Proyecto
    • Partes de horas
    • Servicio de campo
    • Servicio de asistencia
    • Planificación
    • Citas
    Productividad
    • Conversaciones
    • Aprobaciones
    • IoT
    • VoIP
    • Información
    • WhatsApp
    Aplicaciones de terceros Studio de Odoo Plataforma de Odoo Cloud
  • Industrias
    Comercio al por menor
    • Librería
    • Tienda de ropa
    • Tienda de muebles
    • Tienda de ultramarinos
    • Ferretería
    • Juguetería
    Alimentación y hostelería
    • Bar y taberna
    • Restaurante
    • Comida rápida
    • Casa de huéspedes
    • Distribuidor de bebidas
    • Hotel
    Inmueble
    • Agencia inmobiliaria
    • Estudio de arquitectura
    • Construcción
    • Gestión inmobiliaria
    • Jardinería
    • Asociación de propietarios
    Consultoría
    • Empresa contable
    • Partner de Odoo
    • Agencia de marketing
    • Bufete de abogados
    • Adquisición de talentos
    • Auditorías y certificaciones
    Fabricación
    • Textil
    • Metal
    • Muebles
    • Alimentos
    • Brewery
    • Regalos de empresas
    Salud y bienestar
    • Club deportivo
    • Óptica
    • Gimnasio
    • Terapeutas
    • Farmacia
    • Peluquería
    Oficios
    • Handyman
    • Hardware y asistencia informática
    • Sistemas de energía solar
    • Zapatero
    • Servicios de limpieza
    • Servicios de calefacción, ventilación y aire acondicionado
    Otros
    • Organización sin ánimo de lucro
    • Agencia de protección del medio ambiente
    • Alquiler de paneles publicitarios
    • Estudio fotográfico
    • Alquiler de bicicletas
    • Distribuidor de software
    Browse all Industries
  • Comunidad
    Aprender
    • Tutoriales
    • Documentación
    • Certificaciones
    • Formación
    • Blog
    • Podcast
    Potenciar la educación
    • Programa de formación
    • Scale Up! El juego empresarial
    • Visita Odoo
    Obtener el software
    • Descargar
    • Comparar ediciones
    • Versiones
    Colaborar
    • GitHub
    • Foro
    • Eventos
    • Traducciones
    • Convertirse en partner
    • Services for Partners
    • Registrar tu empresa contable
    Obtener servicios
    • Encontrar un partner
    • Encontrar un asesor fiscal
    • Contacta con un experto
    • Servicios de implementación
    • Referencias de clientes
    • Ayuda
    • Actualizaciones
    GitHub YouTube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Solicitar 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
  • Proyecto
  • 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

How to avoid use of Internal Warehouse address on Sales Order or Purchase Order? V17e

Suscribirse

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

Se marcó esta pregunta
purchasestocksales
1 Responder
2258 Vistas
Avatar
Andrew Whelan

My client has multiple suppliers and customers who also hold some of my client's stock on consignment. The problem comes when my client sets up the warehouse for this consignment stock, and - as would seem natural to them - selects the main customer/vendor address as the warehouse address. The problem is that Odoo then treats any subsequent Sales order delivery or Purchase order receipt for that company as an internal transfer rather than as a sale/purchase. They only realize this later when looking at their stock.  

What ways do you deal with this to prevent users making this to-easy-to-make mistake?

Version 17.0 Enterprise


0
Avatar
Descartar
Avatar
Lars Aam
Mejor respuesta

The address for the warehouse should always be the physical address.  The premises.  Nothing else. Do not set up warehouse according to the owner. There are other functions to set owner of stock - consignment stock

You need to set up routes that define from which warehouse you want to deliver from.  Set possible to select either on product or om sales order - or both. 

For purchase order there is available to set the operation type for the incoming to the correct warehouse.  Each warehouse should have their own transfer for incoming.

0
Avatar
Descartar
Andrew Whelan
Autor

I think I need to clarify. In this case, the customer's delivery address for sales IS exactly the same as the address of the warehouse to which consignment stock is sent. e.g. Sales to Bob's Cool Foods Ltd are delivered to Bob's Coolstore, 14 Smith Street, Jonesville. Other stock, which remains the company's stock, may also be shipped, by way of transfer, for storage at Bob's Coolstore, 14 Smith Street, Jonesville. If the Address "Bob's Coolstore, 14 Smith Street, Jonesville" is selected as the Warehouse address (only natural for a user to do, as it is exactly that address), any sales order will be treated as an internal transfer with no transparency to the user that this will be the case. 

Lars Aam

Why is the customer and the warehouse the same address? Is this like the business sell their own stock to customer, but keeps the stock in the warehouse for the customer.
In that case it is not directly supported. But what we do in other businesses is to process and outbound delivery to the customer, and then take a return where we set the owner of the returned stock to the customer partner.
To ship it when customer want it sent, we create an outbound delivery without reference to sales order.

Andrew Whelan
Autor

Imagine you're the owner of Pete's Pineapple Juicery. You're a primary producer of Pineapple juice, predominantly for wholesale supply to secondary producers. You also make a variety of fruit iceblocks for the retail market for which you buy in other juices. 4 hours away is Arnie's Apple Juicery, selling Apple juice to secondary producers, and also making a variety of retail fruit leathers. Another 4 hours away is Bernie's Berrys; They sell berry pulp and juice to secondary producers, and also have a retail line of fruit jellies.
In common to all three businesses is that they each own the only coolstore in their town, attached to their factory. They buy the wholesale juice products off each other, as ingredients for their respective secondary products. AND because the coolstore attached to each factory is the only coolstore in their respective town, each business also uses the other business' coolstores as their storage depot in that town for their retail products. So, the same physical address is a delivery address for sales, and an address for purchases, and a Warehouse address for their own stock.
In Odoo, the moment you select an address as the address for a warehouse, the Customer Location and Vendor location (hidden except in Dev mode) get updated to the Inter-warehouse transit location. Unfortunately Odoo doesn't block an address that's been set as a warehouse address from being selected as a customer or delivery address in a Sales order, or as vendor in a Purchase order. Sales orders isn't so bad, because at time of confirming the order it'll error because there isn't a defined replenishment route for the Inter-warehouse transit location. It only becomes a problem if that delivery address is set as a warehouse address after the confirmation and before the delivery. In Purchase orders through, it'll allow it through without the user knowing better, and on receipt, the stock transaction is that of the inward side of a transfer rather than that of a purchase. So that's a bit of a gaping hole.
I've now set an automation rule on contacts so that when the customer or vendor location is updated to a Transit type location, it adds a blocking message on that contact for both Sales Orders and Purchase Orders, and it also changes the Address Type from Delivery Address to Other Address, so that it won't default as delivery address on sales orders. Open to better suggestions though.
Without knowing if there are *legitimate* use cases for internal warehouse addresses being allowed on Sales and Purchase orders, it would make sense to me that there should be tighter control around this, including at the very least an additional Address Type "Internal Warehouse" on the contact.

Lars Aam

From your description it looks like your business is operating a third party warehouse: You provide warehouse operations for other companies?
As far as I have found, there is not a full support for such a business in Odoo. But the solution should be to set a owner on the products when you recieve the product, and you must set owner on the product also for shipping out. My recommendation in cases like that is to use specific products by customer, as it will be easier to separate. And maybe also product categories for each customer.

What you seems to do is connect owner of the products with name on the warehouse. So you have define one physical warehouse as several warehouses by customer? This will not work properly.

The solution in Odoo would be to manage owner of the stock and not define different warehouse by customer. Odoo is missing a sales order type to help on create outbound shipment, and a purchase order for create inbound shipment for a third party operator. The solution for that is to manually create directly the transfer in and out.

There is a third party app that might help. But it looks to me that it is ment to be for business that rent warehouse services.

Andrew Whelan
Autor

I probably shouldn't use the word "Consignment", because we decided not to use Odoo's consignment feature on this site; we didn't want the other business' stock sitting in our stock at all. It's more like, they just rent space in our warehouse. Each business still manages their own stock within each others' warehouse as if it's their own warehouse. We do internal transfers for our stock that's just moving between warehouses, versus Sales and Purchase orders when we're actually buying and selling the stock. That's all working just fine. We just had to find a way to stop the users from using an internal warehouse address on a Sales or Purchase order, because, well, from the user's point of view, it's the same address.

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

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

Inscribirse
Publicaciones relacionadas Respuestas Vistas Actividad
Automatically creating Receipt on sale order instead of Delivery
purchase stock sales
Avatar
Avatar
Avatar
3
ago 25
2119
Automatic stock update after a sale
stock sales
Avatar
Avatar
Avatar
2
ago 25
2581
How to add products up to the available stock quantity in my store?
purchase sales
Avatar
Avatar
Avatar
2
ago 25
2480
Multi Company Transfer Resuelto
purchase sales
Avatar
Avatar
1
jul 25
1488
pass value from sale.order.line to stock.move in odoo 16 Resuelto
stock sales
Avatar
Avatar
1
may 25
2682
Comunidad
  • Tutoriales
  • Documentación
  • Foro
Código abierto
  • Descargar
  • GitHub
  • Runbot
  • Traducciones
Servicios
  • Alojamiento Odoo.sh
  • Ayuda
  • Actualizar
  • Desarrollos personalizados
  • Educación
  • Encontrar un asesor fiscal
  • Encontrar un partner
  • Convertirse en partner
Sobre nosotros
  • Nuestra empresa
  • Activos de marca
  • Contacta con nosotros
  • Puestos de trabajo
  • Eventos
  • Podcast
  • Blog
  • Clientes
  • Información 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 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