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

Incorrect turnover & cost of sales. V8 online

By
Geoff Kimpton
on 5/5/16, 3:56 AM 219 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

 

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

1 follower(s)

Stats

Asked: 5/5/16, 3:56 AM
Seen: 219 times
Last updated: 5/5/16, 5:05 AM