Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

How can you have proper Inventory Valuation using OpenERP?

By
Robert Nicholls
on 11/5/13, 7:58 PM 7,759 views

I changed the settings to "Compute product cost price based on average cost" (which is found under settings -> Purchases) and I set my products to Average cost (there is a drop down box when editing each product). I assumed OpenERP would run the inventory cost through the stock journal, but the stock journal isn't even used. Were can I see the current valuation of my products?

2

Ray Carnes

--Ray Carnes--
15717
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

Ray Carnes
On 11/5/13, 8:03 PM

Is your stock valuation manual or real-time?

You will only see stock accounting transactions if it is setup as real-time.

https://doc.openerp.com/6.1/fr/book/5/5_14_Stock/5_14_Stock_financial/

I set my products to real time like you suggest (1) settings->warehouse->generate accounting entries per stock movement 2) Under the product page, I select real time 3) I created an input and an output account) What is the value of the input and output account?

Robert Nicholls
on 11/7/13, 7:53 PM

Perhaps my question is not clear. Let me tell you what happens, then tell you what I was hoping to have happen. Here are the journal entries: When purchasing: debits purchase and credits input. When manufacturing: debit output and credits input. When making a sale debit output and credit purchase. The net effect of a cycle is ouput debited for 2x the purchase amount, input credited for 2x the purchase amount, and the purchase is properly gone back to 0. I don't see any mechanism for reducing the input or output accounts except a manual entry. I don't see what value those numbers have.

Robert Nicholls
on 11/12/13, 2:48 PM

What I thought would happen: I would call the input account materials and the output would be called inventory. Journal entries: 1)When purchasing: debit materials(input) credit Accounts Payable. 2)When manufacturing: debit Inventory(output) credit materials(input). 3) When selling: debit COGS credit Inventory(output). Now I know at any given time how much materials I have and how much inventory I have, but the system doesn't seem to work that way.

Robert Nicholls
on 11/12/13, 2:59 PM

Check out http://ursainfosystems.com/homesite/webinar/ - there needs to be different input and output accounts for different kinds of products. Purchased v Manufactured.

Bista Solutions US, Ray Carnes
on 11/17/13, 10:43 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

3 follower(s)

Stats

Asked: 11/5/13, 7:58 PM
Seen: 7759 times
Last updated: 3/16/15, 8:10 AM