Pular para o conteúdo
Odoo Menu
  • Entrar
  • Experimente grátis
  • Aplicativos
    Finanças
    • Financeiro
    • Faturamento
    • Despesas
    • Planilhas (BI)
    • Documentos
    • Assinar Documentos
    Vendas
    • CRM
    • Vendas
    • PDV Loja
    • PDV Restaurantes
    • Assinaturas
    • Locação
    Websites
    • Criador de Sites
    • e-Commerce
    • Blog
    • Fórum
    • Chat ao Vivo
    • e-Learning
    Cadeia de mantimentos
    • Inventário
    • Fabricação
    • PLM - Ciclo de Vida do Produto
    • Compras
    • Manutenção
    • Qualidade
    Recursos Humanos
    • Funcionários
    • Recrutamento
    • Folgas
    • Avaliações
    • Indicações
    • Frota
    Marketing
    • Redes Sociais
    • Marketing por E-mail
    • Marketing por SMS
    • Eventos
    • Automação de Marketing
    • Pesquisas
    Serviços
    • Projeto
    • Planilhas de Horas
    • Serviço de Campo
    • Central de Ajuda
    • Planejamento
    • Compromissos
    Produtividade
    • Mensagens
    • Aprovações
    • Internet das Coisas
    • VoIP
    • Conhecimento
    • WhatsApp
    Aplicativos de terceiros Odoo Studio Plataforma Odoo Cloud
  • Setores
    Varejo
    • Loja de livros
    • Loja de roupas
    • Loja de móveis
    • Mercearia
    • Loja de ferramentas
    • Loja de brinquedos
    Comida e hospitalidade
    • Bar e Pub
    • Restaurante
    • Fast Food
    • Hospedagem
    • Distribuidor de bebidas
    • Hotel
    Imóveis
    • Imobiliária
    • Escritório de arquitetura
    • Construção
    • Administração de propriedades
    • Jardinagem
    • Associação de proprietários de imóveis
    Consultoria
    • Escritório de Contabilidade
    • Parceiro Odoo
    • Agência de marketing
    • Escritório de advocacia
    • Aquisição de talentos
    • Auditoria e Certificação
    Fabricação
    • Têxtil
    • Metal
    • Móveis
    • Alimentação
    • Cervejaria
    • Presentes corporativos
    Saúde e Boa forma
    • Clube esportivo
    • Loja de óculos
    • Academia
    • Profissionais de bem-estar
    • Farmácia
    • Salão de cabeleireiro
    Comércio
    • Handyman
    • Hardware e Suporte de TI
    • Sistemas de energia solar
    • Sapataria
    • Serviços de limpeza
    • Serviços de climatização
    Outros
    • Organização sem fins lucrativos
    • Agência Ambiental
    • Aluguel de outdoors
    • Fotografia
    • Aluguel de bicicletas
    • Revendedor de software
    Navegar por todos os setores
  • Comunidade
    Aprenda
    • Tutoriais
    • Documentação
    • Certificações
    • Treinamento
    • Blog
    • Podcast
    Empodere a Educação
    • Programa de educação
    • Scale Up! Jogo de Negócios
    • Visite a Odoo
    Obtenha o Software
    • Baixar
    • Comparar edições
    • Releases
    Colaborar
    • Github
    • Fórum
    • Eventos
    • Traduções
    • Torne-se um parceiro
    • Serviços para parceiros
    • Cadastre seu escritório contábil
    Obtenha os serviços
    • Encontre um parceiro
    • Encontre um Contador
    • Conheça um consultor
    • Serviços de Implementação
    • Referências de Clientes
    • Suporte
    • Upgrades
    Github YouTube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Faça uma demonstração
  • Preços
  • Ajuda

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

  • CRM
  • e-Commerce
  • Financeiro
  • Inventário
  • PoS
  • Projeto
  • MRP
All apps
É necessário estar registrado para interagir com a comunidade.
Todas as publicações Pessoas Emblemas
Marcadores (Ver tudo)
odoo accounting v14 pos v15
Sobre este fórum
É necessário estar registrado para interagir com a comunidade.
Todas as publicações Pessoas Emblemas
Marcadores (Ver tudo)
odoo accounting v14 pos v15
Sobre este fórum
Ajuda

Product output and valuation account are same error

Inscrever

Seja notificado quando houver atividade nesta publicação

Esta pergunta foi sinalizada
journalaccountentryoutput
2 Respostas
17908 Visualizações
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
Cancelar
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
Melhor resposta

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
Cancelar
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
Melhor resposta

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
Cancelar
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.

Está gostando da discussão? Não fique apenas lendo, participe!

Crie uma conta hoje mesmo para aproveitar os recursos exclusivos e interagir com nossa incrível comunidade!

Inscreva-se
Publicações relacionadas Respostas Visualizações Atividade
What is the difference between account and journal ? Resolvido
journal account
Avatar
Avatar
Avatar
Avatar
5
jul. 19
17203
Proforma Invoice - Unposted Journal Entry
journal entry proforma
Avatar
Avatar
1
jul. 16
7506
Star (Asterisk) with Number in the Journal Entry
journal asterisk entry
Avatar
1
mar. 15
4982
Multi Company and account_id
journal account multi
Avatar
Avatar
1
mar. 15
4540
Why note between invoice lines generates journal item?
journal v7 account
Avatar
0
mar. 15
4671
Comunidade
  • Tutoriais
  • Documentação
  • Fórum
Open Source
  • Baixar
  • Github
  • Runbot
  • Traduções
Serviços
  • Odoo.sh Hosting
  • Suporte
  • Upgrade
  • Desenvolvimentos personalizados
  • Educação
  • Encontre um Contador
  • Encontre um parceiro
  • Torne-se um parceiro
Sobre nós
  • Nossa empresa
  • Ativos da marca
  • Contato
  • Empregos
  • Eventos
  • Podcast
  • Blog
  • Clientes
  • Legal • Privacidade
  • Segurança
الْعَرَبيّة 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 é um conjunto de aplicativos de negócios em código aberto que cobre todas as necessidades de sua empresa: CRM, comércio eletrônico, contabilidade, estoque, ponto de venda, gerenciamento de projetos, etc.

A proposta de valor exclusiva Odoo é ser, ao mesmo tempo, muito fácil de usar e totalmente integrado.

Site feito com

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