Skip to Content
Odoo Menu
  • Log ind
  • Prøv gratis
  • Apps
    Økonomi
    • Bogføring
    • Fakturering
    • Udgifter
    • Regneark (BI)
    • Dokumenter
    • e-Signatur
    Salg
    • CRM
    • Salg
    • POS Butik
    • POS Restaurant
    • Abonnementer
    • Udlejning
    Hjemmeside
    • Hjemmesidebygger
    • e-Handel
    • Blog
    • Forum
    • LiveChat
    • e-Læring
    Forsyningskæde
    • Lagerbeholdning
    • Produktion
    • PLM
    • Indkøb
    • Vedligeholdelse
    • Kvalitet
    HR
    • Medarbejdere
    • Rekruttering
    • Fravær
    • Medarbejdersamtaler
    • Anbefalinger
    • Flåde
    Marketing
    • Markedsføring på sociale medier
    • E-mailmarketing
    • SMS-marketing
    • Arrangementer
    • Automatiseret marketing
    • Spørgeundersøgelser
    Tjenester
    • Projekt
    • Timesedler
    • Udkørende Service
    • Kundeservice
    • Planlægning
    • Aftaler
    Produktivitet
    • Dialog
    • Godkendelser
    • IoT
    • VoIP
    • Vidensdeling
    • WhatsApp
    Tredjepartsapps Odoo Studio Odoo Cloud-platform
  • Brancher
    Detailhandel
    • Boghandel
    • Tøjforretning
    • Møbelforretning
    • Dagligvarebutik
    • Byggemarked
    • Legetøjsforretning
    Mad og værtsskab
    • Bar og pub
    • Restaurant
    • Fastfood
    • Gæstehus
    • Drikkevareforhandler
    • Hotel
    Ejendom
    • Ejendomsmægler
    • Arkitektfirma
    • Byggeri
    • Ejendomsadministration
    • Havearbejde
    • Boligejerforening
    Rådgivning
    • Regnskabsfirma
    • Odoo-partner
    • Marketingbureau
    • Advokatfirma
    • Rekruttering
    • Audit & certificering
    Produktion
    • Tekstil
    • Metal
    • Møbler
    • Fødevareproduktion
    • Bryggeri
    • Firmagave
    Heldbred & Fitness
    • Sportsklub
    • Optiker
    • Fitnesscenter
    • Kosmetolog
    • Apotek
    • Frisør
    Håndværk
    • Handyman
    • IT-hardware og support
    • Solenergisystemer
    • Skomager
    • Rengøringsservicer
    • VVS- og ventilationsservice
    Andet
    • Nonprofitorganisation
    • Miljøagentur
    • Udlejning af billboards
    • Fotografi
    • Cykeludlejning
    • Softwareforhandler
    Gennemse alle brancher
  • Community
    Få mere at vide
    • Tutorials
    • Dokumentation
    • Certificeringer
    • Oplæring
    • Blog
    • Podcast
    Bliv klogere
    • Udannelselsesprogram
    • Scale Up!-virksomhedsspillet
    • Besøg Odoo
    Få softwaren
    • Download
    • Sammenlign versioner
    • Udgaver
    Samarbejde
    • Github
    • Forum
    • Arrangementer
    • Oversættelser
    • Bliv partner
    • Tjenester til partnere
    • Registrér dit regnskabsfirma
    Modtag tjenester
    • Find en partner
    • Find en bogholder
    • Kontakt en rådgiver
    • Implementeringstjenester
    • Kundereferencer
    • Support
    • Opgraderinger
    Github Youtube Twitter LinkedIn Instagram Facebook Spotify
    +1 (650) 691-3277
    Få en demo
  • Prissætning
  • Hjælp

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

  • CRM
  • e-Commerce
  • Bogføring
  • Lager
  • PoS
  • Projekt
  • MRP
All apps
Du skal være registreret for at interagere med fællesskabet.
All Posts People Emblemer
Tags (View all)
odoo accounting v14 pos v15
Om dette forum
Du skal være registreret for at interagere med fællesskabet.
All Posts People Emblemer
Tags (View all)
odoo accounting v14 pos v15
Om dette forum
Hjælp

Product output and valuation account are same error

Tilmeld

Få besked, når der er aktivitet på dette indlæg

Dette spørgsmål er blevet anmeldt
journalaccountentryoutput
2 Besvarelser
17924 Visninger
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
Kassér
odimegwu david
Forfatter

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
Bedste svar

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
Kassér
odimegwu david
Forfatter

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
Forfatter

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
Forfatter

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
Forfatter

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
Bedste svar

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
Kassér
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.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Tilmeld dig
Related Posts Besvarelser Visninger Aktivitet
What is the difference between account and journal ? Løst
journal account
Avatar
Avatar
Avatar
Avatar
5
jul. 19
17217
Proforma Invoice - Unposted Journal Entry
journal entry proforma
Avatar
Avatar
1
jul. 16
7512
Star (Asterisk) with Number in the Journal Entry
journal asterisk entry
Avatar
1
mar. 15
4991
Multi Company and account_id
journal account multi
Avatar
Avatar
1
mar. 15
4550
Why note between invoice lines generates journal item?
journal v7 account
Avatar
0
mar. 15
4683
Community
  • Tutorials
  • Dokumentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Oversættelser
Tjenester
  • Odoo.sh-hosting
  • Support
  • Opgradere
  • Individuelt tilpasset udvikling
  • Uddannelse
  • Find en bogholder
  • Find en partner
  • Bliv partner
Om os
  • Vores virksomhed
  • Brandaktiver
  • Kontakt os
  • Stillinger
  • Arrangementer
  • Podcast
  • Blog
  • Kunder
  • Juridiske dokumenter • Privatlivspolitik
  • Sikkerhedspolitik
الْعَرَبيّة 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 er en samling open source-forretningsapps, der dækker alle dine virksomhedsbehov – lige fra CRM, e-handel og bogføring til lagerstyring, POS, projektledelse og meget mere.

Det unikke ved Odoo er, at systemet både er brugervenligt og fuldt integreret.

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