Odoo Help


Incorrect turnover & cost of sales. V8 online

Geoff Kimpton
on 5/5/16, 3:56 AM 580 views

I have multiple accounting problems occurring. Standard UK chart of accounts in use.

1/  On "Tax statements" (VAT) the box 6 sales & box 7 purchases totals are being misreported (a lot more than actual) .

The taxes are correct.

2/  In chart of accounts (UK chart of accounts) Sales, purchases & stock are all reporting a lot more than actual which in turn is obviously impacting on the balance sheet & profit & loss.

In short, the only part that works correctly is the tax reporting.

I now know that the problem is caused by my real time inventory valuation configuration:

Stock input account 500000 Cost of sales

Stock output account 400000 Sales Category 1

Income account  400000 Sales Category 1

Expense account 500000 Cost of sales

Incidentally, I did have a little help from Odoo at the very beginning. The configuration above came direct from an Odoo advisor.

My question is; Is it possible to re-set all the DATA (not configuration settings) on V8 online ?

So that I could then start from the beginning again.  If I cannot find a solution to the real time inventory valuation problem I could revert to manual stock valuation.

If a re-set is not possible I would be very grateful for alternative suggestions to return to 0.

However, it seems that reversing all my entries would probably cause further problems due to an apparent bug that I have read about: https://www.odoo.com/forum/help-1/question/customer-returns-causing-ever-increasing-asset-liability-account-growth-real-time-stock-valuation-54204


On 1/4/18, 1:55 AM


This report will help you to print valuation on particular date with stock IN/OUT/ADJUSTMENT Quantities.

Navigate To : https://apps.odoo.com/apps/modules/11.0/stock_valuation_on_date/

For more information contact : tidyway.in@gmail.com

Thank you, Rohan

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 5/5/16, 3:56 AM
Seen: 580 times
Last updated: 1/4/18, 1:55 AM