Contact Us

Wednesday, 17 August 2016

Odoo Stock Accounting and Inventory Valuation

The article explains, how to work with real-time Stock valuation in Odoo/OpenERP. Connecting the stock module with accounts module enables users to generate accounting entries per stock moves. The Inventory Valuation connected with accounts helps to determine the price of the products more logically.

  1. Warehouse Settings - 
    1. Generate Accounting Entries Per Stock Move
    2. Calculate Landed Cost on products(Optional)
  2. Purchase Settings -Use "Real Price" or "Average" Costing Method
  3. Create Stock Accounts
    1. Stock Valuation Account (Internal Type : Regular, Account Type : Asset) under Current Assets
    2. Stock Control Accounts (Internal Type : View, Account Type : Asset View) under Current Assets
    3. Stock Input Account (Internal Type : Regular, Account Type : Asset) under Stock Control Accounts
    4. Stock Output Account(Internal Type : Regular, Account Type : Asset) under Stock Control Accounts
    5. Expense Account for landed cost (Optional)

  4. Define a new journal - Stock Journal
  5. Configure  Stock Valuation Account, Stock Input Account, Stock output Account and Stock Journal in Product Category Master
  6. Configure Product Type as "Stockable" and Costing Method as "Real Price" in Product Master
  7. Configure
    Inventory Valuation
    Real Time (automated)
  8. Create PO, Receive Product
  9. Check Stock Journal Entries
  10. Check Current Inventory Valuation

Please refer the video for more details..


markson said...

this content
Unwind and feel better realizing that your feelings of trepidation are to some degree unwarranted.

Unknown said...

This is great website and owner of this website is also great because he give help full information with us thanks for sharing great and wonderful information. Check It Out

Roman lesnar said...

I love this blog!! The flash up the top is awesome!! Jameson Tanner said...

Thank you for another great article. Where else could anyone get that kind of information in such a perfect way of writing? I have a presentation next week, and I am on the look for such information. Accountants near me 

Emma Stone said...

Kindly fill me in as to whether you're searching for an article essayist for your site. You have some truly extraordinary posts and I feel I would be a decent resource. On the off chance that you ever need to take a percentage of the heap off, I'd totally love to compose some material for your web journal in return for a connection back to mine. It would be ideal if you send me an email if intrigued. Much obliged to you! Tax preparation services

Unknown said...

Informative article, precisely what I wanted.Accountants in Toronto

fortnite said...

I can see that you are an expert at your field! I am launching a website soon, and your information will be very useful for me.. Thanks for all your help and wishing you all the success in your business. bookkeeping Ottawa

william oscar said...

I have learnt various good stuff right here, and I’m sure everyone will get advantage of it.

Accounting Firms in Toronto

Parker Newman said...

Every week-end I used to pay a fast visit this site, because I’d like enjoyment, because this web site conations certainly fussy material.sell closeout merchandise