Se rendre au contenu
Odoo Menu
  • Se connecter
  • Essai gratuit
  • Applications
    Finance
    • Comptabilité
    • Facturation
    • Notes de frais
    • Feuilles de calcul (BI)
    • Documents
    • Signature
    Ventes
    • CRM
    • Ventes
    • PdV Boutique
    • PdV Restaurant
    • Abonnements
    • Location
    Sites web
    • Site Web
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Chaîne d'approvisionnement
    • Inventaire
    • Fabrication
    • PLM
    • Achats
    • Maintenance
    • Qualité
    Ressources Humaines
    • Employés
    • Recrutement
    • Congés
    • Évaluations
    • Recommandations
    • Parc automobile
    Marketing
    • Marketing Social
    • E-mail Marketing
    • SMS Marketing
    • Événements
    • Marketing Automation
    • Sondages
    Services
    • Projet
    • Feuilles de temps
    • Services sur Site
    • Assistance
    • Planification
    • Rendez-vous
    Productivité
    • Discussion
    • Intelligence artificielle
    • Internet des Objets
    • VoIP
    • Connaissances
    • WhatsApp
    Applications tierces Odoo Studio Plateforme Cloud d'Odoo
  • Industries
    Commerce de détail
    • Librairie
    • Magasin de vêtements
    • Magasin de meubles
    • Supermarché
    • Quincaillerie
    • Magasin de jouets
    Restauration & Hôtellerie
    • Bar et Pub
    • Restaurant
    • Fast-food
    • Maison d’hôtes
    • Distributeur de boissons
    • Hôtel
    Immobilier
    • Agence immobilière
    • Cabinet d'architecture
    • Construction
    • Gestion immobilière
    • Jardinage
    • Association de copropriétaires
    Consultance
    • Cabinet d'expertise comptable
    • Partenaire Odoo
    • Agence Marketing
    • Cabinet d'avocats
    • Aquisition de talents
    • Audit & Certification
    Fabrication
    • Textile
    • Métal
    • Meubles
    • Alimentation
    • Brasserie
    • Cadeaux d'entreprise
    Santé & Fitness
    • Club de sports
    • Opticien
    • Salle de fitness
    • Praticiens bien-être
    • Pharmacie
    • Salon de coiffure
    Commerce
    • Homme à tout faire
    • Matériel informatique & support
    • Systèmes photovoltaïques
    • Cordonnier
    • Services de nettoyage
    • Services CVC
    Autres
    • Organisation à but non lucratif
    • Agence environnementale
    • Location de panneaux d'affichage
    • Photographie
    • Leasing de vélos
    • Revendeur de logiciel
    Parcourir toutes les industries
  • Communauté
    Apprenez
    • Tutoriels
    • Documentation
    • Certifications
    • Formation
    • Blog
    • Podcast
    Renforcer l'éducation
    • Programme éducatif
    • Business Game Scale-Up!
    • Rendez-nous visite
    Obtenir le logiciel
    • Téléchargement
    • Comparez les éditions
    • Versions
    Collaborer
    • Github
    • Forum
    • Événements
    • Traductions
    • Devenir partenaire
    • Services pour partenaires
    • Enregistrer votre cabinet comptable
    Nos Services
    • Trouver un partenaire
    • Trouver un comptable
    • Rencontrer un conseiller
    • Services de mise en œuvre
    • Références clients
    • Assistance
    • Mises à niveau
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Obtenir une démonstration
  • Tarification
  • Aide
Vous devez être inscrit pour interagir avec la communauté.
Toutes les publications Personnes Badges
Étiquettes (Voir toutl)
odoo accounting v14 pos v15
À propos de ce forum
Vous devez être inscrit pour interagir avec la communauté.
Toutes les publications Personnes Badges
Étiquettes (Voir toutl)
odoo accounting v14 pos v15
À propos de ce forum
Aide

Stock valuation account based on location

S'inscrire

Recevez une notification lorsqu'il y a de l'activité sur ce poste

Cette question a été signalée
stockaccounting
2 Réponses
24093 Vues
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
Ignorer
Ray Carnes

Which version of OpenERP?

Richard Lewis
Auteur

It's version 6.1.

Avatar
Mohammad Alhashash
Meilleure réponse

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
Ignorer
Richard Lewis
Auteur

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
Auteur

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
Auteur

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
Auteur

And easily reported on the balance sheet?

Mohammad Alhashash

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

Richard Lewis
Auteur

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
Meilleure réponse

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
Ignorer
Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !

Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !

S'inscrire
Publications associées Réponses Vues Activité
(Soporte ➤ 24/7) 🛩☎【Necesidad  24/7 +506☎ 4105 9205 】 ¿Cómo llamar a Volaris desde Costa Rica?🏝
stock accounting
Avatar
0
mai 26
1
How to convert a Storable Item to a Fixed Asset for depreciation Résolu
stock accounting
Avatar
Avatar
2
avr. 25
4355
Stock value on the 31st December Résolu
stock accounting
Avatar
Avatar
2
févr. 25
2673
odoo v18 analytic items analytic distribution
stock accounting v18
Avatar
0
juin 25
4465
Serial Numbers Not Visible in Intercompany (Branch) Invoices – But Visible for Other Customers
stock accounting pdf
Avatar
0
avr. 25
2119
Communauté
  • Tutoriels
  • Documentation
  • Forum
Open Source
  • Téléchargement
  • Github
  • Runbot
  • Traductions
Services
  • Hébergement Odoo.sh
  • Assistance
  • Migration
  • Développements personnalisés
  • Éducation
  • Trouver un comptable
  • Trouver un partenaire
  • Devenir partenaire
À propos
  • Notre société
  • Actifs de la marque
  • Contactez-nous
  • Emplois
  • Événements
  • Podcast
  • Blog
  • Clients
  • Informations légales • Confidentialité
  • Sécurité.
الْعَرَبيّة 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 Svenska ภาษาไทย Türkçe українська Tiếng Việt

Odoo est une suite d'applications open source couvrant tous les besoins de votre entreprise : CRM, eCommerce, Comptabilité, Inventaire, Point de Vente, Gestion de Projet, etc.

Le positionnement unique d'Odoo est d'être à la fois très facile à utiliser et totalement intégré.

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