Skip ke Konten
Odoo Menu
  • Login
  • Uji coba gratis
  • Aplikasi
    Keuangan
    • Akuntansi
    • Faktur
    • Pengeluaran
    • Spreadsheet (BI)
    • Dokumen
    • Tanda Tangan
    Sales
    • CRM
    • Sales
    • POS Toko
    • POS Restoran
    • Langganan
    • Rental
    Website
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Rantai Pasokan
    • Inventaris
    • Manufaktur
    • PLM
    • Purchase
    • Maintenance
    • Kualitas
    Sumber Daya Manusia
    • Karyawan
    • Rekrutmen
    • Cuti
    • Appraisal
    • Referensi
    • Armada
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Acara
    • Otomatisasi Marketing
    • Survei
    Layanan
    • Project
    • Timesheet
    • Layanan Lapangan
    • Meja Bantuan
    • Planning
    • Appointment
    Produktivitas
    • Diskusi
    • Approval
    • IoT
    • VoIP
    • Pengetahuan
    • WhatsApp
    Aplikasi pihak ketiga Odoo Studio Platform Odoo Cloud
  • Industri-Industri
    Retail
    • Toko Buku
    • Toko Baju
    • Toko Furnitur
    • Toko Kelontong
    • Toko Hardware
    • Toko Mainan
    Makanan & Hospitality
    • Bar dan Pub
    • Restoran
    • Fast Food
    • Rumah Tamu
    • Distributor Minuman
    • Hotel
    Real Estate
    • Agensi Real Estate
    • Firma Arsitektur
    • Konstruksi
    • Estate Management
    • Perkebunan
    • Asosiasi Pemilik Properti
    Konsultansi
    • Firma Akuntansi
    • Mitra Odoo
    • Agensi Marketing
    • Firma huku
    • Talent Acquisition
    • Audit & Sertifikasi
    Manufaktur
    • Tekstil
    • Logam
    • Perabotan
    • Makanan
    • Brewery
    • Corporate Gift
    Kesehatan & Fitness
    • Sports Club
    • Toko Kacamata
    • Fitness Center
    • Wellness Practitioners
    • Farmasi
    • Salon Rambut
    Perdagangan
    • Handyman
    • IT Hardware & Support
    • Sistem-Sistem Energi Surya
    • Pembuat Sepatu
    • Cleaning Service
    • Layanan HVAC
    Lainnya
    • Organisasi Nirlaba
    • Agen Lingkungan
    • Rental Billboard
    • Fotografi
    • Penyewaan Sepeda
    • Reseller Software
    Browse semua Industri
  • Komunitas
    Belajar
    • Tutorial-tutorial
    • Dokumentasi
    • Sertifikasi
    • Pelatihan
    • Blog
    • Podcast
    Empower Education
    • Program Edukasi
    • Game Bisnis 'Scale Up!'
    • Kunjungi Odoo
    Dapatkan Softwarenya
    • Download
    • Bandingkan Edisi
    • Daftar Rilis
    Kolaborasi
    • Github
    • Forum
    • Acara
    • Terjemahan
    • Menjadi Partner
    • Layanan untuk Partner
    • Daftarkan perusahaan Akuntansi Anda.
    Dapatkan Layanan
    • Temukan Mitra
    • Temukan Akuntan
    • Temui penasihat
    • Layanan Implementasi
    • Referensi Pelanggan
    • Bantuan
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Dapatkan demo
  • Harga
  • Bantuan

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

  • CRM
  • e-Commerce
  • Akuntansi
  • Inventaris
  • PoS
  • Project
  • MRP
All apps
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Help

Stock valuation account based on location

Langganan

Dapatkan notifikasi saat terdapat aktivitas pada post ini

Pertanyaan ini telah diberikan tanda
stockaccounting
2 Replies
22403 Tampilan
Avatar
Richard Lewis

I'm trying to enable stock valuation based on locations of stock moves, rather than on product category.

I created a new 'Inventory'-type location for the purpose and set its Stock Valuation Account (Incoming) and Stock Valuation Account (Outgoing) accounts to some appropriate balance sheet accounts. But when I try and process a stock move from a supplier location to this new Inventory location I get this error:

Can not create Journal Entry, Output Account defined on this product and Valuation account on category of this product are same.

This is because the destination location's account and the valuation account are both False; it's not retrieving the valuation_in_account from the move.location_dest_id. And I'm not setting a valuation account because there's no option to do so for a location.

Is this because I've configured this wrongly?

EDIT

So just to make clear: what I'd like to be able to do is stock valuation based on locations only, not on product or product category.

Here's another example of how this fails. When receiving stock moves from suppliers, the moves cannot successfully create valuation account moves because the source of the move (the supplier location) does not---and cannot---have a valuation account; the stock location form view prevents setting valuation accounts for supplier locations.

Perhaps I need to define an intermediate location between supplier and physical stock, configure that location to create valuation account moves, and set up stock move chaining from supplier, through this intermediate location, to physical stock location?

FURTHER EDIT

I want to be able to report value of stock at locations on the balance sheet using automatically created account moves from stock moves, but setting the accounts for the automatically created moves using only the move locations, not the product or product categories.

4
Avatar
Buang
Ray Carnes

Which version of OpenERP?

Richard Lewis
Penulis

It's version 6.1.

Avatar
Mohammad Alhashash
Jawaban Terbai

The location type 'Inventory' is not a physical location. It is a virtual location to represent the source/destination of inventory adjustment operations (matching the physical quantities to the recorded quantities). May be it is a misnomer but the help text gives a clear description about its function.

The 'Stock Valuation Account (Incoming)/(Outgoing)' accounts should be an income/expense accounts that will be affected by the increase/decrease of inventory value as a result of inventory operation.

You do not need separate account per location to track the value of product in it as quantity per location is known. But, it is not possible to have different product cost per location in standard OpenERP.

2
Avatar
Buang
Richard Lewis
Penulis

But you can't set the valuation accounts on a location if the location type is not either Inventory or Production; the view definition makes them readonly.

Mohammad Alhashash

You cannot have an a different valuation accounts for internal locations. You can enable the fields by changing the view, but you will break a lot of things. The help clearly says 'This has no effect for internal locations'

Richard Lewis
Penulis

OK. I don't believe I'm attempting to set valuation accounts for internal locations.

Mohammad Alhashash

May be I misunderstood. Could you describe what do you mean by "valuation based on locations". Perhaps with the business case and expected account moves.

Richard Lewis
Penulis

I want to be able to value my stock without setting valuation accounts on the products (or product categories). I would set valuation accounts on a variety of locations (e.g. factory, warehouse) and would be able to see the value of my stock at each location. The value would have been recorded by the stock moves that have passed through those locations.

Mohammad Alhashash

That was my understanding. This is not possible currently in OpenERP. You do not need separate account per location to get its stock value. The stock value per location is the value of products in it, which can be easily obtained.

Richard Lewis
Penulis

And easily reported on the balance sheet?

Mohammad Alhashash

No. You have to create a special balance sheet report for that.

Richard Lewis
Penulis

OK, thanks. Wish I'd known this wasn't possible before :-(

michel Guénard

I understand that you need to add some new costs to products when they are moved from one location to another one; these may be an allocation of "location costs" over each of the products.

Avatar
michel Guénard
Jawaban Terbai

The question raised by Richard Lewis did not receive a satisfactory answer - in my opinion -.

There is probably not any ready answer with the current release of OpenErp (modules and addons). However this issue is of interest as far as I understand it.

The underlying need is to consider that when products move from one location to another one they receive added value, because the receiving location is a place where there are transformed in bulk. In a sense this is an extension of a MRP process affecting every single product passing thru the said location.

This would require to enlarge the MRP module

How SAP or Oracle do this would be interesting to know!

2
Avatar
Buang
Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar
Post Terkait Replies Tampilan Aktivitas
How to convert a Storable Item to a Fixed Asset for depreciation Diselesaikan
stock accounting
Avatar
Avatar
2
Apr 25
2996
Stock value on the 31st December Diselesaikan
stock accounting
Avatar
Avatar
2
Feb 25
1749
odoo v18 analytic items analytic distribution
stock accounting v18
Avatar
0
Jun 25
2845
Serial Numbers Not Visible in Intercompany (Branch) Invoices – But Visible for Other Customers
stock accounting pdf
Avatar
0
Apr 25
1413
Automatic Accounting: Stock Input/Output Account Diselesaikan
stock accounting automation
Avatar
Avatar
1
Feb 25
2802
Komunitas
  • Tutorial-tutorial
  • Dokumentasi
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Terjemahan
Layanan
  • Odoo.sh Hosting
  • Bantuan
  • Peningkatan
  • Custom Development
  • Pendidikan
  • Temukan Akuntan
  • Temukan Mitra
  • Menjadi Partner
Tentang Kami
  • Perusahaan kami
  • Aset Merek
  • Hubungi kami
  • Tugas
  • Acara
  • Podcast
  • Blog
  • Pelanggan
  • Hukum • Privasi
  • Keamanan
الْعَرَبيّة 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 adalah rangkaian aplikasi bisnis open source yang mencakup semua kebutuhan perusahaan Anda: CRM, eCommerce, akuntansi, inventaris, point of sale, manajemen project, dan seterusnya.

Mudah digunakan dan terintegrasi penuh pada saat yang sama adalah value proposition unik Odoo.

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