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

Product output and valuation account are same error

Suscribirse

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

Se marcó esta pregunta
journalaccountentryoutput
2 Respuestas
17873 Vistas
Avatar
odimegwu david

can anyone help me? I got this message when I wanted to Receive a product whose Purchase Order was already confirmed: Error: Cannot create Journal Entry, Output Account of this product and Valuation account on category of this product are same. I do not know how to resolve it. Beats me! TIA

0
Avatar
Descartar
odimegwu david
Autor

Additional details. Just found this out: Stock Input Account, Stock output Account and Stock Valuation Account have the same values: 1107 Stock Account. i wonder why input account and valuation account should not be the same. Can anyone explain why they should be different? My accounting says I am correct, unless I am missing out on something. tia

Avatar
Farook
Mejor respuesta

Dear David, To correct your error follow below steps. Please note its just an example, you have to name your accounts according to your chart of accounts 1) create an Account called "Purchase Account" (Internal Type=Regular, Account Type=Expense). Then make this the Stock Input Account. 2) Then create an Account called "Purchased Stock" (Internal Type=Regular, Account Type=Asset) and make this as the Stock Valuation Account 3) Create an Account called "Cost of Goods Sold" (Internal Type=Regular, Account Type=Expense) and make this as the Stock Output Account 4) Make sure your "Expense" account and "Stock Input" account in the product/product category are the same.

The above scenario will give you a perfect stock valuation and accounting. Please note it's just an example of setting this. You can do it in your own way

3
Avatar
Descartar
odimegwu david
Autor

Thanks Farouk. I have already done so after reading a blog entry. I followed the stock inventory model : beginning inventory + purchases = available for sale. Av. for sale = cost of goods sold + end inventory. I want to ask one question though: Why is the Purchase Account with Account type=Expense in your prescription, because I think it should be of type=Asset, just as Purchased Account is type=Asset. Your response would be helpful.

Farook

Hi David, in my Chart of Accounts, "Purchase Account" represents the money I spent for buying the products, so it's an expense account. The "Purchased Stock" represents the stock bought by the company, so that's the Asset account you are referring to in my case. So when I create a Purchase Invoice, my "Purchase Account" will get debited and "Supplier Account" will get credited. Then when I create an Incoming Shipment document for receiving those purchased product, "Purchase Account" will get credited and "Purchased Stock" account will get debited.

Farook

Now when you sell this product, this is the way accounting entries gets created. 1) When Sales Invoice is created, "Sales Account" gets credited with sales price and "Customer Account" gets debited with sales price 2) When you create a Delivery Order for the same product and deliver it from the warehouse, "Purchased Stock" Account gets credited with the cost price and "Sales Account" gets debited with the Cost Price.

odimegwu david
Autor

Chart of accounts comment: I follow your logic, Farook, but the money spent for buying the product is reflected in either Accounts Payable for the customer (if on credit) or cash account (if on cash basis). You should rename Purchase Account, Stock Purchases Account. I am a student of accounting. On buying goods, you debit the Stock Purchases Account and credit the cash or Accounts Payable account. Eventually, when you are to deliver the goods, or when it is doing inventory management, the system does a reconciliation between Stock Purchases Account and Purchased Account (to be continued)

odimegwu david
Autor

in reconciliation, it then credits Stock Purchases Account and debits Stock Purchased Account. so check account reconciliation for all your stock accounts. I uncheck for all accounts by default. So, you see, both are stock accounts and asset accounts, only that openerp wants a seamless inventory management system so it doesn't confuse purchases with stock available for sale which is that base for valuation. thanks. also, it was programmed that beginning and ending stock are virtual containers which are reflected in Stock Purchased Account.

odimegwu david
Autor

BTW, when you deliver goods, Stock Purchased account gets credited while cost of goods sold is debited. Cost of goods sold is an expense account.

Vaibhav

@Farook can you please tell me that what is internal type and Account Type for Price Difference Account ?(I installed account_anglo_saxon module)

Avatar
Ray Carnes
Mejor respuesta

The valuation account holds stock accounting moves (debits and credits) that correspond to the movement of the stock, and the overall value at any given time.

Stock moves either into or out of the stock location.

The stock input account holds the corresponding credits for the value of stock moved into the stock location.

The stock output account holds the corresponding debits for the value of stock moved out of the stock location.

It may be easier to watch the demo and/or review the slides that show how to set this up. http://www.ursainfosystems.com/webinar

2
Avatar
Descartar
Sean Samborski

Hi, Ray. Your link is now dead. Do you have an updated link? I am running through this issue right now and can't figure out why this error says my accounts are the same when clearly they are different. There isn't a single same entry on any line. Your video might be of help. Thanks.

¿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
What is the difference between account and journal ? Resuelto
journal account
Avatar
Avatar
Avatar
Avatar
5
jul 19
17157
Proforma Invoice - Unposted Journal Entry
journal entry proforma
Avatar
Avatar
1
jul 16
7473
Star (Asterisk) with Number in the Journal Entry
journal asterisk entry
Avatar
1
mar 15
4958
Multi Company and account_id
journal account multi
Avatar
Avatar
1
mar 15
4530
Why note between invoice lines generates journal item?
journal v7 account
Avatar
0
mar 15
4644
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